ccdexposure_flexdata

Flexible key/value metadata about each detector (CCD) within each raw image taken; used for development and engineering purposes

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
detector primary key foreign key	int	Number of the detector in the focal plane.		false	meta.id.part;instr.det
obs_id foreign key indexed	long	Unique identifier.		false
key primary key foreign key indexed	string	Name of key.		false		128*	128
value	text	Content of value as a string.		true		*

Indexes

Index	Definition	Description
idx_ccdexposure_flexdata_obs_id_key	obs_id, key	Explicit index for single-column ID.

Constraints

Constraint	Type	Definition	Description
fk_ccdexposure_flexdata_obs_id	ForeignKey	Columns: obs_id References: ccdexposure.ccdexposure_id	Flex data obs_id must be a CcdExposure ccdexposure_id.
fk_ccdexposure_flexdata_dsd	ForeignKey	Columns: day_obs, seq_num, detector References: ccdexposure.day_obs, ccdexposure.seq_num, ccdexposure.detector	Flex data day_obs/seq_num/detector must be a CcdExposure.
fk_ccdexposure_flexdata_obs_id_dsd	ForeignKey	Columns: obs_id, day_obs, seq_num, detector References: ccdexposure.ccdexposure_id, ccdexposure.day_obs, ccdexposure.seq_num, ccdexposure.detector	Flex data obs_id/day_obs/seq_num/detector must match a CcdExposure.
fk_ccdexposure_flexdata_key	ForeignKey	Columns: key References: ccdexposure_flexdata_schema.key	Flex data key must be listed in the schema.