tbl_sample_group_description_types

59 rows


Description

Categorizes the types of descriptions related to sample groups. It includes types such as architectural data (e.g., roof type, structural details) or dendrochronological anlabels related to shipwrecks. Note that these descriptions are intended to provide context and should not be used to infer specific features of the samples. Users can add custom lookup data.

Columns

Column Type Size Nulls Auto Children Parents Comments
sample_group_description_type_id int4 10 √
tbl_sample_group_description_type_sampling_contexts.sample_group_description_type_id fk_sample_group_description_type_sampling_context_id R
tbl_sample_group_descriptions.sample_group_description_type_id fk_sample_group_descriptions_sample_group_description_type_id R

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

The name or label of the sample group description type.
type_description varchar 2147483647 √

A detailed description of the sample group description type.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_sample_group_description_types_pkey Primary key Asc sample_group_description_type_id
tbl_sample_group_description_types_norm_trgm Performance
tbl_sample_group_description_types_type_name_key Must be unique Asc type_name
tbl_sample_group_description_types_type_name_unique Must be unique Asc type_name

Check Constraints

Constraint Name Constraint
tbl_sample_group_descripti_sample_group_description_t_not_null2 sample_group_description_type_id IS NOT NULL

Relationships

Close relationships within degrees of separation