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: PDS-PPI VO server'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_columns,
  year=2009,
  title={Untitled Resource},
  author={{PDS}-{PPI}},
  url={http://vo-pds-ppi.igpp.ucla.edu/tableinfo/tap_schema.key_columns},
  howpublished={{VO} resource provided by the {PDS}-{PPI} VO server}
}

Columns

Sorted alphabetically. [Sort by DB column index]

NameTable Head DescriptionUnitUCD
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

The following services may use the data contained in this table:

VOResource

VO nerds may sometimes need VOResource XML for this table.