tbl_sample_alt_refs

28421 rows


Description

Contains various reference names for physical samples, such as laboratory or field numbers.

Columns

Column Type Size Nulls Auto Children Parents Comments
sample_alt_ref_id int4 10 √

Primary key (automatically incremented).
alt_ref varchar(80) 80

Alternative reference name for the physical sample.
alt_ref_type_id int4 10
tbl_alt_ref_types.alt_ref_type_id fk_sample_alt_refs_alt_ref_type_id R

Specifies the type of alternative identification.
date_updated timestamptz 35,6 √
physical_sample_id int4 10
tbl_physical_samples.physical_sample_id fk_sample_alt_refs_physical_sample_id R

Identifies the specific physical sample.

Indexes

Constraint Name Type Sort Column(s)
tbl_sample_alt_refs_pkey Primary key Asc sample_alt_ref_id
idx_sample_alt_refs_alt_ref_type_id Performance Asc alt_ref_type_id
idx_sample_alt_refs_physical_sample_id Performance Asc physical_sample_id
uq_tbl_sample_alt_refs Must be unique Asc/Asc/Asc physical_sample_id + alt_ref + alt_ref_type_id

Relationships

Close relationships within degrees of separation