geologictimeperiodtreedefitem

Table info.

Title Geological Time Period Tree Definition Item
Description Geological Time Period Tree Definition Item

Fields

Name Type Required Index Hidden On form Title Pick list Description
GeologicTimePeriodTreeDefItemID 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
ModifiedByAgentID int(11) MUL
GeologicTimePeriodTreeDefID int(11) MUL
ParentItemID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FKB6DF7F1F5327F942 ModifiedByAgentID
FKB6DF7F1F7699B003 CreatedByAgentID
FKB6DF7F1F9093DC94 ParentItemID
FKB6DF7F1F9988ED70 GeologicTimePeriodTreeDefID
PRIMARY GeologicTimePeriodTreeDefItemID

One-to-many relationships

Name Field Related table Related field
FKA2A8513BA8A8AC76 GeologicTimePeriodTreeDefItemID geologictimeperiod GeologicTimePeriodTreeDefItemID
FKB6DF7F1F9093DC94 GeologicTimePeriodTreeDefItemID geologictimeperiodtreedefitem ParentItemID

Many-to-one relationships

Name Field Related table Related field
FKB6DF7F1F5327F942 ModifiedByAgentID agent AgentID
FKB6DF7F1F7699B003 CreatedByAgentID agent AgentID
FKB6DF7F1F9093DC94 ParentItemID geologictimeperiodtreedefitem GeologicTimePeriodTreeDefItemID
FKB6DF7F1F9988ED70 GeologicTimePeriodTreeDefID geologictimeperiodtreedef GeologicTimePeriodTreeDefID