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: BSDC-VO'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'

Fields

Sorted alphabetically. [Sort by DB column index]

Name	Table Head	Description	Unit	UCD
from_column	Src. Column	Key column name in the from table	N/A	N/A
key_id	Id	Key identifier from TAP_SCHEMA.keys	N/A	N/A
sourceRD	Sourcerd	Id of the originating rd (local information)	N/A	N/A
target_column	Tgt. Column	Key column in the target table	N/A	N/A

Columns that are parts of indices are marked like this.

Other