tbl_sample_types

18 rows


Description

Defines the physical form or category of a sample. This can include specific sub-samples related to the sampling method of a sample group, or general bulk samples. Examples include ‘Core Subsample’, ‘Grab Sample’, and ‘Bulk (Bag) Sample’.

Columns

Column Type Size Nulls Auto Children Parents Comments
sample_type_id int4 10 √
tbl_physical_samples.sample_type_id fk_physical_samples_sample_type_id R

Primary key (automatically incremented).
type_name varchar(40) 40

The name or label of the sample type.
description text 2147483647 √

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

Indexes

Constraint Name Type Sort Column(s)
tbl_sample_types_pkey Primary key Asc sample_type_id
tbl_sample_types_type_name_key Must be unique Asc type_name
tbl_sample_types_type_name_unique Must be unique Asc type_name

Relationships

Close relationships within degrees of separation