localitycitation

Table info.

Title Locality Citation
Description Locality Citation

Fields

Name Type Required Index Hidden On form Title Pick list Description
LocalityCitationID 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
Remarks text Remarks Additional Comments
ReferenceWorkID int(11) MUL
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
DisciplineID int(11) MUL
LocalityID int(11) MUL

Indexes

Name Fields Unique Nullable
FK9877F54A4CE675DE DisciplineID
FK9877F54A5327F942 ModifiedByAgentID
FK9877F54A69734F30 ReferenceWorkID
FK9877F54A7699B003 CreatedByAgentID
FK9877F54AA666A5C4 LocalityID
LocCitDspMemIDX DisciplineID
PRIMARY LocalityCitationID
ReferenceWorkID ReferenceWorkID, LocalityID

Many-to-one relationships

Name Field Related table Related field
FK9877F54A4CE675DE DisciplineID discipline UserGroupScopeId
FK9877F54A5327F942 ModifiedByAgentID agent AgentID
FK9877F54A69734F30 ReferenceWorkID referencework ReferenceWorkID
FK9877F54A7699B003 CreatedByAgentID agent AgentID
FK9877F54AA666A5C4 LocalityID locality LocalityID

View: LocalityCitation (Common)

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

View def.: LocalityCitation

<viewdef type="form"
      name="LocalityCitation"
      class="edu.ku.brc.specify.datamodel.LocalityCitation"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[Locality]]></desc>
    <columnDef>105px,2px,200px,5px,103px,2px,150px,265px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,230px,5px,73px,2px,155px,p:g</columnDef>
    <columnDef os="mac">130px,2px,215px,5px,80px,2px,165px,433px,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g,5px,100px,2px,p:g,p:g(2)</columnDef>
    <rowDef auto="true" cell="p" sep="2dlu"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="referenceWork" uitype="querycbx" initialize="name=ReferenceWork;title=ReferenceWork" colspan="6"/>
        </row>            
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="remarks" uitype="textareabrief" rows="2" colspan="6"/>
        </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>-->
    </rows>
</viewdef>