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
Keeps track of information about people who will access the HiCat database. People can belong to different groups, such as Co-I, team, validater, suggestor, with different HiCat access privileges.

Field Description Type Null Limits Size Key Default Authority Source
ID This is the unique ID for each Person. The values here should not be assigned by external programs. Instead it can either be ignored, or NULL can be inserted, and the database will automatically assign the next ID. INT(10) unsigned auto_increment Not Null Primary Key db server
USERNAME A unique user name for this person. VARCHAR(15) Not Null unique index HiWeb SIS HiWeb
VERSION Version number of this record. VARCHAR(255) Not Null HiWeb
GIVEN_NAME The given name of this Person. VARCHAR(20) HiWeb SIS HiWeb
FAMILY_NAME The family name of this Person. VARCHAR(20) HiWeb SIS HiWeb
ADDITIONAL_NAMES Any additional names or initials for this Person. VARCHAR(20) HiWeb SIS HiWeb
NAME_SUFFIX Any name suffixes for this person. VARCHAR(20) HiWeb SIS HiWeb
EMAIL_ADDRESS An e-mail address for this person. VARCHAR(60) HiWeb SIS HiWeb
EMAIL_ADDRESS_TMP This field is a temporary place holder used to specify an unconfirmed email address update. The field should be null unless the email address listed here is pending confirmation. VARCHAR(60) HiWish
GROUP_NAME People can be in one or more specific groups. These groups are meant for internal use by various applications. SET("TEAM_MEMBER","VALIDATOR", "TAG", "EPO", "PUB", "HIROC_STAFF","POSTDOC_STUDENT","QUEST_CHALLENGE","HiTS","CIPP", "STL","DEVELOPER","EDITOR") HiWeb SIS HiWeb
POSTAL_CODE The postal code for this Person. VARCHAR(10) HiWeb SIS HiWeb
COUNTRY The country where this person lives. VARCHAR(20) HiWeb SIS HiWeb
OCCUPATION The occupation of this person. VARCHAR(20) HiWeb SIS HiWeb
HIGHEST_GRADE_COMPLETED The highest grade that this person has completed. (Elementary School, Middle School, High School, Undergraduate, Masters, PhD) ENUM("ELEMENTARY SCHOOL","MIDDLE SCHOOL","HIGH SCHOOL","UNDERGRADUATE", "MASTERS","PHD") 0 to 14 HiWeb SIS HiWeb
PASSWORD The encrypted password for this person. This password should be encrypted by MySQL. VARCHAR(40) HiWeb SIS HiWeb
AFFILIATION The affiliation with a particular institution or body that this person has. VARCHAR(80) HiWeb SIS HiWeb
IS_AN_EDUCATOR Is this person an educator? ENUM("NO","YES") Not Null "NO" HiWeb
IS_A_STUDENT Is this person a student? ENUM("NO","YES") Not Null "NO" HiWeb
GRADE_LEVEL The grade level of this classroom. SET("ELEMENTARY SCHOOL","MIDDLE SCHOOL","HIGH SCHOOL","UNDERGRADUATE", "GRADUATE","OTHER") HiWeb
GRADE_LEVEL_OTHER A free form entry column if "OTHER" is selected from the GRADE_LEVEL column. VARCHAR(60) HiWeb
PUBLIC_KEY The public key for this person. TEXT HiPlan SIS? HiWeb
NOTE Who adds this note? What is it for? VARCHAR(200) ??? HiWeb
NOTIFY_ON_RELEASE If set to "YES" the person will be notified via email when the image data of the obseravtion retiring their suggestion is released to the PDS. ENUM("NO","YES") Not Null "NO" HiWish
NOTIFY_ON_UPDATE If set to "YES" the person will also be notified via email when an updated version of the image data that retired thier observation is released. ENUM("NO","YES") Not Null "NO" HiWish
NOTIFY_ON_GEOMETRY_COMPLETION If set to "YES", the team member will be notified via email when an observation retiring one of their targets has completed HiGeomInit. ENUM("NO","YES") Not Null "NO" HiWish
CONFIRMATION_TOKEN A confirmation token used to verify user registration, password change, or email address change requests. VARCHAR(41) HiWish
CONFIRMATION_TYPE The type of user change request needing confirmation from the CONFIRMATION_TOKEN field. ENUM("REGISTER","PASSWORD","EMAIL") HiWish
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

Contact

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