Entity - cdm_source link
Properties |
Name | Value | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Description |
CDM_SOURCETable Description The CDM_SOURCE table contains detail about the source database and the process used to transform the data into the OMOP Common Data Model.
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Data Model | Physical | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Primary Key Clustered | Unspecified | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Unlogged | false |
Columns Summary |
Column Name | Data Type | PK / FK | Nullable | Description | |||||
cdm_source_name | varchar(255) | No | |||||||
cdm_source_abbreviation | varchar(25) | No | |||||||
cdm_holder | varchar(255) | No | |||||||
source_description | text | Yes | |||||||
source_documentation_reference | varchar(255) | Yes | |||||||
cdm_etl_reference | varchar(255) | Yes | |||||||
source_release_date | date | No | |||||||
cdm_release_date | date | No | |||||||
cdm_version | varchar(10) | Yes | |||||||
cdm_version_concept_id | int4 | PK / FK | No | ||||||
vocabulary_version | varchar(20) | No |
Relationships Summary |
Name | Begin | End | |||
|
|
|
Columns Detail |
Name | Value | ||
Name | cdm_source_name | ||
Type | varchar | ||
Nullable | false | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | varchar | ||
Length | 255 | ||
Scale | 0 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | cdm_source_abbreviation | ||
Type | varchar | ||
Nullable | false | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | varchar | ||
Length | 25 | ||
Scale | 0 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | cdm_holder | ||
Type | varchar | ||
Nullable | false | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | varchar | ||
Length | 255 | ||
Scale | 0 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | source_description | ||
Type | text | ||
Nullable | true | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | text | ||
Length | 0 | ||
Scale | 0 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | source_documentation_reference | ||
Type | varchar | ||
Nullable | true | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | varchar | ||
Length | 255 | ||
Scale | 0 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | cdm_etl_reference | ||
Type | varchar | ||
Nullable | true | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | varchar | ||
Length | 255 | ||
Scale | 0 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | source_release_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 | cdm_release_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 | cdm_version | ||
Type | varchar | ||
Nullable | true | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | varchar | ||
Length | 10 | ||
Scale | 0 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Name | Value | ||
Name | cdm_version_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 | vocabulary_version | ||
Type | varchar | ||
Nullable | false | ||
Unique | false | ||
Primary Key | false | ||
Index | false | ||
Type Name | varchar | ||
Length | 20 | ||
Scale | 0 | ||
Id Generator | native | ||
Foreign Key | false | ||
Generated | Unspecified | ||
Sync To Attribute | Yes |
Relationships Detail |
Name | Value | ||||||||
Name | fpk_cdm_source_cdm_version_concept_id | ||||||||
Foreign Key |
|
||||||||
Primary Key |
|
||||||||
To Multiplicity | 0..* | ||||||||
From Multiplicity | 0..1 | ||||||||
Sync To Association | Yes | ||||||||
Data Model | Physical |
Appears In |
Diagram | |||
|
|||
|