musewide_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 | unsignedByte | Designates if the column is considered a core part of the service | ||
| indexed | unsignedByte | Designates if the column is indexed | ||
| std | unsignedByte | 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 |