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 |
Table Options:
Copyright (C) 2005-2022 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
Please send comments to: HiCat@pirlmail.lpl.arizona.edu.