SchemaSpy - Table postgres.omop.concept

[VOCABULARY] 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:

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

concept_class_id

varchar

concept.concept_class_id

fpk_concept_class R

A unique key for each class.

concept_class_name

varchar

255

The name describing the Concept Class, e.g. "Clinical Finding", "Ingredient", etc.

concept_class_concept_id

int4

concept.concept_id

fpk_concept_class_concept R

A foreign key that refers to an identifier in the [CONCEPT](https://github.com/OHDSI/CommonDataModel/wiki/CONCEPT) table for the unique Concept Class the record belongs to.

Table contained 0 rows at dim. sept. 10 20:08 CEST 2017

Indexes:

Column(s)	Type	Sort	Constraint Name
concept_class_id	Primary key	Asc	xpk_concept_class
concept_class_id	Must be unique	Asc	idx_concept_class_class_id