ccdexposure

Information from observatory systems about each detector (CCD) within each raw image taken

Columns

name	datatype	description	nullable	ivoa:ucd	votable:arraysize	length
ccdexposure_id	long	Unique identifier.	false	meta.id
exposure_id foreign key	long	Identifier of the exposure.	false
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
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

Constraint	Type	Definition	Description
un_ccdexposure_ccdexposure_id	Unique	ccdexposure_id	Ensure ccdexposure_id is unique.
un_ccdexposure_exposure_id_detector	Unique	exposure_id, detector	Ensure exposure_id plus detector is unique.
un_ccdexposure_ccdexposure_id_dsd	Unique	ccdexposure_id, day_obs, seq_num, detector	Ensure ccdexposure_id plus day_obs plus seq_num plus detector is unique.
fk_ccdexposure_ds	ForeignKey	Columns: day_obs, seq_num References: exposure.day_obs, exposure.seq_num	day_obs must be in the Exposure table.
fk_ccdexposure_exposure_id	ForeignKey	Columns: exposure_id References: exposure.exposure_id	exposure_id must be in the Exposure table.
fk_ccdexposure_exposure_id_ds	ForeignKey	Columns: exposure_id, day_obs, seq_num References: exposure.exposure_id, exposure.day_obs, exposure.seq_num	exposure_id/day_obs/seq_num must match an Exposure.