Field | Description | Type | Null | Limits | Size | Key | Default | Authority | Source |
---|---|---|---|---|---|---|---|---|---|
PLANNED_OBSERVATIONS_ID | This field should hold a value from the ID column of the Planned_Observations table. The combination of this field, and the CCD_NAME field are unique. | INT(10) unsigned | Not Null | Foreign Key which references Planned_Observations (ID) ON DELETE CASCADE | db server | ||||
CCD_NAME | This is the CCD name for this planned CCD parameter. | VARCHAR(4) | Not Null | HiPlan | |||||
VERSION | Version number of this record. If needed by HiPlan. | VARCHAR(255) | Not Null | HiPlan | |||||
BINNING | The binning for this CCD for this Planned Observation. Allowable values are 1, 2, 3, 4, 8, and 16. | TINYINT(2) unsigned | Not Null | 1, 2, 3, 4, 8, or 16 | HiPlan | ||||
TDI | The Time Delay and Integration mode for this CCD for this Planned Observation. Allowable values are 8, 32, 64, and 128. | TINYINT(3) unsigned | Not Null | 8, 32, 64, or 128 | HiPlan | ||||
IMAGE_LINES | The number of image lines that this CCD will produce for this Planned Observation. | INT(11) | Not Null | HiPlan | |||||
TRIM_LINES | The number of trim lines that this CCD will have for this Planned Observation. | INT(11) | Not Null | HiPlan | |||||
LOOKUP_TABLE_TYPE | The lookup table that will be applied to the data coming from this CCD for this Planned Observation. If data is added or altered in this table, data in the other LOOKUP_TABLE_ fields should also be changed. | ENUM("N/A", "LINEAR", "SQUARE ROOT", "STORED") | Not Null | HiPlan | |||||
LOOKUP_TABLE_MINIMUM | The minimum value that will be returned from the lookup table for this CCD for this Planned Observation. If data is added or altered in this table, data in the other LOOKUP_TABLE_ fields should also be changed. | INT(11) | HiPlan | ||||||
LOOKUP_TABLE_MAXIMUM | The maximum value that will be returned from the lookup table for this CCD for this Planned Observation. If data is added or altered in this table, data in the other LOOKUP_TABLE_ fields should also be changed. | INT(11) | HiPlan | ||||||
LOOKUP_TABLE_MEDIAN | The median value of the the lookup table for this CCD for this Planned Observation. If data is added or altered in this table, data in the other LOOKUP_TABLE_ fields should also be changed. | INT(11) | HiPlan | ||||||
LOOKUP_TABLE_K_VALUE | The k value, or spread, of the lookup table for this CCD for this Planned Observation. If data is added or altered in this table, data in the other LOOKUP_TABLE_ fields should also be changed. | INT(11) | HiPlan | ||||||
LOOKUP_TABLE_NUMBER | This is the number of the stored lookup table that will be used when LOOKUP_TABLE_TYPE is set to "STORED". It is meaningless otherwise. There are 28 stored lookup tables, numbered zero through 27 | SMALLINT(2) | 0 to 27 | HiPlan | |||||
RAW_DATA_VOLUME_BYTES | The expected file size in bytes, that this CCD will produce for this Planned Observation. This volume does not include FELICS compression. | INT(10) unsigned | Not Null | HiPlan | |||||
IMAGE_MEAN | The estimated image mean for the CCD. | FLOAT | HIPHOP | ||||||
PLANNED_SNR | This is the expected signal-to-noise-ratio for this CCD for this Planned Observation. | FLOAT | HiPlan | ||||||
LAST_UPDATE | This column records the last time that a record was updated. | TIMESTAMP | db server |
Other creation definitions:
Table Options:
Copyright (C) 2005-2022 Arizona Board of Regents on behalf of the Planetary Image Research Laboratory, Lunar and Planetary Laboratory at the University of Arizona.
This page was generated from the XML HiCat Data Dictionary. HEAD
Please send comments to: HiCat@pirlmail.lpl.arizona.edu.