storage

Table info.

Title Storage
Description Storage

Fields

Name Type Required Index Hidden On form Title Pick list Description
StorageID 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
Abbrev varchar(16) Abbreviation abbrev
FullName varchar(255) MUL Full name The full storage name string
HighestChildNodeNumber int(11) Highest Child Node Number highestChildNodeNumber
IsAccepted bit(1) Is Preferred isAccepted
Name varchar(64) MUL Name name
NodeNumber int(11) Node Number nodeNumber
Number1 int(11) Number1 User definable
Number2 int(11) Number2 User definable
RankID int(11) Rank Id rankId
Remarks text Comments Additional comments about storage
Text1 varchar(32) Curation officer Curation officer responsible for this group
Text2 varchar(32) Taxonomic group Taxonomic group: only fill in for Major Groups where there is an exact match between the Major Group and a taxon in the taxon tree, e.g. Musci, Basidiomycetes, but not Dicots or Monocots.
TimestampVersion datetime Timestamp Version timestampVersion
AcceptedID int(11) MUL
ModifiedByAgentID int(11) MUL
ParentID int(11) MUL
StorageTreeDefItemID int(11) MUL
StorageTreeDefID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK8FB0427B3D83D67A AcceptedID
FK8FB0427B4D340BDC StorageTreeDefItemID
FK8FB0427B5327F942 ModifiedByAgentID
FK8FB0427B53C7EFD6 StorageTreeDefID
FK8FB0427B7699B003 CreatedByAgentID
FK8FB0427BCCAA0ABD ParentID
PRIMARY StorageID
StorFullNameIDX FullName
StorNameIDX Name

One-to-many relationships

Name Field Related table Related field
FKE7814C81EB48144E StorageID container StorageID
FKB1982697EB48144E StorageID preparation StorageID
FKB1982697EBDCBD14 StorageID preparation AlternateStorageID
FK8FB0427B3D83D67A StorageID storage AcceptedID
FK8FB0427BCCAA0ABD StorageID storage ParentID
FKBE9EFDDEEB48144E StorageID storageattachment StorageID

Many-to-one relationships

Name Field Related table Related field
FK8FB0427B3D83D67A AcceptedID storage StorageID
FK8FB0427B4D340BDC StorageTreeDefItemID storagetreedefitem StorageTreeDefItemID
FK8FB0427B5327F942 ModifiedByAgentID agent AgentID
FK8FB0427B53C7EFD6 StorageTreeDefID storagetreedef StorageTreeDefID
FK8FB0427B7699B003 CreatedByAgentID agent AgentID
FK8FB0427BCCAA0ABD ParentID storage StorageID

View: Storage (Discipline)

<view name="Storage"
      class="edu.ku.brc.specify.datamodel.Storage"
      busrules="edu.ku.brc.specify.datamodel.busrules.StorageBusRules"
      isinternal="false"
      resourcelabels="false">
    <desc><![CDATA[Storage data entry form.]]></desc>
    <altviews>
        <altview name="Storage View" viewdef="Storage" mode="view"/>
        <altview name="Storage Edit" viewdef="Storage" mode="edit" default="true"/>
    </altviews>
</view>

View def.: Storage

<viewdef name="Storage"
      type="form"
      class="edu.ku.brc.specify.datamodel.Storage"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj"
      useresourcelabels="true">
 
    <desc><![CDATA[New Storage Node Form]]></desc>
    <enableRules>
        <rule id="definitionItem"><![CDATA[parent.getValue() != null]]></rule>
     <!--   <rule id="acceptedParent"><![CDATA[!isAccepted.isSelected()]]></rule> -->
    </enableRules>
 
    <columnDef>100px,2px,445px,5px,60px,2px,213px,0px,15px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,475px,5px,80px,2px,238px,0px,15px,p:g</columnDef>
    <columnDef os="mac">130px,2px,568px,5px,75px,2px,250px,0px,15px,p:g</columnDef>
    <columnDef os="exp">p,2px,445px,5px:g,p,2px,p,0px,p,p:g</columnDef>
    <rowDef auto="true" cell="p" sep="2dlu"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="name"/>
            <cell type="field" id="name" uitype="text" cols="10" name="name" isrequired="true"/> 
            <cell type="label" labelfor="parent"/>
        	<cell type="field" id="parent" uitype="querycbx" isrequired="true" initialize="name=Storage;title=Storage;editbtn=false;newbtn=false;editoncreate=true" name="parent"/>
        </row>
        <row>
            <cell type="label" labelfor="definitionItem"/>
        	<cell type="field" id="definitionItem" uitype="combobox" name="definitionItem" colspan="6"/>
        </row>
        <row>
            <cell type="label" labelfor="remarks"/>
            <cell type="field" id="remarks" uitype="textareabrief" rows="2" name="remarks" colspan="6"/>
        </row>
        <row>
            <cell type="subview" viewname="StorageSubform" id="children" name="children" colspan="9"/>
        </row>
    </rows>
</viewdef>