Table information for 'glots.columns'

General

Table Description: A table of columns within the tables listed in glots.tables.

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

Resource Description:

The global TAP schema collects information on tables and columns from known TAP servers. This facilitates locating queriable data by physics (via UCD) or keywords (via description).

Note that this shouldn't really be necessary as all information present here should be exposed through Registry records. However, in reality data providers currently are much more liable to give column metadata in their tap_schema than in their Registry records. Hence, for the time being, we maintain this service by harvesting tap_schemas about monthly.

For a list of all services and tables belonging to this table's resource, see Information on resource 'GloTS, the Global TAP Schema'

Citing this table

To cite the table as such, we suggest the following BibTeX entry:

@MISC{vo:glots_columns,
  year=2010,
  title={{GloTS}, the Global {TAP} Schema},
  author={{GAVO} Data Centre},
  url={https://dc.zah.uni-heidelberg.de/tableinfo/glots.columns},
  howpublished={{VO} resource provided by the {GAVO} Data Center}
}

Columns

Sorted by DB column index. [Sort alphabetically]

NameTable Head DescriptionUnitUCD
ivoid id IVOA identifier of providing service N/A N/A
table_name Table name Fully qualified table name N/A N/A
column_name Column 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 (some services still have 1.0 UCDs). N/A N/A
utype Utype Utype of column N/A N/A
datatype Datatype ADQL datatype N/A N/A
"size" Size Length of variable length datatypes N/A N/A
principal Principal Is column principal? N/A N/A
indexed Index? Is there an index on this column? N/A N/A
std Std Is this a standard column? N/A N/A

Columns that are parts of indices are marked like this.

Other

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

VOResource

VO nerds may sometimes need VOResource XML for this table.