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_ptyR

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