== Init Batch (IN) == Init batches have a lot of tables, consisting of metadata tables. These are the ones that ipptopsps is responsible for * Filter * FitModel * Survey * CameraConfig * PhotoCal * SkyCell * ProjectionCell * Region * StackType * ImageFlags * StackDetectionFlags * DetectionFlags * ObjectInfoFlags * ObjectFilterFlags * ObjectQualityFlags --------------------------- Filter VOTable description of PSPS table Filter --------------------------- ||filterID || || TINYINT 1 || ||filter ID: g=1, r=2, i=3, z=4, y=5, w=6, ...|| ||filterType || || VARCHAR(100) || ||filter name: g,r,i,z,y, etc.|| ||filterSpec || || VARCHAR(100) || ||No comment|| --------------------------- FitModel VOTable description of PSPS table FitModel --------------------------- ||fitModelID || || SMALLINT 2 || ||indentifier of alternate model fit|| ||name || || VARCHAR(100) || ||model name|| ||description || || VARCHAR(100) || ||string describing the model|| ||param1 || || VARCHAR(100) || ||description of model parameter 1|| ||param2 || || VARCHAR(100) || ||description of model parameter 2|| ||param3 || || VARCHAR(100) || ||description of model parameter 3|| ||param4 || || VARCHAR(100) || ||description of model parameter 4|| ||param5 || || VARCHAR(100) || ||description of model parameter 5|| ||param6 || || VARCHAR(100) || ||description of model parameter 6|| ||param7 || || VARCHAR(100) || ||description of model parameter 7|| ||param8 || || VARCHAR(100) || ||description of model parameter 8|| ||param9 || || VARCHAR(100) || ||description of model parameter 9|| ||param10 || || VARCHAR(100) || ||description of model parameter 10|| ||param11 || || VARCHAR(100) || ||description of model parameter 11|| ||param12 || || VARCHAR(100) || ||description of model parameter 12|| ||param13 || || VARCHAR(100) || ||description of model parameter 13|| ||param14 || || VARCHAR(100) || ||description of model parameter 14|| ||param15 || || VARCHAR(100) || ||description of model parameter 15|| ||param16 || || VARCHAR(100) || ||description of model parameter 16|| ||param17 || || VARCHAR(100) || ||description of model parameter 17|| ||param18 || || VARCHAR(100) || ||description of model parameter 18|| ||param19 || || VARCHAR(100) || ||description of model parameter 19|| ||param20 || || VARCHAR(100) || ||description of model parameter 20|| ||param21 || || VARCHAR(100) || ||description of model parameter 21|| ||param22 || || VARCHAR(100) || ||description of model parameter 22|| ||param23 || || VARCHAR(100) || ||description of model parameter 23|| ||param24 || || VARCHAR(100) || ||description of model parameter 24|| ||param25 || || VARCHAR(100) || ||description of model parameter 25|| ||param26 || || VARCHAR(100) || ||description of model parameter 26|| ||param27 || || VARCHAR(100) || ||description of model parameter 27|| ||param28 || || VARCHAR(100) || ||description of model parameter 28|| ||param29 || || VARCHAR(100) || ||description of model parameter 29|| ||param30 || || VARCHAR(100) || ||description of model parameter 30|| ||param31 || || VARCHAR(100) || ||description of model parameter 31|| ||param32 || || VARCHAR(100) || ||description of model parameter 32|| ||param33 || || VARCHAR(100) || ||description of model parameter 33|| ||param34 || || VARCHAR(100) || ||description of model parameter 34|| ||param35 || || VARCHAR(100) || ||description of model parameter 35|| ||param36 || || VARCHAR(100) || ||description of model parameter 36|| ||param37 || || VARCHAR(100) || ||description of model parameter 37|| ||param38 || || VARCHAR(100) || ||description of model parameter 38|| ||param39 || || VARCHAR(100) || ||description of model parameter 39|| --------------------------- Survey VOTable description of PSPS table Survey --------------------------- ||surveyID || || TINYINT 1 || ||index of survey type|| ||name || || VARCHAR(100) || ||survey name|| ||description || || VARCHAR(100) || ||survey description|| --------------------------- CameraConfig VOTable description of PSPS table CameraConfig --------------------------- ||cameraID || || SMALLINT 2 || ||camera identification number|| ||cameraConfigID || || SMALLINT 2 || ||configuration identification number|| ||endDate || || REAL 4 || || ending date of this configuration in MJD (unit = day)|| ||configDetails || || VARCHAR(100) || ||text/table giving the details of the camera configuration|| --------------------------- PhotoCal VOTable description of PSPS table PhotoCal --------------------------- ||photoCalID || || INT 4 || ||numerical code for this reduction|| ||filterID || || TINYINT 1 || ||filter id|| ||photoCodeDesc || || VARCHAR(100) || ||Photometry reduction code name|| ||AB || || REAL 4 || ||AB magnitude|| ||zeropoint || || REAL 4 || ||photometric zero point (excluding long term variation)|| ||extinction || || REAL 4 || ||photometric extinction term (excluding long term variation)|| ||colorterm || || REAL 4 || ||photometric color term (excluding long term variation)|| ||colorExtn || || REAL 4 || ||photometric color dependent extinction (excluding long term variation)|| ||orphanCalColor || || REAL 4 || ||color adopted for magnitude calculation|| ||orphanCalColorErr|| || REAL 4 || ||error in calibrating color|| ||startDate || || REAL 4 || || starting date of this configuration in MJD (unit = day)|| --------------------------- SkyCell VOTable description of PSPS table SkyCell --------------------------- ||skyCellID || || INT 4 || ||indentifier of the sky cell|| ||projectionCellID || || INT 4 || ||indentifier of the projection cell|| ||partitionKey || || BIGINT 8 || ||fgetPANobjID(skyCell_center_ra, skyCell_center_dec, zHeight)|| ||regionID || || BIGINT 8 || ||region identifier in the Region table|| --------------------------- ProjectionCell VOTable description of PSPS table ProjectionCell --------------------------- ||projectionCellID || || INT 4 || ||projection cell unique identifier|| ||partitionKey || || BIGINT 8 || ||fGetPanObjID(crval1,crval2)|| ||primaryCellRegionID|| || BIGINT 8 || ||reference to the primary cell region definition in the Region table|| ||projectionCellRegionID|| || BIGINT 8 || ||reference to the projectio cell region definition in the Region table)|| ||ctype1 || || VARCHAR(100) || ||name of astrometric projection in RA|| ||ctype2 || || VARCHAR(100) || ||name of astrometric projection in DEC|| ||crval1 || || FLOAT 8 || || RA corresponding to reference pixel (unit = deg)|| ||crval2 || || FLOAT 8 || || DEC corresponding to reference pixel (unit = deg)|| ||crpix1 || || FLOAT 8 || ||reference pixel value for RA|| ||crpix2 || || FLOAT 8 || ||reference pixel value for DEC|| ||pc001001 || || FLOAT 8 || ||elements of rotation/scale matrix|| ||pc001002 || || FLOAT 8 || ||elements of rotation/scale matrix|| ||pc002001 || || FLOAT 8 || ||elements of rotation/scale matrix|| ||pc002002 || || FLOAT 8 || ||elements of rotation/scale matrix|| --------------------------- Region VOTable description of PSPS table Region --------------------------- ||regionID || || BIGINT 8 || ||Unique Region identifier|| ||id || || BIGINT 8 || ||Custom Identifier|| ||type || || VARCHAR(100) || ||Region type|| ||comment || || VARCHAR(100) || ||Comment|| ||area || || FLOAT 8 || ||Area covered by the region|| ||regionBinary || || VARCHAR(100) || ||Binary object managed by the spatial library|| --------------------------- StackType VOTable description of PSPS table StackType --------------------------- ||stackTypeID || || TINYINT 1 || ||stack type identifier|| ||name || || VARCHAR(100) || ||stack type name|| ||description || || VARCHAR(100) || ||stack type description|| --------------------------- ImageFlags VOTable description of PSPS table ImageFlags --------------------------- ||name || || VARCHAR(100) || ||Name of flag|| ||value || || BIGINT 8 || ||Flag value|| ||description || || VARCHAR(100) || ||Description of the flag|| --------------------------- StackDetectionFlags VOTable description of PSPS table DetectionFlags --------------------------- ||name || || VARCHAR(100) || ||Name of flag|| ||value || || BIGINT 8 || ||Flag value|| ||description || || VARCHAR(100) || ||Description of the flag|| --------------------------- DetectionFlags VOTable description of PSPS table DetectionFlags --------------------------- ||name || || VARCHAR(100) || ||Name of flag|| ||value || || BIGINT 8 || ||Flag value|| ||description || || VARCHAR(100) || ||Description of the flag|| --------------------------- ObjectInfoFlags VOTable description of PSPS table ObjectInfoFlags --------------------------- ||name || || VARCHAR(100) || ||Name of flag|| ||value || || BIGINT 8 || ||Flag value|| ||description || || VARCHAR(100) || ||Description of the flag|| --------------------------- ObjectFilterFlags VOTable description of PSPS table ObjectInfoFlags --------------------------- ||name || || VARCHAR(100) || ||Name of flag|| ||value || || BIGINT 8 || ||Flag value|| ||description || || VARCHAR(100) || ||Description of the flag|| --------------------------- ObjectQualityFlags VOTable description of PSPS table ObjectInfoFlags --------------------------- ||name || || VARCHAR(100) || ||Name of flag|| ||value || || BIGINT 8 || ||Flag value|| ||description || || VARCHAR(100) || ||Description of the flag||