relativeagepublications

115 rows


Description

This table stores Publications in which Relative Ages are reported for CollectionUnits.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
relativeageid int4 10 null
relativeages.relativeageid fk_relativeagepublications_relativeagesC

Relative Ages identification number. Field links to the RelativeAges table.

publicationid int4 10 null
publications.publicationid fk_relativeagepublications_publicationsC

Publication identification number. Field links to Publications table.

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

Indexes

Constraint Name Type Sort Column(s)
relativeagepublications_pkey Primary key Asc/Asc relativeageid + publicationid
ix_relativeageid_relativeagepublications Performance Asc relativeageid

Relationships