paleocontext

Table info.

Title Paleo Context
Description Paleo Context

Fields

Name Type Required Index Hidden On form Title Pick list Description
PaleoContextID 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
Remarks text Remarks remarks
Text1 varchar(64) Remarks text1
Text2 varchar(64) Text2 text2
YesNo1 bit(1) Yes No1 yesNo1
YesNo2 bit(1) Yes No2 yesNo2
ChronosStratEndID int(11) MUL
LithoStratID int(11) MUL
BioStratID int(11) MUL
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
ChronosStratID int(11) MUL
Number1 double Number1 number1
Number2 double Number2 number2
Number3 double Number3 number3
Number4 double Number4 number4
Number5 double Number5 number5
PaleoContextName varchar(80) Context Name paleoContextName
Text3 varchar(500) Text3 text3
Text4 varchar(500) Text4 text4
Text5 varchar(500) Text5 text5
YesNo3 bit(1) Yes No3 yesNo3
YesNo4 bit(1) Yes No4 yesNo4
YesNo5 bit(1) Yes No5 yesNo5
DisciplineID int(11) MUL

Indexes

Name Fields Unique Nullable
FK99B5438A1D72DA20 ChronosStratEndID
FK99B5438A4CE675DE DisciplineID
FK99B5438A50D2926D ChronosStratID
FK99B5438A5327F942 ModifiedByAgentID
FK99B5438A7699B003 CreatedByAgentID
FK99B5438A89FD3495 BioStratID
FK99B5438A9B80EF6A LithoStratID
PRIMARY PaleoContextID

One-to-many relationships

Name Field Related table Related field
FKFEB30F2297ECD2B2 PaleoContextID collectingevent PaleoContextID
FKC1D4635D97ECD2B2 PaleoContextID collectionobject PaleoContextID
FK714BFD6397ECD2B2 PaleoContextID locality PaleoContextID

Many-to-one relationships

Name Field Related table Related field
FK99B5438A1D72DA20 ChronosStratEndID geologictimeperiod GeologicTimePeriodID
FK99B5438A4CE675DE DisciplineID discipline UserGroupScopeId
FK99B5438A50D2926D ChronosStratID geologictimeperiod GeologicTimePeriodID
FK99B5438A5327F942 ModifiedByAgentID agent AgentID
FK99B5438A7699B003 CreatedByAgentID agent AgentID
FK99B5438A89FD3495 BioStratID geologictimeperiod GeologicTimePeriodID
FK99B5438A9B80EF6A LithoStratID lithostrat LithoStratID

View: SubPaleoContext (Common)

<view name="SubPaleoContext"
      class="edu.ku.brc.specify.datamodel.PaleoContext"
      isinternal="true">
    <desc><![CDATA[PaleoContext subform within Collection Object form.]]></desc>
    <altviews>
        <altview name="SubPaleoContext View" viewdef="SubPaleoContext" mode="view"/>
        <altview name="SubPaleoContext Edit" viewdef="SubPaleoContext" mode="edit" default="true"/>
    </altviews>
</view>

View def.: SubPaleoContext

<viewdef name="SubPaleoContext"
      type="form"
      class="edu.ku.brc.specify.datamodel.PaleoContext"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[Stratigraphy subform within Collection Object form.]]></desc>
    <enableRules/>
 
    <columnDef>100px,2px,195px,5px,59px,2px,195px,5px,67px,2px,195px,0px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,210px,5px,74px,2px,210px,5px,82px,2px,210px,0px,p:g</columnDef>
    <columnDef os="mac">130px,2px,241px,5px,87px,2px,241px,5px,101px,2px,241px,0px,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g,5px:g,p,2px,p:g,5px:g,p,2px,p:g,0px</columnDef>
    <rowDef auto="true" cell="p" sep="2dlu"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="chronosStrat" uitype="querycbx" initialize="name=ChronosStrat;displaydlg=ChronosStratDisplay;searchdlg=ChronosStratSearch" isrequired="false"/>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="bioStrat" uitype="querycbx" initialize="name=BioStrat;displaydlg=BioStratDisplay;searchdlg=BioStratSearch" isrequired="false"/>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="lithoStrat" uitype="querycbx" initialize="name=LithoStrat"/> 
        </row>
        <row>
            <cell type="label" labelfor="4"/>
            <cell type="field" id="4" name="remarks" uitype="textareabrief" rows="2" colspan="10"/>                    
        </row>
        <!--<row>
            <cell type="label" labelfor="bd"/>
            <cell type="field" id="bd" name="bottomDistance" uitype="text"/>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="chronosStratEnd" uitype="querycbx" initialize="name=ChronosStrat;displaydlg=ChronosStratDisplay;searchdlg=ChronosStratSearch" isrequired="false"/>
        </row>
        <row>
            <cell type="label" labelfor="dir"/>
            <cell type="field" id="dir" name="direction" uitype="text"/>
            <cell type="label" labelfor="du"/>
            <cell type="field" id="du" name="distanceUnits" uitype="text"/>
            <cell type="label" labelfor="ps"/>
            <cell type="field" id="ps" name="positionState" uitype="text"/>
        </row>
        <row>
            <cell type="label" labelfor="n1"/>
            <cell type="field" id="n1" name="number1" uitype="text"/>
            <cell type="label" labelfor="n2"/>
            <cell type="field" id="n2" name="number2" uitype="text"/>
        </row>
        <row>
            <cell type="label" labelfor="t1"/>
            <cell type="field" id="t1" name="text1" uitype="text"/>
            <cell type="label" labelfor="t2"/>
            <cell type="field" id="t2" name="text2" uitype="text"/>
            <cell type="label" labelfor="td"/>
            <cell type="field" id="td" name="topDistance" uitype="text"/>
        </row>
        <row>
            <cell type="field" id="20" name="yesNo1" uitype="checkbox" initialize="editable=true"/>
            <cell type="field" id="20" name="yesNo2" uitype="checkbox" initialize="editable=true"/>
        </row>
        <row>
            <cell type="label" labelfor="9"/>
            <cell type="field" id="9" name="createdByAgent" uitype="label" readonly="true"  uifieldformatter="Agent"/>
            <cell type="label" labelfor="10"/>
            <cell type="field" id="10" name="modifiedByAgent" uitype="label" readonly="true"  uifieldformatter="Agent"/>
        </row>
        <row>
            <cell type="label" labelfor="11"/>
            <cell type="field" id="11" name="timestampModified" uitype="label" readonly="true"/>
            <cell type="label" labelfor="12"/>
            <cell type="field" id="12" name="timestampCreated" uitype="label" readonly="true"/>
        </row>-->
    </rows>
</viewdef>