HiCat Data Dictionary

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.