Field | Description | Type | Null | Limits | Size | Key | Default | Authority | Source |
---|---|---|---|---|---|---|---|---|---|
ID | This is the unique ID for each event. 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 | ||||
EVENT_TITLE | The title of the event. | VARCHAR(255) | Not Null | Date Book Editor | |||||
DESCRIPTION | A short description of the event. | VARCHAR(255) | Date Book Editor | ||||||
ENTRY_DATE | The date the event was entered into the catalog. | DATE | Not Null | Date Book Editor | |||||
START_DATE | The starting date of the event. | DATE | Not Null | Date Book Editor | |||||
START_TIME | The start time of the event. | TIME | Date Book Editor | ||||||
END_DATE | The ending date of the event. | DATE | Not Null | Date Book Editor | |||||
PUBLIC | Is the even public? If yes, the event will be on the website, if no, then the even will be in the BackOffice. | ENUM("YES","NO") | Date Book Editor | ||||||
STATUS | The status of the event. | TINYINT(1) | Date Book Editor | ||||||
LAST_UPDATE | This column records when this record was last updated. | TIMESTAMP | Not Null | 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.