-
Notifications
You must be signed in to change notification settings - Fork 10
DATA_SOURCE
Robert Miller edited this page May 28, 2019
·
2 revisions
The DATA SOURCE table records metadata about external data sets.
| Field | Required | Type | Description |
|---|---|---|---|
| data_source_id | Yes | varchar(100) | A unique string identifier. Similar pattern of 'vocabulary_id' |
| data_source_name | Yes | varchar(255) | The name of the data source |
| data_source_description | No | varchar(max) | A short description of the data source. |
| data_source_type_id | Yes | varchar(255) | (TODO) A foreign key to a Standard Concept ID of the type of data source |
| data_source_type_name | Yes | varchar(255) | Text representation of type |
| document_url | No | varchar(100) | A link to documentation for the data source. |
| source_version | No | varchar(50) | Specifies which version or release of the source data was used. |
| collection_start_date | No | date | The date the data started being collected. |
| collection_end_date | No | date | The date the data ended being collected. |
| timeframe_concept_id | No | integer | A foreign key to a Standard Concept ID of time intervals in the Standardized Vocabularies. Used in conjunction with timeframe_value to specify the length of time the data represents. |
| timeframe_name | No | varchar(100) | text representation of timeframe. 'Year', 'Month', etc. |
| timeframe_value | No | float | A numeric qualifier used in conjunction with timeframe_concept_id to specify the length of time the data represents. |
| last_updated_date | No | date | The date of the last edit of the data set |
Subject
Relation
Attribute
Metadata