tbl_site_references

2703 rows


Description

This table catalogs publications that describe or mention sites. Publications related to specific sample groups, physical samples, or datasets are documented at their respective hierarchical levels.

Columns

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

Primary key (automatically incremented).
site_id int4 10 √
tbl_sites.site_id fk_site_references_site_id R

Specifies the specific site.
biblio_id int4 10
tbl_biblio.biblio_id fk_site_references_biblio_id R

Specifies the publication that describes or mentions the site.
date_updated timestamptz 35,6 √

Indexes

Constraint Name Type Sort Column(s)
tbl_site_references_pkey Primary key Asc site_reference_id
uq_site_references Must be unique Asc/Asc site_id + biblio_id

Relationships

Close relationships within degrees of separation