tbl_site_other_records

2583 rows


Description

Contains information about data related to specific sites that is not currently stored in SEAD. Each record corresponds to a distinct proxy type, even if multiple proxies are linked to the same publication. Note that some of these datasets might be integrated into SEAD in the future. Requests for data submission can be directed to the SEAD project team.

Columns

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

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

Specifies the specific site.
biblio_id int4 10 √
tbl_biblio.biblio_id fk_site_other_records_biblio_id R

Specifies the publication that describes or mentions site data is documented.
record_type_id int4 10 √
tbl_record_types.record_type_id fk_site_other_records_record_type_id R

Specifies the type of data (proxy) represented in this record.
description text 2147483647 √

A brief description of the data not currently stored in SEAD.
date_updated timestamptz 35,6 √
site_other_records_uuid uuid 2147483647

Indexes

Constraint Name Type Sort Column(s)
tbl_site_other_records_pkey Primary key Asc site_other_records_id
pk_tbl_site_other_records Must be unique Asc site_other_records_uuid

Relationships

Close relationships within degrees of separation