taxontreedef

Table info.

Title Taxon Tree Definition
Description Taxon Tree Definition

Fields

Name Type Required Index Hidden On form Title Pick list Description
TaxonTreeDefID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
FullNameDirection int(11) Full Name Direction fullNameDirection
Name varchar(64) Name name
Remarks varchar(255) Remarks Additional Comments
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK169B1D9D5327F942 ModifiedByAgentID
FK169B1D9D7699B003 CreatedByAgentID
PRIMARY TaxonTreeDefID

One-to-many relationships

Name Field Related table Related field
FK157B9B70EFA9D5F8 TaxonTreeDefID discipline TaxonTreeDefID
FK6908ECAEFA9D5F8 TaxonTreeDefID taxon TaxonTreeDefID
FKF29A8230EFA9D5F8 TaxonTreeDefID taxontreedefitem TaxonTreeDefID

Many-to-one relationships

Name Field Related table Related field
FK169B1D9D5327F942 ModifiedByAgentID agent AgentID
FK169B1D9D7699B003 CreatedByAgentID agent AgentID