tbl_dataset_masters

5 rows


Description

Represents a major grouping identifier for datasets, typically indicating a contributing database, project, user, or laboratory (e.g., BugsCEP, MAL, Lund Dendro Lab).

Columns

Column Type Size Nulls Auto Children Parents Comments
master_set_id int4 10 √
tbl_datasets.master_set_id fk_datasets_master_set_id R

Primary key (automatically incremented).
contact_id int4 10 √
tbl_contacts.contact_id fk_dataset_masters_contact_id R

Identifies the contact person or organization responsible for the master dataset.
biblio_id int4 10 √
tbl_biblio.biblio_id fk_dataset_masters_biblio_id R

Specifies the primary literature or reference related to the master dataset (e.g., Buckland & Buckland 2006 for BugsCEP).
master_name varchar(100) 100 √

Name or title assigned to the master dataset (e.g., MAL, BugsCEP, DendroLab).
master_notes text 2147483647 √

Detailed description of the master dataset, including its nature (e.g., database, lab) and any pertinent tracking information.
url text 2147483647 √

Web address or URL related to the master dataset, which could be a project, lab, or other entity.
date_updated timestamptz 35,6 √
master_set_uuid uuid 2147483647

Indexes

Constraint Name Type Sort Column(s)
tbl_dataset_masters_pkey Primary key Asc master_set_id
pk_tbl_dataset_masters Must be unique Asc master_set_uuid
tbl_dataset_masters_master_name_key Must be unique Asc master_name
tbl_dataset_masters_master_name_unique Must be unique Asc master_name

Relationships

Close relationships within degrees of separation