division

Table info.

Title Division
Description Division

Fields

Name Type Required Index Hidden On form Title Pick list Description
UserGroupScopeId 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
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
Abbrev varchar(64) Abbreviation The abbreviation for the division.
AltName varchar(128) Alt Name altName
Description text Description description
DisciplineType varchar(64)
divisionId int(11)
IconURI varchar(255) Icon URI The URL to their icon
Name varchar(255) MUL Name The name of the division
RegNumber varchar(24) Reg Number regNumber
Remarks text Remarks Additional Comments
Uri varchar(255) URI A URI (web site) address for the department
InstitutionID int(11) MUL
AddressID int(11) MUL

Indexes

Name Fields Unique Nullable
DivisionNameIDX Name
FK15BD30AD81223908 InstitutionID
FK15BD30ADE6A64D00 AddressID
FK3D0021605327F94215bd30ad ModifiedByAgentID
FK3D0021607699B00315bd30ad CreatedByAgentID
PRIMARY UserGroupScopeId
UserGroupScopeId UserGroupScopeId

One-to-many relationships

Name Field Related table Related field
FK81EF382497C961D8 UserGroupScopeId accession DivisionID
FK587430597C961D8 UserGroupScopeId agent DivisionID
FKA8BE49397C961D8 UserGroupScopeId autonumsch_div DivisionID
FK7043CC8D97C961D8 UserGroupScopeId collector DivisionID
FKC040F46497C961D8 UserGroupScopeId conservdescription DivisionID
FK157B9B7097C961D8 UserGroupScopeId discipline DivisionID
FK366E9E8897C961D8 UserGroupScopeId exchangein DivisionID
FK97654A4B97C961D8 UserGroupScopeId exchangeout DivisionID
FK30693097C961D8 UserGroupScopeId gift DivisionID
FK5DEB769497C961D8 UserGroupScopeId groupperson DivisionID
FK32C4F097C961D8 UserGroupScopeId loan DivisionID
FKA5A38A0097C961D8 UserGroupScopeId repositoryagreement DivisionID
FK577D852297C961D8 UserGroupScopeId treatmentevent DivisionID

Many-to-one relationships

Name Field Related table Related field
FK15BD30AD81223908 InstitutionID institution UserGroupScopeId
FK15BD30ADE6A64D00 AddressID address AddressID
FK3D0021605327F94215bd30ad ModifiedByAgentID agent AgentID
FK3D0021607699B00315bd30ad CreatedByAgentID agent AgentID

View: Division (Common)

<view name="Division"
      class="edu.ku.brc.specify.datamodel.Division"
      busrules="edu.ku.brc.specify.datamodel.busrules.DivisionBusRules">
    <desc><![CDATA[Subform within the Collection Object form.]]></desc>
    <altviews>
        <altview name="Division View" viewdef="Division" mode="view"/>
        <altview name="Division Edit" viewdef="Division" mode="edit" default="true"/>
    </altviews>
</view>

View def.: Division

<viewdef name="Division"
      type="form"
      class="edu.ku.brc.specify.datamodel.Division"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[Division Form.]]></desc>
    <enableRules/>
 
    <columnDef>100px,2px,361px,5px,70px,2px,80px,5px,80px,2px,120px,0px,15px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,377px,5px,100px,2px,80px,5px,100px,2px,129px,0px,15px,p:g</columnDef>
    <columnDef os="mac">130px,2px,396px,5px,100px,2px,120px,5px,120px,2px,150px,0px,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),0px,15px,p:g</columnDef>
    <rowDef auto="true" cell="p" sep="2px"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="name" uitype="text" isrequired="true" colspan="5"/>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="abbrev" uitype="text"/>
        </row>
        <row>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="altName" uitype="text" colspan="9"/>
        </row>
        <row>
            <cell type="label" labelfor="4"/>
            <cell type="field" id="4" name="uri" uitype="text"/>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="iconURI" uitype="text" colspan="5"/>
        </row>
        <row>
            <cell type="label" labelfor="6"/>
            <cell type="field" id="6" name="description" uitype="textareabrief" colspan="10" rows="2"/>
        </row>
        <!-- <row>
            <cell type="label" labelfor="7"/>
            <cell type="field" id="7" name="remarks" uitype="textarea" colspan="10"/>
        </row>  -->
        <row>
            <cell type="subview" viewname="DisciplineViewOnlyCollections" id="9" name="disciplines" colspan="13"/>
        </row>
        <row>
            <cell type="subview" viewname="AddressDiv" id="10" name="address" colspan="13" initialize="btn=true"/>
        </row>
    </rows>
</viewdef>
 

View: DivisionOnly (Common)

<view name="DivisionOnly"
      class="edu.ku.brc.specify.datamodel.Division"
      busrules="edu.ku.brc.specify.datamodel.busrules.DivisionBusRules">
    <desc><![CDATA[Subform within the Collection Object form.]]></desc>
    <altviews>
        <altview name="Division View" viewdef="DivisionOnly" mode="view"/>
        <altview name="Division Edit" viewdef="DivisionOnly" mode="edit" default="true"/>
    </altviews>
</view>

View def.: DivisionOnly

<viewdef name="DivisionOnly"
      type="form"
      class="edu.ku.brc.specify.datamodel.Division"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[Division Form.]]></desc>
    <enableRules/>
 
    <columnDef>100px,2px,361px,5px,70px,2px,80px,5px,80px,2px,120px,0px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,377px,5px,100px,2px,80px,5px,100px,2px,129px,0px,p:g</columnDef>
    <columnDef os="mac">130px,2px,396px,5px,100px,2px,120px,5px,120px,2px,150px,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),0px</columnDef>
    <rowDef auto="true" cell="p" sep="2px"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="name" uitype="text" isrequired="true" colspan="9"/>
        </row>
        <row>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="altName" uitype="text" colspan="5"/>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="abbrev" uitype="text"/>
        </row>
        <row>
            <cell type="label" labelfor="4"/>
            <cell type="field" id="4" name="uri" uitype="text"/>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="iconURI" uitype="text" colspan="5"/>
        </row>
        <row>
            <cell type="label" labelfor="6"/>
            <cell type="field" id="6" name="description" uitype="textareabrief" rows="2" colspan="10"/>
        </row>
        <row>
            <cell type="subview" viewname="AddressSingle" id="10" name="address" colspan="12" initialize="btn=true"/>
        </row>
    </rows>
</viewdef>