tbl_sample_location_types

9 rows


Description

Contains the different types of sample locations used within the system.

Columns

Column Type Size Nulls Auto Children Parents Comments
sample_location_type_id int4 10 √
tbl_sample_location_type_sampling_contexts.sample_location_type_id fk_sample_location_sampling_contexts_sampling_context_id R
tbl_sample_locations.sample_location_type_id fk_sample_locations_sample_location_type_id R

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

The name or identifier of the sample location type.
location_type_description text 2147483647 √

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

Indexes

Constraint Name Type Sort Column(s)
tbl_sample_location_types_pkey Primary key Asc sample_location_type_id
tbl_sample_location_types_location_type_key Must be unique Asc location_type
tbl_sample_location_types_location_type_unique Must be unique Asc location_type

Relationships

Close relationships within degrees of separation