IPP Software Navigation Tools IPP Links Communication Pan-STARRS Links

Changeset 29164


Ignore:
Timestamp:
Sep 15, 2010, 2:44:24 PM (16 years ago)
Author:
rhenders
Message:

Changes to tables to be used for stacks

File:
1 edited

Legend:

Unmodified
Added
Removed

  • trunk/ippToPsps/config/stack/tables.xml

    r27361 r29164  
    11<?xml version="1.0" encoding="UTF-8"?>
    22
    3 <tableDescriptions type="ST">
     3<tableDescriptions type="stack">
    44  <table name="StackMeta">
    55    <column name="stackMetaID" type="TLONGLONG" default="0" comment="stack identifier"></column>
    … …  
    3030    <column name="ctype1" type="TSTRING" default=" " comment="name of astrometric projection in RA"></column>
    3131    <column name="ctype2" type="TSTRING" default=" " comment="name of astrometric projection in DEC"></column>
    32     <column name="crval1" type="TFLOAT" default="-999" comment="RA corresponding to reference pixel"></column>
    33     <column name="crval2" type="TFLOAT" default="-999" comment="DEC corresponding to reference pixel"></column>
    34     <column name="crpix1" type="TFLOAT" default="-999" comment="reference pixel value for RA"></column>
    35     <column name="crpix2" type="TFLOAT" default="-999" comment="reference pixel value for DEC"></column>
    36     <column name="pc001001" type="TFLOAT" default="-999" comment="elements of rotation/Dcale matrix"></column>
    37     <column name="pc001002" type="TFLOAT" default="-999" comment="elements of rotation/Dcale matrix"></column>
    38     <column name="pc002001" type="TFLOAT" default="-999" comment="elements of rotation/Dcale matrix"></column>
    39     <column name="pc002002" type="TFLOAT" default="-999" comment="elements of rotation/Dcale matrix"></column>
     32    <column name="crval1" type="TDOUBLE" default="-999" comment="RA corresponding to reference pixel"></column>
     33    <column name="crval2" type="TDOUBLE" default="-999" comment="DEC corresponding to reference pixel"></column>
     34    <column name="crpix1" type="TDOUBLE" default="-999" comment="reference pixel value for RA"></column>
     35    <column name="crpix2" type="TDOUBLE" default="-999" comment="reference pixel value for DEC"></column>
     36    <column name="cdelt1" type="TDOUBLE" default="-999" comment="scale factor for RA"></column>
     37    <column name="cdelt2" type="TDOUBLE" default="-999" comment="scale factor for DEC"></column>
     38    <column name="pc001001" type="TDOUBLE" default="-999" comment="elements of rotation/Dcale matrix"></column>
     39    <column name="pc001002" type="TDOUBLE" default="-999" comment="elements of rotation/Dcale matrix"></column>
     40    <column name="pc002001" type="TDOUBLE" default="-999" comment="elements of rotation/Dcale matrix"></column>
     41    <column name="pc002002" type="TDOUBLE" default="-999" comment="elements of rotation/Dcale matrix"></column>
    4042    <column name="polyOrder" type="TBYTE" default="255" comment="polynomial order of astrometry fit"></column>
    41     <column name="pca1x3y0" type="TFLOAT" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
    42     <column name="pca1x2y1" type="TFLOAT" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
    43     <column name="pca1x1y2" type="TFLOAT" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
    44     <column name="pca1x0y3" type="TFLOAT" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
    45     <column name="pca1x2y0" type="TFLOAT" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
    46     <column name="pca1x1y1" type="TFLOAT" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
    47     <column name="pca1x0y2" type="TFLOAT" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
    48     <column name="pca2x3y0" type="TFLOAT" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
    49     <column name="pca2x2y1" type="TFLOAT" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
    50     <column name="pca2x1y2" type="TFLOAT" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
    51     <column name="pca2x0y3" type="TFLOAT" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
    52     <column name="pca2x2y0" type="TFLOAT" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
    53     <column name="pca2x1y1" type="TFLOAT" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
    54     <column name="pca2x0y2" type="TFLOAT" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
     43    <column name="pca1x3y0" type="TDOUBLE" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
     44    <column name="pca1x2y1" type="TDOUBLE" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
     45    <column name="pca1x1y2" type="TDOUBLE" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
     46    <column name="pca1x0y3" type="TDOUBLE" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
     47    <column name="pca1x2y0" type="TDOUBLE" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
     48    <column name="pca1x1y1" type="TDOUBLE" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
     49    <column name="pca1x0y2" type="TDOUBLE" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
     50    <column name="pca2x3y0" type="TDOUBLE" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
     51    <column name="pca2x2y1" type="TDOUBLE" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
     52    <column name="pca2x1y2" type="TDOUBLE" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
     53    <column name="pca2x0y3" type="TDOUBLE" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
     54    <column name="pca2x2y0" type="TDOUBLE" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
     55    <column name="pca2x1y1" type="TDOUBLE" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
     56    <column name="pca2x0y2" type="TDOUBLE" default="-999" comment="polynomial coefficients for the astrometric fit"></column>
    5557    <column name="calibModNum" type="TSHORT" default="0" comment="calibration modification number"></column>
    5658    <column name="dataRelease" type="TBYTE" default="0" comment="Data release"></column>
    … …  
    6971    <column name="projectionCellID" type="TLONG" default="-999" comment="projection cell identifier"></column>
    7072    <column name="stackVer" type="TSHORT" default="-999" comment="version number of this stack"></column>
    71     <column name="obsTime" type="TFLOAT" default="-999" comment=" Time of mid observation (unit = day)"></column>
     73    <column name="obsTime" type="TDOUBLE" default="-999" comment=" Time of mid observation (unit = day)"></column>
    7274    <column name="xPos" type="TFLOAT" default="-999" comment="measured x on CCD from PSF fit"></column>
    7375    <column name="yPos" type="TFLOAT" default="-999" comment="measured y on CCD from PSF fit"></column>
    … …  
    103105    <column name="dataRelease" type="TBYTE" default="0" comment="Data release when this detection was originally taken."></column>
    104106  </table>
    105   <table name="SkinnyObject">
    106     <column name="objID" type="TLONGLONG" default="0" comment="ODM object identifier index"></column>
    107     <column name="ippObjID" type="TLONGLONG" default="0" comment="IPP object number"></column>
    108     <column name="projectionCellID" type="TLONG" default="-999" comment="projection cell identifier at discovery time"></column>
    109     <column name="dataRelease" type="TBYTE" default="0" comment="Data release to propagate to the object"></column>
    110   </table>
    111   <table name="StackOrphan">
    112     <column name="partitionKey" type="TLONGLONG" default="0" comment="partitioning key"></column>
    113     <column name="stackDetectID" type="TLONGLONG" default="0" comment="detection identifier"></column>
     107  <table name="StackApFlx">
     108    <column name="objID" type="TLONGLONG" default="0" comment="ODM object identifier"></column>
     109    <column name="stackDetectID" type="TLONGLONG" default="0" comment="ODM detection identifier"></column>
     110    <column name="ippObjID" type="TLONGLONG" default="0" comment="IPP object identifier"></column>
    114111    <column name="ippDetectID" type="TLONGLONG" default="0" comment="detection ID generated by IPP"></column>
    115112    <column name="filterID" type="TBYTE" default="0" comment="filter identifier"></column>
    116113    <column name="stackTypeID" type="TBYTE" default="0" comment="stack type identifier"></column>
    117     <column name="surveyID" type="TBYTE" default="0" comment="survey identifier"></column>
     114    <column name="surveyID" type="TBYTE" default="0" comment="survey flag identifier"></column>
    118115    <column name="primaryF" type="TBYTE" default="255" comment="identifies best stack detection for Stacks overlapping the same region of the sky."></column>
    119116    <column name="stackMetaID" type="TLONGLONG" default="0" comment="stack identifier"></column>
    120     <column name="skyCellID" type="TLONG" default="-999" comment="skycell identifier"></column>
    121     <column name="stackVer" type="TSHORT" default="-999" comment="version number of this stack"></column>
    122     <column name="xPos" type="TFLOAT" default="-999" comment="measured x on CCD from PSF fit"></column>
    123     <column name="yPos" type="TFLOAT" default="-999" comment="measured y on CCD from PSF fit"></column>
    124     <column name="xPosErr" type="TFLOAT" default="-999" comment="estimated error in x"></column>
    125     <column name="yPosErr" type="TFLOAT" default="-999" comment="estimated error in y"></column>
    126     <column name="instFlux" type="TFLOAT" default="-999" comment="PSF instrumental flux"></column>
    127     <column name="instFluxErr" type="TFLOAT" default="-999" comment="estimated error in instrumental flux"></column>
    128     <column name="peakFlux" type="TFLOAT" default="-999" comment="ratio of peak flux to total flux"></column>
    129     <column name="sky" type="TFLOAT" default="-999" comment="PSF sky level at source (adu)"></column>
    130     <column name="skyErr" type="TFLOAT" default="-999" comment="estimated error in sky"></column>
    131     <column name="sgSep" type="TFLOAT" default="-999" comment="star/galaxy separator"></column>
    132     <column name="psfWidMajor" type="TFLOAT" default="-999" comment="PSF width in major axis"></column>
    133     <column name="psfWidMinor" type="TFLOAT" default="-999" comment="PSF width in minor axis"></column>
    134     <column name="psfTheta" type="TFLOAT" default="-999" comment="PSF orientation angle"></column>
    135     <column name="psfLikelihood" type="TFLOAT" default="-999" comment="PSF likelihood"></column>
    136     <column name="psfCf" type="TFLOAT" default="-999" comment="PSF coverage factor"></column>
    137     <column name="infoFlag" type="TLONG" default="-999" comment="indicator of strange propeties"></column>
    138     <column name="nFrames" type="TLONG" default="-999" comment="number of frames contributing to source"></column>
    139     <column name="wlSigma" type="TFLOAT" default="-999" comment="weak lensing sigma"></column>
    140     <column name="eps1" type="TFLOAT" default="-999" comment="weak lensing vector element eps(1)"></column>
    141     <column name="eps2" type="TFLOAT" default="-999" comment="weak lensing vector element eps(2)"></column>
    142     <column name="Psm11" type="TFLOAT" default="-999" comment="weak lensing matrix element P_sm(1,1)"></column>
    143     <column name="Psm12" type="TFLOAT" default="-999" comment="weak lensing matrix element P_sm(1,2)"></column>
    144     <column name="Psm21" type="TFLOAT" default="-999" comment="weak lensing matrix element P_sm(2,1)"></column>
    145     <column name="Psm22" type="TFLOAT" default="-999" comment="weak lensing matrix element P_sm(2,2)"></column>
    146     <column name="Psh11" type="TFLOAT" default="-999" comment="weak lensing matrix element P_sh(1,1)"></column>
    147     <column name="Psh12" type="TFLOAT" default="-999" comment="weak lensing matrix element P_sh(1,2)"></column>
    148     <column name="Psh21" type="TFLOAT" default="-999" comment="weak lensing matrix element P_sh(2,1)"></column>
    149     <column name="Psh22" type="TFLOAT" default="-999" comment="weak lensing matrix element P_sh(2,2)"></column>
     117    <column name="isophotMag" type="TFLOAT" default="-999" comment="isophotal magnitude"></column>
     118    <column name="isophotMagErr" type="TFLOAT" default="-999" comment="estimated error in isophotal magnitude"></column>
     119    <column name="isophotMajAxis" type="TFLOAT" default="-999" comment="isophotal Major Axis"></column>
     120    <column name="isophotMajAxisErr" type="TFLOAT" default="-999" comment="estimated error in isophotal Major Axis"></column>
     121    <column name="isophotMinAxis" type="TFLOAT" default="-999" comment="isophotal Minor Axis"></column>
     122    <column name="isophotMinAxisErr" type="TFLOAT" default="-999" comment="estimated error in isophotal Minor Axis"></column>
     123    <column name="isophotMajAxisGrad" type="TFLOAT" default="-999" comment="isophotal major axis gradient"></column>
     124    <column name="isophotMinAxisGrad" type="TFLOAT" default="-999" comment="isophotal minor axis gradient"></column>
     125    <column name="isophotPA" type="TFLOAT" default="-999" comment="isophotal position angle"></column>
     126    <column name="isophotPAErr" type="TFLOAT" default="-999" comment="estimated error in isophotal position angle"></column>
     127    <column name="isophotPAGrad" type="TFLOAT" default="-999" comment="isophotal position angle gradient"></column>
     128    <column name="petRadius" type="TFLOAT" default="-999" comment="Petrosian radius"></column>
     129    <column name="petRadiusErr" type="TFLOAT" default="-999" comment="estimated error inPetrosian radius"></column>
     130    <column name="petMag" type="TFLOAT" default="-999" comment="Petrosian magntiude"></column>
     131    <column name="petMagErr" type="TFLOAT" default="-999" comment="estimated error in petMag"></column>
     132    <column name="petR50" type="TFLOAT" default="-999" comment="Petrosian radius at 50% light"></column>
     133    <column name="petR50Err" type="TFLOAT" default="-999" comment="estimated error inPetrosian radius at 50% light"></column>
     134    <column name="petR90" type="TFLOAT" default="-999" comment="Petrosian radius at 90% light"></column>
     135    <column name="petR90Err" type="TFLOAT" default="-999" comment="estimated error in Petrosian radius at 90% light"></column>
     136    <column name="petCf" type="TFLOAT" default="-999" comment="Petrosian fit coverage factor"></column>
     137    <column name="flxR1" type="TFLOAT" default="-999" comment="Flux inside r = 1"></column>
     138    <column name="flxR1Err" type="TFLOAT" default="-999" comment="estimated error is flxR1"></column>
     139    <column name="flxR1Var" type="TFLOAT" default="-999" comment="estimated variance in flxR1"></column>
     140    <column name="flxR2" type="TFLOAT" default="-999" comment="Flux inside r = 2"></column>
     141    <column name="flxR2Err" type="TFLOAT" default="-999" comment="estimated error is flxR2"></column>
     142    <column name="flxR2Var" type="TFLOAT" default="-999" comment="estimated variance in flxR2"></column>
     143    <column name="flxR3" type="TFLOAT" default="-999" comment="Flux inside r = 3"></column>
     144    <column name="flxR3Err" type="TFLOAT" default="-999" comment="estimated error is flxR3"></column>
     145    <column name="flxR3Var" type="TFLOAT" default="-999" comment="estimated variance in flxR3"></column>
     146    <column name="flxR4" type="TFLOAT" default="-999" comment="Flux inside r = 4"></column>
     147    <column name="flxR4Err" type="TFLOAT" default="-999" comment="estimated error is flxR4"></column>
     148    <column name="flxR4Var" type="TFLOAT" default="-999" comment="estimated variance in flxR4"></column>
     149    <column name="flxR5" type="TFLOAT" default="-999" comment="Flux inside r = 5"></column>
     150    <column name="flxR5Err" type="TFLOAT" default="-999" comment="estimated error is flxR5"></column>
     151    <column name="flxR5Var" type="TFLOAT" default="-999" comment="estimated variance in flxR5"></column>
     152    <column name="flxR6" type="TFLOAT" default="-999" comment="Flux inside r = 6"></column>
     153    <column name="flxR6Err" type="TFLOAT" default="-999" comment="estimated error is flxR6"></column>
     154    <column name="flxR6Var" type="TFLOAT" default="-999" comment="estimated variance in flxR6"></column>
     155    <column name="flxR7" type="TFLOAT" default="-999" comment="Flux inside r = 7"></column>
     156    <column name="flxR7Err" type="TFLOAT" default="-999" comment="estimated error is flxR7"></column>
     157    <column name="flxR7Var" type="TFLOAT" default="-999" comment="estimated variance in flxR7"></column>
     158    <column name="flxR8" type="TFLOAT" default="-999" comment="Flux inside r = 8"></column>
     159    <column name="flxR8Err" type="TFLOAT" default="-999" comment="estimated error is flxR8"></column>
     160    <column name="flxR8Var" type="TFLOAT" default="-999" comment="estimated variance in flxR8"></column>
     161    <column name="flxR9" type="TFLOAT" default="-999" comment="Flux inside r = 9"></column>
     162    <column name="flxR9Err" type="TFLOAT" default="-999" comment="estimated error is flxR9"></column>
     163    <column name="flxR9Var" type="TFLOAT" default="-999" comment="estimated variance in flxR9"></column>
     164    <column name="flxR10" type="TFLOAT" default="-999" comment="Flux inside r = 10"></column>
     165    <column name="flxR10Err" type="TFLOAT" default="-999" comment="estimated error is flxR10"></column>
     166    <column name="flxR10Var" type="TFLOAT" default="-999" comment="estimated variance in flxR10"></column>
     167    <column name="c1FlxR1" type="TFLOAT" default="-999" comment="Flux inside r = 1"></column>
     168    <column name="c1FlxR1Err" type="TFLOAT" default="-999" comment="estimated error is c1FlxR1"></column>
     169    <column name="c1FlxR1Var" type="TFLOAT" default="-999" comment="estimated variance in c1FlxR1"></column>
     170    <column name="c1FlxR2" type="TFLOAT" default="-999" comment="Flux inside r = 2"></column>
     171    <column name="c1FlxR2Err" type="TFLOAT" default="-999" comment="estimated error is c1FlxR2"></column>
     172    <column name="c1FlxR2Var" type="TFLOAT" default="-999" comment="estimated variance in c1FlxR2"></column>
     173    <column name="c1FlxR3" type="TFLOAT" default="-999" comment="Flux inside r = 3"></column>
     174    <column name="c1FlxR3Err" type="TFLOAT" default="-999" comment="estimated error is c1FlxR3"></column>
     175    <column name="c1FlxR3Var" type="TFLOAT" default="-999" comment="estimated variance in c1FlxR3"></column>
     176    <column name="c1FlxR4" type="TFLOAT" default="-999" comment="Flux inside r = 4"></column>
     177    <column name="c1FlxR4Err" type="TFLOAT" default="-999" comment="estimated error is c1FlxR4"></column>
     178    <column name="c1FlxR4Var" type="TFLOAT" default="-999" comment="estimated variance in c1FlxR4"></column>
     179    <column name="c1FlxR5" type="TFLOAT" default="-999" comment="Flux inside r = 5"></column>
     180    <column name="c1FlxR5Err" type="TFLOAT" default="-999" comment="estimated error is c1FlxR5"></column>
     181    <column name="c1FlxR5Var" type="TFLOAT" default="-999" comment="estimated variance in c1FlxR5"></column>
     182    <column name="c1FlxR6" type="TFLOAT" default="-999" comment="Flux inside r = 6"></column>
     183    <column name="c1FlxR6Err" type="TFLOAT" default="-999" comment="estimated error is c1FlxR6"></column>
     184    <column name="c1FlxR6Var" type="TFLOAT" default="-999" comment="estimated variance in c1FlxR6"></column>
     185    <column name="c1FlxR7" type="TFLOAT" default="-999" comment="Flux inside r = 7"></column>
     186    <column name="c1FlxR7Err" type="TFLOAT" default="-999" comment="estimated error is c1FlxR7"></column>
     187    <column name="c1FlxR7Var" type="TFLOAT" default="-999" comment="estimated variance in c1FlxR7"></column>
     188    <column name="c1FlxR8" type="TFLOAT" default="-999" comment="Flux inside r = 8"></column>
     189    <column name="c1FlxR8Err" type="TFLOAT" default="-999" comment="estimated error is c1FlxR8"></column>
     190    <column name="c1FlxR8Var" type="TFLOAT" default="-999" comment="estimated variance in c1FlxR8"></column>
     191    <column name="c1FlxR9" type="TFLOAT" default="-999" comment="Flux inside r = 9"></column>
     192    <column name="c1FlxR9Err" type="TFLOAT" default="-999" comment="estimated error is c1FlxR9"></column>
     193    <column name="c1FlxR9Var" type="TFLOAT" default="-999" comment="estimated variance in c1FlxR9"></column>
     194    <column name="c1FlxR10" type="TFLOAT" default="-999" comment="Flux inside r = 10"></column>
     195    <column name="c1FlxR10Err" type="TFLOAT" default="-999" comment="estimated error is c1FlxR10"></column>
     196    <column name="c1FlxR10Var" type="TFLOAT" default="-999" comment="estimated variance in c1FlxR10"></column>
     197    <column name="c2FlxR1" type="TFLOAT" default="-999" comment="Flux inside r = 1"></column>
     198    <column name="c2FlxR1Err" type="TFLOAT" default="-999" comment="estimated error is c2FlxR1"></column>
     199    <column name="c2FlxR1Var" type="TFLOAT" default="-999" comment="estimated variance in c2FlxR1"></column>
     200    <column name="c2FlxR2" type="TFLOAT" default="-999" comment="Flux inside r = 2"></column>
     201    <column name="c2FlxR2Err" type="TFLOAT" default="-999" comment="estimated error is c2FlxR2"></column>
     202    <column name="c2FlxR2Var" type="TFLOAT" default="-999" comment="estimated variance in c2FlxR2"></column>
     203    <column name="c2FlxR3" type="TFLOAT" default="-999" comment="Flux inside r = 3"></column>
     204    <column name="c2FlxR3Err" type="TFLOAT" default="-999" comment="estimated error is c2FlxR3"></column>
     205    <column name="c2FlxR3Var" type="TFLOAT" default="-999" comment="estimated variance in c2FlxR3"></column>
     206    <column name="c2FlxR4" type="TFLOAT" default="-999" comment="Flux inside r = 4"></column>
     207    <column name="c2FlxR4Err" type="TFLOAT" default="-999" comment="estimated error is c2FlxR4"></column>
     208    <column name="c2FlxR4Var" type="TFLOAT" default="-999" comment="estimated variance in c2FlxR4"></column>
     209    <column name="c2FlxR5" type="TFLOAT" default="-999" comment="Flux inside r = 5"></column>
     210    <column name="c2FlxR5Err" type="TFLOAT" default="-999" comment="estimated error is c2FlxR5"></column>
     211    <column name="c2FlxR5Var" type="TFLOAT" default="-999" comment="estimated variance in c2FlxR5"></column>
     212    <column name="c2FlxR6" type="TFLOAT" default="-999" comment="Flux inside r = 6"></column>
     213    <column name="c2FlxR6Err" type="TFLOAT" default="-999" comment="estimated error is c2FlxR6"></column>
     214    <column name="c2FlxR6Var" type="TFLOAT" default="-999" comment="estimated variance in c2FlxR6"></column>
     215    <column name="c2FlxR7" type="TFLOAT" default="-999" comment="Flux inside r = 7"></column>
     216    <column name="c2FlxR7Err" type="TFLOAT" default="-999" comment="estimated error is c2FlxR7"></column>
     217    <column name="c2FlxR7Var" type="TFLOAT" default="-999" comment="estimated variance in c2FlxR7"></column>
     218    <column name="c2FlxR8" type="TFLOAT" default="-999" comment="Flux inside r = 8"></column>
     219    <column name="c2FlxR8Err" type="TFLOAT" default="-999" comment="estimated error is c2FlxR8"></column>
     220    <column name="c2FlxR8Var" type="TFLOAT" default="-999" comment="estimated variance in c2FlxR8"></column>
     221    <column name="c2FlxR9" type="TFLOAT" default="-999" comment="Flux inside r = 9"></column>
     222    <column name="c2FlxR9Err" type="TFLOAT" default="-999" comment="estimated error is c2FlxR9"></column>
     223    <column name="c2FlxR9Var" type="TFLOAT" default="-999" comment="estimated variance in c2FlxR9"></column>
     224    <column name="c2FlxR10" type="TFLOAT" default="-999" comment="Flux inside r = 10"></column>
     225    <column name="c2FlxR10Err" type="TFLOAT" default="-999" comment="estimated error is c2FlxR10"></column>
     226    <column name="c2FlxR10Var" type="TFLOAT" default="-999" comment="estimated variance in c2FlxR10"></column>
     227    <column name="c3FlxR1" type="TFLOAT" default="-999" comment="Flux inside r = 1"></column>
     228    <column name="c3FlxR1Err" type="TFLOAT" default="-999" comment="estimated error is c3FlxR1"></column>
     229    <column name="c3FlxR1Var" type="TFLOAT" default="-999" comment="estimated variance in c3FlxR1"></column>
     230    <column name="c3FlxR2" type="TFLOAT" default="-999" comment="Flux inside r = 2"></column>
     231    <column name="c3FlxR2Err" type="TFLOAT" default="-999" comment="estimated error is c3FlxR2"></column>
     232    <column name="c3FlxR2Var" type="TFLOAT" default="-999" comment="estimated variance in c3FlxR2"></column>
     233    <column name="c3FlxR3" type="TFLOAT" default="-999" comment="Flux inside r = 3"></column>
     234    <column name="c3FlxR3Err" type="TFLOAT" default="-999" comment="estimated error is c3FlxR3"></column>
     235    <column name="c3FlxR3Var" type="TFLOAT" default="-999" comment="estimated variance in c3FlxR3"></column>
     236    <column name="c3FlxR4" type="TFLOAT" default="-999" comment="Flux inside r = 4"></column>
     237    <column name="c3FlxR4Err" type="TFLOAT" default="-999" comment="estimated error is c3FlxR4"></column>
     238    <column name="c3FlxR4Var" type="TFLOAT" default="-999" comment="estimated variance in c3FlxR4"></column>
     239    <column name="c3FlxR5" type="TFLOAT" default="-999" comment="Flux inside r = 5"></column>
     240    <column name="c3FlxR5Err" type="TFLOAT" default="-999" comment="estimated error is c3FlxR5"></column>
     241    <column name="c3FlxR5Var" type="TFLOAT" default="-999" comment="estimated variance in c3FlxR5"></column>
     242    <column name="c3FlxR6" type="TFLOAT" default="-999" comment="Flux inside r = 6"></column>
     243    <column name="c3FlxR6Err" type="TFLOAT" default="-999" comment="estimated error is c3FlxR6"></column>
     244    <column name="c3FlxR6Var" type="TFLOAT" default="-999" comment="estimated variance in c3FlxR6"></column>
     245    <column name="c3FlxR7" type="TFLOAT" default="-999" comment="Flux inside r = 7"></column>
     246    <column name="c3FlxR7Err" type="TFLOAT" default="-999" comment="estimated error is c3FlxR7"></column>
     247    <column name="c3FlxR7Var" type="TFLOAT" default="-999" comment="estimated variance in c3FlxR7"></column>
     248    <column name="c3FlxR8" type="TFLOAT" default="-999" comment="Flux inside r = 8"></column>
     249    <column name="c3FlxR8Err" type="TFLOAT" default="-999" comment="estimated error is c3FlxR8"></column>
     250    <column name="c3FlxR8Var" type="TFLOAT" default="-999" comment="estimated variance in c3FlxR8"></column>
     251    <column name="c3FlxR9" type="TFLOAT" default="-999" comment="Flux inside r = 9"></column>
     252    <column name="c3FlxR9Err" type="TFLOAT" default="-999" comment="estimated error is c3FlxR9"></column>
     253    <column name="c3FlxR9Var" type="TFLOAT" default="-999" comment="estimated variance in c3FlxR9"></column>
     254    <column name="c3FlxR10" type="TFLOAT" default="-999" comment="Flux inside r = 10"></column>
     255    <column name="c3FlxR10Err" type="TFLOAT" default="-999" comment="estimated error is c3FlxR10"></column>
     256    <column name="c3FlxR10Var" type="TFLOAT" default="-999" comment="estimated variance in c3FlxR10"></column>
     257    <column name="logC" type="TFLOAT" default="-999" comment="Abraham concentration index"></column>
     258    <column name="logA" type="TFLOAT" default="-999" comment="Abraham asymmetry index"></column>
    150259    <column name="activeFlag" type="TBYTE" default="-999" comment="indicates whether this detection/orphan is still a detection/orphan"></column>
    151     <column name="assocDate" type="TSTRING" default="28881231" comment="date object association assigned"></column>
    152     <column name="historyModNum" type="TSHORT" default="0" comment="modification number in the O-D association history"></column>
    153     <column name="dataRelease" type="TBYTE" default="0" comment="Data release to reproduce queries through data releases"></column>
    154   </table>
    155   <table name="ObjectCalColor">
     260    <column name="dataRelease" type="TBYTE" default="0" comment="Data release when this detection was taken"></column>
     261  </table>
     262  <table name="StackModelFit">
    156263    <column name="objID" type="TLONGLONG" default="0" comment="ODM object identifier"></column>
    157     <column name="ippObjID" type="TLONGLONG" default="0" comment="ipp object identifier"></column>
     264    <column name="stackDetectID" type="TLONGLONG" default="0" comment="ODM detection identifier"></column>
     265    <column name="ippObjID" type="TLONGLONG" default="0" comment="IPP object identifier"></column>
     266    <column name="ippDetectID" type="TLONGLONG" default="0" comment="detection ID generated by IPP"></column>
    158267    <column name="filterID" type="TBYTE" default="0" comment="filter identifier"></column>
    159     <column name="calColor" type="TFLOAT" default="0" comment=" color adopted for magnitude calculation (unit = mag)"></column>
    160     <column name="calColorErr" type="TFLOAT" default="0" comment=" error in calibrating color (unit = mag)"></column>
    161     <column name="calibModNum" type="TSHORT" default="0" comment="calibration modification number"></column>
    162     <column name="dataRelease" type="TBYTE" default="0" comment="Data release when this color calibration was established"></column>
     268    <column name="stackTypeID" type="TBYTE" default="0" comment="stack type identifier"></column>
     269    <column name="surveyID" type="TBYTE" default="0" comment="survey flag identifier"></column>
     270    <column name="primaryF" type="TBYTE" default="255" comment="identifies best stack detection for Stacks overlapping the same region of the sky."></column>
     271    <column name="stackMetaID" type="TLONGLONG" default="0" comment="stack identifier"></column>
     272    <column name="deVRadius" type="TFLOAT" default="-999" comment="deVaucouleurs radius"></column>
     273    <column name="deVRadiusErr" type="TFLOAT" default="-999" comment="estimated error in deVaucouleurs radius"></column>
     274    <column name="deVMag" type="TFLOAT" default="-999" comment="deVaucouleurs magntiude"></column>
     275    <column name="deVMagErr" type="TFLOAT" default="-999" comment="estimated error in deV_mag"></column>
     276    <column name="deVAb" type="TFLOAT" default="-999" comment="deVaucoulerus axis ratio"></column>
     277    <column name="deVAbErr" type="TFLOAT" default="-999" comment="estimated error in deVaucoulerus axis ratio"></column>
     278    <column name="raDeVOff" type="TFLOAT" default="-999" comment="Offset in RA of deVaucouleurs fit from PSF RA"></column>
     279    <column name="decDeVOff" type="TFLOAT" default="-999" comment="Offset in DEC of deVaucouleurs fit from PSF DEC"></column>
     280    <column name="raDeVOffErr" type="TFLOAT" default="-999" comment="estimated error in ra offset"></column>
     281    <column name="decDeVOffErr" type="TFLOAT" default="-999" comment="estimated error in dec offset"></column>
     282    <column name="deVCf" type="TFLOAT" default="-999" comment="deVaucouleurs fit coverage factor"></column>
     283    <column name="deVLikelihood" type="TFLOAT" default="-999" comment="deVaucouleurs fit likelihood factor"></column>
     284    <column name="deVCovar11" type="TFLOAT" default="-999" comment="covariance for deVaucouleurs fit"></column>
     285    <column name="deVCovar12" type="TFLOAT" default="-999" comment="covariance for deVaucouleurs fit"></column>
     286    <column name="deVCovar13" type="TFLOAT" default="-999" comment="covariance for deVaucouleurs fit"></column>
     287    <column name="deVCovar14" type="TFLOAT" default="-999" comment="covariance for deVaucouleurs fit"></column>
     288    <column name="deVCovar15" type="TFLOAT" default="-999" comment="covariance for deVaucouleurs fit"></column>
     289    <column name="deVCovar16" type="TFLOAT" default="-999" comment="covariance for deVaucouleurs fit"></column>
     290    <column name="deVCovar22" type="TFLOAT" default="-999" comment="covariance for deVaucouleurs fit"></column>
     291    <column name="deVCovar23" type="TFLOAT" default="-999" comment="covariance for deVaucouleurs fit"></column>
     292    <column name="deVCovar24" type="TFLOAT" default="-999" comment="covariance for deVaucouleurs fit"></column>
     293    <column name="deVCovar25" type="TFLOAT" default="-999" comment="covariance for deVaucouleurs fit"></column>
     294    <column name="deVCovar26" type="TFLOAT" default="-999" comment="covariance for deVaucouleurs fit"></column>
     295    <column name="deVCovar33" type="TFLOAT" default="-999" comment="covariance for deVaucouleurs fit"></column>
     296    <column name="deVCovar34" type="TFLOAT" default="-999" comment="covariance for deVaucouleurs fit"></column>
     297    <column name="deVCovar35" type="TFLOAT" default="-999" comment="covariance for deVaucouleurs fit"></column>
     298    <column name="deVCovar36" type="TFLOAT" default="-999" comment="covariance for deVaucouleurs fit"></column>
     299    <column name="deVCovar44" type="TFLOAT" default="-999" comment="covariance for deVaucouleurs fit"></column>
     300    <column name="deVCovar45" type="TFLOAT" default="-999" comment="covariance for deVaucouleurs fit"></column>
     301    <column name="deVCovar46" type="TFLOAT" default="-999" comment="covariance for deVaucouleurs fit"></column>
     302    <column name="deVCovar55" type="TFLOAT" default="-999" comment="covariance for deVaucouleurs fit"></column>
     303    <column name="deVCovar56" type="TFLOAT" default="-999" comment="covariance for deVaucouleurs fit"></column>
     304    <column name="deVCovar66" type="TFLOAT" default="-999" comment="covariance for deVaucouleurs fit"></column>
     305    <column name="expRadius" type="TFLOAT" default="-999" comment="Exponential fit radius"></column>
     306    <column name="expRadiusErr" type="TFLOAT" default="-999" comment="estimated error in Exponential fit radius"></column>
     307    <column name="expMag" type="TFLOAT" default="-999" comment="Exponential fit magntiude"></column>
     308    <column name="expMagErr" type="TFLOAT" default="-999" comment="estimated error in expMag"></column>
     309    <column name="expAb" type="TFLOAT" default="-999" comment="Exponential fit axis ratio"></column>
     310    <column name="expAbErr" type="TFLOAT" default="-999" comment="estimated error in Exponential fit axis ratio"></column>
     311    <column name="raExpOff" type="TFLOAT" default="-999" comment="Offset in RA of Exponential fit from PSF RA"></column>
     312    <column name="decExpOff" type="REAl" default="-999" comment="Offset in DEC of Exponential fit from PSF DEC"></column>
     313    <column name="raExpOffErr" type="TFLOAT" default="-999" comment="estimated error in raExpOff"></column>
     314    <column name="decExpOffErr" type="TFLOAT" default="-999" comment="estimated error in decExpOff"></column>
     315    <column name="expCf" type="TFLOAT" default="-999" comment="Exponential fit coverage factor"></column>
     316    <column name="expLikelihood" type="TFLOAT" default="-999" comment="Exponential fit likelihood factor"></column>
     317    <column name="expCovar11" type="TFLOAT" default="-999" comment="covariance for Exponential fit"></column>
     318    <column name="expCovar12" type="TFLOAT" default="-999" comment="covariance for Exponential fit"></column>
     319    <column name="expCovar13" type="TFLOAT" default="-999" comment="covariance for Exponential fit"></column>
     320    <column name="expCovar14" type="TFLOAT" default="-999" comment="covariance for Exponential fit"></column>
     321    <column name="expCovar15" type="TFLOAT" default="-999" comment="covariance for Exponential fit"></column>
     322    <column name="expCovar16" type="TFLOAT" default="-999" comment="covariance for Exponential fit"></column>
     323    <column name="expCovar22" type="TFLOAT" default="-999" comment="covariance for Exponential fit"></column>
     324    <column name="expCovar23" type="TFLOAT" default="-999" comment="covariance for Exponential fit"></column>
     325    <column name="expCovar24" type="TFLOAT" default="-999" comment="covariance for Exponential fit"></column>
     326    <column name="expCovar25" type="TFLOAT" default="-999" comment="covariance for Exponential fit"></column>
     327    <column name="expCovar26" type="TFLOAT" default="-999" comment="covariance for Exponential fit"></column>
     328    <column name="expCovar33" type="TFLOAT" default="-999" comment="covariance for Exponential fit"></column>
     329    <column name="expCovar34" type="TFLOAT" default="-999" comment="covariance for Exponential fit"></column>
     330    <column name="expCovar35" type="TFLOAT" default="-999" comment="covariance for Exponential fit"></column>
     331    <column name="expCovar36" type="TFLOAT" default="-999" comment="covariance for Exponential fit"></column>
     332    <column name="expCovar44" type="TFLOAT" default="-999" comment="covariance for Exponential fit"></column>
     333    <column name="expCovar45" type="TFLOAT" default="-999" comment="covariance for Exponential fit"></column>
     334    <column name="expCovar46" type="TFLOAT" default="-999" comment="covariance for Exponential fit"></column>
     335    <column name="expCovar55" type="TFLOAT" default="-999" comment="covariance for Exponential fit"></column>
     336    <column name="expCovar56" type="TFLOAT" default="-999" comment="covariance for Exponential fit"></column>
     337    <column name="expCovar66" type="TFLOAT" default="-999" comment="covariance for Exponential fit"></column>
     338    <column name="serRadius" type="TFLOAT" default="-999" comment="Sersic radius"></column>
     339    <column name="serRadiusErr" type="TFLOAT" default="-999" comment="estimated error in Sersic radius"></column>
     340    <column name="serMag" type="TFLOAT" default="-999" comment="Sersic magntiude"></column>
     341    <column name="serMagErr" type="TFLOAT" default="-999" comment="estimated error in serMag"></column>
     342    <column name="serAb" type="TFLOAT" default="-999" comment="Sersic axis ratio"></column>
     343    <column name="serAbErr" type="TFLOAT" default="-999" comment="estimated error in Sersic axis ratio"></column>
     344    <column name="serNu" type="TFLOAT" default="-999" comment="Sersic index"></column>
     345    <column name="serNuErr" type="TFLOAT" default="-999" comment="estimated error in Sersic index"></column>
     346    <column name="raSerOff" type="TFLOAT" default="-999" comment="Offset in RA of Sersic fit from PSF RA"></column>
     347    <column name="decSerOff" type="TFLOAT" default="-999" comment="Offset in DEC of Sersic fit from PSF DEC"></column>
     348    <column name="raSerOffErr" type="TFLOAT" default="-999" comment="estimated error in raSerOff"></column>
     349    <column name="decSerOffErr" type="TFLOAT" default="-999" comment="estimated error in decSerOff"></column>
     350    <column name="serCf" type="TFLOAT" default="-999" comment="Sersic fit coverage factor"></column>
     351    <column name="serLikelihood" type="TFLOAT" default="-999" comment="Sersic fit likelihood factor"></column>
     352    <column name="sersicCovar11" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     353    <column name="sersicCovar12" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     354    <column name="sersicCovar13" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     355    <column name="sersicCovar14" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     356    <column name="sersicCovar15" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     357    <column name="sersicCovar16" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     358    <column name="sersicCovar17" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     359    <column name="sersicCovar22" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     360    <column name="sersicCovar23" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     361    <column name="sersicCovar24" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     362    <column name="sersicCovar25" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     363    <column name="sersicCovar26" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     364    <column name="sersicCovar27" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     365    <column name="sersicCovar33" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     366    <column name="sersicCovar34" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     367    <column name="sersicCovar35" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     368    <column name="sersicCovar36" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     369    <column name="sersicCovar37" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     370    <column name="sersicCovar44" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     371    <column name="sersicCovar45" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     372    <column name="sersicCovar46" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     373    <column name="sersicCovar47" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     374    <column name="sersicCovar55" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     375    <column name="sersicCovar56" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     376    <column name="sersicCovar57" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     377    <column name="sersicCovar66" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     378    <column name="sersicCovar67" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     379    <column name="sersicCovar77" type="TFLOAT" default="-999" comment="covariance for Sersic fit"></column>
     380    <column name="activeFlag" type="TBYTE" default="-999" comment="indicates whether this detection/orphan is still a detection/orphan"></column>
     381    <column name="dataRelease" type="TBYTE" default="0" comment="Data release when this detection was taken"></column>
     382  </table>
     383  <table name="StackToImage">
     384    <column name="stackMetaID" type="TLONGLONG" default="0" comment="stack identifier"></column>
     385    <column name="imageID" type="TLONGLONG" default="0" comment="hashed exposure-ccdID identifier"></column>
    163386  </table>
    164387</tableDescriptions>
Note: See TracChangeset for help on using the changeset viewer.