exposure_flexdata

Flexible key/value metadata about each raw image taken; used for development and engineering purposes

Columns

name	datatype	description	nullable	ivoa:ucd	votable:arraysize	length
obs_id foreign key	long	Unique identifier.	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
key primary key foreign key	string	Name of key.	false		128*	128
value	text	Content of value as a string.	true		*

Constraint	Type	Definition	Description
fk_exposure_flexdata_ds	ForeignKey	Columns: day_obs, seq_num References: exposure.day_obs, exposure.seq_num	Flex data day_obs must be an Exposure day_obs
fk_exposure_flexdata_obs_id	ForeignKey	Columns: obs_id References: exposure.exposure_id	Flex data obs_id must be an Exposure exposure_id.
fk_exposure_flexdata_obs_id_ds	ForeignKey	Columns: obs_id, day_obs, seq_num References: exposure.exposure_id, exposure.day_obs, exposure.seq_num	Flex data obs_id/day_obs/seq_num must match an Exposure.
fk_exposure_flexdata_key	ForeignKey	Columns: key References: exposure_flexdata_schema.key	Flex data key must be listed in the schema.
un_exposure_flexdata_ds_key	Unique	day_obs, seq_num, key	Day obs + seq num + key must be unique.
un_exposure_flexdata_obs_id_key	Unique	obs_id, key	obs_id plus key must be unique.