exsiccataitem

Table info.

Title Exsiccata Item
Description Exsiccata Item

Fields

Name Type Required Index Hidden On form Title Pick list Description
ExsiccataItemID int(11) PRI
TimestampCreated datetime Created timestampCreated
TimestampModified datetime Last edited timestampModified
Version int(11) Version version
Fascicle varchar(16) Fascicle The fascicle number for exsiccata series
Number varchar(16) Number The list number of the collection object within the exsiccata
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
CollectionObjectID int(11) MUL
ExsiccataID int(11) MUL

Indexes

Name Fields Unique Nullable
FK23150E183B4364A2 ExsiccataID
FK23150E185327F942 ModifiedByAgentID
FK23150E1875E37458 CollectionObjectID
FK23150E187699B003 CreatedByAgentID
PRIMARY ExsiccataItemID

Many-to-one relationships

Name Field Related table Related field
FK23150E183B4364A2 ExsiccataID exsiccata ExsiccataID
FK23150E185327F942 ModifiedByAgentID agent AgentID
FK23150E1875E37458 CollectionObjectID collectionobject CollectionObjectID
FK23150E187699B003 CreatedByAgentID agent AgentID

View: ExsiccataItem (Collection)

<view name="ExsiccataItem"
      class="edu.ku.brc.specify.datamodel.ExsiccataItem"
      resourcelabels="false">
    <desc><![CDATA[Project form.]]></desc>
    <altviews>
        <altview name="ExsiccataItem View" viewdef="ExsiccataItem" mode="view"/>
        <altview name="ExsiccataItem Edit" viewdef="ExsiccataItem" mode="edit" default="true"/>
    </altviews>
</view>

View def.: ExsiccataItem

<viewdef name="ExsiccataItem"
      type="form"
      class="edu.ku.brc.specify.datamodel.ExsiccataItem"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[Form for ExsiccataItem]]></desc>
    <!--columnDef>p,2px,p,2px,100px,2px,p,2px,100px,2px,100px,p:g</columnDef-->
    <columnDef>p,2px,100px,5px,150px,2px,100px,2px,p,p:g</columnDef>
    <rowDef auto="true" sep="2px" cell="p"/>
 
    <rows>
         <row>
             <cell type="label" labelfor="exsiccata"/>
             <cell type="field" id="exsiccata" name="exsiccata" uitype="querycbx" initialize="name=Exsiccata" colspan="5"/>
         </row>
         <row>
             <cell type="label" labelfor="1"/>
             <cell type="field" id="1" name="fascicle" uitype="text"/>
             <cell type="label" labelfor="2"/>
             <cell type="field" id="2" name="number" uitype="text"/>
         </row>
    </rows>
</viewdef>