Changeset 42573 for branches/eam_branches/ipp-20230313/dbconfig/xcsky.md

Timestamp:

Dec 28, 2023, 8:48:12 AM (3 years ago)

Author:

eugene

Message:

adding xcsky tables

File:

• branches/eam_branches/ipp-20230313/dbconfig/xcsky.md (modified) (4 diffs)

branches/eam_branches/ipp-20230313/dbconfig/xcsky.md

@@ -3 +3 @@
 
 xcskyRun METADATA
-    sky_id      S64         0       # Primary Key AUTO_INCREMENT
+    xcsky_id    S64         0       # Primary Key AUTO_INCREMENT
     state       STR         64      # Key
     workdir     STR         255
@@ -15 +15 @@
 
 xcskyInput METADATA
-    sky_id      S64         0       # Primary Key fkey(sky_id) ref xcskyRun(sky_id)
-    xcstack_id  S64         0       # Primary Key fkey(xcstack_id) ref stackSumSkyfile(xcstack_id)
+    xcsky_id    S64         0       # Primary Key fkey(xcsky_id) ref xcskyRun(xcsky_id)
+    xcstack_id  S64         0       # Primary Key fkey(xcstack_id) ref xcstackSumSkyfile(xcstack_id)
 END
 
 xcskyResult METADATA
-    sky_id             S64    0       # Primary Key fkey(sky_id) ref xcskyRun(sky_id)
+    xcsky_id           S64    0       # Primary Key fkey(xcsky_id) ref xcskyRun(xcsky_id)
     path_base          STR    255
     dtime_phot         F32    0.0
@@ -33 +33 @@
 
 xccalRun METADATA
-    cal_id      S64         0       # Primary Key AUTO_INCREMENT
-    sky_id      S64         0       # fkey(sky_id) ref xcskyRun(sky_id)
+    xccal_id    S64         0       # Primary Key AUTO_INCREMENT
+    xcsky_id    S64         0       # fkey(xcsky_id) ref xcskyRun(xcsky_id)
     xcstack_id  S64         0       # fkey(xcstack_id) ref xcstackRun(xcstack_id)
     state       STR         64      # Key
@@ -47 +47 @@
 
 xccalResult METADATA
-    cal_id         S64    0       # Primary Key fkey(cal_id) ref xccalRun(cal_id)
+    xccal_id       S64    0       # Primary Key fkey(xccal_id) ref xccalRun(xccal_id)
     path_base      STR    255
     dtime_script   F32    0.0