Changeset 37586 for trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES
- Timestamp:
- Nov 12, 2014, 12:05:37 PM (12 years ago)
- Location:
- trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables
- Files:
-
- 10 edited
-
DiffDetObject (modified) (1 diff)
-
DiffDetObject.txt (modified) (1 diff)
-
DiffDetection (modified) (1 diff)
-
DiffDetection.txt (modified) (1 diff)
-
ForcedMeanObject (modified) (1 diff)
-
ForcedMeanObject.txt (modified) (1 diff)
-
ForcedWarpExtended (modified) (1 diff)
-
ForcedWarpExtended.txt (modified) (1 diff)
-
ForcedWarpMeasurement (modified) (1 diff)
-
ForcedWarpMeasurement.txt (modified) (1 diff)
Legend:
- Unmodified
- Added
- Removed
-
trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetObject
r37474 r37586 3 3 diffObjID dimensionless BIGINT 8 NA ODM object identifier index 4 4 unique_psps_do_id dimentionless BIGINT 8 NA unique id provided by ipptopsps, based on batch_Id + counter 5 diffgcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier6 5 ippObjID dimensionless BIGINT 8 NA IPP object number 7 6 surveyID dimensionless TINYINT 1 255 Survey ID -
trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetObject.txt
r37474 r37586 3 3 diffObjID = dvo / addstar 4 4 unique_psps_do_id = ipptopsps 5 diffgcObjID = dvo / addstar6 5 ippObjID = dvo / addstar 7 6 surveyID = ipptopsps -
trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetection
r37474 r37586 2 2 diffObjID dimensionless BIGINT 8 NA diff object identifier 3 3 unique_psps_df_id dimensionless BIGINT 8 NA unique psps id (combination of batch_id, and counter) provided by ipptopsps 4 diffgcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier5 4 diffDetID dimensionless BIGINT 8 NA diff detection identifier 6 5 diffDetMetaID dimensionless BIGINT 8 NA diff detection meta identifier -
trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetection.txt
r37474 r37586 2 2 diffObjID = dvo / addstar 3 3 unique_psps_df_id = ipptopsps 4 diffgcObjID = dvo / addstar5 4 diffDetID = dvo / addstar 6 5 diffDetMetaID = dvo / addstar -
trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject
r37474 r37586 2 2 objID dimensionless BIGINT 8 NA ODM object identifier index 3 3 unique_psps_fo_id dimensionless BIGINT 8 NA unique id supplied by ipptopsps 4 gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier5 4 ippObjID dimensionless BIGINT 8 NA IPP object identifier 6 5 nDetections dimensionless SMALLINT 2 -999 total number of detection measurements in all filters -
trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject.txt
r37524 r37586 2 2 objID = cpt.extID 3 3 unique_psps_fo_id = ipptopsps 4 gcobjID = remove?5 4 ippObjID = cpt.objID | cpt.catID << 32 6 5 nDetections = sql sum of cps.NCODE (xnTotal) -
trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended
r37474 r37586 2 2 objID dimensionless BIGINT 8 NA ODM object identifier 3 3 unique_psps_fw_id dimentionless BIGINT 8 NA unique id supplied by ipptopsps 4 gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier5 4 detectID dimensionless BIGINT 8 NA ODM detection identifier 6 5 ippObjID dimensionless BIGINT 8 NA ippobject id generated by IPP -
trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended.txt
r37524 r37586 2 2 objID = cpt.extID (???) 3 3 unique_psps_fw_id = ipptopsps 4 gcObjID = remove?5 4 detectID = cpm.extID (???) 6 5 ippObjID = cpx.obj_ID | cpx.cat_ID << 32 -
trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement
r37474 r37586 2 2 objID dimensionless BIGINT 8 NA ODM object identifier 3 3 unique_psps_fw_id dimensionless BIGINT 8 NA unique identifier provided by ipptopsps 4 gcObjID dimensionless BIGINT 8 NA ODM galactic coordinates identifier5 4 detectID dimensionless BIGINT 8 NA ODM detection identifier 6 5 ippObjID dimensionless BIGINT 8 NA ippobject id generated by IPP -
trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement.txt
r37524 r37586 2 2 objID = cpt.extID (???) 3 3 unique_psps_fw_id = ipptopsps 4 gcObjID = remove?5 4 detectID = cpm.extID (???) 6 5 ippObjID = cpx.obj_id | cps.cat_id << 32
Note:
See TracChangeset
for help on using the changeset viewer.
