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_ecolsettypes C

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