otheridentifier

Table info.

Title Other Identifier
Description Other Identifier

Fields

Name Type Required Index Hidden On form Title Pick list Description
OtherIdentifierID 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
Identifier varchar(64) Institution The Index Herbariorum acronym of the institution from which the specimen was received, or where the specimen was originally held
Institution varchar(64) Catalogue no. The catalogue number for the specimen at the other institution
Remarks text Type Other identifier type
  • Ex herbarium
  • Duplicate
  • Orig. herbarium
 The type of other identifier
CreatedByAgentID int(11) MUL
CollectionObjectID int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK2A5397B95327F942 ModifiedByAgentID
FK2A5397B975E37458 CollectionObjectID
FK2A5397B97699B003 CreatedByAgentID
OthIdColMemIDX CollectionMemberID
PRIMARY OtherIdentifierID

Many-to-one relationships

Name Field Related table Related field
FK2A5397B95327F942 ModifiedByAgentID agent AgentID
FK2A5397B975E37458 CollectionObjectID collectionobject CollectionObjectID
FK2A5397B97699B003 CreatedByAgentID agent AgentID

View: OtherIdentifiers (Common)

<view name="OtherIdentifiers"
      class="edu.ku.brc.specify.datamodel.OtherIdentifier">
    <desc><![CDATA[Subform within the collectionObject form.]]></desc>
    <altviews>
        <altview name="OtherIdentifiers Table View" viewdef="OtherIdentifiers Table" mode="view"/>
        <altview name="OtherIdentifiers Table Edit" viewdef="OtherIdentifiers Table" mode="edit"/>
        <altview name="OtherIdentifiers View" viewdef="OtherIdentifiers" mode="view"/>
        <altview name="OtherIdentifiers Edit" viewdef="OtherIdentifiers" mode="edit" default="true"/>
    </altviews>
</view>

View def.: OtherIdentifiers Table

<viewdef type="formtable"
      name="OtherIdentifiers Table"
      class="edu.ku.brc.specify.datamodel.OtherIdentifier"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[Preparation subform table for Collection Object form.]]></desc>
    <definition>OtherIdentifiers</definition>
</viewdef>
 

View: OtherIdentifiersSub (Collection)

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

View def.: OtherIdentifiersSub

<viewdef name="OtherIdentifiersSub"
      type="form"
      class="edu.ku.brc.specify.datamodel.OtherIdentifier"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj"
      useresourcelabels="true">
    <desc><![CDATA[subform on the Collection Object form.]]></desc>
    <enableRules/>
 
    <columnDef>100px,2px,150px,5px,100px,2px,150px,0px,15px,p:g</columnDef>
    <!--columnDef os="lnx">115px,2px,510px,5px,85px,2px,198px,0px,15px,p:g</columnDef>
    <columnDef os="mac">130px,2px,530px,5px,105px,2px,218px,0px,15px,p:g</columnDef>
    <columnDef os="exp">p,2px,473px,5px:g,p,2px,125px,0px,15px,p:g</columnDef-->
    <rowDef auto="true" cell="p" sep="2dlu"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="7"/>
            <cell type="field" id="7" name="remarks" uitype="combobox" picklist="Other identifier type" default="Ex herbarium"/>
        </row>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="identifier" uitype="text"/>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="institution" uitype="text"/>
        </row>
    </rows>
</viewdef>