geologictimeperiodtreedef

Table info.

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

Fields

Name Type Required Index Hidden On form Title Pick list Description
GeologicTimePeriodTreeDefID 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
FK8109EA0C5327F942 ModifiedByAgentID
FK8109EA0C7699B003 CreatedByAgentID
PRIMARY GeologicTimePeriodTreeDefID

One-to-many relationships

Name Field Related table Related field
FK157B9B709988ED70 GeologicTimePeriodTreeDefID discipline GeologicTimePeriodTreeDefID
FKA2A8513B9988ED70 GeologicTimePeriodTreeDefID geologictimeperiod GeologicTimePeriodTreeDefID
FKB6DF7F1F9988ED70 GeologicTimePeriodTreeDefID geologictimeperiodtreedefitem GeologicTimePeriodTreeDefID

Many-to-one relationships

Name Field Related table Related field
FK8109EA0C5327F942 ModifiedByAgentID agent AgentID
FK8109EA0C7699B003 CreatedByAgentID agent AgentID