Table information for 'tap_schema.columns'


Table Description: Columns in tables available for ADQL querying.

This table is available for ADQL queries and through the TAP endpoint.

Resource Description: BSDC-VO's Table Access Protocol (TAP) service with table metadata.

For a list of all services and tables belonging to this table's resource, see Information on resource '__system__/tap'


Sorted by DB column index. [Sort alphabetically]

NameTable Head DescriptionUnitUCD
table_name Table Fully qualified table name N/A N/A
column_name Name Column name N/A N/A
description Description Brief description of column N/A N/A
unit Unit Unit in VO standard format N/A N/A
ucd UCD UCD of column if any N/A N/A
utype Utype Utype of column if any N/A N/A
datatype Type ADQL datatype N/A N/A
"size" "size" Length of variable length datatypes N/A N/A
principal Princ? Is column principal? N/A N/A
indexed Indexed? Is there an index on this column? N/A N/A
std Std? Is this a standard column? N/A N/A
sourceRD Sourcerd Id of the originating rd (local information) N/A N/A

Columns that are parts of indices are marked like this.


The following services may use the data contained in this table: