lithostrattreedefitem

Table info.

Title Lithostratigraphy Tree Definition Item
Description Lithostratigraphy Tree Definition Item

Fields

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

Indexes

Name Fields Unique Nullable
FKEC263C745327F942 ModifiedByAgentID
FKEC263C7472939D3A LithoStratTreeDefID
FKEC263C747699B003 CreatedByAgentID
FKEC263C748340DB49 ParentItemID
PRIMARY LithoStratTreeDefItemID

One-to-many relationships

Name Field Related table Related field
FK3292970699E26740 LithoStratTreeDefItemID lithostrat LithoStratTreeDefItemID
FKEC263C748340DB49 LithoStratTreeDefItemID lithostrattreedefitem ParentItemID

Many-to-one relationships

Name Field Related table Related field
FKEC263C745327F942 ModifiedByAgentID agent AgentID
FKEC263C7472939D3A LithoStratTreeDefID lithostrattreedef LithoStratTreeDefID
FKEC263C747699B003 CreatedByAgentID agent AgentID
FKEC263C748340DB49 ParentItemID lithostrattreedefitem LithoStratTreeDefItemID