Changeset 11818 for trunk/dbconfig

Timestamp:

Feb 14, 2007, 5:55:48 PM (19 years ago)

Author:

jhoblitt

Message:

remove exp_tag & p3_version from p4Scfile's primary key

Location:

trunk/dbconfig

Files:

• p4.md (modified) (3 diffs)
• p5.md (modified) (2 diffs)

trunk/dbconfig/p4.md

@@ -1 @@
-# $Id: p4.md,v 1.11 2007-02-13 22:33:30 jhoblitt Exp $
+# $Id: p4.md,v 1.12 2007-02-15 03:53:24 jhoblitt Exp $
 
 #
@@ -22 +22 @@
 
 # the list of imfiles in our skycell keyed against phase 3
+# only allow one p3_version of an exp_tag per p4Run
 p4InputExp METADATA
     p4_id       S32         0       # Primary Key
     exp_tag     STR         64      # Primary Key
-    p3_version  S32         0       # Primary Key
+    p3_version  S32         0       # Key
 # if magic is T then look for the exp_tag in the magic output tables
-    magiced     BOOL        f       # Primary Key
+    magiced     BOOL        f       # Key
 END
 
@@ -45 +46 @@
     skycell_id  STR         64      # Primary Key
     tess_id     STR         64      # Primary Key
-    exp_tag     STR         64      # Primary Key
-    p3_version  S32         0       # Primary Key
+    exp_tag     STR         64      # Key
+    p3_version  S32         0       # Key
     uri         STR         255
     bg          F64         0.0

trunk/dbconfig/p5.md

@@ -1 @@
-# $Id: p5.md,v 1.2 2007-02-15 02:01:30 jhoblitt Exp $
+# $Id: p5.md,v 1.3 2007-02-15 03:53:24 jhoblitt Exp $
 
 p5Run METADATA
@@ -18 +18 @@
     skycell_id  STR         64      # Primary Key
     tess_id     STR         64      # Primary Key
-    exp_tag     STR         64      # Primary Key
-    p3_version  S32         0       # Primary Key
 # either a input or a template
     kind        STR         64      # Key