Changeset 14270 for trunk/dbconfig

Timestamp:

Jul 17, 2007, 11:25:40 AM (19 years ago)

Author:

jhoblitt

Message:

add detRegisteredImfile table

File:

• trunk/dbconfig/det.md (modified) (2 diffs)

trunk/dbconfig/det.md

@@ -1 +1 @@
 detRun METADATA
     det_id      S64         0       # Primary Key AUTO_INCREMENT
-    iteration   S32         0       # Key
+    iteration   S32         0       # Key INDEX(det_id, iteration)
     det_type    STR         64      # Key
     mode        STR         64      # Key
@@ -208 +208 @@
     fault       S16         0       # Key NOT NULL
 END
+
+#
+# Note: This table needs to stay more or less identical to detNormalizedImfile.
+# It only exists as a seperate entity so they it can have different fkeys
+#
+detRegisteredImfile METADATA
+    det_id      S64         0       # Primary Key fkey(det_id, iteration) ref detRun(det_id, iteration)
+    iteration   S32         0       # Primary Key
+    class_id    STR         64      # Primary Key
+    uri         STR         255
+    bg          F64         0.0
+    bg_stdev    F64         0.0
+    bg_mean_stdev   F64     0.0
+    user_1      F64         0.0
+    user_2      F64         0.0
+    user_3      F64         0.0
+    user_4      F64         0.0
+    user_5      F64         0.0
+    path_base   STR         255
+    fault       S16         0       # Key NOT NULL
+END