...
(See https://dev.lsstcorp.org/trac/wiki/DC/Winter2013 for more information. I have updated the RunDeepForcedSource table name, all the column names except for the flag bits, added the exposure ID to the 'SELECT' clause, and updated the objectId to the one in the other reference queries on the present page, compared to the query given on Trac. Note that we'll need the single-epoch exposure ID in the results table in order to set up the link to the image cutouts for the light curve viewer. I've also updated the objectId to the one in the other reference queries on the present page.)
...
...
-
Fix the flag
...
bits
For returning the flux:
Computing a calibrated flux (call functions scisql_dnToFlux and scisql_dnToFluxSigma) requires correcting the observed flux for the photometric zero point. This requires a join between the RunDeepForcedSource table (for the information about the individual observations) and the Science_Ccd_Exposure table (for a per-visit-image photometric zero point).
...
(See https://dev.lsstcorp.org/trac/wiki/DC/Winter2013 for more information. I have updated the RunDeepForcedSource table name, all the column names except for the flag bits, added the exposure ID to the 'SELECT' clause, and updated the objectId to the one in the other reference queries on the present page, compared to the query given on Trac. Note that we'll need the single-epoch exposure ID in the results table in order to set up the link to the image cutouts for the light curve viewer. I've also updated the objectId to the one in the other reference queries on the present page.)
...
...
-
Fix the flag
...
bits