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: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 |
- 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.
|
