gaia_dev_tap_schema.columns
Description
The table of columns of the service
Columns
| Name | Type | UCD | Unit | Description |
|---|---|---|---|---|
| id | int |
Internal ID of the column |
||
| table_name | char |
The name of the table of the column |
||
| column_name | char |
The name of the column |
||
| datatype | char |
The datatype of the column |
||
| arraysize | int |
The size of the column for variable length datatypes |
||
| size | int |
The size of the column for variable length datatypes (legacy) |
||
| description | char |
The description of the column |
||
| utype | char |
The IVOA UTYPE of the column |
||
| unit | char |
The Unit of the column |
||
| ucd | char |
The IVOA UCD of the column |
||
| principal | int |
Designates if the column is considered a core part of the service |
||
| indexed | int |
Designates if the column is indexed |
||
| std | int |
Designates if the column is defined by some standard |
||
| column_index | int |
The ordering index of the column |
||
| table_id | int |
The foreign key to the table of this column |