container

Table info.

Title Container
Description Container

Fields

Name Type Required Index Hidden On form Title Pick list Description
ContainerID 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
CollectionMemberID int(11) MUL Collection Member Id collectionMemberId
Description varchar(255) Description A description of the container
Name varchar(64) MUL Name The name of the container
Number int(11) Number User definable
Type smallint(6) Type The type of container
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
StorageID int(11) MUL
ParentID int(11) MUL

Indexes

Name Fields Unique Nullable
ContainerMemIDX CollectionMemberID
ContainerNameIDX Name
FKE7814C8121C1C983 ParentID
FKE7814C815327F942 ModifiedByAgentID
FKE7814C817699B003 CreatedByAgentID
FKE7814C81EB48144E StorageID
PRIMARY ContainerID

One-to-many relationships

Name Field Related table Related field
FKC1D4635DA40125AB ContainerID collectionobject ContainerOwnerID
FKC1D4635DE816739A ContainerID collectionobject ContainerID
FKE7814C8121C1C983 ContainerID container ParentID

Many-to-one relationships

Name Field Related table Related field
FKE7814C8121C1C983 ParentID container ContainerID
FKE7814C815327F942 ModifiedByAgentID agent AgentID
FKE7814C817699B003 CreatedByAgentID agent AgentID
FKE7814C81EB48144E StorageID storage StorageID

View: Container (Common)

<view name="Container"
      class="edu.ku.brc.specify.datamodel.Container"
      isinternal="false"
      busrules="edu.ku.brc.specify.datamodel.busrules.ContainerBusRules">
    <desc><![CDATA[Conservation Description.]]></desc>
    <altviews>
        <altview name="Container View" viewdef="Container" mode="view" default="true"/>
        <altview name="Container Edit" viewdef="Container" mode="edit"/>
    </altviews>
</view>

View def.: Container

<viewdef type="form"
      name="Container"
      class="edu.ku.brc.specify.datamodel.Container"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj"
      useresourcelabels="true">
    <desc><![CDATA[Container Description]]></desc>
    <enableRules/>
 
    <columnDef>100px,2px,178px,5px,108px,2px,130px,5px,100px,2px,195px,0px,15px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,196px,2px,113px,2px,150px,2px,115px,5px,215px,0px,15px,p:g</columnDef>
    <columnDef os="mac">130px,2px,216px,2px,133px,2px,170px,2px,135px,5px,235px,0px,15px,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g,2px,p:g(2),5px,p:g,2px,p:g(2),5px:g,p,2px,p:g,0px,p,p:g</columnDef>
    <rowDef auto="true" cell="p" sep="2px"/>
 
    <rows>
        <row> 
            <cell type="label" labelfor="nm"/>
            <cell type="field" id="nm" name="name" uitype="text"/>
            <cell type="label" labelfor="typ"/>
            <cell type="field" id="typ" name="type" uitype="combobox"/>
        </row>
        <row>
            <cell type="label" labelfor="parent"/>
            <cell type="field" id="parent" name="parent" uitype="querycbx" initialize="name=Container;displaydlg=ContainerDisplay;searchdlg=ContainerSearch;" colspan="10"/>                
        </row>
        <row>
            <cell type="label" label="COLOBJ" initialize="align=right"/>
            <cell type="field" id="this_" name="this" uitype="plugin" initialize="name=ContainersColObjPlugin"/>                
            <cell type="label" label="CONTNR_COLOBJ" initialize="align=left" colspan="5"/>
        </row>
        <row>
            <cell type="label" labelfor="desc"/>
            <cell type="field" id="desc" name="description" uitype="textareabrief" rows="2" colspan="10"/> 
        </row>
        <row>
            <cell type="subview" id="collectionObjectKids" name="collectionObjectKids" viewname="CollectionObjectSubTable" initialize="addsearch=true;title=COLOBJ_IN_CONTR" defaulttype="table" colspan="13"/>               
        </row>
        <row>
            <cell type="subview" id="children" name="children" viewname="ContainerBriefTable" initialize="addsearch=true;title=SUBCONTAINERS" defaulttype="table" colspan="13"/>               
        </row>
   </rows>
</viewdef>
 

View: ContainerBrief (Common)

<view name="ContainerBrief"
      class="edu.ku.brc.specify.datamodel.Container"
      isinternal="true"
      busrules="edu.ku.brc.specify.datamodel.busrules.ContainerBusRules">
    <desc><![CDATA[Conservation Description.]]></desc>
    <altviews>
        <altview name="ContainerBrief View" viewdef="ContainerBrief" mode="view" default="true"/>
        <altview name="ContainerBrief Edit" viewdef="ContainerBrief" mode="edit"/>
    </altviews>
</view>

View def.: ContainerBrief

<viewdef type="form"
      name="ContainerBrief"
      class="edu.ku.brc.specify.datamodel.Container"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj"
      useresourcelabels="true">
    <desc><![CDATA[Container Description]]></desc>
    <enableRules/>
 
    <columnDef>100px,2px,178px,5px,108px,2px,130px,5px,100px,2px,195px,0px,15px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,196px,2px,113px,2px,150px,2px,115px,5px,215px,0px,15px,p:g</columnDef>
    <columnDef os="mac">130px,2px,216px,2px,133px,2px,170px,2px,135px,5px,235px,0px,15px,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g,2px,p:g(2),5px,p:g,2px,p:g(2),5px:g,p,2px,p:g,0px,p,p:g</columnDef>
    <rowDef auto="true" cell="p" sep="2px"/>
 
    <rows>
        <row> 
            <cell type="label" labelfor="nm"/>
            <cell type="field" id="nm" name="name" uitype="text"/>
            <cell type="label" labelfor="typ"/>
            <cell type="field" id="typ" name="type" uitype="combobox"/>
        </row>
        <row>
            <cell type="label" labelfor="parent"/>
            <cell type="field" id="parent" name="parent" uitype="querycbx" initialize="name=Container;displaydlg=ContainerDisplay;searchdlg=ContainerSearch;" colspan="10"/>                
        </row>
        <row>
            <cell type="label" label="COLOBJ" initialize="align=right"/>
            <cell type="field" id="this_" name="this" uitype="plugin" initialize="name=ContainersColObjPlugin"/>                
            <cell type="label" label="CONTNR_COLOBJ" initialize="align=left" colspan="5"/>
        </row>
        <row>
            <cell type="label" labelfor="desc"/>
            <cell type="field" id="desc" name="description" uitype="textareabrief" rows="2" colspan="10"/> 
        </row>
        <row>
            <cell type="subview" id="collectionObjectKids" name="collectionObjectKids" viewname="CollectionObjectSubTable" initialize="addsearch=true;title=COLOBJ_IN_CONTR" defaulttype="table" colspan="13"/>               
        </row>
   </rows>
</viewdef>