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:People_Science_Themes_map
This table connects People with Science Themes. This is mostly for team members, most records in the People table will not have a connection to a Science Theme.

Field Description Type Null Limits Size Key Default Authority Source
PEOPLE_ID This field should hold a value from the ID column of the People table. INT(10) unsigned Not Null Foreign Key which references People (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. VARCHAR(255) Not Null HiWeb
LAST_UPDATE This column records the last time that a record was updated. TIMESTAMP db server

Other creation definitions:

Table Options:

Copyright (C) 2015 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

Contact

Please send comments to: HiCat@pirlmail.lpl.arizona.edu.