2MAPPS Software Interface Specification DBM02 4.3 98/02/11 Interface Name: DBMAN/DB Extended Source Data Interface Type of Interface: Database (Informix) Field Data Specification Written By: DBMAN _______________________________ T. Evans Read By: Informix DB Description: DBMAN loads 2MASS data into the Informix 2MASS database. This SIS describes the DB fields (AKA "table columns") for the extended source data. This data includes "regular" (algorithm 1) extended src data and Low Central Surface Brightness (LCSB, algorithm 2) src data. Descriptions of the point source, scan/quality, auxiliary, and calibration DB data are found in the other DBMxx SISs. Also, information from each DBMAN run will also be written to a UNIX summary file. The DB table containing this data from survey scans is named "ext_src", and the table containing this data from calibration scans is named "ext_src_c". Both are in the "tmass" DB. Each regular extended source has an associated point src DB entry with a matching "key" consisting of the combination of the hemis + date + scan + id fields. However, since neighboring coadds in a scan have a slight overlap, an ext. src may have a duplicate extraction. Thus, there may be up to 2 ext. src entries, distinguished by the coadd number, for each point src entry. On the other hand, each LCSB source has an ID number unique within the scan since it does NOT have an associated point src. Note also that dup extractions of an LCSB src from neighboring coadds will have DIFFERENT IDs, as opposed to regular extended srcs. If a field is not applicable or contains a "bad or N/A measurement value" (see previous 2MAPPS SISs for details) for a certain source, the field will contain "NULL" values as defined by the DB. However, some fields are defined slightly differently for LCSB data, as indicated by "LCSB:" in the descriptions below, and some behave differently for band-filled data, as indicated by "BF" in the descriptions below. The descriptions below contain the following information: 1. "Name" is the name of the DB fields or table columns. Note that they are all in lower case, because the DB doesn't distinguish between upper and lower case names. If there is a number in parentheses after the name, please refer to the numbered notes at the end of the descriptions for more information. Many fields are repeated 3 times, once for each band, but are found only once in the description below; these fields contain "" in the name, where "b" is understood to mean "j", "h", and "k". NOTE: The "cntr" column MUST be the first column in each table. 2. "Description" contains a short description of the field contents. 3. "Units" contains the units of the values in the fields. 4. "DBType" contains the DB data storage type for the fields. Note that some data types are further defined by values in parentheses following the type name. Also, these types are NOT cast in stone and could change, especially for the position fields. 5. "Null" indicates (y/n) whether the DB fields accept NULL values. 6. "Idx" contains a code indicating whether fields are indexed and what type of indexes they have. If the code is "0", the field is not indexed. If it is "1", the field has a simple index. If there is a "u" after the digit(s), the index is a "unique" one. If the code has a 2-digit number, the first digit indicates to which composite index the field belongs, and the second digit indicates the ordering of the fields within the composite index. 7. "Fmt" contains a C-like description of the best formats for displaying the field contents, *excluding* a leading space for field separation. 8. "Tbl" contains the (sub-)table ID to which the fields belong. NOTE: The "cntr" field will be the first field in each sub-table, and is used as a join index. The 1st sub-table ("01") is the "main" sub-table, and must contain one entry per table cntr number; any other sub-table will not contain an entry for a cntr number if its fields would all be NULL. 9. "Min" and "Std" indicate (y/n) whether the DB fields are found in the "mini" and "standard" table output views. NOTE: A line beginning with "-------" can only be used herein to delineate the section of field/data dictionary lines seen below. Name Description Units DBType Null Idx Fmt Tbl Min Std ----------------------------------------------------------------------------------------------------------------------------------------- cntr entry counter (key) number (unique within table) - integer n 1u 9d 01 y y hemis hemisphere (N/S) of observation - char(1) n 21 1s 01 n y date observation date - date n 22 yymmdd 01 n y scan scan number (unique within date) - smallint n 23 3hd 01 n y coadd 3-digit coadd number (unique within scan) - smallint n 24 03hd 01 n y id source ID number (unique within scan, coadd) - integer n 25 6d 01 n y ra right ascension (J2000 decimal deg) deg decimal(9,6) n 1 10.6f 01 y y dec declination (J2000 decimal deg) deg decimal(8,6) n 1 10.6f 01 y y glon galactic longitude (decimal deg) deg decimal(9,6) n 0 10.6f 01 n y glat galactic latitude (decimal deg) deg decimal(9,6) n 1 10.6f 01 n y x unit sphere x value - decimal(10,9) n 0 12.9f 01 n n y unit sphere y value - decimal(10,9) n 0 12.9f 01 n n z unit sphere z value - decimal(10,9) n 0 12.9f 01 n n x_coadd x (cross-scan) position (coadd coord.) arcsec decimal(4,1) n 1 6.1f 01 n n y_coadd y (in-scan) position (coadd coord.) arcsec decimal(5,1) n 1 6.1f 01 n n r_3sig 3-sigma K isophotal major axis radius arcsec decimal(4,1) y 0 5.1f 01 y y _ba 3-sigma minor/major axis ratio - decimal(4,3) y 0 5.3f 01 y y _phi angle to 3-sigma major axis (E of N) deg smallint y 0 3hd 01 y y _m (1) selected "default" magnitude mag decimal(5,3) y 1 6.3f 01 y y _msig "default" mag uncertainty mag decimal(4,3) y 0 5.3f 01 y y _flg flag for "default" mag - smallint n 0 1hd 01 y y Total elliptical photometry _r_e total Kron elliptical aperture major axis arcsec decimal(4,1) y 0 5.1f 01 n n _m_e total Kron elliptical magnitude mag decimal(5,3) y 0 6.3f 01 n n _msig_e 1-sigma uncertainty in total Kron ell. mag mag decimal(4,3) y 0 5.3f 01 n n _flg_e (2) confusion flag for total Kron ell. mag - smallint y 0 1hd 01 n n Total photometry using K fiducial elliptical aperture r_fe (3) K fiducial Kron elliptical aperture major axis arcsec decimal(4,1) y 0 5.1f 01 n n _m_fe fiducial Kron elliptical magnitude mag decimal(5,3) y 0 6.3f 01 n n _msig_fe 1-sigma uncertainty in fiducial Kron ell. mag mag decimal(4,3) y 0 5.3f 01 n n _flg_fe confusion flag for fiducial Kron ell. mag - smallint y 0 1hd 01 n n Total circular photometry _r_c total Kron circular aperture radius arcsec decimal(4,1) y 0 5.1f 01 n n _m_c total Kron circular aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n _msig_c 1-sigma uncertainty in total Kron circ. mag mag decimal(4,3) y 0 5.3f 01 n n _flg_c confusion flag for total Kron circ. mag - smallint y 0 1hd 01 n n Total photom using K fiducial circular aperture r_fc K fiducial Kron circular aperture radius arcsec decimal(4,1) y 0 5.1f 01 n n _m_fc fiducial Kron circular magnitude mag decimal(5,3) y 1 6.3f 01 n n _msig_fc 1-sigma uncertainty in fiducial Kron circ. mag mag decimal(4,3) y 0 5.3f 01 n n _flg_fc confusion flag for fiducial Kron circ. mag - smallint y 0 1hd 01 n n Isophotal photom at 20 mag/sq.arcsec using ell ap _r_i20e 20mag/sq." isophotal elliptical ap. major axis arcsec decimal(4,1) y 0 5.1f 01 n n _m_i20e 20mag/sq." isophotal elliptical ap. magnitude mag decimal(5,3) y 0 6.3f 01 n n _msig_i20e 1-sigma uncertainty in 20mag/sq." iso. ell. mag mag decimal(4,3) y 0 5.3f 01 n n _flg_i20e confusion flag for 20mag/sq." iso. ell. mag - smallint y 0 1hd 01 n n Isophotal photom at 20 using K fiducial ellip ap r_k20fe 20mag/sq." isophotal K fiducial elliptical ap. major axis arcsec decimal(4,1) y 0 5.1f 01 n y _m_k20fe 20mag/sq." isophotal fiducial ell. ap. magnitude mag decimal(5,3) y 1 6.3f 01 n y _msig_k20fe 1-sigma uncertainty in 20mag/sq." iso.fid.ell.mag mag decimal(4,3) y 0 5.3f 01 n y _flg_k20fe confusion flag for 20mag/sq." iso. fid. ell. mag - smallint y 0 1hd 01 n y Isophotal photom at 20 using circ ap _r_i20c 20mag/sq." isophotal circular aperture radius arcsec decimal(4,1) y 0 5.1f 01 n n _m_i20c 20mag/sq." isophotal circular ap. magnitude mag decimal(5,3) y 0 6.3f 01 n n _msig_i20c 1-sigma uncertainty in 20mag/sq." iso. circ. mag mag decimal(4,3) y 0 5.3f 01 n n _flg_i20c confusion flag for 20mag/sq." iso. circ. mag - smallint y 0 1hd 01 n n Isophotal photom at 20 using K fiducial circ ap r_k20fc 20mag/sq." isophotal K fiducial circular ap. radius arcsec decimal(4,1) y 0 5.1f 01 n n _m_k20fc 20mag/sq." isophotal fiducial circ. ap. mag mag decimal(5,3) y 1 6.3f 01 n n _msig_k20fc 1-sigma uncertainty in 20mag/sq." iso.fid.circ. mag mag decimal(4,3) y 0 5.3f 01 n n _flg_k20fc confusion flag for 20mag/sq." iso. fid. circ. mag - smallint y 0 1hd 01 n n Isophotal photom at 21 mag/sq.arcsec using ell ap _r_i21e 21mag/sq." isophotal elliptical ap. major axis arcsec decimal(4,1) y 0 5.1f 01 n n _m_i21e 21mag/sq." isophotal elliptical ap. magnitude mag decimal(5,3) y 0 6.3f 01 n n _msig_i21e 1-sigma uncertainty in 21mag/sq." iso. ell. mag mag decimal(4,3) y 0 5.3f 01 n n _flg_i21e confusion flag for 21mag/sq." iso. ell. mag - smallint y 0 1hd 01 n n Isophotal photom at 21 using J fiducial ellip ap r_j21fe 21mag/sq." isophotal J fiducial elliptical ap. major axis arcsec decimal(4,1) y 0 5.1f 01 n n _m_j21fe 21mag/sq." isophotal fiducial ell. ap. magnitude mag decimal(5,3) y 0 6.3f 01 n n _msig_j21fe 1-sigma uncertainty in 21mag/sq." iso.fid.ell.mag mag decimal(4,3) y 0 5.3f 01 n n _flg_j21fe confusion flag for 21mag/sq." iso. fid. ell. mag - smallint y 0 1hd 01 n n Isophotal photom at 21 using circ ap _r_i21c 21mag/sq." isophotal circular aperture radius arcsec decimal(4,1) y 0 5.1f 01 n n _m_i21c 21mag/sq." isophotal circular ap. magnitude mag decimal(5,3) y 0 6.3f 01 n n _msig_i21c 1-sigma uncertainty in 21mag/sq." iso. circ. mag mag decimal(4,3) y 0 5.3f 01 n n _flg_i21c confusion flag for 21mag/sq." iso. circ. mag - smallint y 0 1hd 01 n n Isophotal photom at 21 using J fiducial circ ap r_j21fc 21mag/sq." isophotal J fiducial circular ap. radius arcsec decimal(4,1) y 0 5.1f 01 n n _m_j21fc 21mag/sq." isophotal fiducial circ. ap. mag mag decimal(5,3) y 0 6.3f 01 n n _msig_j21fc 1-sigma uncertainty in 21mag/sq." iso.fid.circ.mag mag decimal(4,3) y 0 5.3f 01 n n _flg_j21fc confusion flag for 21mag/sq." iso. fid. circ. mag - smallint y 0 1hd 01 n n Photometry from extrapolation fit _r_ext extrapolation radius arcsec decimal(4,1) y 0 5.1f 01 n n _m_ext mag from fit extrapolation mag decimal(5,3) y 0 6.3f 01 n n Photometry from fixed circular aperture _m_5 5 arcsec circular aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n _msig_5 1-sigma uncertainty in 5 arcsec circular ap. mag mag decimal(4,3) y 0 5.3f 01 n n _flg_5 confusion flag for 5 arcsec circular ap. mag - smallint y 0 1hd 01 n n _m_7 7 arcsec circular aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n _msig_7 1-sigma uncertainty in 7 arcsec circular ap. mag mag decimal(4,3) y 0 5.3f 01 n n _flg_7 confusion flag for 7 arcsec circular ap. mag - smallint y 0 1hd 01 n n _m_10 10 arcsec circular aperture magnitude mag decimal(5,3) y 1 6.3f 01 n y _msig_10 1-sigma uncertainty in 10 arcsec circular ap. mag mag decimal(4,3) y 0 5.3f 01 n y _flg_10 confusion flag for 10 arcsec circular ap. mag - smallint y 0 1hd 01 n y _m_15 15 arcsec circular aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n _msig_15 1-sigma uncertainty in 15 arcsec circular ap. mag mag decimal(4,3) y 0 5.3f 01 n n _flg_15 confusion flag for 15 arcsec circular ap. mag - smallint y 0 1hd 01 n n _m_20 20 arcsec circular aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n _msig_20 1-sigma uncertainty in 20 arcsec circular ap. mag mag decimal(4,3) y 0 5.3f 01 n n _flg_20 confusion flag for 20 arcsec circular ap. mag - smallint y 0 1hd 01 n n _m_25 25 arcsec circular aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n _msig_25 1-sigma uncertainty in 25 arcsec circular ap. mag mag decimal(4,3) y 0 5.3f 01 n n _flg_25 confusion flag for 25 arcsec circular ap. mag - smallint y 0 1hd 01 n n _m_30 30 arcsec circular aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n _msig_30 1-sigma uncertainty in 30 arcsec circular ap. mag mag decimal(4,3) y 0 5.3f 01 n n _flg_30 confusion flag for 30 arcsec circular ap. mag - smallint y 0 1hd 01 n n _m_40 40 arcsec circular aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n _msig_40 1-sigma uncertainty in 40 arcsec circular ap. mag mag decimal(4,3) y 0 5.3f 01 n n _flg_40 confusion flag for 40 arcsec circular ap. mag - smallint y 0 1hd 01 n n _m_50 50 arcsec circular aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n _msig_50 1-sigma uncertainty in 50 arcsec circular ap. mag mag decimal(4,3) y 0 5.3f 01 n n _flg_50 confusion flag for 50 arcsec circular ap. mag - smallint y 0 1hd 01 n n _m_60 60 arcsec circular aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n _msig_60 1-sigma uncertainty in 60 arcsec circular ap. mag mag decimal(4,3) y 0 5.3f 01 n n _flg_60 confusion flag for 60 arcsec circular ap. mag - smallint y 0 1hd 01 n n _m_70 70 arcsec circular aperture magnitude mag decimal(5,3) y 0 6.3f 01 n n _msig_70 1-sigma uncertainty in 70 arcsec circular ap. mag mag decimal(4,3) y 0 5.3f 01 n n _flg_70 confusion flag for 70 arcsec circular ap. mag - smallint y 0 1hd 01 n n System photometry _m_sys (4) system photometry magnitude mag decimal(5,3) y 0 6.3f 01 n y _msig_sys 1-sigma uncertainty in system photometry mag mag decimal(4,3) y 0 5.3f 01 n y sys_flg system flag: 0=no system, 1=system - smallint y 0 1hd 01 n y contam_flg contamination flag: 0=clear, 1=contaminated - smallint y 0 1hd 01 n y 3-sigma radii and mean surface brightness _r_3signorm 3-sigma normalized by shape major axis radius arcsec decimal(5,1) y 0 6.1f 01 n n _mnsurfb mean surface brightness at the 3-sig norm. radius mag decimal(5,2) y 0 6.2f 01 n n 5-sigma area ratios _5sig_ba 5-sigma minor/major axis ratio - decimal(4,3) y 0 5.3f 01 n n _5sig_phi angle to 5-sigma major axis (E of N) deg smallint y 0 3hd 01 n n 5-sigma to 3-sigma area _d_area 5-sigma to 3-sigma delta area - smallint y 0 3hd 01 n n _perc_darea 5-sigma to 3-sigma percent area change - smallint y 0 3hd 01 n n Bi-symmetric quantities _bisym_rat bi-symmetric flux ratio - decimal(4,3) y 0 5.3f 01 n n _bisym_chi bi-symmetric cross-correlation chi - decimal(5,3) y 0 6.3f 01 n n Parameters for extended src discrimination from point srcs _sh0 ridge shape (LCSB: BSNR limit) - decimal(4,2) y 0 5.2f 01 y y _sig_sh0 ridge shape sigma (LCSB: B2SNR limit) - decimal(4,2) y 0 5.2f 01 y y _sc_mxdn mxdn (score) (LCSB: BSNR - block/smoothed SNR) - decimal(5,1) y 0 6.1f 01 n n _sc_sh shape (score) - decimal(5,1) y 0 6.1f 01 n n _sc_wsh wsh (score) (LCSB: PSNR - peak raw SNR) - decimal(5,1) y 0 6.1f 01 n n _sc_r23 r23 (score) (LCSB: TSNR - integrated SNR for r=15) - decimal(5,1) y 0 6.1f 01 n n _sc_1mm 1st moment (score) (LCSB: super blk 2,4,8 SNR) - decimal(5,1) y 0 6.1f 01 n n _sc_2mm 2nd moment (score) (LCSB: SNRMAX - super SNR max) - decimal(5,1) y 0 6.1f 01 n n _sc_vmn vmean (score) - decimal(5,1) y 0 6.1f 01 n n _sc_vint vint (score) - decimal(5,1) y 0 6.1f 01 n n _scalen alpha scale length - decimal(5,1) y 0 6.1f 01 n n _sc_r1 r1 (score) - decimal(5,1) y 0 6.1f 01 n n _sc_msh median shape score - decimal(5,1) y 0 6.1f 01 n n _subst2 residual background #2 (score) - decimal(5,1) y 0 6.1f 01 n n Coadd background, brightness _back coadd median background - decimal(5,1) y 0 6.2f 01 y y _resid_ann residual annulus background median DN decimal(6,3) y 0 7.3f 01 n n _peak peak pixel brightness mag decimal(5,2) y 0 6.2f 01 n y _5surf central surface brightness (r<=5) mag decimal(5,2) y 0 6.2f 01 y y Super-coadd parameters sup_ra super-coadd RA (J2000 decimal deg) deg decimal(9,6) n 0 10.6f 01 n n sup_dec super-coadd Dec (J2000 decimal deg) deg decimal(8,6) n 0 10.6f 01 n n sup_r_3sig super-coadd 3-sigma isophotal major axis radius arcsec decimal(4,1) y 0 5.1f 01 n n sup_ba super-coadd minor/major axis ratio - decimal(4,3) y 0 5.3f 01 n n sup_phi super-coadd angle to major axis (E of N) deg smallint y 0 3hd 01 n n sup_r_3signorm super-coadd 3-sigma normalized by shape major axis radius arcsec decimal(5,1) y 0 6.1f 01 n n sup_mnsurfb super-coadd mean surface brightness at 3-sig norm. radius mag decimal(5,2) y 0 6.2f 01 n n Postage-stamp image parameters im_nx size of postage stamp image in pixels - smallint n 0 2hd 01 n n n_blank (5) number of blanked source records - smallint n 0 4hd 01 y y n_sub number of subtracted source records - smallint n 0 4hd 01 y y bl_sub_flg blanked/subtracted src description flag - smallint n 0 1hd 01 n n Other parameters id_flg (6) type/galaxy ID flag (0=non-catalog, 1=catalog, 2=LCSB) - smallint n 0 1hd 01 y y id_cat matched galaxy's catalog name - char(10) y 0 10s 01 y y r_ngc distance from nearest big galaxy arcsec decimal(5,2) y 0 6.2f 01 n y fg_flg flux-growth convergence flag - char(6) y 0 6s 01 n n blk_fac blocking factor (1, 2, 4, 8) - smallint y 0 1hd 01 n n ellfit_flg ellipse fitting contamination flag - smallint y 0 1hd 01 n n Color parameters j_h (7) default J-H mag color mag decimal(5,3) y 1 7.3f 01 y y j_h_sig sigma for J-H mag color mag decimal(4,3) y 0 5.3f 01 y y h_k default H-K mag color mag decimal(5,3) y 1 7.3f 01 y y h_k_sig sigma for H-K mag color mag decimal(4,3) y 0 5.3f 01 y y j_k default J-K mag color mag decimal(5,3) y 1 7.3f 01 y y j_k_sig sigma for J-K mag color mag decimal(4,3) y 0 5.3f 01 y y b_r B-R mag color of associated optical source mag decimal(5,3) y 0 7.3f 01 n y r_k default R-K mag color (using associated optical source) mag decimal(5,3) y 0 7.3f 01 n y b_k default B-K mag color mag decimal(5,3) y 0 7.3f 01 n y r_j default R-J mag color mag decimal(5,3) y 0 7.3f 01 n y b_j default B-J mag color mag decimal(5,3) y 0 7.3f 01 n y pts_key (8) key to point source data DB record - integer y 0 9d 01 y y mp_key (9) key to minor planet prediction DB record - integer y 0 5d 01 n n night_key (10) key to night data record in "scan DB" - integer n 1 4d 01 n n scan_key key to scan data record in "scan DB" - integer n 0 6d 01 n n _coadd_key key to coadd data record in "scan DB" - integer n 0 7d 01 n n spt_ind spatial (x,y,z) index key - integer n 1 9d 01 n n clr_ind color index key - integer y 0 9d 01 n n ----------------------------------------------------------------------------------------------------------------------------------------- total # columns = 400, # bytes/row = 1420 ----------------------------------------------------------------------------------------------------------------------------------------- NOTES: (Be aware that all flag definitions are subject to change) (1)_m: selected default magnitude for each band For each band, a "default" magnitude is selected by DBMAN and is used to calculate the mag colors J-H,...R-K,...etc. The first choice for the _m values are the mags in each band at 20 mag/sq.arcsec w/K fiducial circular aperture (_m_k20fc). If, however, the K band mag in this group is band is > 14.0 (including neg. flux or no mag found), all 3 _m values will be the mags at 21 mag/sq.arcsec w/J fiducial circular aperture (_m_j21fc) and the flags _flg are set to 1. If any one of chosen set of "default" mags is > 99, the DB entry for that "default" mag will be set to NULL. The _msig fields contain the corresponding default mag sigmas. Thus, the _flg flags will indicate the source of the "default" mags and sigmas as follows: 0: _m_k20fe values 1: _m_j21fe values (2)_flg_<...>: confusion flags The confusion flags for each mag are defined as follows: 0 if no other sources within aperture used 1 if ap contained pixels masked off in coadd 2 if ap contained pixels masked off due to neighboring sources 3 if ap contained pixels that had a point source flux subtracted off 4 if ap contained pixels within bright star mask 5 if ap contained pixels masked off due to persistence 6 if aperture ran into coadd boundary 7 if ap contained pixels within bright galaxy mask 9 if integrated flux is negative If the integrated flux is negative, a mag value is calculated using BFMag = 99.0 - [ZERO_CAL - 2.5 log10(|flux|)]; the resulting mag range is between ~ 75 and 99. (3)r_f<...>: major axis or radius of fiducial apertures "Fiducial" apertures are determined for each type of total and isophotal photometry measurements as described in the GALWORKS SDS. Essentially, they are used to make mag measurements for each type of photometry with the same aperture size in all three bands. The fiducial band for the total Kron photometry and 20mag/sq." isophotal photometry is the K band, and for the 21mag/sq." isophotal photometry it is the J band. (4)System photometry The system flux includes the flux from this ext. src and anything else in the galaxy field, including stars and neighboring galaxies that "touch" this src. system flag: 0 = no nearby "touching" galaxy 1 = nearby galaxy flux included in system flux contamination flag: 0 = no stars within field 1 = stellar flux incorporated in system flux (5)Blanked/subtracted srcs These parameters refer to srcs that were blanked and/or subtracted from the images before doing photometry. Data for each of these blanked/ subtracted srcs is found in a separate table (see SIS DBM05). (6)id_flg: type/galaxy ID flag 0 = non-catalog ext. src 1 = catalog galaxy (ID found in id_cat field) 2 = LCSB src (7)Mag colors Magnitude colors and their sigmas are calculated using the "default" mags and sigmas for extended srcs (see (1) above) and the optical mags _m_opt in the associated point src entry. If one of the bands used in a color calculation is band-filled or NULL, the color value is an upper or lower limit. (8)Point src record key: default (no pt src data - only LCSBs) = "0" or NULL? If the src has point src data (i.e. it is not an LCSB), this field will be set to the key of the record containing the point src data (see SIS DBM01). The point src data will also have the same date, hemisphere, scan, id keys. (9)Minor planet record key: default (no minor planet match) = "0" or NULL? If a minor planet (asteroid) is predicted at this src's position, the field will be set to the key of the record containing the minor planet prediction data (see SIS DBM03). The minor planet data will also have the same date, hemisphere, scan, id keys. (10)Night, scan, coadd data keys: no default (non-null) These fields will be set to the keys of the records containing the corresponding night, scan, band, and coadd data in the "scan DB" (see SIS DBM06). These records will also have the same date, hemisphere, scan, band, and coadd keys. Possible NULL fields -------------------- All fields can be NULL at times, except for the first 15 fields listed above (cntr through y_coadd), fiducial radii fields, flag fields, super-coadd fields, and the night, scan, and coadd data keys. The number of NULLs will be non-negligible, since extended srcs often can only be detected in 1 or 2 bands, and only the "default" mags will contain a band-fill mag value. However, the mag colors that involve only one NULL or band-filled mag will be upper or lower limits. For LCSB srcs, the following fields are NULL (including all elliptical aperture mag fields): r_3sig _ba _phi _r_e _m_e _msig_e _flg_e r_fe _m_fe _msig_fe _flg_fe _r_i20e _m_i20e _msig_i20e _flg_i20e r_k20fe _m_k20fe _msig_k20fe _flg_k20fe _r_i21e _m_i21e _msig_i21e _flg_i21e r_j21fe _m_j21fe _msig_j21fe _flg_j21fe _r_ext _m_ext _m_sys _msig_sys sys_flg contam_flg _5sig_ba _5sig_phi _bisym_rat _bisym_chi _sc_vmn _sc_vint _sc_r1 _sc_msh _subst2 _resid_ann ellfit_flg pts_key mp_key