geographytreedefitem

Table info.

Title Geography Tree Definition Item
Description Geography Tree Definition Item

Fields

Name Type Required Index Hidden On form Title Pick list Description
GeographyTreeDefItemID 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
FullNameSeparator varchar(32) Full Name Separator fullNameSeparator
IsEnforced bit(1) Is Enforced isEnforced
IsInFullName bit(1) Is In Full Name isInFullName
Name varchar(64) 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
GeographyTreeDefID int(11) MUL
ParentItemID int(11) MUL
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FKF584963E5327F942 ModifiedByAgentID
FKF584963E7699B003 CreatedByAgentID
FKF584963EA1F648D9 ParentItemID
FKF584963EBF9C9714 GeographyTreeDefID
PRIMARY GeographyTreeDefItemID

One-to-many relationships

Name Field Related table Related field
FK496A777CE3C6E41A GeographyTreeDefItemID geography GeographyTreeDefItemID
FKF584963EA1F648D9 GeographyTreeDefItemID geographytreedefitem ParentItemID

Many-to-one relationships

Name Field Related table Related field
FKF584963E5327F942 ModifiedByAgentID agent AgentID
FKF584963E7699B003 CreatedByAgentID agent AgentID
FKF584963EA1F648D9 ParentItemID geographytreedefitem GeographyTreeDefItemID
FKF584963EBF9C9714 GeographyTreeDefID geographytreedef GeographyTreeDefID