discipline

Table info.

Title Discipline
Description Discipline

Fields

Name Type Required Index Hidden On form Title Pick list Description
UserGroupScopeId int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
disciplineId int(11)
Name varchar(64) MUL Name name
RegNumber varchar(24) Reg Number regNumber
Type varchar(64) Type type
TaxonTreeDefID int(11) MUL
DataTypeID int(11) MUL
GeologicTimePeriodTreeDefID int(11) MUL
LithoStratTreeDefID int(11) MUL
GeographyTreeDefID int(11) MUL
DivisionID int(11) MUL
IsPaleoContextEmbedded bit(1) Is Paleo Context Embedded isPaleoContextEmbedded
PaleoContextChildTable varchar(50) Paleo Context Child Table paleoContextChildTable

Indexes

Name Fields Unique Nullable
DisciplineNameIDX Name
FK157B9B7072939D3A LithoStratTreeDefID
FK157B9B7097C961D8 DivisionID
FK157B9B709988ED70 GeologicTimePeriodTreeDefID
FK157B9B70BF9C9714 GeographyTreeDefID
FK157B9B70D62E36A6 DataTypeID
FK157B9B70EFA9D5F8 TaxonTreeDefID
FK3D0021605327F942157b9b70 ModifiedByAgentID
FK3D0021607699B003157b9b70 CreatedByAgentID
PRIMARY UserGroupScopeId
UserGroupScopeId UserGroupScopeId

One-to-many relationships

Name Field Related table Related field
FKC36883E94CE675DE UserGroupScopeId attributedef DisciplineID
FKA8BE5C34CE675DE UserGroupScopeId autonumsch_dsp DisciplineID
FKFEB30F224CE675DE UserGroupScopeId collectingevent DisciplineID
FK9AD681BA4CE675DE UserGroupScopeId collectingeventattribute DisciplineID
FK1080269D4CE675DE UserGroupScopeId collectingtrip DisciplineID
FK381CA49F4CE675DE UserGroupScopeId collectingtripattribute DisciplineID
FK9835AE9E4CE675DE UserGroupScopeId collection DisciplineID
FK9A0BCB54CE675DE UserGroupScopeId exchangeinprep DisciplineID
FK7405CEF84CE675DE UserGroupScopeId exchangeoutprep DisciplineID
FK4647A8D54CE675DE UserGroupScopeId fieldnotebook DisciplineID
FK162198E44CE675DE UserGroupScopeId fieldnotebookpage DisciplineID
FK6FC0C8FE4CE675DE UserGroupScopeId fieldnotebookpageset DisciplineID
FK3069304CE675DE UserGroupScopeId gift DisciplineID
FK221917D54CE675DE UserGroupScopeId giftagent DisciplineID
FK18B1F674CE675DE UserGroupScopeId giftpreparation DisciplineID
FK32C4F04CE675DE UserGroupScopeId loan DisciplineID
FK63FA14154CE675DE UserGroupScopeId loanagent DisciplineID
FK374DEBA74CE675DE UserGroupScopeId loanpreparation DisciplineID
FK363284774CE675DE UserGroupScopeId loanreturnpreparation DisciplineID
FK714BFD634CE675DE UserGroupScopeId locality DisciplineID
FK9877F54A4CE675DE UserGroupScopeId localitycitation DisciplineID
FK29EB5CA24CE675DE UserGroupScopeId localitynamealias DisciplineID
FK99B5438A4CE675DE UserGroupScopeId paleocontext DisciplineID
FKE139719A4CE675DE UserGroupScopeId shipment DisciplineID
FK3A2F5C9B4CE675DE UserGroupScopeId spappresourcedir DisciplineID
FKD2861D324CE675DE UserGroupScopeId spexportschema DisciplineID
FK3CC8F6A4CE675DE UserGroupScopeId splocalecontainer DisciplineID
FKF2333F224CE675DE UserGroupScopeId sptasksemaphore DisciplineID

Many-to-one relationships

Name Field Related table Related field
FK157B9B7072939D3A LithoStratTreeDefID lithostrattreedef LithoStratTreeDefID
FK157B9B7097C961D8 DivisionID division UserGroupScopeId
FK157B9B709988ED70 GeologicTimePeriodTreeDefID geologictimeperiodtreedef GeologicTimePeriodTreeDefID
FK157B9B70BF9C9714 GeographyTreeDefID geographytreedef GeographyTreeDefID
FK157B9B70D62E36A6 DataTypeID datatype DataTypeID
FK157B9B70EFA9D5F8 TaxonTreeDefID taxontreedef TaxonTreeDefID
FK3D0021605327F942157b9b70 ModifiedByAgentID agent AgentID
FK3D0021607699B003157b9b70 CreatedByAgentID agent AgentID

View: Discipline (Common)

<view name="Discipline"
      class="edu.ku.brc.specify.datamodel.Discipline"
      busrules="edu.ku.brc.specify.datamodel.busrules.DisciplineBusRules">
    <desc><![CDATA[The Discipline Object form.]]></desc>
    <altviews>
        <altview name="Discipline View" viewdef="Discipline" mode="view" validated="false"/>
        <altview name="Discipline Edit" viewdef="Discipline" mode="edit" validated="true" default="true"/>
    </altviews>
</view>

View def.: Discipline

<viewdef type="form"
      name="Discipline"
      class="edu.ku.brc.specify.datamodel.Discipline"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[Discipline Data Entry Form]]></desc>
    <columnDef>100px,2px,180px,5px,85px,2px,180px,5px,86px,2px,180px,15px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,195px,5px,92px,2px,200px,5px,96px,2px,p:g,15px,p:g</columnDef>
    <columnDef os="mac">130px,2px,218px,5px,112px,2px,220px,5px,116px,2px,220px,15px,p:g</columnDef>
    <columnDef os="exp">100px,2px,p:g(2),5px:g,p,2px,p:g(2),5px:g,p,2px,p:g(2),15px,p:g</columnDef>
    <rowDef auto="true" cell="p" sep="2dlu"/>            
 
    <rows>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="dataType" uitype="dsptextfield" readonly="true"/>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="type" uitype="combobox" isrequired="true" readonly="true" initialize="editoncreate=true"/> 
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="name" uitype="text" isrequired="true"/>
        </row>
        <row>
            <cell type="subview" viewname="CollectionSub" id="5" name="collections" colspan="12"/>
        </row>
    </rows>
</viewdef>
 

View: DisciplineViewOnlyCollections (Common)

<view name="DisciplineViewOnlyCollections"
      class="edu.ku.brc.specify.datamodel.Discipline"
      busrules="edu.ku.brc.specify.datamodel.busrules.DisciplineBusRules">
    <desc><![CDATA[The Discipline Object form without collections subform.]]></desc>
    <altviews>
        <altview name="Discipline View" viewdef="DisciplineViewOnlyCollections" mode="view" validated="false"/>
        <altview name="Discipline Edit" viewdef="DisciplineViewOnlyCollections" mode="edit" validated="true" default="true"/>
    </altviews>
</view>

View def.: DisciplineViewOnlyCollections

<viewdef type="form"
      name="DisciplineViewOnlyCollections"
      class="edu.ku.brc.specify.datamodel.Discipline"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[Discipline Data Entry Form]]></desc>
    <columnDef>100px,2px,180px,5px,85px,2px,180px,5px,86px,2px,180px,10px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,195px,5px,92px,2px,200px,5px,96px,2px,200px,10px,p:g</columnDef>
    <columnDef os="mac">130px,2px,218px,5px,112px,2px,220px,5px,116px,2px,220px,10px,p:g</columnDef>
    <columnDef os="exp">100px,2px,p:g(2),5px:g,p,2px,p:g(2),5px:g,p,2px,p:g(2),p</columnDef>
    <rowDef auto="true" cell="p" sep="2dlu"/>            
 
    <rows>
        <row>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="dataType" uitype="dsptextfield" readonly="true"/>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="type" uitype="text" isrequired="true" readonly="true"/> 
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="name" uitype="text" isrequired="true"/>
        </row>
        <row>
            <cell type="subview" viewname="CollectionGridViewOnly" id="4" name="collections" colspan="12"/>
        </row>
    </rows>
</viewdef>
 

View: DisciplineWithoutCollections (Common)

<view name="DisciplineWithoutCollections"
      class="edu.ku.brc.specify.datamodel.Discipline"
      busrules="edu.ku.brc.specify.datamodel.busrules.DisciplineBusRules">
    <desc><![CDATA[The Discipline Object form without collections subform.]]></desc>
    <altviews>
        <altview name="Discipline Edit View" viewdef="DisciplineWithoutCollections" mode="view" validated="false"/>
        <altview name="Discipline Edit" viewdef="DisciplineWithoutCollections" mode="edit" validated="true" default="true"/>
    </altviews>
</view>

View def.: DisciplineWithoutCollections

<viewdef type="form"
      name="DisciplineWithoutCollections"
      class="edu.ku.brc.specify.datamodel.Discipline"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[Discipline Data Entry Form]]></desc>
    <columnDef>p,3dlu,p,p:g</columnDef>
    <rowDef auto="true" cell="p" sep="2dlu"/>            
 
    <rows>
        <row>
            <cell type="separator" label="Discipline" colspan="4"/>
        </row>
        <row>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="dataType" uitype="dsptextfield" readonly="true"/>
        </row>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="type" uitype="text" isrequired="true" readonly="true"/> 
        </row>
        <row>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="name" uitype="text"/>
        </row>
    </rows>
</viewdef>