tbl_dataset_contacts

44787 rows


Description

Contains information about one or more contacts related to a dataset, such as data providers or digitalisers.

Columns

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

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

Identifies the contact person or organization related to the dataset.
contact_type_id int4 10
tbl_contact_types.contact_type_id fk_dataset_contacts_contact_type_id R

Specifies the type of contact, such as provider or digitaliser.
dataset_id int4 10
tbl_datasets.dataset_id fk_dataset_contacts_dataset_id R

Specifies the dataset the contact is related to.
date_updated timestamptz 35,6 √
event_date date 13 √

Records when the dataset contact activity occurred, when known.

Indexes

Constraint Name Type Sort Column(s)
tbl_dataset_contacts_pkey Primary key Asc dataset_contact_id

Relationships

Close relationships within degrees of separation