ccdvisit1

Information from observatory systems about each detector (CCD) within each visit in visit system 1 (visit per exposure); describes detectors in processed visit images (or calibrated exposures)

Columns

name datatype description unit nullable ivoa:ucd votable:arraysize length
day_obs primary key foreign key int Day of observation. false meta.id.part
seq_num primary key foreign key int Sequence number. false meta.id.part
ccdvisit_id long Unique identifier. false meta.id
visit_id foreign key long Identifier of the visit. false meta.id.part
detector primary key int Number of the detector in the focal plane. false meta.id.part;instr.det
s_region string Sky region in STC-S format (https://www.ivoa.net/documents/STC-S/20130917/index.html). true pos.outline;obs.field 1024* 1024

Constraints

Constraint Type Definition Description
un_ccdvisit1_ccdvisit_id Unique ccdvisit_id Ensure ccdvisit_id is unique.
un_ccdvisit1_ccdvisit_id_dsd Unique ccdvisit_id, day_obs, seq_num, detector Ensure ccdvisit_id plus day_obs plus seq_num plus detector is unique.
un_ccdvisit1_visit_id_detector Unique visit_id, detector Ensure visit_id plus detector is unique.
fk_ccdvisit1_visit_id ForeignKey
Columns: visit_id
References: visit1.visit_id
 visit_id must be in the Visit1 table.
fk_ccdvisit1_ds ForeignKey
Columns: day_obs, seq_num
 day_obs/seq_num must be in the Visit1 table.