Changeset 17877 for trunk/dbconfig/fake.md

Timestamp:

Jun 2, 2008, 11:24:18 AM (18 years ago)

Author:

jhoblitt

Message:

first use of fake* tables
VERSION 1.1.38

File:

• trunk/dbconfig/fake.md (modified) (3 diffs)

trunk/dbconfig/fake.md

@@ -1 +1 @@
 fakeRun METADATA
     fake_id     S64         0       # Primary Key AUTO_INCREMENT
-    exp_id      S64         64      # Key INDEX(fake_id, exp_id) fkey (exp_id) ref rawExp(exp_id)
+    cam_id      S64         0       # Key INDEX(fake_id, cam_id) fkey (cam_id) ref camRun(cam_id)
     state       STR         64      # Key
     workdir     STR         255 
-    workdir_state STR       64      # Key
     label       STR         64      # Key
     reduction   STR         64      # Reduction class
@@ -11 +10 @@
     tess_id     STR         64
     end_stage   STR         64      # Key
+    epoch       UTC         0001-01-01T00:00:00Z
 END
 
 fakeProcessedImfile METADATA
-    fake_id         S64     0       # Primary Key fkey (fake_id, exp_id) ref fakeRun(fake_id, exp_id)
+    fake_id         S64     0       # Primary Key fkey (fake_id) ref fakeRun(fake_id)
     exp_id          S64     64      # Primary Key fkey (exp_id, class_id) ref rawImfile(exp_id, class_id)
     class_id        STR     64      # Primary Key
@@ -22 +22 @@
     path_base       STR     255
     fault           S16     0       # Key NOT NULL
+    epoch           UTC         0001-01-01T00:00:00Z
 END