lithostrattreedef

Table info.

Title Lithostratigraphy Tree Definition
Description Lithostratigraphy Tree Definition

Fields

Name Type Required Index Hidden On form Title Pick list Description
LithoStratTreeDefID 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
FK268699E15327F942 ModifiedByAgentID
FK268699E17699B003 CreatedByAgentID
PRIMARY LithoStratTreeDefID

One-to-many relationships

Name Field Related table Related field
FK157B9B7072939D3A LithoStratTreeDefID discipline LithoStratTreeDefID
FK3292970672939D3A LithoStratTreeDefID lithostrat LithoStratTreeDefID
FKEC263C7472939D3A LithoStratTreeDefID lithostrattreedefitem LithoStratTreeDefID

Many-to-one relationships

Name Field Related table Related field
FK268699E15327F942 ModifiedByAgentID agent AgentID
FK268699E17699B003 CreatedByAgentID agent AgentID