tbl_sample_description_types

11 rows


Description

Specifies various types of sample descriptions used in the database.

Columns

Column Type Size Nulls Auto Children Parents Comments
sample_description_type_id int4 10 √
tbl_sample_description_sample_group_contexts.sample_description_type_id fk_sample_description_types_sample_group_context_id R
tbl_sample_descriptions.sample_description_type_id fk_sample_descriptions_sample_description_type_id R

Primary key (automatically incremented).
type_name varchar(255) 255 √

Name assigned to the sample type.
type_description text 2147483647 √

Detailed description of the sample type.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_sample_description_types_pkey Primary key Asc sample_description_type_id
tbl_sample_description_types_norm_trgm Performance
tbl_sample_description_types_type_name_key Must be unique Asc type_name
tbl_sample_description_types_type_name_unique Must be unique Asc type_name

Relationships

Close relationships within degrees of separation