exsiccata

Table info.

Title Exsiccata
Description Exsiccata

Fields

Name Type Required Index Hidden On form Title Pick list Description
ExsiccataID int(11) PRI
TimestampCreated datetime Created timestampCreated
TimestampModified datetime Last edited timestampModified
Version int(11) Version version
Title varchar(255) Title The name of the exsiccata series or personal herbarium that the specimen came from
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
ReferenceWorkID int(11) MUL
Remarks text Remarks remarks
Schedae varchar(255) Schedae schedae

Indexes

Name Fields Unique Nullable
FKACC7DD855327F942 ModifiedByAgentID
FKACC7DD8569734F30 ReferenceWorkID
FKACC7DD857699B003 CreatedByAgentID
PRIMARY ExsiccataID

One-to-many relationships

Name Field Related table Related field
FK23150E183B4364A2 ExsiccataID exsiccataitem ExsiccataID

Many-to-one relationships

Name Field Related table Related field
FKACC7DD855327F942 ModifiedByAgentID agent AgentID
FKACC7DD8569734F30 ReferenceWorkID referencework ReferenceWorkID
FKACC7DD857699B003 CreatedByAgentID agent AgentID

View: Exsiccata (Collection)

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

View def.: Exsiccata

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