datasetpublications

47012 rows


Description

This table lists the publications for datasets.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
datasetid int4 10 null
datasets.datasetid fk_datasetpublications_datasetsC

Dataset identification number. Field links to Dataset table.

publicationid int4 10 null
publications.publicationid fk_datasetpublications_publicationsR

Publication identification number. Field links to Publications table.

primarypub bool 1 null

Is «True» if the publication is the primary publication for the dataset.

recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
datasetpublications_pkey Primary key Asc/Asc datasetid + publicationid
ix_datasetid_datasetpublications Performance Asc datasetid
ix_publicationid_datasetpublications Performance Asc publicationid

Relationships