geologictimeperiod

Table info.

Title Chronostratigraphy
Description Chronostratigraphy

Fields

Name Type Required Index Hidden On form Title Pick list Description
GeologicTimePeriodID 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
EndPeriod float(20,10) End Period endPeriod
EndUncertainty float(20,10) End Uncertainty endUncertainty
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
IsBioStrat bit(1) Is BioStratigraphy isBioStrat
Name varchar(64) MUL Name name
NodeNumber int(11) Node Number nodeNumber
RankID int(11) Rank Id Numeric representation of Items rank in stratigraphic hierarchy.
Remarks text Remarks Additional Comments.
Standard varchar(64) Standard The system of Stratigraphy the record is included in.
StartPeriod float(20,10) Start Period startPeriod
StartUncertainty float(20,10) Start Uncertainty startUncertainty
Text1 varchar(128) Text1 text1
Text2 varchar(128) Text2 text2
ParentID int(11) MUL
GeologicTimePeriodTreeDefItemID int(11) MUL
AcceptedID int(11) MUL
GeologicTimePeriodTreeDefID int(11) MUL
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FKA2A8513B523E3360 AcceptedID
FKA2A8513B5327F942 ModifiedByAgentID
FKA2A8513B7699B003 CreatedByAgentID
FKA2A8513B9988ED70 GeologicTimePeriodTreeDefID
FKA2A8513BA8A8AC76 GeologicTimePeriodTreeDefItemID
FKA2A8513BE16467A3 ParentID
GTPFullNameIDX FullName
GTPGuidIDX GUID
GTPNameIDX Name
PRIMARY GeologicTimePeriodID

One-to-many relationships

Name Field Related table Related field
FKA2A8513B523E3360 GeologicTimePeriodID geologictimeperiod AcceptedID
FKA2A8513BE16467A3 GeologicTimePeriodID geologictimeperiod ParentID
FK99B5438A1D72DA20 GeologicTimePeriodID paleocontext ChronosStratEndID
FK99B5438A50D2926D GeologicTimePeriodID paleocontext ChronosStratID
FK99B5438A89FD3495 GeologicTimePeriodID paleocontext BioStratID

Many-to-one relationships

Name Field Related table Related field
FKA2A8513B523E3360 AcceptedID geologictimeperiod GeologicTimePeriodID
FKA2A8513B5327F942 ModifiedByAgentID agent AgentID
FKA2A8513B7699B003 CreatedByAgentID agent AgentID
FKA2A8513B9988ED70 GeologicTimePeriodTreeDefID geologictimeperiodtreedef GeologicTimePeriodTreeDefID
FKA2A8513BA8A8AC76 GeologicTimePeriodTreeDefItemID geologictimeperiodtreedefitem GeologicTimePeriodTreeDefItemID
FKA2A8513BE16467A3 ParentID geologictimeperiod GeologicTimePeriodID