elementtaxagroups

897 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
elementtaxagroupid serial 10 nextval('ndb.seq_elementtaxagroups_elementtaxagroupid'::regclass)
elementtaxagroupmaturities.elementtaxagroupid fk_elementtaxagroupmaturities_elementtaxagroupC
elementtaxagroupportions.elementtaxagroupid fk_elementtaxagroupportions_elementtaxagroupsC
elementtaxagroupsymmetries.elementtaxagroupid fk_elementtaxagroupsymmetries_elementtaxagroupsC
taxagroupid varchar 3 null
taxagrouptypes.taxagroupid fk_elementtaxagrouptypes_taxagrouptypesC
elementtypeid int4 10 null
elementtypes.elementtypeid fk_elementtaxagrouptypes_elementtypesC
recdatecreated timestamp 22 timezone('UTC'::text, now())
recdatemodified timestamp 22 null

Indexes

Constraint Name Type Sort Column(s)
elementtaxagroups_pkey Primary key Asc elementtaxagroupid
ix_elementtaxagrouptypes Must be unique Asc/Asc taxagroupid + elementtypeid

Relationships