Field | Description | Type | Null | Limits | Size | Key | Default | Authority | Source |
---|---|---|---|---|---|---|---|---|---|
ID | This is the unique ID for each publication. 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 | ||||
AUTHORS | Release author(s). Input by Co-I. | TEXT | Co-I | ||||||
DATE | Release date. Input by Co-I. | DATE | Co-I? | ||||||
RELEASE_LOCATION | Release location? Input by Co-I. | VARCHAR(250) | HiCat FRD | ||||||
TITLE | The title of the article. | VARCHAR(255) | The release | ||||||
ABSTRACT | The abstract of the paper, if applicable. | TEXT | The release | ||||||
STATUS | The status of this publication. | ENUM( "NO","YES","DRAFT","EMBARGOED" ) | Not Null | ||||||
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.