Table information for 'tap_schema.key_columns'

General

Table Description: Columns participating in foreign key relationships between tables available for ADQL querying.

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

Resource Description: AIP DaCHS'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

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

@MISC{vo:tap_schema_key_c,
  year=2009,
  title={Untitled Resource},
  author={The {GAVO} data center team},
  url={http://gavo.aip.de/tableinfo/tap_schema.key_columns},
  howpublished={{VO} resource provided by the {AIP} {DaCHS}}
}

Columns

Sorted by DB column index. [Sort alphabetically]

NameTable Head DescriptionUnitUCD
key_id Id Key identifier from TAP_SCHEMA.keys N/A N/A
from_column Src. Column Key column name in the from table N/A N/A
target_column Tgt. Column Key column in the target table N/A N/A
sourceRD Sourcerd Id of the originating rd (local information) 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.