ecolsettypes

23 rows


Description

Lookup table of Ecological Set Types. Table is referenced by the EcolGroups table.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
ecolsetid serial 10 nextval('ndb.seq_ecolsettypes_ecolsetid'::regclass)
ecolgroups.ecolsetid fk_ecolgroups_ecolsettypesC

An arbitrary Ecological Set identification number.

ecolsetname varchar 64 null

Ecological Set name.

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

Indexes

Constraint Name Type Sort Column(s)
ecolsettypes_pkey Primary key Asc ecolsetid

Relationships