lithostrat

Table info.

Title Lithostratigraphy
Description Lithostratigraphy

Fields

Name Type Required Index Hidden On form Title Pick list Description
LithoStratID 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
FullName varchar(255) MUL Full Name fullName
GUID varchar(128) MUL GUID guid
HighestChildNodeNumber int(11) Highest Child Node Number highestChildNodeNumber
IsAccepted bit(1) Is Preferred isAccepted
Name varchar(64) MUL Name name
NodeNumber int(11) Node Number nodeNumber
Number1 double Number1 number1
Number2 double Number2 number2
RankID int(11) Rank Id rankId
Remarks text Remarks Additional Comments.
Text1 text Text1 text1
Text2 text Text2 text2
YesNo1 bit(1) Yes No1 yesNo1
YesNo2 bit(1) Yes No2 yesNo2
ParentID int(11) MUL
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
LithoStratTreeDefItemID int(11) MUL
LithoStratTreeDefID int(11) MUL
AcceptedID int(11) MUL

Indexes

Name Fields Unique Nullable
FK329297065327F942 ModifiedByAgentID
FK3292970672939D3A LithoStratTreeDefID
FK329297067699B003 CreatedByAgentID
FK329297067A1D53CB AcceptedID
FK32929706943880E ParentID
FK3292970699E26740 LithoStratTreeDefItemID
LithoFullNameIDX FullName
LithoGuidIDX GUID
LithoNameIDX Name
PRIMARY LithoStratID

One-to-many relationships

Name Field Related table Related field
FK329297067A1D53CB LithoStratID lithostrat AcceptedID
FK32929706943880E LithoStratID lithostrat ParentID
FK99B5438A9B80EF6A LithoStratID paleocontext LithoStratID

Many-to-one relationships

Name Field Related table Related field
FK329297065327F942 ModifiedByAgentID agent AgentID
FK3292970672939D3A LithoStratTreeDefID lithostrattreedef LithoStratTreeDefID
FK329297067699B003 CreatedByAgentID agent AgentID
FK329297067A1D53CB AcceptedID lithostrat LithoStratID
FK32929706943880E ParentID lithostrat LithoStratID
FK3292970699E26740 LithoStratTreeDefItemID lithostrattreedefitem LithoStratTreeDefItemID