Context Navigation

← Previous Change
Next Change →

PSPS_TABLES

Timestamp:

Nov 12, 2014, 2:58:40 PM (12 years ago)

Author:

heather

Message:

cleaning up the schema, and adding uniquePsps()id to all tables. Populated in
all except FO/FW/DF/DO (those are still in progress)

Location:

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables

Files:

: 37 edited

Detection (modified) (1 diff)
Detection.txt (modified) (1 diff)
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)
MeanObject (modified) (1 diff)
MeanObject.txt (modified) (1 diff)
ObjectThin (modified) (1 diff)
ObjectThin.txt (modified) (1 diff)
StackApFlx (modified) (1 diff)
StackApFlx.txt (modified) (1 diff)
StackApFlxEGCon6 (modified) (1 diff)
StackApFlxEGCon6.txt (modified) (1 diff)
StackApFlxEGCon8 (modified) (1 diff)
StackApFlxEGCon8.txt (modified) (1 diff)
StackApFlxEGUnc (modified) (1 diff)
StackApFlxEGUnc.txt (modified) (1 diff)
StackModelFitDeV (modified) (1 diff)
StackModelFitDeV.txt (modified) (1 diff)
StackModelFitExp (modified) (1 diff)
StackModelFitExp.txt (modified) (1 diff)
StackModelFitExtra (modified) (1 diff)
StackModelFitSer (modified) (1 diff)
StackModelFitSer.txt (modified) (1 diff)
StackObjectAttributes (modified) (1 diff)
StackObjectAttributes.txt (modified) (1 diff)
StackObjectThin (modified) (1 diff)
StackObjectThin.txt (modified) (1 diff)
StackPetrosian (modified) (1 diff)
StackPetrosian.txt (modified) (1 diff)

Legend:

: Unmodified
: Added
: Removed

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection

r37474	r37592
1	1	objID dimensionless BIGINT 8 NA ODM object identifier
2		unique~~_psps_p2_~~id dimensionless BIGINT 8 NA unique identifier for psps based on batch_id, OTA, and counter (per detection)
	2	uniquePspsP2id dimensionless BIGINT 8 NA unique identifier for psps based on batch_id, OTA, and counter (per detection)
3	3	detectID dimensionless BIGINT 8 NA ODM detection identifier
4	4	ippObjID dimensionless BIGINT 8 NA detection id generated by IPP

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/Detection.txt

r37474	r37592
1	1	objID + dvo = average.extID [calculated in addstar]
2		unique~~_psps_p2_~~id + ipptopsps : combination of batch_id, ota, and counter
	2	uniquePspsP2id + ipptopsps : combination of batch_id, ota, and counter
3	3	detectID + dvo = measure.extID [calculated in addstar]
4	4	ippObjID + dvo = average.objID + (average.catID << 32) [NOTE: this is a change in definition]

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetObject

r37586	r37592
2	2	diffObjName string VAR 8 NA IAU Name constructed from objID postion PS1.x JHHMMSS.SS+/-DDMMSS.S x procesing version
3	3	diffObjID dimensionless BIGINT 8 NA ODM object identifier index
4		unique~~_psps_do_~~id dimentionless BIGINT 8 NA unique id provided by ipptopsps, based on batch_Id + counter
	4	uniquePspsDOid dimentionless BIGINT 8 NA unique id provided by ipptopsps, based on batch_Id + counter
5	5	ippObjID dimensionless BIGINT 8 NA IPP object number
6	6	surveyID dimensionless TINYINT 1 255 Survey ID

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetObject.txt

r37586	r37592
2	2	diffObjName = ipptopsps
3	3	diffObjID = dvo / addstar
4		unique~~_psps_do_~~id = ipptopsps
	4	uniquePspsDOid = ipptopsps
5	5	ippObjID = dvo / addstar
6	6	surveyID = ipptopsps

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetection

r37586	r37592
1	1
2	2	diffObjID dimensionless BIGINT 8 NA diff object identifier
3		unique~~_psps_df_~~id dimensionless BIGINT 8 NA unique psps id (combination of batch_id, and counter) provided by ipptopsps
	3	uniquePspsDFid dimensionless BIGINT 8 NA unique psps id (combination of batch_id, and counter) provided by ipptopsps
4	4	diffDetID dimensionless BIGINT 8 NA diff detection identifier
5	5	diffDetMetaID dimensionless BIGINT 8 NA diff detection meta identifier

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/DiffDetection.txt

r37586	r37592
1	1
2	2	diffObjID = dvo / addstar
3		unique~~_psps_df_id~~ = ipptopsps
	3	uniquePspsDFid = ipptopsps
4	4	diffDetID = dvo / addstar
5	5	diffDetMetaID = dvo / addstar

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedMeanObject

r37586	r37592
1	1
2	2	objID dimensionless BIGINT 8 NA ODM object identifier index
3		unique~~_psps_fo_~~id dimensionless BIGINT 8 NA unique id supplied by ipptopsps
	3	uniquePspsFOid dimensionless BIGINT 8 NA unique id supplied by ipptopsps
4	4	ippObjID dimensionless BIGINT 8 NA IPP object identifier
5	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

r37586	r37592
1	1
2	2	objID = cpt.extID
3		unique~~_psps_fo_~~id = ipptopsps
	3	uniquePspsFOid = ipptopsps
4	4	ippObjID = cpt.objID \| cpt.catID << 32
5	5	nDetections = sql sum of cps.NCODE (xnTotal)

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpExtended

r37586	r37592
1	1
2	2	objID dimensionless BIGINT 8 NA ODM object identifier
3		unique~~_psps_fw_~~id dimentionless BIGINT 8 NA unique id supplied by ipptopsps
	3	uniquePspsFWid dimentionless BIGINT 8 NA unique id supplied by ipptopsps
4	4	detectID dimensionless BIGINT 8 NA ODM detection identifier
5	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

r37586	r37592
1	1
2	2	objID = cpt.extID (???)
3		unique~~_psps_fw_~~id = ipptopsps
	3	uniquePspsFWid = ipptopsps
4	4	detectID = cpm.extID (???)
5	5	ippObjID = cpx.obj_ID \| cpx.cat_ID << 32

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ForcedWarpMeasurement

r37586	r37592
1	1
2	2	objID dimensionless BIGINT 8 NA ODM object identifier
3		unique~~_psps_fw_~~id dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
	3	uniquePspsFWid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
4	4	detectID dimensionless BIGINT 8 NA ODM detection identifier
5	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

r37586	r37592
1	1
2	2	objID = cpt.extID (???)
3		unique~~_psps_fw_id~~ = ipptopsps
	3	uniquePspsFWid = ipptopsps
4	4	detectID = cpm.extID (???)
5	5	ippObjID = cpx.obj_id \| cps.cat_id << 32

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject

r37474	r37592
4	4
5	5	objID dimensionless BIGINT 8 NA ODM object identifier index
6		unique~~_psps_ob_~~id dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
	6	uniquePspsOBid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
7	7	gQfPerfect dimensionless REAL 4 -999 maximum psf qfPerfect from best available g band detections
8	8	gMeanPSFMag AB_magnitude REAL 4 -999 mean g psf AB magnitude from best available measurements (best available as current defined by ipp "waterfall logic"

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/MeanObject.txt

r37474	r37592
3	3
4	4	objID + dvo / addstar
5		unique~~_psps_ob_~~id = ipptopsps
	5	uniquePspsOBid = ipptopsps
6	6	gQfPerfect + dvo / relphot / secfilt.psfQfMax
7	7	gMeanPSFMag + dvo / relphot / secfilt.M

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin

r37474	r37592
2	2	objName string VAR 8 NA IAU Name constructed from objID postion PS1.x JHHMMSS.SS+/-DDMMSS.S where x is leading number of procesing version
3	3	objID dimensionless BIGINT 8 NA ODM object identifier index
4		unique~~_psps_ob_id~~ dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
	4	uniquePspsOBid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
5	5	ippObjID dimensionless BIGINT 8 NA IPP object number
6	6	surveyID dimensionless TINYINT 1 255 Survey ID

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/ObjectThin.txt

r37474	r37592
2	2	objName - ipptopsps : move to dvopsps?
3	3	objID + dvo:average.extID
4		unique~~_psps_ob_id~~ = ipptopsps
	4	uniquePspsOBid = ipptopsps
5	5	ippObjID + dvo:(average.objID \| average.catID << 32)
6	6	surveyID + ipptopsps : internal, from survey name

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx

r37475	r37592
1	1
2	2	objID dimensionless BIGINT 8 NA ODM object identifier
3		unique~~_psps_st_id~~ dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
	3	uniquePspsSTid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
4	4	ippObjID dimensionless BIGINT 8 NA ipp object identifier
5	5	randomStackObjID dimensionless BIGINT 8 NA random stack id

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlx.txt

r37475	r37592
1	1
2	2	objID + from StackObjectThin
3		unique~~_psps_st_~~id = ipptopsps
	3	uniquePspsSTid = ipptopsps
4	4	ippObjID + from StackObjectThin
5	5	randomStackObjID + from StackObjectThin

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxEGCon6

r37475	r37592
1	1
2	2	objID dimensionless BIGINT 8 NA ODM object identifier
3		unique~~_psps_st_id~~ dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
	3	uniquePspsSTid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
4	4	ippObjID dimensionless BIGINT 8 NA object ID generated by IPP
5	5	randomStackObjID dimensionless BIGINT 8 NA random stack id

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxEGCon6.txt

r37475	r37592
1	1
2	2	objID + from StackObjectThin
3		unique~~_psps_st_id~~ = ipptopsps
	3	uniquePspsSTid = ipptopsps
4	4	ippObjID + from StackObjectThin
5	5	randomStackObjID + from StackObjectThin

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxEGCon8

r37475	r37592
1	1
2	2	objID dimensionless BIGINT 8 NA ODM object identifier
3		unique~~_psps_st_~~id dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
	3	uniquePspsSTid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
4	4	ippObjID dimensionless BIGINT 8 NA object ID generated by IPP
5	5	randomStackObjID dimensionless BIGINT 8 NA random stack id

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxEGCon8.txt

r37475	r37592
1	1
2	2	objID + from StackObjectThin
3		unique~~_psps_st_id~~ = ipptopsps
	3	uniquePspsSTid = ipptopsps
4	4	ippObjID + from StackObjectThin
5	5	randomStackObjID + from StackObjectThin

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxEGUnc

r37474	r37592
1	1
2	2	objID dimensionless BIGINT 8 NA ODM object identifier
3		unique~~_psps_st_id~~ dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
	3	uniquePspsSTid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
4	4	ippObjID dimensionless BIGINT 8 NA object ID generated by IPP
5	5	randomStackObjID dimensionless BIGINT 8 NA random stack id

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackApFlxEGUnc.txt

r37474	r37592
1	1
2	2	objID + from StackObjectThin
3		unique~~_psps_st_id~~ = ipptopsps
	3	uniquePspsSTid = ipptopsps
4	4	ippObjID + from StackObjectThin
5	5	randomStackObjID + from StackObjectThin

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV

r37474	r37592
1	1
2	2	objID dimensionless BIGINT 8 NA ODM object identifier
3		unique~~_psps_st_~~id dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
	3	uniquePspsSTid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
4	4	ippObjID dimensionless BIGINT 8 NA object ID generated by IPP
5	5	randomStackObjID dimensionless BIGINT 8 NA random stack id

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitDeV.txt

r37474	r37592
1	1
2	2	objID + from StackObjectThin
3		unique~~_psps_st_~~id = ipptopsps
	3	uniquePspsSTid = ipptopsps
4	4	ippObjID + from StackObjectThin
5	5	randomStackObjID + from StackObjectThin

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp

r37474	r37592
1	1
2	2	objID dimensionless BIGINT 8 NA ODM object identifier
3		unique~~_psps_st_~~id dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
	3	uniquePspsSTid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
4	4	ippObjID dimensionless BIGINT 8 NA object ID generated by IPP
5	5	randomStackObjID dimensionless BIGINT 8 NA random stack id

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExp.txt

r37474	r37592
1	1
2	2	objID + from StackObjectThin
3		unique~~_psps_st_~~id = ipptopsps
	3	uniquePspsSTid = ipptopsps
4	4	ippObjID + from StackObjectThin
5	5	randomStackObjID + from StackObjectThin

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitExtra

r37475	r37592
1	1
2	2	objID dimensionless BIGINT 8 NA ODM object identifier
3		unique~~_psps_st_~~id dimensionless BIGINT 8 NA unique ipptopsps id
	3	uniquePspsSTid dimensionless BIGINT 8 NA unique ipptopsps id
4	4	ippObjID dimensionless BIGINT 8 NA object ID generated by IPP
5	5	randomStackObjID dimensionless BIGINT 8 NA random stack id

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer

r37474	r37592
1	1
2	2	objID dimensionless BIGINT 8 NA ODM object identifier
3		unique~~_psps_st_~~id dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
	3	uniquePspsSTid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
4	4	ippObjID dimensionless BIGINT 8 NA object ID generated by IPP
5	5	randomStackObjID dimensionless BIGINT 8 NA random stack id

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackModelFitSer.txt

r37474	r37592
1	1
2	2	objID + from StackObjectThin
3		unique~~_psps_st_id~~ = ipptopsps
	3	uniquePspsSTid = ipptopsps
4	4	ippObjID + from StackObjectThin
5	5	randomStackObjID + from StackObjectThin

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectAttributes

r37577	r37592
1	1
2	2	objID dimensionless BIGINT 8 NA ODM object identifie
3		unique~~_psps_st_~~id dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
	3	uniquePspsSTid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
4	4	ippObjID dimensionless BIGINT 8 NA object ID generated by IPP
5	5	randomStackObjID dimensionless BIGINT 8 NA random stack id

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectAttributes.txt

r37577	r37592
1	1
2	2	objID + from StackObjectThin
3		unique~~_psps_st_~~id = ipptopsps
	3	uniquePspsSTid = ipptopsps
4	4	ippObjID + from StackObjectThin
5	5	randomStackObjID + from StackObjectThin

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin

r37474	r37592
1	1
2	2	objID dimensionless BIGINT 8 NA ODM object identifier
3		unique~~_psps_st_~~id dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
	3	uniquePspsSTid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
4	4	ippObjID dimensionless BIGINT 8 NA object ID generated by IPP [this is a per-object, not per-filter value]
5	5	surveyID dimensionless TINYINT 1 NA survey flag identifier

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackObjectThin.txt

r37474	r37592
3	3
4	4	objID + dvo = average.extID [calculated in addstar]
5		unique~~_psps_st_~~id = ipptopsps
	5	uniquePspsSTid = ipptopsps
6	6	ippObjID + dvo = average.objID + (average.catID << 32) [NOTE: this is a change in definition]
7	7	surveyID + ipptopsps : internal, from survey name

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian

r37474	r37592
1	1
2	2	objID dimensionless BIGINT 8 NA ODM object identifier
3		unique~~_psps_st_~~id dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
	3	uniquePspsSTid dimensionless BIGINT 8 NA unique identifier provided by ipptopsps
4	4	ippbjID dimensionless BIGINT 8 NA object ID generated by IPP
5	5	randomStackObjID dimensionless BIGINT 8 NA random stack id

trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES/Fundamental_IPP_Data_Product_Tables/StackPetrosian.txt

r37474	r37592
1	1
2	2	objID + from StackObjectThin
3		unique~~_psps_st_~~id = ipptopsps
	3	uniquePspsSTid = ipptopsps
4	4	ippobjID + from StackObjectThin
5	5	randomStackObjID + from StackObjectThin

Note: See TracChangeset for help on using the changeset viewer.

Context Navigation

Changeset 37592 for trunk/ippToPsps/pspsschema/SchemaNew19.0/PSPS_TABLES

Legend:

Download in other formats: