objectType ForeignKey

A description of the mapping a foreign key -- a set of columns from one table -- to columns in another table. When foreign keys are declared in this way, clients can expect that joins constrained with the foreign keys are preformed efficiently (e.g., using an index).

Members

name	type	mult	description
targetTable	ivoa:string		The fully qualified name (including catalogue and schema, as applicable) of the table that can be joined with the table containing this foreign key.
fkColumn	FKColumn	1 or more	A pair of column names, one from this table and one from the target table that should be used to join the tables in a query.
description	ivoa:string	optional	A free-text description of what this key points to and what the relationship means.
utype	ivoa:string	optional	An identifier for a concept in a data model that the association enabled by this key represents. The form of the utype string depends on the data model; common forms are sequences of dotted identifiers (e.g., in SSA) or URIs (e.g., in RegTAP).

Containment

This is contained by Table