commonnametx

Table info.

Title Common Name
Description Common Name

Fields

Name Type Required Index Hidden On form Title Pick list Description
CommonNameTxID 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
Author varchar(128) Author author
Country varchar(2) MUL Country The country code.
Language varchar(2) Language The language code.
Name varchar(255) MUL Name name
Variant varchar(2) Variant The variant code of the language.
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
TaxonID int(11) MUL

Indexes

Name Fields Unique Nullable
CommonNameTxCountryIDX Country
CommonNameTxNameIDX Name
FK3413DFFA1D39F06C TaxonID
FK3413DFFA5327F942 ModifiedByAgentID
FK3413DFFA7699B003 CreatedByAgentID
PRIMARY CommonNameTxID

One-to-many relationships

Name Field Related table Related field
FK829B50E115A0FFF2 CommonNameTxID commonnametxcitation CommonNameTxID

Many-to-one relationships

Name Field Related table Related field
FK3413DFFA1D39F06C TaxonID taxon TaxonID
FK3413DFFA5327F942 ModifiedByAgentID agent AgentID
FK3413DFFA7699B003 CreatedByAgentID agent AgentID

View: CommonNameTx (Common)

<view name="CommonNameTx"
      class="edu.ku.brc.specify.datamodel.CommonNameTx">
    <desc><![CDATA[The Common Name form.]]></desc>
    <altviews>
        <altview name="CommonNameTx View" viewdef="CommonNameTx" mode="view" default="true"/>
        <altview name="CommonNameTx Edit" viewdef="CommonNameTx" mode="edit"/>
    </altviews> 
</view>

View def.: CommonNameTx

<viewdef type="form"
      name="CommonNameTx"
      class="edu.ku.brc.specify.datamodel.CommonNameTx"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[Common Name form]]></desc>
    <enableRules/>
 
    <columnDef>200px,2px,p,10px,p,2px,p,2px,p,2px,200px,p:g</columnDef>
    <rowDef auto="true" cell="p" sep="2px"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="name" uitype="text"/>
        </row> 
        <row>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="language" uitype="combobox" picklist="Languages" colspan="10"/>
        </row> 
        <row>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="country" uitype="text" colspan="10"/>
        </row> 
        <!--<row>
            <cell type="label" labelfor="au"/>
            <cell type="field" id="au" name="author" uitype="text"/>
            <cell type="label" labelfor="var"/>
            <cell type="field" id="var" name="variant" uitype="text"/>
        </row> 
        <row>
            <cell type="label" labelfor="9"/>
            <cell type="field" id="9" name="createdByAgent" uitype="label" readonly="true"  uifieldformatter="Agent"/>
            <cell type="label" labelfor="10"/>
            <cell type="field" id="10" name="modifiedByAgent" uitype="label" readonly="true"  uifieldformatter="Agent"/>
        </row>
        <row>
            <cell type="label" labelfor="11"/>
            <cell type="field" id="11" name="timestampModified" uitype="label" readonly="true"/>
            <cell type="label" labelfor="12"/>
            <cell type="field" id="12" name="timestampCreated" uitype="label" readonly="true"/>
        </row>
        <row>
            <cell type="subview" id="10" viewname="CommonNameTXCitation" name="citations" colspan="12"/>
        </row> -->
    </rows>
</viewdef>