ccdexposure_camera

Information from the Camera Control System about each detector (CCD) within each raw image taken

Columns

name	datatype	description	unit	nullable	ivoa:ucd
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 foreign key	int	Number of the detector in the focal plane.		false	meta.id.part;instr.det
ccdexposure_id foreign key indexed	long	Unique identifier.		false
temp_set	float	Temperature setpoint of CCD in degC.		true
ccd_temp	float	Temperature of CCD in degC.		true	phys.temperature

Indexes

Index	Definition	Description
idx_ccdexposure_camera_ccdexposure_id	ccdexposure_id	Explicit index for single-column ID.

Constraints

Constraint	Type	Definition	Description
fk_ccdexposure_camera_ccdexposure_id	ForeignKey	Columns: ccdexposure_id References: ccdexposure.ccdexposure_id	exposure_id must be in the Exposure table.
fk_ccdexposure_camera_dsd	ForeignKey	Columns: day_obs, seq_num, detector References: ccdexposure.day_obs, ccdexposure.seq_num, ccdexposure.detector	day_obs/seq_num/detector must be in the CcdExposure table.
fk_ccdexposure_camera_ccdexposure_id_dsd	ForeignKey	Columns: ccdexposure_id, day_obs, seq_num, detector References: ccdexposure.ccdexposure_id, ccdexposure.day_obs, ccdexposure.seq_num, ccdexposure.detector	ccdexposure_id/day_obs/seq_num/detector must match a CcdExposure.