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: PVOL EPN-TAP'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'

Citing this table

Reference the Table

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

@MISC{vo:tap_schema_columns,
  year=2009,
  title={Untitled Resource},
  author={Planetary Sciences Group, {UPV}/{EHU}},
  url={http://pvol2.ehu.eus:8083/tableinfo/tap_schema.columns},
  howpublished={{VO} resource provided by the {PVOL} {EPN}-{TAP}}
}

Fields

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
column_index Ind. 1-based index of the column in database order. 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.