tap_schema.columns
Description
The table of columns of the service
Columns
An asterisk (*) marks an indexed column.
| 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 |