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={The {GAVO} data center team},
  url={http://gavo.aip.de/tableinfo/glots.columns},
  howpublished={{VO} resource provided by the {AIP} {DaCHS}}
}

Columns

Sorted alphabetically. [Sort by DB column index]

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