Table information for 'tap_schema.columns'

General

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'

Fields

Sorted alphabetically. [Sort by DB column index]

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

Columns that are parts of indices are marked like this.

Other