TABLE SpecFrameFitsKey

List of FITS keywords extracted from the headers of SpecFrames.

This table lists all the FITS keywords in all the SpecFrames ingested into
the archive. It is not anticipated that these keywords will be accessed
often, since the most useful metadata keys are present as attributes in the
SpecFrame table. If, however, information from this table is required, note
that all data are stored as FITS key character strings so use of the built-in
SQL function CAST is required to perform operations within expressions on these
attributes.

Required constraints:
Primary key is (specFrameID, extNum, name)
(specFrameID) references SpecFrame(specFrameID)

Name Type Length Unit Description Default Value Unified Content Descriptor

specFrameID int 4 specFrameID of the specFrame from which the keyword was extracted. -99999999

extNum smallint 2 Extension number (0 corresponds to the primary HDU) -9999

name varchar 128 Name of the FITS keyword 'NONE'

value varchar 128 Value of the FITS keyword (copied as a character string) 'NONE'

units varchar 128 Any units for the FITS keyword 'NONE'

description varchar 128 Description of the FITS keyword 'NONE'

Total length 518

Name	Type	Length	Description	Default Value
specFrameID	int	4	specFrameID of the specFrame from which the keyword was extracted.	-99999999
extNum	smallint	2	Extension number (0 corresponds to the primary HDU)	-9999
name	varchar	128	Name of the FITS keyword	'NONE'
value	varchar	128	Value of the FITS keyword (copied as a character string)	'NONE'
units	varchar	128	Any units for the FITS keyword	'NONE'
description	varchar	128	Description of the FITS keyword	'NONE'
Total length		518