depagenttypes

19 rows


Description

Lookup table of Depositional Agents. Table is referenced by the DepAgents table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
depagentid serial 10 nextval('ndb.seq_depagenttypes_depagentid'::regclass)
depagents.depagentid fk_depagents_depagenttypesC

An arbitrary Depositional Agent identification number.

depagent varchar 64 null

Depositional Agent.

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

Indexes

Constraint Name Type Sort Column(s)
depagenttypes_pkey Primary key Asc depagentid

Relationships