Table postgres.omop.drug_strength
[VOCABULARY] The DRUG_STRENGTH table contains structured content about the amount or concentration and associated units of a specific ingredient contained within a particular drug product. This table is supplemental information to support standardized analysis of drug utilization.

 Generated by
SchemaSpy
Legend: SourceForge.net
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
drug_concept_id int4 10
concept.concept_id fpk_drug_strength_concept_1 R
A foreign key to the Concept in the CONCEPT table representing the identifier for Branded Drug or Clinical Drug Concept.
ingredient_concept_id int4 10
concept.concept_id fpk_drug_strength_concept_2 R
A foreign key to the Concept in the CONCEPT table, representing the identifier for drug Ingredient Concept contained within the drug product.
amount_value numeric 131089  √  null The numeric value associated with the amount of active ingredient contained within the product.
amount_unit_concept_id int4 10  √  null
concept.concept_id fpk_drug_strength_unit_1 R
A foreign key to the Concept in the CONCEPT table representing the identifier for the Unit for the absolute amount of active ingredient.
numerator_value numeric 131089  √  null The numeric value associated with the concentration of the active ingredient contained in the product
numerator_unit_concept_id int4 10  √  null
concept.concept_id fpk_drug_strength_unit_2 R
A foreign key to the Concept in the CONCEPT table representing the identifier for the numerator Unit for the concentration of active ingredient.
denominator_value numeric 131089  √  null The amount of total liquid (or other divisible product, such as ointment, gel, spray, etc.).
denominator_unit_concept_id int4 10  √  null
concept.concept_id fpk_drug_strength_unit_3 R
A foreign key to the Concept in the CONCEPT table representing the identifier for the denominator Unit for the concentration of active ingredient.
box_size int4 10  √  null The number of units of Clinical of Branded Drug, or Quantified Clinical or Branded Drug contained in a box as dispensed to the patient
valid_start_date date 13 The date when the Concept was first recorded. The default value is 1-Jan-1970.
valid_end_date date 13 The date when the concept became invalid because it was deleted or superseded (updated) by a new Concept. The default value is 31-Dec-2099.
invalid_reason varchar 1  √  null Reason the concept was invalidated. Possible values are 'D'(deleted), 'U'(replaced with an update) or NULL when valid_end_date has the default value.

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

Indexes:
Column(s) Type Sort Constraint Name
drug_concept_id + ingredient_concept_id Primary key Asc/Asc xpk_drug_strength
drug_concept_id Performance Asc idx_drug_strength_id_1
ingredient_concept_id Performance Asc idx_drug_strength_id_2

Close relationships  within of separation: