Table information for 'rr.table_column'

General

Table Description: Metadata on columns of a resource's tables.

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

Resource Description:

Tables containing the information in the IVOA Registry. To query these tables, use our TAP service.

For more information and example queries, see the RegTAP specification.

For a list of all services and tables belonging to this table's resource, see Information on resource 'GAVO RegTAP Service (Potsdam mirror)'

Citing this table

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

@MISC{vo:rr_table_column,
  year=2012,
  title={{GAVO} {RegTAP} Service (Potsdam mirror)},
  author={The {GAVO} data center team},
  url={http://gavo.aip.de/tableinfo/rr.table_column},
  howpublished={{VO} resource provided by the {AIP} {DaCHS}}
}

Columns

Sorted by DB column index. [Sort alphabetically]

NameTable Head DescriptionUnitUCD
ivoid Ivoid The parent resource. N/A N/A
table_index Table_index Index of the table this column belongs to. N/A N/A
name Name The name of the column. N/A N/A
ucd Ucd A unified content descriptor that describes the scientific content of the column. N/A N/A
unit Unit The unit associated with all values in the column. N/A N/A
utype Utype An identifier for a role in a data model that the data in this column represents. N/A N/A
std Std If 1, the meaning and use of this column is reserved and defined by a standard model. If 0, it represents a database-specific column that effectively extends beyond the standard. N/A N/A
datatype Datatype The type of the data contained in the column. N/A N/A
extended_schema Extended_schema An identifier for the schema that the value given by the extended attribute is drawn from. N/A N/A
extended_type Extended_type A custom type for the values this column contains. N/A N/A
arraysize Arraysize The shape of the array that constitutes the value, e.g., 4, *, 4*, 5x4, or 5x*, as specified by VOTable. N/A N/A
delim Delim The string that is used to delimit elements of an array value when arraysize is not '1'. N/A N/A
type_system Type_system The type system used, as a QName with a canonical prefix; this will ususally be one of vs:simpledatatype, vs:votabletype, and vs:taptype. N/A N/A
flag Flag Hash-separated keywords representing traits of the column. Recognized values include "indexed", "primary", and "nullable". N/A N/A
column_description Column_description A free-text description of the column's contents. 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.