elementtypes

820 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
elementtypeid serial 10 nextval('ndb.seq_elementtypes_elementtypeid'::regclass)
elementtaxagroups.elementtypeid fk_elementtaxagrouptypes_elementtypesC
isostratdata.elementtypeid fk_isostratdata_elementtypesC
specimendates.elementtypeid sd_etyidR
specimens.elementtypeid fk_specimens_elementtypesC
variableelements.elementtypeid fk_variableelements_elementtypesR
elementtype varchar 64 null
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
elementtypes_pkey Primary key Asc elementtypeid
ix_elementtypes Must be unique Asc elementtype

Relationships