Changes between Version 15 and Version 16 of CommonVocabulary


Ignore:
Timestamp:
02/28/2008 10:45:27 PM (12 years ago)
Author:
jbecla
Comment:

added columns (now empty) for UCDs

Legend:

Unmodified
Added
Removed
Modified
  • CommonVocabulary

    v15 v16  
    1111A columns called ''probability'' have table-specific meaning, for example in PhotoZ table it means ''probability that given object has a photo z''. 
    1212 
    13 || '''name''' || '''unit''' || '''type''' || '''description''' || '''comments''' || 
     13|| '''name''' || '''unit''' || '''type''' || '''ucd''' || '''description''' || '''comments''' || 
    1414 
    1515|| '''Position related''' || || || || || 
    1616 
    17 || ra || degrees || int64 || Right ascension || ||  
    18 || decl || degrees || int64 || Declination || dec is a reserved word in most DBMSes || 
    19 || muRa || arcsec/year || double || Derived proper motion || mu_alpha*cos(decl) || 
    20 || muDecl || arcsec/year || double || Derived proper motion || mu_delta || 
    21  
    22 || uPosErrA || arcsec || float || Large dimension of the position error ellipse, assuming gaussian scatter || for u filter || 
    23 || uPosErrB || arcsec || float || Small dimension of the position error ellipse, assuming gaussian scatter || for u filter || 
    24 || uPosErrTheta || degrees || float || Orientation of the position error ellipse || for u filter || 
    25  
    26 || parallax || || float || Derived parallax for the object || || 
    27  
    28 || '''WCS related''' || || || || || 
    29  
    30 || radesys || || string(5) || Type of WCS used || Obsolete in ICRS || 
    31 || equinox || || float || Equinox of the WCS || Obsolete in ICRS || 
    32 || ctype1 || || string(20) || Coordinate projection type, axis 1 || || 
    33 || ctype2 || || string(20) || Coordinate projection type, axis 2 || || 
    34 || crpix1 || || float || Coordinate reference pixel, axis 1 || || 
    35 || crpix2 || || float || Coordinate reference pixel, axis 2 || || 
    36 || crval1 || || double || Coordinate value 1 @reference pixel || || 
    37 || crval2 || || double || Coordinate value 2 @reference pixel || || 
    38 || cunit1 || || varchar(10) || X axis units || || 
    39 || cunit2 || || varchar(10) || Y axis units || || 
    40 || cdelt1 || || float || || Obsolete by cd_xx terms? || 
    41 || cdelt2 || || float || || Obsolete by cd_xx terms? || 
    42 || cd11 || || float || First derivative of coordinate 1 w.r.t. axis 1 || || 
    43 || cd21 || || float || First derivative of coordinate 2 w.r.t. axis 1 || || 
    44 || cd12 || || float || First derivative of coordinate 1 w.r.t. axis 2 || || 
    45 || cd22 || || float || First derivative of coordinate 2 w.r.t. axis 2 || || 
    46 || ra_ll || degrees || double || Ra for the low-left corner || probably something more fancy needed || 
    47 || decl_ll || degrees || double || Decl for the low-left corner || probably something more fancy needed || 
    48 || ra_lr || degrees || double || Ra for the low-right corner || probably something more fancy needed || 
    49 || decl_lr || degrees || double || Decl for the low-right corner || probably something more fancy needed || 
    50 || ra_ul || degrees || double || Ra for the upper-left corner || probably something more fancy needed || 
    51 || decl_ul || degrees || double || Decl for the upper-left corner || probably something more fancy needed || 
    52 || ra_ur || degrees || double || Ra for the upper-right corner || probably something more fancy needed || 
    53 || decl_ur || degrees || double || Decl for the upper-right corner || probably something more fancy needed || 
    54  
    55  
    56 || '''Time related''' || || || || || 
    57  
    58 || dateObs || || datetime || Date/Time of observation start (UTC) || || 
    59 || taiObs || || datetime || time of shutter open || international atomic time || 
    60 || mjdObs || || double || MJD of observation start || || 
    61 || expTime || || float || Duration of exposure for this particular element, eg Amplifier, CCD || || 
    62 || darkTime || || float || Total elapsed time from exposure start to end of read || || 
    63 || taiDark || || double || Time of shutter closed || during the exposure, if there was such an occasion; see Kem Cook for details. International atomic time. There also could be a situation when the shutter was closed and reopened multiple times during the exposure. In this case, a more complicated data structure is needed?||  
    64 || taiMidPoint || || double || If a DIASource corresponds to a single exposure, taiMidPoint represents tai time of the middle of exposure. For multiple exposures, this is middle of beginning-of-first-exposure to end-of-last-exposure. || || 
    65 || taiRange || || float || If a DIASource corresponds to a single exposure, taiRange equals to exposure length. If DIASoure corresponds to multiple exposures, its taiRange equals to end-of-last-exposure minus beginning-of-first-exposure. || || 
    66 || earliestObsTime || || datetime || Time of the first observation of given object || || 
    67 || latestObsTime || || datetime || Time of the last observation of given object || || 
    68 || timeGenerated || || datetime || Date/time when alert was generated || || 
     17|| ra || degrees || int64 || || Right ascension || ||  
     18|| decl || degrees || int64 || || Declination || dec is a reserved word in most DBMSes || 
     19|| muRa || arcsec/year || double || || Derived proper motion || mu_alpha*cos(decl) || 
     20|| muDecl || arcsec/year || double || || Derived proper motion || mu_delta || 
     21 
     22|| uPosErrA || arcsec || float || || Large dimension of the position error ellipse, assuming gaussian scatter || for u filter || 
     23|| uPosErrB || arcsec || float || || Small dimension of the position error ellipse, assuming gaussian scatter || for u filter || 
     24|| uPosErrTheta || degrees || float || || Orientation of the position error ellipse || for u filter || 
     25 
     26|| parallax || || float || || Derived parallax for the object || || 
     27 
     28|| '''WCS related''' || || || || || || 
     29 
     30|| radesys || || string(5) || || Type of WCS used || Obsolete in ICRS || 
     31|| equinox || || float || || Equinox of the WCS || Obsolete in ICRS || 
     32|| ctype1 || || string(20) || || Coordinate projection type, axis 1 || || 
     33|| ctype2 || || string(20) || || Coordinate projection type, axis 2 || || 
     34|| crpix1 || || float || || Coordinate reference pixel, axis 1 || || 
     35|| crpix2 || || float || || Coordinate reference pixel, axis 2 || || 
     36|| crval1 || || double || || Coordinate value 1 @reference pixel || || 
     37|| crval2 || || double || || Coordinate value 2 @reference pixel || || 
     38|| cunit1 || || varchar(10) || || X axis units || || 
     39|| cunit2 || || varchar(10) || || Y axis units || || 
     40|| cdelt1 || || float || || || Obsolete by cd_xx terms? || 
     41|| cdelt2 || || float || || || Obsolete by cd_xx terms? || 
     42|| cd11 || || float || || First derivative of coordinate 1 w.r.t. axis 1 || || 
     43|| cd21 || || float || || First derivative of coordinate 2 w.r.t. axis 1 || || 
     44|| cd12 || || float || || First derivative of coordinate 1 w.r.t. axis 2 || || 
     45|| cd22 || || float || || First derivative of coordinate 2 w.r.t. axis 2 || || 
     46|| ra_ll || degrees || double || || Ra for the low-left corner || probably something more fancy needed || 
     47|| decl_ll || degrees || double || || Decl for the low-left corner || probably something more fancy needed || 
     48|| ra_lr || degrees || double || || Ra for the low-right corner || probably something more fancy needed || 
     49|| decl_lr || degrees || double || || Decl for the low-right corner || probably something more fancy needed || 
     50|| ra_ul || degrees || double || || Ra for the upper-left corner || probably something more fancy needed || 
     51|| decl_ul || degrees || double || || Decl for the upper-left corner || probably something more fancy needed || 
     52|| ra_ur || degrees || double || || Ra for the upper-right corner || probably something more fancy needed || 
     53|| decl_ur || degrees || double || || Decl for the upper-right corner || probably something more fancy needed || 
     54 
     55 
     56|| '''Time related''' || || || || || || 
     57 
     58|| dateObs || || datetime || || Date/Time of observation start (UTC) || || 
     59|| taiObs || || datetime || || time of shutter open || international atomic time || 
     60|| mjdObs || || double || || MJD of observation start || || 
     61|| expTime || || float || || Duration of exposure for this particular element, eg Amplifier, CCD || || 
     62|| darkTime || || float || || Total elapsed time from exposure start to end of read || || 
     63|| taiDark || || double || || Time of shutter closed || during the exposure, if there was such an occasion; see Kem Cook for details. International atomic time. There also could be a situation when the shutter was closed and reopened multiple times during the exposure. In this case, a more complicated data structure is needed?||  
     64|| taiMidPoint || || double || || If a DIASource corresponds to a single exposure, taiMidPoint represents tai time of the middle of exposure. For multiple exposures, this is middle of beginning-of-first-exposure to end-of-last-exposure. || || 
     65|| taiRange || || float || || If a DIASource corresponds to a single exposure, taiRange equals to exposure length. If DIASoure corresponds to multiple exposures, its taiRange equals to end-of-last-exposure minus beginning-of-first-exposure. || || 
     66|| earliestObsTime || || datetime || || Time of the first observation of given object || || 
     67|| latestObsTime || || datetime || || Time of the last observation of given object || || 
     68|| timeGenerated || || datetime || || Date/time when alert was generated || || 
    6969 
    7070 
     
    7272|| '''Observation related''' || || || || || 
    7373 
    74 || zd || || float || Zenith distance at observation mid-point || || 
    75 || airmass || || float || Airmass value for the Amp reference pixel || preferably center, but not guaranteed || 
    76 || temperature || celsius || float || || || 
    77 || wavelength || || float || Wavelength || || 
    78 || telAngle || degrees || float || Orientation angle of the telescope w.r.t sky || This is different from camera orientation w.r.t sky (encapsulated in WCS), since telescope is on alt-az mount || 
    79 || azimuth || degrees || float || Azimuth of observation || Preferably at center of exposure at center of image and including refraction correction, but none of this is guaranteed || 
    80 || alt || degrees || float || Altitude of observation || Preferably at center of observation at center of image and including refraction correction, but none of this is guaranteed || 
    81 || elevation || degrees || float || ''[Same as alt?]'' || || 
    82 || zpt || || double || Photometric zero point magnitude || || 
    83  
    84 || apDia || pixels || float || Diameter of aperture || || 
    85 || photoFlam || || float || Inverse sensitivity || || 
    86 || photoZP || || float || System photometric zero-point || || 
    87  
    88  
    89 || '''PSF related''' || || || || || 
    90  
    91 || psf_nstar || || int32 || Number of stars used for PSF measurement || || 
    92 || psf_apcorr || || float || Photometric error due to imperfect PSF model (aperture correction) || || 
    93 || psf_sigma1 || || float || Inner Gaussian sigma for the composite fit (XXX) || || 
    94 || psf_sigma2 || || float || Outer Gaussian sigma for the composite fit (XXX) || || 
    95 || psf_b || || float || Ratio of inner PSF to outer PSF (XXX) || || 
    96 || psf_b_2G || || float || Ratio of Gaussian 2 to Gaussian 1 at origin (XXX) || || 
    97 || psf_p0 || || float || The value of the power law at the origin (XXX) || || 
    98 || psf_beta || || float || The slope of the power law (XXX) || || 
    99 || psf_sigmap || || float || Width parameter for the power law (XXX) || || 
    100 || psf_nprof || || float || Number of profile bins (XXX) || || 
    101 || psf_fwhm || || float || Effective PSF width || || 
    102 || psf_sigma_x || || float || || || 
    103 || psf_sigma_y || || float || || || 
    104 || psf_posAngle || || float || || || 
    105 || psf_peak || || float || || || 
    106 || psf_x0 || || float || || || 
    107 || psf_x1 || || float || || || 
    108 || chi2 || || float || Chi-square value for the PSF fit || 
    109  
    110  
    111  
    112 || '''Magnitudes and shapes''' || || || || || 
    113  
    114 || uMagnitude || || double || magnitude (weighted average) || for u filter || 
    115 || uPetroMag || || double || petrosian magnitude || for u filter || 
    116 || uApMag || || double || aperture magnitude || for u filter || 
    117  
    118 || uApMag || || double || aperture magnitude for u filter || || 
    119 || psfMag || || double || PSF magnitude of the object || || 
    120 || apMag || || double || Aperture magnitude || || 
    121 || modelMag || || double || Model magnitude (adaptive 2D gauss) || || 
    122  
    123  
    124 || uIxx || || float || Adaptive second moment || for u filter || 
    125 || uIyy || || float || Adaptive second moment || for u filter || 
    126 || uIxy || || float || Adaptive second moment || for u filter || 
    127  
    128  
    129 || fwhmA || || float || Size of the object along major axis (pixels) || || 
    130 || fwhmB || || float || Size of the object along minor axis (pixels) || || 
    131 || fwhmTheta || degrees || float || Position angle of the major axis w.r.t. X-axis || || 
    132 || flux || || float || Measured DIA flux for the source (ADUs) || || 
    133 || snr || - || float || Signal-to-Noise ratio || 
    134 || ugColor || || double || Precalculated color: difference between u and g) || || 
    135 || grColor || || double || Precalculated color: difference between g and r) || || 
    136 || riColor || || double || Precalculated color: difference between r and i) || || 
    137 || izColor || || double || Precalculated color: difference between i and z) || || 
    138 || zyColor || || double || Precalculated color: difference between z and y) || || 
    139  
    140  
    141 || moment0 || || float || Sum of all flux of all pixels that belong to a source || placeholder || 
    142 || moment1_x || || float || Center of light - x component || placeholder || 
    143 || moment1_y || || float || Center of light - y component || placeholder || 
    144 || moment2_xx || || float || Standard deviation about center of light - xx component || placeholder || 
    145 || moment2_xy || || float || Standard deviation about center of light - xy component || placeholder || 
    146 || moment2_yy || || float || Standard deviation about center of light - yy component || placeholder || 
    147 || moment3_xxx || || float || Skewness of the profile - xxx component || placeholder || 
    148 || moment3_xxy || || float || Skewness of the profile - xxy component || placeholder || 
    149 || moment3_xyy || || float || Skewness of the profile - xyy component || placeholder || 
    150 || moment3_yyy || || float || Skewness of the profile - yyy component || placeholder || 
    151 || moment4_xxxx || || float || Kurtosis - xxxx component || placeholder || 
    152 || moment4_xxxy || || float || Kurtosis - xxxy component || placeholder || 
    153 || moment4_xxyy || || float || Kurtosis - xxyy component || placeholder || 
    154 || moment4_xyyy || || float || Kurtosis - xyyy component || placeholder || 
    155 || moment4_yyyy || || float || Kurtosis - yyyy component || placeholder || 
    156  
    157 || splitPercentage || % || int8 || percentage of the split || all for a given source must add up to 100% || 
    158  
    159  
    160 || '''Redshifts''' || || || || || 
    161  
    162 || redshift || || float || Photometric redshift || || 
    163 || photoZ1 || || float || || || 
    164 || photoZ2 || || float || || || 
    165 || photoZ1Outlier || || float || || || 
    166 || photoZ2Outlier || || float || || || 
    167 || probability || || int8 || Probability that given object has photo-z || || 
    168  
    169  
    170  
    171 || '''Variability''' || || || || || 
    172  
    173 || uAmplitude || || float || amplitude of magnitude variations || for u filter || 
    174 || uPeriod || || float || period of magnitude variations || for u filter || 
    175 || primaryPeriod || || float || Average period across all filters || || 
    176  
    177 || uTimescale || days || float || timescale of flux variations || for u filter || 
    178 || uNumObs || - || int32 || number of measurements in the lightcurve || for u filter || 
    179 || uVarProb || % || int16 || probability of variability. 100% = variable object || for u filter ||  
    180  
    181 || '''Calibration related''' || || || || || 
    182  
    183 || bias || || float || Bias level for the calibrated image || || 
    184 || gain || || float || Gain value for the amplifier || || 
    185 || rdNoise || electrons || float || Read noise value || for this particular element, eg !AmpExposure || 
    186 || sky || || float || The average sky level in the frame || || 
    187 || skySig || || float || Sigma of distribution of sky values || || 
    188 || u_fringeTime || || datetime || Time when corresponding CMFringeExposure was processed || for u filter || 
    189 || u_flatTime || || datetime || Time when corresponding CMFlatExposure was processed || for u filter || 
    190  
    191 || '''Image pixel array properties''' || || || || || 
    192  
    193 || binX || || int16 || binning in X-coordinate || || 
    194 || binY || || int16 || binning in Y-coordinate || ||  
    195 || sizeX || || int16 || Size of the image in X-direction (along rows; binned pixels) || Ignores overscan but includes regions that may be considered outside of the data portion of the image || 
    196 || sizeY || || int16 || Size of the image in Y-direction (along columns; binned pixels) || Ignores overscan but includes regions that may be considered outside of the data portion of the image || 
    197 || averPixelValue || || float || average pixel value || || 
    198 || stdevPixelValue || || float || standard deviation of average pixel value || || 
    199  
    200 || '''Rectilinear coordinates''' || || || || || 
    201 || row || || double || Pixel coordinate (Y) of the source centroid || || 
    202 || col || || double || Pixel coordinate (X) of the source centroid || || 
    203 || cx || || double || x-component of the (RA,Dec) unit vector || || 
    204 || cy || || double || y-component of the (RA,Dec) unit vector || || 
    205 || cz || || double || z-component of the (RA,Dec) unit vector || || 
    206  
    207  
    208 || '''flags''' || || || || || 
    209 || flag || - || ''[varies]'' || Flag to indicate a problem/special condition || || 
    210  
    211 || flag4association || - || int16 || Flag to indicate a problem/special condition related to Association Pipeline || || 
    212 || flag4detection || - || int16 || Flag to indicate a problem/special condition related to Detection Pipeline || || 
    213 || flag4wcs || - || int16 || Flag to indicate a problem/special condition related to WCS || || 
    214  
    215 || isProvisional || || bool || If this is set to true it indicates that the object was created at the base camp. If set to false, it means it was created by Deep Detection || || 
    216  
    217  
    218  
    219 || '''uncategorized''' || || || || || 
    220  
    221 || url || - || string || logical url of the corresponding FITS file || || 
    222 || imagePStampURL || || string(255) || Logical URL describing where the image postamp associated with the alert is located || || 
    223 || templatePStampURL || || string(255) || Logical URL of the postagestamp of the template image related to given alert || || 
    224 || alertURL || || string(255) || Logical URL to the actual alert sent || || 
    225  
    226 || nCombine || - ||  int32 || Number of images co-added to create a deeper image || || 
    227  
    228 || probability || % || int8 || Probability that given object is of given type || || 
    229  
    230 || sizeRa || || float || size of ra || this appears in postage stamp table || 
    231 || sizeDecl || || float || size of decl || this appears in postage stamp table|| 
    232  
    233  
    234 || '''mops related''' || || || || || 
    235 || a || || float || semi-major axis of the orbit (AU) || || 
    236 || incl || degrees || float || inclination of the orbit || || 
    237 || e || || float || eccentricity of the orbit || || 
    238 || periTAI || || float || TAI of the perihelion passage (comets) || || 
    239 || periDist || || float || Perihelion distance (AU) || || 
    240 || omega || || float || argument of perihelion || || 
    241 || node || || float || longitude of the ascending node || || 
    242 || meanAnom || || float || mean anomaly of the orbit || || 
    243 || qual || || float || measure of the accuracy of the derived orbit, classification, etc.|| can be more than one. Placeholder || 
     74|| zd || || float || || Zenith distance at observation mid-point || || 
     75|| airmass || || float || || Airmass value for the Amp reference pixel || preferably center, but not guaranteed || 
     76|| temperature || celsius || float || || || || 
     77|| wavelength || || float || || Wavelength || || 
     78|| telAngle || degrees || float || || Orientation angle of the telescope w.r.t sky || This is different from camera orientation w.r.t sky (encapsulated in WCS), since telescope is on alt-az mount || 
     79|| azimuth || degrees || float || || Azimuth of observation || Preferably at center of exposure at center of image and including refraction correction, but none of this is guaranteed || 
     80|| alt || degrees || float || || Altitude of observation || Preferably at center of observation at center of image and including refraction correction, but none of this is guaranteed || 
     81|| elevation || degrees || float || || ''[Same as alt?]'' || || 
     82|| zpt || || double || || Photometric zero point magnitude || || 
     83 
     84|| apDia || pixels || float || || Diameter of aperture || || 
     85|| photoFlam || || float || || Inverse sensitivity || || 
     86|| photoZP || || float || || System photometric zero-point || || 
     87 
     88 
     89|| '''PSF related''' || || || || || || 
     90 
     91|| psf_nstar || || int32 || || Number of stars used for PSF measurement || || 
     92|| psf_apcorr || || float || || Photometric error due to imperfect PSF model (aperture correction) || || 
     93|| psf_sigma1 || || float || || Inner Gaussian sigma for the composite fit (XXX) || || 
     94|| psf_sigma2 || || float || || Outer Gaussian sigma for the composite fit (XXX) || || 
     95|| psf_b || || float || || Ratio of inner PSF to outer PSF (XXX) || || 
     96|| psf_b_2G || || float || || Ratio of Gaussian 2 to Gaussian 1 at origin (XXX) || || 
     97|| psf_p0 || || float || || The value of the power law at the origin (XXX) || || 
     98|| psf_beta || || float || || The slope of the power law (XXX) || || 
     99|| psf_sigmap || || float || || Width parameter for the power law (XXX) || || 
     100|| psf_nprof || || float || || Number of profile bins (XXX) || || 
     101|| psf_fwhm || || float || || Effective PSF width || || 
     102|| psf_sigma_x || || float || || || || 
     103|| psf_sigma_y || || float || || || || 
     104|| psf_posAngle || || float || || || || 
     105|| psf_peak || || float || || || || 
     106|| psf_x0 || || float || || || || 
     107|| psf_x1 || || float || || || || 
     108|| chi2 || || float || || Chi-square value for the PSF fit || 
     109 
     110 
     111 
     112|| '''Magnitudes and shapes''' || || || || || || 
     113 
     114|| uMagnitude || || double || || magnitude (weighted average) || for u filter || 
     115|| uPetroMag || || double || || petrosian magnitude || for u filter || 
     116|| uApMag || || double || || aperture magnitude || for u filter || 
     117 
     118|| uApMag || || double || || aperture magnitude for u filter || || 
     119|| psfMag || || double || || PSF magnitude of the object || || 
     120|| apMag || || double || || Aperture magnitude || || 
     121|| modelMag || || double || || Model magnitude (adaptive 2D gauss) || || 
     122 
     123 
     124|| uIxx || || float || || Adaptive second moment || for u filter || 
     125|| uIyy || || float || || Adaptive second moment || for u filter || 
     126|| uIxy || || float || || Adaptive second moment || for u filter || 
     127 
     128 
     129|| fwhmA || || float || || Size of the object along major axis (pixels) || || 
     130|| fwhmB || || float || || Size of the object along minor axis (pixels) || || 
     131|| fwhmTheta || degrees || float || || Position angle of the major axis w.r.t. X-axis || || 
     132|| flux || || float || || Measured DIA flux for the source (ADUs) || || 
     133|| snr || - || float || || Signal-to-Noise ratio || 
     134|| ugColor || || double || || Precalculated color: difference between u and g) || || 
     135|| grColor || || double || || Precalculated color: difference between g and r) || || 
     136|| riColor || || double || || Precalculated color: difference between r and i) || || 
     137|| izColor || || double || || Precalculated color: difference between i and z) || || 
     138|| zyColor || || double || || Precalculated color: difference between z and y) || || 
     139 
     140 
     141|| moment0 || || float || || Sum of all flux of all pixels that belong to a source || placeholder || 
     142|| moment1_x || || float || || Center of light - x component || placeholder || 
     143|| moment1_y || || float || || Center of light - y component || placeholder || 
     144|| moment2_xx || || float || || Standard deviation about center of light - xx component || placeholder || 
     145|| moment2_xy || || float || || Standard deviation about center of light - xy component || placeholder || 
     146|| moment2_yy || || float || || Standard deviation about center of light - yy component || placeholder || 
     147|| moment3_xxx || || float || || Skewness of the profile - xxx component || placeholder || 
     148|| moment3_xxy || || float || || Skewness of the profile - xxy component || placeholder || 
     149|| moment3_xyy || || float || || Skewness of the profile - xyy component || placeholder || 
     150|| moment3_yyy || || float || || Skewness of the profile - yyy component || placeholder || 
     151|| moment4_xxxx || || float || || Kurtosis - xxxx component || placeholder || 
     152|| moment4_xxxy || || float || || Kurtosis - xxxy component || placeholder || 
     153|| moment4_xxyy || || float || || Kurtosis - xxyy component || placeholder || 
     154|| moment4_xyyy || || float || || Kurtosis - xyyy component || placeholder || 
     155|| moment4_yyyy || || float || || Kurtosis - yyyy component || placeholder || 
     156 
     157|| splitPercentage || % || int8 || || percentage of the split || all for a given source must add up to 100% || 
     158 
     159 
     160|| '''Redshifts''' || || || || || || 
     161 
     162|| redshift || || float || || Photometric redshift || || 
     163|| photoZ1 || || float || || || || 
     164|| photoZ2 || || float || || || || 
     165|| photoZ1Outlier || || float || || || || 
     166|| photoZ2Outlier || || float || || || || 
     167|| probability || || int8 || || Probability that given object has photo-z || || 
     168 
     169 
     170 
     171|| '''Variability''' || || || || || || 
     172 
     173|| uAmplitude || || float || || amplitude of magnitude variations || for u filter || 
     174|| uPeriod || || float || || period of magnitude variations || for u filter || 
     175|| primaryPeriod || || float || || Average period across all filters || || 
     176 
     177|| uTimescale || days || float || || timescale of flux variations || for u filter || 
     178|| uNumObs || - || int32 || || number of measurements in the lightcurve || for u filter || 
     179|| uVarProb || % || int16 || || probability of variability. 100% = variable object || for u filter ||  
     180 
     181|| '''Calibration related''' || || || || || || 
     182 
     183|| bias || || float || || Bias level for the calibrated image || || 
     184|| gain || || float || || Gain value for the amplifier || || 
     185|| rdNoise || electrons || float || || Read noise value || for this particular element, eg !AmpExposure || 
     186|| sky || || float || || The average sky level in the frame || || 
     187|| skySig || || float || || Sigma of distribution of sky values || || 
     188|| u_fringeTime || || datetime || || Time when corresponding CMFringeExposure was processed || for u filter || 
     189|| u_flatTime || || datetime || || Time when corresponding CMFlatExposure was processed || for u filter || 
     190 
     191|| '''Image pixel array properties''' || || || || || || 
     192 
     193|| binX || || int16 || || binning in X-coordinate || || 
     194|| binY || || int16 || || binning in Y-coordinate || ||  
     195|| sizeX || || int16 || || Size of the image in X-direction (along rows; binned pixels) || Ignores overscan but includes regions that may be considered outside of the data portion of the image || 
     196|| sizeY || || int16 || || Size of the image in Y-direction (along columns; binned pixels) || Ignores overscan but includes regions that may be considered outside of the data portion of the image || 
     197|| averPixelValue || || float || || average pixel value || || 
     198|| stdevPixelValue || || float || || standard deviation of average pixel value || || 
     199 
     200|| '''Rectilinear coordinates''' || || || || || || 
     201|| row || || double || || Pixel coordinate (Y) of the source centroid || || 
     202|| col || || double || || Pixel coordinate (X) of the source centroid || || 
     203|| cx || || double || || x-component of the (RA,Dec) unit vector || || 
     204|| cy || || double || || y-component of the (RA,Dec) unit vector || || 
     205|| cz || || double || || z-component of the (RA,Dec) unit vector || || 
     206 
     207 
     208|| '''flags''' || || || || || || 
     209|| flag || - || ''[varies]'' || || Flag to indicate a problem/special condition || || 
     210 
     211|| flag4association || - || int16 || || Flag to indicate a problem/special condition related to Association Pipeline || || 
     212|| flag4detection || - || int16 || || Flag to indicate a problem/special condition related to Detection Pipeline || || 
     213|| flag4wcs || - || int16 || || Flag to indicate a problem/special condition related to WCS || || 
     214 
     215|| isProvisional || || bool || || If this is set to true it indicates that the object was created at the base camp. If set to false, it means it was created by Deep Detection || || 
     216 
     217 
     218 
     219|| '''uncategorized''' || || || || || || 
     220 
     221|| url || - || string || || logical url of the corresponding FITS file || || 
     222|| imagePStampURL || || string(255) || || Logical URL describing where the image postamp associated with the alert is located || || 
     223|| templatePStampURL || || string(255) || || Logical URL of the postagestamp of the template image related to given alert || || 
     224|| alertURL || || string(255) || || Logical URL to the actual alert sent || || 
     225 
     226|| nCombine || - ||  int32 || || Number of images co-added to create a deeper image || || 
     227 
     228|| probability || % || int8 || || Probability that given object is of given type || || 
     229 
     230|| sizeRa || || float || || size of ra || this appears in postage stamp table || 
     231|| sizeDecl || || float || || size of decl || this appears in postage stamp table|| 
     232 
     233 
     234|| '''mops related''' || || || || || || 
     235|| a || || float || || semi-major axis of the orbit (AU) || || 
     236|| incl || degrees || float || || inclination of the orbit || || 
     237|| e || || float || || eccentricity of the orbit || || 
     238|| periTAI || || float || || TAI of the perihelion passage (comets) || || 
     239|| periDist || || float || || Perihelion distance (AU) || || 
     240|| omega || || float || || argument of perihelion || || 
     241|| node || || float || || longitude of the ascending node || || 
     242|| meanAnom || || float || || mean anomaly of the orbit || || 
     243|| qual || || float || || measure of the accuracy of the derived orbit, classification, etc.|| can be more than one. Placeholder || 
    244244||  
    245245 
    246246 
    247247 
    248 || '''various ids''' || || || || || 
    249 || alertId || - || int32 || Id of an Alert || || 
    250 || amplifierId || - || int16 || Id of an Amplifier || || 
    251 || ccExposureId || - || int64 || Id of CCD Exposure || || 
    252 || filterId || - || int8 || Id of a Filter || || 
    253 || objectId || - || int64 || Id of an Astronomical Object || || 
    254 || movingObjectId || - || int64 || Id of a Moving Object || || 
    255 || visitId || - || int32 || Id of a Visit || || 
    256 || flatExposureId || - || int32 || Id of a Flat Exposure || || 
    257 || biasExposureId || - || int32 || Id of a Bias Exposure || ||  
    258 || darkExposureId || - || int32 || Id of a Dark Exposure || ||  
    259 || cmFlatExposureId || - || int32 || Id of a Calibrated Master Flat Exposure || || 
    260 || subtractedExposureId || - || int32 || Id of a Subtracted Exposure || ||  
    261 || varianceExposureId || - || int32 || Id of a Variance Exposure || 
     248|| '''various ids''' || || || || || || 
     249|| alertId || - || int32 || || Id of an Alert || || 
     250|| amplifierId || - || int16 || || Id of an Amplifier || || 
     251|| ccExposureId || - || int64 || || Id of CCD Exposure || || 
     252|| filterId || - || int8 || || Id of a Filter || || 
     253|| objectId || - || int64 || || Id of an Astronomical Object || || 
     254|| movingObjectId || - || int64 || || Id of a Moving Object || || 
     255|| visitId || - || int32 || || Id of a Visit || || 
     256|| flatExposureId || - || int32 || || Id of a Flat Exposure || || 
     257|| biasExposureId || - || int32 || || Id of a Bias Exposure || ||  
     258|| darkExposureId || - || int32 || || Id of a Dark Exposure || ||  
     259|| cmFlatExposureId || - || int32 || || Id of a Calibrated Master Flat Exposure || || 
     260|| subtractedExposureId || - || int32 || || Id of a Subtracted Exposure || ||  
     261|| varianceExposureId || - || int32 || || Id of a Variance Exposure ||