geographytreedef

Table info.

Title Geography Tree Definition
Description Geography Tree Definition

Fields

Name Type Required Index Hidden On form Title Pick list Description
GeographyTreeDefID 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 text Remarks Additional Comments.
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FKE8DD68AB5327F942 ModifiedByAgentID
FKE8DD68AB7699B003 CreatedByAgentID
PRIMARY GeographyTreeDefID

One-to-many relationships

Name Field Related table Related field
FK157B9B70BF9C9714 GeographyTreeDefID discipline GeographyTreeDefID
FK496A777CBF9C9714 GeographyTreeDefID geography GeographyTreeDefID
FKF584963EBF9C9714 GeographyTreeDefID geographytreedefitem GeographyTreeDefID

Many-to-one relationships

Name Field Related table Related field
FKE8DD68AB5327F942 ModifiedByAgentID agent AgentID
FKE8DD68AB7699B003 CreatedByAgentID agent AgentID