dataset_contact

0 rows


Description

Pivot table between dataset and contacts.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 nextval('pgmetadata.dataset_contact_id_seq'::regclass)

Internal automatic integer ID

fk_id_contact int4 10 null
contact.id dataset_contact_fk_id_contact_fkeyR

Id of the contact item

fk_id_dataset int4 10 null
dataset.id dataset_contact_fk_id_dataset_fkeyC

Id of the dataset item

contact_role text 2147483647 null

Role of the contact for the specified dataset item. E.g. owner, distributor

Indexes

Constraint Name Type Sort Column(s)
dataset_contact_pkey Primary key Asc id
dataset_contact_fk_id_contact_fk_id_dataset_contact_role_key Must be unique Asc/Asc/Asc fk_id_contact + fk_id_dataset + contact_role

Relationships