HiRISE Home
Last updated:
(none)
|
-
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 |
- Field: the field name within the table.
- Description: the definition for the field.
- 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.
- Authority: the agency responsible for definition of the field.
- Source: the most frequent source of data for this field.
Table Options:
Copyright (C) 2005-2020 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.
$Name: $
Contact
Please send comments to:
HiCat@pirlmail.lpl.arizona.edu.
|
