HiRISE: HiCat Data Dictionary HiRISE.People

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 ID is available in both a 32-bit binary code and a user-friendly text representation. 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	Key
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
USERNAME	A unique user name for this person.	VARCHAR(15)	Not Null
GIVEN_NAME	The given name of this Person.	VARCHAR(20)
FAMILY_NAME	The family name of this Person.	VARCHAR(20)
ADDITIONAL_NAMES	Any additional names or initials for this Person.	VARCHAR(20)
NAME_SUFFIX	Any name suffixes for this person.	VARCHAR(20)
EMAIL_ADDRESS	An e-mail address for this person.	VARCHAR(60)
GROUP_NAME	This should probably be a set, not an enum. We may want to break this out into an entirely separate table with a mapping table.	ENUM("PI", "DPI", "PROJECT_MANAGER", "CO-I", "VALIDATOR", "TAG", "EPO", "PUB", "HIROC_STAFF", "OTHER")
POSTAL_CODE	The postal code for this Person.	VARCHAR(10)
COUNTRY	The country where this person lives.	VARCHAR(20)
OCCUPATION	The occupation of this person.	VARCHAR(20)
HIGHEST_GRADE_COMPLETED	The highest grade that this person has completed. This field is intended to represent kindergarten through graduate school. A zero indicates any grade less than first. First through high school are indicated by one through twelve. Undergraduate is thirteen, and graduate school is fourteen.	TINYINT(2) unsigned
PASSWORD	The encrypted password for this person. This password should be encrypted by MySQL.	VARCHAR(40)
AFFILIATION	The affiliation with a particular institution or body that this person has.	VARCHAR(80)
PUBLIC_KEY	The public key for this person.	TEXT
NOTE	Who adds this note? What is it for?	VARCHAR(200)
LAST_UPDATE	This column records the last time that a record was updated.	TIMESTAMP

Field: the field name inside table.
Type: the data type of the field.
Null: whether the field is allowed to be null.
Limits: the acceptable data range for the field.
Size: the upper limit data storage size for the field.
Default: the default value for the field.
Description: the definition for the field.
Authority: the agency responsible for definition of the field.
The fields with yellow color background is primary key or keys frequently used to link tables together.

Table Options:

type=InnoDB

This page was generated from the XML HiCat Data Dictionary. $Name: $

Contact

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