The structure of each QC1 table is defined in a definition file (configuration table). This definition table has to be provided by the QC scientist. It is read by internal QC1 database management tools and defines completely the structure of the QC1 database for that instrument.
The configuration table is the prime source of database structure information. It needs to be carefully designed and maintained.
The configuration table can either be an excel table (.xls) or a flat text file with separators.
The configuration table is used internally for the sql create/table command.
As a database table, each table definition file itself has rows and columns which become entries and keys.
There is one table definition file per QC1 table (or one sheet in the excel file). It lists:
General keywordsThe essential set of general keywords is the following:
-cdbfile: the file name of the master calibration file (DFO naming
-tpl_start: tpl.start keyword from the raw files
Filenames: For the purpose of being able to cross-correlate (join) information from the qc1 database with e.g. the raw data archive, it is extremely useful to have, as part of the qc1 database, information about the file names associated with the qc1 parameters. Of course this information is not always present, but we should try hard to retrieve it for historical data, and to provide for future data by default.
MJD-OBS is considered a fundamental keyword which (in connection
with some other parameters) is used to identify entries (primary key).
This is needed if e.g. an entry should be deleted or updated. Therefore,
it should have highest-possible precision, as stored in the FITS
QC1 keywordsChoose names which are as close as reasonable to their parent FITS key names.
These contain relevant setup information, just taken from the FITS headers.
The description field is used for self-documentation. Any care taken in filling this field with sensible content pays back manifold since it provides essential self-documentation.
Find here some details of an example table description.
There is also a general part which contains
The content of this table is read into the database table qc1_tables.
The complete UVES definition file in excel format can be found here.