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:Classrooms
Keeps track of information about classroom activities and group educational projects. People can belong to different classrooms via the People_Classrooms_map table.

Field Description Type Null Limits Size Key Default Authority Source
ID This is the unique ID for each Classroom. 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
VERSION Version number of this record. VARCHAR(255) Not Null HiWeb
USERNAME A unique user name for this classroom. VARCHAR(15) Not Null unique index HiWeb
PASSWORD The encrypted password for this classroom. This password should be encrypted by MySQL. VARCHAR(40) HiWeb
LEADER_ID The ID from the People table of the leader of this classroom group. INT(10) unsigned Foreign Key which references People (ID) ON DELETE SET NULL HiWeb
SCHOOL_NAME This is the name of the school that this classroom belongs to. VARCHAR(128) HiWeb
ADDRESS The post office box or street address for this classroom. TEXT HiWeb
CITY The city where this classroom is located. TEXT HiWeb
REGION The region where this classroom is located. TEXT HiWeb
POSTAL_CODE The postal code for this classroom. VARCHAR(10) HiWeb
COUNTRY The country where this classroom is located. VARCHAR(20) HiWeb
GRADE_LEVEL The grade level(s) of the classroom. SET("KINDERGARTEN","1","2","3","4","5","6","7","8","9","10","11","12", "UNDERGRADUATE","GRADUATE") HiWeb
LAST_UPDATE This column records the last time that a record was updated. TIMESTAMP db server

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.