Entity - concept_relationship link
Properties |
Name | Value | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Description |
CONCEPT_RELATIONSHIPTable Description The CONCEPT_RELATIONSHIP table contains records that define direct relationships between any two Concepts and the nature or type of the relationship. Each type of a relationship is defined in the RELATIONSHIP table.
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Data Model | Physical | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Primary Key Clustered | Unspecified | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Unlogged | false |
Columns Summary |
Column Name | Data Type | PK / FK | Nullable | Description | |||||
concept_id_1 | int4 | PK / FK | No | ||||||
concept_id_2 | int4 | PK / FK | No | ||||||
relationship_id | varchar(20) | PK / FK | No | ||||||
valid_start_date | date | No | |||||||
valid_end_date | date | No | |||||||
invalid_reason | varchar(1) | Yes |
Relationships Summary |
Columns Detail |
Name | Value | ||
Name | concept_id_1 | ||
Type | int4 | ||
Nullable | false | ||
Unique | false | ||
Primary Key | true | ||
Index | false | ||
Length | 0 | ||
Scale | 0 | ||
Id Generator | native | ||
Foreign Key | true | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | concept_id_2 | ||
Type | int4 | ||
Nullable | false | ||
Unique | false | ||
Primary Key | true | ||
Index | false | ||
Length | 0 | ||
Scale | 0 | ||
Id Generator | native | ||
Foreign Key | true | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | relationship_id | ||
Type | varchar | ||
Nullable | false | ||
Unique | false | ||
Primary Key | true | ||
Index | false | ||
Type Name | varchar | ||
Length | 20 | ||
Scale | 0 | ||
Id Generator | native | ||
Foreign Key | true | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | valid_start_date | ||
Type | date | ||
Nullable | false | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | date | ||
Length | 0 | ||
Scale | 0 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | valid_end_date | ||
Type | date | ||
Nullable | false | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | date | ||
Length | 0 | ||
Scale | 0 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | invalid_reason | ||
Type | varchar | ||
Nullable | true | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | varchar | ||
Length | 1 | ||
Scale | 0 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Relationships Detail |
Name | Value | ||||||||
Name | fpk_concept_relationship_concept_id_1 | ||||||||
Foreign Key |
|
||||||||
Primary Key |
|
||||||||
To Multiplicity | 0..* | ||||||||
From Multiplicity | 1 | ||||||||
Sync To Association | Yes | ||||||||
Data Model | Physical |
Name | Value | ||||||||
Name | fpk_concept_relationship_concept_id_2 | ||||||||
Foreign Key |
|
||||||||
Primary Key |
|
||||||||
To Multiplicity | 0..* | ||||||||
From Multiplicity | 1 | ||||||||
Sync To Association | Yes | ||||||||
Data Model | Physical |
Name | Value | ||||||||
Name | fpk_concept_relationship_relationship_id | ||||||||
Foreign Key |
|
||||||||
Primary Key |
|
||||||||
To Multiplicity | 0..* | ||||||||
From Multiplicity | 1 | ||||||||
Sync To Association | Yes | ||||||||
Data Model | Physical |
Appears In |
Diagram | |||
|
|||
|