taxontreedefitem

Table info.

Title Taxon Tree Definition Item
Description Taxon Tree Definition Item

Fields

Name Type Required Index Hidden On form Title Pick list Description
TaxonTreeDefItemID int(11) PRI
TimestampCreated datetime Timestamp Created The timestamp the record was created.
TimestampModified datetime Timestamp Modified The timestamp the record was last modified.
Version int(11) Version version
FormatToken varchar(32) Format Token formatToken
FullNameSeparator varchar(32) Full Name Separator fullNameSeparator
IsEnforced bit(1) Is Enforced isEnforced
IsInFullName bit(1) Is In Full Name isInFullName
Name varchar(64) MUL Name name
RankID int(11) Rank Id rankId
Remarks text Remarks Additional Comments
TextAfter varchar(64) Text After User definable
TextBefore varchar(64) Text Before User definable
Title varchar(64) Title title
ParentItemID int(11) MUL
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
TaxonTreeDefID int(11) MUL

Indexes

Name Fields Unique Nullable
FKF29A82305327F942 ModifiedByAgentID
FKF29A82306A76BE4B ParentItemID
FKF29A82307699B003 CreatedByAgentID
FKF29A8230EFA9D5F8 TaxonTreeDefID
PRIMARY TaxonTreeDefItemID
RankIDX Name

One-to-many relationships

Name Field Related table Related field
FK6908ECABB9210FE TaxonTreeDefItemID taxon TaxonTreeDefItemID
FKF29A82306A76BE4B TaxonTreeDefItemID taxontreedefitem ParentItemID

Many-to-one relationships

Name Field Related table Related field
FKF29A82305327F942 ModifiedByAgentID agent AgentID
FKF29A82306A76BE4B ParentItemID taxontreedefitem TaxonTreeDefItemID
FKF29A82307699B003 CreatedByAgentID agent AgentID
FKF29A8230EFA9D5F8 TaxonTreeDefID taxontreedef TaxonTreeDefID