Table postgres.omop.specimen
[CLINICAL] The specimen domain contains the records identifying biological samples from a person.

 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
specimen_id int4 10 A unique identifier for each specimen.
person_id int4 10
person.person_id fpk_specimen_person R
A foreign key identifier to the Person for whom the Specimen is recorded.
specimen_concept_id int4 10
concept.concept_id fpk_specimen_concept R
A foreign key referring to a Standard Concept identifier in the Standardized Vocabularies for the Specimen.
specimen_type_concept_id int4 10
concept.concept_id fpk_specimen_type_concept R
A foreign key referring to the Concept identifier in the Standardized Vocabularies reflecting the system of record from which the Specimen was represented in the source data.
specimen_date date 13 The date the specimen was obtained from the Person.
specimen_datetime timestamp 29,6  √  null The date and time on the date when the Specimen was obtained from the person.
quantity numeric 131089  √  null The amount of specimen collection from the person during the sampling procedure.
unit_concept_id int4 10  √  null
concept.concept_id fpk_specimen_unit_concept R
A foreign key to a Standard Concept identifier for the Unit associated with the numeric quantity of the Specimen collection.
anatomic_site_concept_id int4 10  √  null
concept.concept_id fpk_specimen_site_concept R
A foreign key to a Standard Concept identifier for the anatomic location of specimen collection.
disease_status_concept_id int4 10  √  null
concept.concept_id fpk_specimen_status_concept R
A foreign key to a Standard Concept identifier for the Disease Status of specimen collection.
specimen_source_id varchar 50  √  null The Specimen identifier as it appears in the source data.
specimen_source_value varchar 50  √  null The Specimen value as it appears in the source data. This value is mapped to a Standard Concept in the Standardized Vocabularies and the original code is, stored here for reference.
unit_source_value varchar 50  √  null The information about the Unit as detailed in the source.
anatomic_site_source_value varchar 50  √  null The information about the anatomic site as detailed in the source.
disease_status_source_value varchar 50  √  null The information about the disease status as detailed in the source.

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

Indexes:
Column(s) Type Sort Constraint Name
specimen_id Primary key Asc xpk_specimen
specimen_concept_id Performance Asc idx_specimen_concept_id
person_id Performance Asc idx_specimen_person_id

Close relationships  within of separation: