Description

CONCEPT_CLASS

Table Description

The CONCEPT_CLASS table is a reference table, which includes a list of the classifications used to differentiate Concepts within a given Vocabulary. This reference table is populated with a single record for each Concept Class.

CDM Field	User Guide	Datatype	Required	Primary Key	Foreign Key	FK Table
concept_class_id	A unique key for each class.	varchar(20)	Yes	Yes	No
concept_class_name	The name describing the Concept Class, e.g. Clinical Finding, Ingredient, etc.	varchar(255)	Yes	No	No
concept_class_concept_id	A Concept that represents the Concept Class.	integer	Yes	No	Yes	CONCEPT

Primary Key Constraint Name

xpk_concept_class

Unlogged

false



Name	Begin	End

fpk_concept_concept_class_id : Relationship	concept_class : Entity	concept : Entity
fpk_concept_class_concept_class_concept_id : Relationship	concept : Entity	concept_class : Entity



	Name		Value

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



	Name		Value

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



Column Name	Data Type	PK / FK	Nullable	Description

concept_class_id	varchar(20)	PK	No
concept_class_concept_id	int4	FK	No
concept_class_name	varchar(255)		No



	Diagram

	Vocabulary_With_Standard : Entity Relationship Diagram
	Vocabulary_Tables : Entity Relationship Diagram