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