O |
|---|
| Name | Schema Table | Database | Description | Type | Length | Unit | Default Value | Unified Content Descriptor |
|---|
| object |
Multiframe |
WSA |
Object name from telescope {image primary HDU keyword: OBJECT} |
varchar |
64 |
|
NONE |
meta.id |
| object |
Multiframe |
WSACalib |
Object name from telescope {image primary HDU keyword: OBJECT} |
varchar |
64 |
|
NONE |
meta.id |
| object |
Multiframe |
WSATransit |
Object name from telescope {image primary HDU keyword: OBJECT} |
varchar |
64 |
|
NONE |
meta.id |
| object |
Multiframe |
WSAUHS |
Object name from telescope {image primary HDU keyword: OBJECT} |
varchar |
64 |
|
NONE |
meta.id |
| objID |
gcsListRemeasurement, gpsListRemeasurement, lasListRemeasurement, UKIDSSDetection |
WSA |
Unique identifier for this detection, or default for no detection |
bigint |
8 |
|
-99999999 |
ID_MAIN |
| objID |
calDetection |
WSACalib |
Unique identifier for this detection or default for no detection |
bigint |
8 |
|
-99999999 |
ID_MAIN |
| This attribute is included to provide a single identification number for real detection rows (objID>0) when making cross-neighbour tables between source and detection. In general, users should NOT use this attribute for look-ups between the source and detection tables, because every detector frame has a default row in the detection table, so there are many, many thousands of rows with objID=-99999999 in each detection table which will be associated with every look-up of objID=-99999999 from source (i.e. those rows for which there is no detection or no frame in a particular passband). See the glossary entry for objID in source tables for more information. |
| objID |
dxsDetection, udsDetection |
WSA |
Unique identifier for this detection or default for no detection |
bigint |
8 |
|
-99999999 |
ID_MAIN |
| This attribute is included to provide a single identification number for real detection rows (objID>0) when making cross-neighbour tables between source and detection. In general, users should NOT use this attribute for look-ups between the source and detection tables, because every detector frame has a default row in the detection table, so there are many, many thousands of rows with objID=-99999999 in each detection table which will be associated with every look-up of objID=-99999999 from source (i.e. those rows for which there is no detection or no frame in a particular passband). See the glossary entry for objID in source tables for more information. |
| objID |
gcsDetection, gpsDetection, lasDetection |
WSA |
Unique identifier for this detection, or default for no detection |
bigint |
8 |
|
-99999999 |
ID_MAIN |
| This attribute is included to provide a single identification number for real detection rows (objID>0) when making cross-neighbour tables between source and detection. In general, users should NOT use this attribute for look-ups between the source and detection tables, because every detector frame has a default row in the detection table, so there are many, many thousands of rows with objID=-99999999 in each detection table which will be associated with every look-up of objID=-99999999 from source (i.e. those rows for which there is no detection or no frame in a particular passband). See the glossary entry for objID in source tables for more information. |
| objID |
ptsDetection |
WSATransit |
Unique identifier for this detection or default for no detection |
bigint |
8 |
|
-99999999 |
ID_MAIN |
| This attribute is included to provide a single identification number for real detection rows (objID>0) when making cross-neighbour tables between source and detection. In general, users should NOT use this attribute for look-ups between the source and detection tables, because every detector frame has a default row in the detection table, so there are many, many thousands of rows with objID=-99999999 in each detection table which will be associated with every look-up of objID=-99999999 from source (i.e. those rows for which there is no detection or no frame in a particular passband). See the glossary entry for objID in source tables for more information. |
| objID |
uhsDetection, uhsDetectionAll |
WSAUHS |
Unique identifier for this detection or default for no detection |
bigint |
8 |
|
-99999999 |
ID_MAIN |
| This attribute is included to provide a single identification number for real detection rows (objID>0) when making cross-neighbour tables between source and detection. In general, users should NOT use this attribute for look-ups between the source and detection tables, because every detector frame has a default row in the detection table, so there are many, many thousands of rows with objID=-99999999 in each detection table which will be associated with every look-up of objID=-99999999 from source (i.e. those rows for which there is no detection or no frame in a particular passband). See the glossary entry for objID in source tables for more information. |
| objID |
ukirtFSstars |
WSA |
Faint standard unique identifier (FS number; see Hawarden et al. 2001, MN, 325, 563) |
bigint |
8 |
|
|
|
| objID |
ukirtFSstars |
WSACalib |
Faint standard unique identifier (FS number; see Hawarden et al. 2001, MN, 325, 563) |
bigint |
8 |
|
|
|
| objID |
ukirtFSstars |
WSAUHS |
Faint standard unique identifier (FS number; see Hawarden et al. 2001, MN, 325, 563) |
bigint |
8 |
|
|
|
| obReqs |
RequiredFilters |
WSA |
For wide shallow surveys with small number of epochs, what MSB requirements for each epoch. |
varchar |
32 |
|
NONE |
meta.note |
| obReqs |
RequiredFilters |
WSACalib |
For wide shallow surveys with small number of epochs, what MSB requirements for each epoch. |
varchar |
32 |
|
NONE |
meta.note |
| obReqs |
RequiredFilters |
WSATransit |
For wide shallow surveys with small number of epochs, what MSB requirements for each epoch. |
varchar |
32 |
|
NONE |
meta.note |
| obReqs |
RequiredFilters |
WSAUHS |
For wide shallow surveys with small number of epochs, what MSB requirements for each epoch. |
varchar |
32 |
|
NONE |
meta.note |
| OBS_CLASS |
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0 |
XMM |
Quality classification of the whole observation based on the area flagged as bad in the manual flagging process as compared to the whole detection area. 0 means nothing has been flagged; 1 indicates that 0% < area < 0.1% of the total detection mask has been flagged; 2 indicates that 0.1% <= area < 1% has been flagged; 3 indicates that 1% <= area < 10% has been flagged; 4 indicates that 10% <= area < 100% has been flagged; and 5 means that the whole field was flagged as bad. |
int |
4 |
|
|
|
| OBS_CLASS |
xmm3dr4 |
XMM |
Quality classification of the whole observation based on the area flagged as bad in the manual flagging process as compared to the whole detection area. 0 means nothing has been flagged; 1 indicates that 0% < area < 0.1% of the total detection mask has been flagged; 2 indicates that 0.1% <= area < 1% has been flagged; 3 indicates that 1% <= area < 10% has been flagged; 4 indicates that 10% <= area < 100% has been flagged; and 5 means that the whole field was flagged as bad. |
smallint |
2 |
|
|
|
| OBS_ID |
xmm3dr4 |
XMM |
The XMM-Newton observation identification. |
varchar |
50 |
|
|
|
| observation_time |
phot_variable_time_series_g_fov |
GAIADR1 |
Barycentric light-travle time corrected timestamp for each FoV observation |
float |
8 |
Barycentric JD in TCB - 2455197.5 days |
|
time.epoch |
| observed |
StdFieldInfo |
WSA |
yes or no identifier - have the secondary standards been set up? |
tinyint |
1 |
|
0 |
|
| observed |
StdFieldInfo |
WSACalib |
yes or no identifier - have the secondary standards been set up? |
tinyint |
1 |
|
0 |
|
| observed |
StdFieldInfo |
WSAUHS |
yes or no identifier - have the secondary standards been set up? |
tinyint |
1 |
|
0 |
|
| observer |
Multiframe |
WSA |
Observers names {image primary HDU keyword: OBSERVER} |
varchar |
64 |
|
NONE |
obs.observer |
| observer |
Multiframe |
WSACalib |
Observers names {image primary HDU keyword: OBSERVER} |
varchar |
64 |
|
NONE |
obs.observer |
| observer |
Multiframe |
WSATransit |
Observers names {image primary HDU keyword: OBSERVER} |
varchar |
64 |
|
NONE |
obs.observer |
| observer |
Multiframe |
WSAUHS |
Observers names {image primary HDU keyword: OBSERVER} |
varchar |
64 |
|
NONE |
obs.observer |
| OBSID |
twoxmm, twoxmm_v1_2, twoxmmi_dr3_v1_0 |
XMM |
The XMM-Newton observation identification. |
varchar |
10 |
|
|
|
| obsNum |
Multiframe |
WSA |
Observation number {image primary HDU keyword: OBSNUM} |
int |
4 |
|
-99999999 |
meta.number |
| obsNum |
Multiframe |
WSACalib |
Observation number {image primary HDU keyword: OBSNUM} |
int |
4 |
|
-99999999 |
meta.number |
| obsNum |
Multiframe |
WSATransit |
Observation number {image primary HDU keyword: OBSNUM} |
int |
4 |
|
-99999999 |
meta.number |
| obsNum |
Multiframe |
WSAUHS |
Observation number {image primary HDU keyword: OBSNUM} |
int |
4 |
|
-99999999 |
meta.number |
| obsref |
Multiframe |
WSA |
PATT or other reference {image primary HDU keyword: OBSREF} |
varchar |
64 |
|
NONE |
meta.bib |
| obsref |
Multiframe |
WSACalib |
PATT or other reference {image primary HDU keyword: OBSREF} |
varchar |
64 |
|
NONE |
meta.bib |
| obsref |
Multiframe |
WSATransit |
PATT or other reference {image primary HDU keyword: OBSREF} |
varchar |
64 |
|
NONE |
meta.bib |
| obsref |
Multiframe |
WSAUHS |
PATT or other reference {image primary HDU keyword: OBSREF} |
varchar |
64 |
|
NONE |
meta.bib |
| obstype |
Multiframe |
WSA |
Type (BIAS|DARK|ARC|FLAT|OBJECT|SKY) {image primary HDU keyword: OBSTYPE} |
varchar |
32 |
|
|
?? |
| obstype |
Multiframe |
WSACalib |
Type (BIAS|DARK|ARC|FLAT|OBJECT|SKY) {image primary HDU keyword: OBSTYPE} |
varchar |
32 |
|
|
?? |
| obstype |
Multiframe |
WSATransit |
Type (BIAS|DARK|ARC|FLAT|OBJECT|SKY) {image primary HDU keyword: OBSTYPE} |
varchar |
32 |
|
|
?? |
| obstype |
Multiframe |
WSAUHS |
Type (BIAS|DARK|ARC|FLAT|OBJECT|SKY) {image primary HDU keyword: OBSTYPE} |
varchar |
32 |
|
|
?? |
| oneSecMLVg |
Filter |
WSA |
The Vega magnitude limit of a 1s exposure in this filter |
real |
4 |
mag |
-0.9999995e9 |
|
| oneSecMLVg |
Filter |
WSACalib |
The Vega magnitude limit of a 1s exposure in this filter |
real |
4 |
mag |
-0.9999995e9 |
|
| oneSecMLVg |
Filter |
WSATransit |
The Vega magnitude limit of a 1s exposure in this filter |
real |
4 |
mag |
-0.9999995e9 |
|
| oneSecMLVg |
Filter |
WSAUHS |
The Vega magnitude limit of a 1s exposure in this filter |
real |
4 |
mag |
-0.9999995e9 |
|
| orgDate |
rosat_bsc, rosat_fsc |
ROSAT |
date when source was included (MM-DD-YYYY) |
datetime |
8 |
mm-dd-yyyy |
|
TIME_DATE |
| orient |
dxsAstrometricInfo, udsAstrometricInfo |
WSA |
Orientation of axes |
float |
8 |
degrees |
-0.9999995e9 |
?? |
| orient |
uhsAstrometricInfo |
WSAUHS |
Orientation of axes |
float |
8 |
radians |
-0.9999995e9 |
?? |
| origin |
Multiframe |
WSA |
Origin of this FITS file (eg. UKIRT) {image primary HDU keyword: ORIGIN} |
varchar |
32 |
|
NONE |
|
| origin |
Multiframe |
WSACalib |
Origin of this FITS file (eg. UKIRT) {image primary HDU keyword: ORIGIN} |
varchar |
32 |
|
NONE |
|
| origin |
Multiframe |
WSATransit |
Origin of this FITS file (eg. UKIRT) {image primary HDU keyword: ORIGIN} |
varchar |
32 |
|
NONE |
|
| origin |
Multiframe |
WSAUHS |
Origin of this FITS file (eg. UKIRT) {image primary HDU keyword: ORIGIN} |
varchar |
32 |
|
NONE |
|
| original_ext_source_id |
gaia_hip_tycho2_match |
GAIADR1 |
Original source identified in Hipparcos/Tycho2 |
varchar |
16 |
|
|
id.cross |
