collectiontypes

11 rows


Description

This table is a lookup table for types of Collection Units, or Collection Types. Table is referenced by the CollectionUnits table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
colltypeid serial 10 nextval('ndb.seq_collectiontypes_colltypeid'::regclass)
collectionunits.colltypeid fk_collectionunits_collectiontypesC
colltype varchar 64 null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
collectiontypes_pkey Primary key Asc colltypeid

Relationships