view_bibliography_references

Columns

Column

Type

Size

Nulls

Auto

Children

Parents

Comments

uuid

2147483647

√

biblio_uuid

uuid

2147483647

√

Relationships

Close relationships within degrees of separation

One

View Definition

SELECT e.dataset_uuid AS uuid,
    b.biblio_uuid
   FROM (tbl_datasets e
     JOIN tbl_biblio b USING (biblio_id))
UNION
 SELECT e.rdb_system_uuid AS uuid,
    b.biblio_uuid
   FROM (tbl_rdb_systems e
     JOIN tbl_biblio b USING (biblio_id))
UNION
 SELECT e.sample_group_uuid AS uuid,
    b.biblio_uuid
   FROM ((tbl_sample_group_references r
     JOIN tbl_sample_groups e USING (sample_group_id))
     JOIN tbl_biblio b USING (biblio_id))
UNION
 SELECT e.relative_age_uuid AS uuid,
    b.biblio_uuid
   FROM ((tbl_relative_age_refs r
     JOIN tbl_relative_ages e USING (relative_age_id))
     JOIN tbl_biblio b USING (biblio_id))
UNION
 SELECT e.taxonomy_notes_uuid AS uuid,
    b.biblio_uuid
   FROM (tbl_taxonomy_notes e
     JOIN tbl_biblio b USING (biblio_id))
UNION
 SELECT e.species_association_uuid AS uuid,
    b.biblio_uuid
   FROM (tbl_species_associations e
     JOIN tbl_biblio b USING (biblio_id))
UNION
 SELECT e.distribution_uuid AS uuid,
    b.biblio_uuid
   FROM (tbl_text_distribution e
     JOIN tbl_biblio b USING (biblio_id))
UNION
 SELECT e.tephra_uuid AS uuid,
    b.biblio_uuid
   FROM ((tbl_tephra_refs r
     JOIN tbl_tephras e USING (tephra_id))
     JOIN tbl_biblio b USING (biblio_id))
UNION
 SELECT e.ecocode_system_uuid AS uuid,
    b.biblio_uuid
   FROM (tbl_ecocode_systems e
     JOIN tbl_biblio b USING (biblio_id))
UNION
 SELECT e.master_set_uuid AS uuid,
    b.biblio_uuid
   FROM (tbl_dataset_masters e
     JOIN tbl_biblio b USING (biblio_id))
UNION
 SELECT e.site_other_records_uuid AS uuid,
    b.biblio_uuid
   FROM (tbl_site_other_records e
     JOIN tbl_biblio b USING (biblio_id))
UNION
 SELECT e.key_uuid AS uuid,
    b.biblio_uuid
   FROM (tbl_text_identification_keys e
     JOIN tbl_biblio b USING (biblio_id))
UNION
 SELECT e.geochron_uuid AS uuid,
    b.biblio_uuid
   FROM ((tbl_geochron_refs r
     JOIN tbl_geochronology e USING (geochron_id))
     JOIN tbl_biblio b USING (biblio_id))
UNION
 SELECT e.site_uuid AS uuid,
    b.biblio_uuid
   FROM ((tbl_site_references r
     JOIN tbl_sites e USING (site_id))
     JOIN tbl_biblio b USING (biblio_id))
UNION
 SELECT e.synonym_uuid AS uuid,
    b.biblio_uuid
   FROM (tbl_taxa_synonyms e
     JOIN tbl_biblio b USING (biblio_id))
UNION
 SELECT e.biology_uuid AS uuid,
    b.biblio_uuid
   FROM (tbl_text_biology e
     JOIN tbl_biblio b USING (biblio_id))
UNION
 SELECT e.aggregate_dataset_uuid AS uuid,
    b.biblio_uuid
   FROM (tbl_aggregate_datasets e
     JOIN tbl_biblio b USING (biblio_id))
UNION
 SELECT e.taxonomic_order_system_uuid AS uuid,
    b.biblio_uuid
   FROM ((tbl_taxonomic_order_biblio r
     JOIN tbl_taxonomic_order_systems e USING (taxonomic_order_system_id))
     JOIN tbl_biblio b USING (biblio_id))
UNION
 SELECT e.method_uuid AS uuid,
    b.biblio_uuid
   FROM (tbl_methods e
     JOIN tbl_biblio b USING (biblio_id));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views