Field | Description | Type | Null | Limits | Size | Key | Default | Authority | Source |
---|---|---|---|---|---|---|---|---|---|
ID | A unique, numeric identifier for each request. | INT unsigned auto_increment | Not Null | Primary Key | db server | ||||
CYCLE_ID | The cycle the suggestion is to be acquired in. | INT(5) unsigned | Foreign Key which references Cycle_map (ID) ON DELETE SET NULL | Cycle_map | |||||
SUGGESTED_OBSERVATIONS_ID | The suggestion ID of the target request. | INT(10) unsigned | Not Null | Foreign Key which references Suggested_Observations (ID) ON DELETE CASCADE | Suggested_Observations | ||||
PEOPLE_ID | The user id of the person adding the target to the list. | INT(10) unsigned | Not Null | Foreign Key which references People (ID) ON DELETE CASCADE | People.ID | ||||
CATEGORY_ID | INT unsigned | Foreign Key which references Special_Target_Categories (ID) ON DELETE CASCADE | |||||||
QUEUE_POSITION | INT | Star Tool | |||||||
PRIORITY | The priority of the target. | INT(2) | HiReport | ||||||
USER_INPUT | JSON | Star Tool | |||||||
COMMENT | Additional notes or justification for the target. | TEXT | HiReport | ||||||
JSON_DATA | JSON | Star Tool | |||||||
LAST_UPDATE | This column records the last time that a record was updated. | TIMESTAMP | db server |
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.