tbl_alt_ref_types

11 rows


Description

This table defines the types of alternative references or names assigned to samples. These references might include identifiers like lab numbers, field numbers, museum numbers, or site excavation numbers, indicating the origin or purpose of the sample’s alternative reference.

Columns

Column Type Size Nulls Auto Children Parents Comments
alt_ref_type_id int4 10 √
tbl_physical_samples.alt_ref_type_id fk_physical_samples_sample_name_type_id R
tbl_sample_alt_refs.alt_ref_type_id fk_sample_alt_refs_alt_ref_type_id R

Primary key (automatically incremented).
alt_ref_type varchar(50) 50

The name or type of the alternative reference assigned to a sample.
date_updated timestamptz 35,6 √
description text 2147483647 √

A detailed description of the alternative reference type, providing additional context or clarification.

Indexes

Constraint Name Type Sort Column(s)
tbl_alt_ref_types_pkey Primary key Asc alt_ref_type_id
tbl_alt_ref_types_alt_ref_type_key Must be unique Asc alt_ref_type
tbl_alt_ref_types_alt_ref_type_unique Must be unique Asc alt_ref_type

Relationships

Close relationships within degrees of separation