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_NUMBER field are unique. | INT(10) unsigned | Not Null | Foreign Key which references Planned_Observations (ID) | |||||
CCD_NAME | This is the CCD name for this planned CCD parameter. | VARCHAR(4) | Not Null | ||||||
BINNING_MODE | The binning for this CCD for this Planned Observation. Allowable values are 1, 2, 3, 4, 8, and 16. | TINYINT(2) unsigned | |||||||
TDI_MODE | The Time Delay and Integration mode for this CCD for this Planned Observation. Allowable values are 8, 32, 64, and 128. | TINYINT(3) unsigned | |||||||
IMAGE_LINES | The number of image lines that this CCD will produce for this Planned Observation. | INT(11) | |||||||
TRIM_LINES | The number of trim lines that this CCD will have for this Planned Observation. | INT(11) | |||||||
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", "SQRT", "STORED") | |||||||
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) | |||||||
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) | |||||||
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) | |||||||
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) | |||||||
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) | |||||||
RAW_DATA_VOLUME | The expected file size, in bytes, that this CCD will produce for this Planned Observation. This should be in megabits, similar to Planned_Observations table. All of these should add together to get the value in that table. | FLOAT | |||||||
PLANNED_SNR | This is the expected signal-to-noise-ratio for this CCD for this Planned Observation. | FLOAT | |||||||
LAST_UPDATE | This column records the last time that a record was updated. | TIMESTAMP |
Other creation definitions:
Table Options:
Copyright (C) 2004 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. $Name: $
Please send comments to: HiCat@pirlmail.lpl.arizona.edu .