publicationtypes

13 rows


Description

Lookup table of Publication Types. This table is referenced by the Publications table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
pubtypeid serial 10 √ nextval('ndb.seq_publicationtypes_pubtypeid'::regclass)
publications.pubtypeid pub_pty R

An arbitrary Publication Type identification number.

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

Indexes

Constraint Name Type Sort Column(s)
publicationtypes_pkey Primary key Asc pubtypeid

Relationships