ForeignKey
SuperType: None
Status: ACTIVE_TYPEDEF
Category: RELATIONSHIP_DEF
Version: 1
MultiLink: False
GUID:
3cd4e0e7-fdbf-47a6-ae88-d4b3205e0c07
Attribute Definitions:
| Name | Type | Status | Indexable | Unique | Cardinality | Description |
|---|---|---|---|---|---|---|
| description | string | ACTIVE_ATTRIBUTE | True | False | AT_MOST_ONE | Description of the element or associated resource in free-text. |
| confidence | int | ACTIVE_ATTRIBUTE | True | False | AT_MOST_ONE | Level of confidence in the correctness of the element. 0=unknown; 1=low confidence; 100=total confidence. |
| steward | string | ACTIVE_ATTRIBUTE | True | False | AT_MOST_ONE | Unique identifier for the steward performing the action. |
| source | string | ACTIVE_ATTRIBUTE | True | False | AT_MOST_ONE | Details of the organization, person or process that created the element, or provided the information used to create the element. |
| name | string | ACTIVE_ATTRIBUTE | True | False | AT_MOST_ONE | Short name that the element is known as - not necessarily unique. |
End1: RelationalColumn
- Attribute Name: primaryKey
- Attribute Description: Relational column holding the primary key.
- Attribute Cardinality: AT_MOST_ONE
End2: RelationalColumn
- Attribute Name: foreignKey
- Attribute Description: Use of primary key from another table to enable table joins.
- Attribute Cardinality: ANY_NUMBER
Description:
The primary key for another column is stored in a relational column from another table to enable them to be joined.