with Name

OMOP_5.4_ER_ALL

OMOP_5.4_ER : Model

Entity - metadata link

Properties

Name

Value

Description

METADATA

Table Description

The METADATA table contains metadata information about a dataset that has been transformed to the OMOP Common Data Model.

CDM Field	User Guide	ETL Conventions	Datatype	Required	Primary Key	Foreign Key	FK Table	FK Domain
metadata_id	The unique key given to a Metadata record.	Attribute value is auto-generated	integer	Yes	Yes	No
metadata_concept_id			integer	Yes	No	Yes	CONCEPT
metadata_type_concept_id			integer	Yes	No	Yes	CONCEPT
name			varchar(250)	Yes	No	No
value_as_string			varchar(250)	No	No	No
value_as_concept_id			integer	No	No	Yes	CONCEPT
value_as_number	This is the numerical value of the result of the Metadata, if applicable and available. It is not expected that all Metadata will have numeric results, rather, this field is here to house values should they exist.		float	No	No	No
metadata_date			date	No	No	No
metadata_datetime			datetime	No	No	No

Data Model

Physical

Primary Key Constraint Name

xpk_metadata

Primary Key Clustered

Unspecified

Unlogged

false

Columns Summary



	Column Name		Data Type		PK / FK		Nullable		Description

	metadata_id		int4		PK		No
	metadata_concept_id		int4		PK / FK		No
	metadata_type_concept_id		int4		PK / FK		No
	name		varchar(250)				No
	value_as_string		varchar(250)				Yes
	value_as_concept_id		int4		PK / FK		No
	value_as_number		numeric(19)				Yes
	metadata_date		date				Yes
	metadata_datetime		timestamp(0)				Yes

Relationships Summary



	Name		Begin		End

	fpk_metadata_metadata_concept_id : Relationship		concept : Entity		metadata : Entity
	fpk_metadata_metadata_type_concept_id : Relationship		concept : Entity		metadata : Entity
	fpk_metadata_value_as_concept_id : Relationship		concept : Entity		metadata : Entity

Columns Detail



	Name		Value

	Name		metadata_id
	Type		int4
	Nullable		false
	Unique		false
	Primary Key		true
	Index		false
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		metadata_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		metadata_type_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		name
	Type		varchar
	Nullable		false
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		250
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		value_as_string
	Type		varchar
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		varchar
	Length		250
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		value_as_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		value_as_number
	Type		numeric
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		numeric
	Length		19
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes



	Name		Value

	Name		metadata_date
	Type		date
	Nullable		true
	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		metadata_datetime
	Type		timestamp
	Nullable		true
	Unique		false
	Primary Key		false
	Index		false
	Type Name		timestamp
	Length		0
	Scale		0
	Id Generator		native
	Foreign Key		false
	Generated		Unspecified
	Sync To Attribute		Yes

Relationships Detail

Name

Value

Name

fpk_metadata_metadata_concept_id

Foreign Key

	metadata

	metadata_concept_id : Column

Primary Key

	concept

	concept_id : Column

To Multiplicity

0..*

From Multiplicity

0..1

Sync To Association

Yes

Data Model

Physical

Name

Value

Name

fpk_metadata_metadata_type_concept_id

Foreign Key

	metadata

	metadata_type_concept_id : Column

Primary Key

	concept

	concept_id : Column

To Multiplicity

0..*

From Multiplicity

0..1

Sync To Association

Yes

Data Model

Physical

Name

Value

Name

fpk_metadata_value_as_concept_id

Foreign Key

	metadata

	value_as_concept_id : Column

Primary Key

	concept

	concept_id : Column

To Multiplicity

0..*

From Multiplicity

1

Sync To Association

Yes

Data Model

Physical

Appears In



	Diagram

	Standardized_Tables : Entity Relationship Diagram
	Vocabulary_With_Standard : Entity Relationship Diagram

OMOP_5.4_ER_ALL