Field | Description | Type | Null | Limits | Size | Key | Default | Authority | Source |
---|---|---|---|---|---|---|---|---|---|
ID | A unique integer ID assocated with each coordinate. | INT(10) unsigned auto_increment | Not Null | Primary Key | db server | ||||
TAG_ID | This is the ID of the TAG from the TAGS table that this coordinate is associated with. | INT(10) unsigned | Not Null | Foreign Key which references Tags (ID) ON DELETE CASCADE | Downlink tools | ||||
COORDINATE_TYPE | The type of coordinates being stored. This can be a single point, a polygon, or a circle. | ENUM("POLYGON","CIRCLE_CENTER","CIRCLE_RADIUS") | Not Null | Downlink tools | |||||
SEQUENCE | An optional field indicating the order of the points, for example, to traverse the points of a polygong in a clockwise fashion. | INT(3) unsigned | Downlink tools | ||||||
IMAGE_X | The value of the "X" coordinate in the image for this node. | FLOAT | Not Null | Downlink tools | |||||
IMAGE_Y | The value of thhe "Y" coordinate in the image for this node. | FLOAT | Not Null | Downlink tools | |||||
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.