tbl_sample_group_references

967 rows


Description

Contains bibliographic information specifically relevant to a sample group, distinct from site or dataset references (e.g., a publication that reinterprets a structure within a site).

Columns

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

Primary key (automatically incremented).
biblio_id int4 10
tbl_biblio.biblio_id fk_sample_group_references_biblio_id R

Specifies the publication that describes or mentions the sample group.
date_updated timestamptz 35,6 √
sample_group_id int4 10 √
tbl_sample_groups.sample_group_id fk_sample_group_references_sample_group_id R

Identifies the specific sample group.

Indexes

Constraint Name Type Sort Column(s)
tbl_sample_group_references_pkey Primary key Asc sample_group_reference_id
idx_biblio_id Performance Asc biblio_id
idx_sample_group_id Performance Asc sample_group_id

Relationships

Close relationships within degrees of separation