link
Entity - concept_synonym link
| Properties |
| Name | Value | ||||||||||||||||||||||||||||||||||||||
| Description |
CONCEPT_SYNONYMTable Description The CONCEPT_SYNONYM table is used to store alternate names and descriptions for Concepts.
|
||||||||||||||||||||||||||||||||||||||
| Data Model | Physical | ||||||||||||||||||||||||||||||||||||||
| Primary Key Clustered | Unspecified | ||||||||||||||||||||||||||||||||||||||
| Unlogged | false | ||||||||||||||||||||||||||||||||||||||
| Columns Summary |
| Column Name | Data Type | PK / FK | Nullable | Description | |||||
| concept_id | int4 | PK / FK | No | ||||||
| language_concept_id | int4 | PK / FK | No | ||||||
| concept_synonym_name | varchar(1000) | No | |||||||
| Relationships Summary |
| Name | Begin | End | |||
|
|
|
|
|||
|
|
|
|
|||
| Columns Detail |
| Name | Value | ||
| Name | concept_id | ||
| 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 | language_concept_id | ||
| 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_synonym_name | ||
| Type | varchar | ||
| Nullable | false | ||
| Unique | false | ||
| Primary Key | false | ||
| Index | false | ||
| Type Name | varchar | ||
| Length | 1000 | ||
| Scale | 0 | ||
| Id Generator | native | ||
| Foreign Key | false | ||
| Generated | Unspecified | ||
| Sync To Attribute | Yes | ||
| Relationships Detail |
| Name | Value | ||||||||
| Name | fpk_concept_synonym_concept_id | ||||||||
| Foreign Key |
|
||||||||
| Primary Key |
|
||||||||
| To Multiplicity | 0..* | ||||||||
| From Multiplicity | 1 | ||||||||
| Sync To Association | Yes | ||||||||
| Data Model | Physical | ||||||||
| Name | Value | ||||||||
| Name | fpk_concept_synonym_language_concept_id | ||||||||
| Foreign Key |
|
||||||||
| Primary Key |
|
||||||||
| To Multiplicity | 0..* | ||||||||
| From Multiplicity | 1 | ||||||||
| Sync To Association | Yes | ||||||||
| Data Model | Physical | ||||||||
| Appears In |
| Diagram | |||
|
|
|||
|
|
|||