HiRISE: HiCat Data Dictionary HiRISE.Suggested_Observations_Science_Themes

HiCat Data Dictionary

Catalog: HiRISE: The main HiRISE catalog contains all the information used in operating the HiRISE camera after it is attached to the MRO spacecraft. The information is divided into those related to suggesting, planning, commanding, retrieving, processing, validating, and distributing the observations. The tag that follows an observation through all these catalogs (and from Earth to Mars and back) is the unique Observation_ID. This text representation also forms the core of the product names. The HiRISE catalog also contains ancillary information needed in various uplink and downlink activities, such as the people making image suggestions, MRO project uplink files, SPICE and engineering data, and public image releases.
Table:Suggested_Observations_Science_Themes_map: This table connects Suggested Observations with Science Themes.

Field	Description	Type	Null	Key	Source
SUGGESTED_OBSERVATIONS_ID	This field should hold a value from the ID column of the Suggested_Observations table.	INT(10) unsigned	Not Null	Foreign Key which references Suggested_Observations (ID) ON DELETE CASCADE	HiWeb
SCIENCE_THEMES_ID	This field should hold a value from the ID column of the Science_Themes table.	INT(10) unsigned	Not Null	Foreign Key which references Science_Themes (ID) ON DELETE CASCADE	HiWeb
VERSION	Version number of this record. If needed by HiWeb.	VARCHAR(255)	Not Null		HiWeb
PRECEDENCE	This field indicates the precedence of this Science Theme to this suggestion. A one here indicates that this Science Theme is the primary Science Theme for this Suggestion, a two indicates that it is the secondary Science Theme for this Suggestion and so on. There is currently no uniqueness constraints on these columns, so that you could have one primary Science Theme and many secondaries, or any number of combinations.	TINYINT(10) unsigned			HiWeb
LAST_UPDATE	This column records the last time that a record was updated.	TIMESTAMP			db server

Other creation definitions:

Table Options:

This page was generated from the XML HiCat Data Dictionary. HEAD