SYSTEMTABLEFOREIGNKEYS: Data Dictionary Foreign Keys
read only
- Catalogue :
DataDictionary - Schéma :
Invantive - Label: Foreign Keys
Foreign keys per table per data container, one row per column of a foreign key.
Permet uniquement de récupérer des données.
Résumé
Lists the foreign keys the driver knows of the tables it has loaded the metadata of. The guarantee tells whether the engine may trust a foreign key to leave out an inner join: 'Declared' foreign keys are shown but not relied upon.
Colonnes de table
Les colonnes de la table SYSTEMTABLEFOREIGNKEYS sont présentées ci-dessous. Chaque colonne possède un type de données SQL. Une nouvelle valeur non nulle doit être fournie pour chaque colonne requise à tout moment lors de l'insertion et de la mise à jour.
| Name | Type de données | Label | Required | Marks | Documentation |
|---|---|---|---|---|---|
COLUMN_ |
varchar2 |
Nom de colonne | Name of the column. | ||
COLUMN_ |
int32 |
Position de colonne | Position of the column within the key, starting at 1. | ||
ID |
int32 |
ID | Unique ID of the row. | ||
KEY_ |
int32 |
Columns | Number of columns of the key. | ||
KEY_ |
varchar2 |
Description | When the relation holds or what it was found on, in words; always filled for a textual or candidate foreign key. | ||
KEY_ |
varchar2 |
Key Status | What holds the key: 'Declared' (not relied upon), 'Enforced' or 'EnforcedIgnoringTrailingBlanks' (enforced, comparing texts without their trailing blanks). | ||
KEY_ |
varchar2 |
Key Type | Kind of the foreign key: 'Key' (the columns refer to a key of the table referred to), 'Textual' (described in words only, such as a polymorphic reference or a row that may have moved to an archive) or 'Candidate' (follows from the names and holds in the data, but is not stated by the platform). | ||
KEY_ |
varchar2 |
Key Name | Name of the key, when known. | ||
PROVIDER_ |
varchar2 |
Alias du conteneur de données | Data container alias. | ||
PROVIDER_ |
varchar2 |
ID du conteneur de données | Data container ID. | ||
PROVIDER_ |
varchar2 |
Description du fournisseur | Provider description. | ||
PROVIDER_ |
guid |
UID de l'instance du fournisseur | Unique ID of the provider instance. | ||
PROVIDER_ |
varchar2 |
Nom du fournisseur | Name of the provider. | ||
PROVIDER_ |
varchar2 |
Nom abrégé du fournisseur | Provider short name. | ||
REFERENCED_ |
varchar2 |
Reference Column Name | Name of the column referred to, at the same position in the key referred to. | ||
REFERENCED_ |
varchar2 |
Tableau de référence | Name of the table referred to. | ||
REFERENCED_ |
varchar2 |
Reference Schema | Schema of the table referred to, when known. | ||
TABLE_ |
varchar2 |
Table Catalog | Catalog where the tables are contained in. | ||
TABLE_ |
varchar2 |
Nom complet de la table | Full qualified name. | ||
TABLE_ |
varchar2 |
Nom de la table | Name of the table or view. | ||
TABLE_ |
varchar2 |
Table Schema | Schema within the catalog where the table is contained in. | ||
TABLE_ |
varchar2 |
Type de table | Type, can be either 'view' or 'table'. |
Clés
| Key | Column | Se réfère à | Kind | Description |
|---|---|---|---|---|
SYSTEMTABLEFOREIGNKEYS_ |
PROVIDER_ |
SYSTEMDATACONTAINERS. |
Key | |
SYSTEMTABLEFOREIGNKEYS_ |
PROVIDER_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLEFOREIGNKEYS_ |
TABLE_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLEFOREIGNKEYS_ |
TABLE_ |
SYSTEMTABLES. |
Key | |
SYSTEMTABLEFOREIGNKEYS_ |
TABLE_ |
SYSTEMTABLES.NAME |
Key |
Notes de Version
Quels ont été les changements apportés à chaque version au niveau des tables, des colonnes, des attributs et des fonctionnalités du chauffeur :