tbl_sample_descriptions

6943 rows


Description

Stores detailed descriptions of samples categorized by different description types.

Columns

Column Type Size Nulls Auto Children Parents Comments
sample_description_id int4 10 √

Primary key (automatically incremented).
sample_description_type_id int4 10
tbl_sample_description_types.sample_description_type_id fk_sample_descriptions_sample_description_type_id R

Specifies the type identifier for the sample description.
physical_sample_id int4 10
tbl_physical_samples.physical_sample_id fk_sample_descriptions_physical_sample_id R

Identifies the specific physical sample.
description varchar 2147483647 √

Textual description of the sample.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_sample_descriptions_pkey Primary key Asc sample_description_id

Relationships

Close relationships within degrees of separation