xmmssc_tap_schema.columns
Description
The table of columns of the service
Columns
| Name | Type | UCD | Unit | Description |
|---|---|---|---|---|
| id | integer |
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 | integer |
The size of the column for variable length datatypes |
||
| size | integer |
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 | boolean |
Designates if the column is considered a core part of the service |
||
| indexed | boolean |
Designates if the column is indexed |
||
| std | boolean |
Designates if the column is defined by some standard |
||
| column_index | integer |
The ordering index of the column |
||
| table_id | integer |
The foreign key to the table of this column |