determinationcitation

Table info.

Title Determination Citation
Description Determination Citation

Fields

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

Indexes

Name Fields Unique Nullable
DetCitColMemIDX CollectionMemberID
FK259B07CA47AE835E DeterminationID
FK259B07CA5327F942 ModifiedByAgentID
FK259B07CA69734F30 ReferenceWorkID
FK259B07CA7699B003 CreatedByAgentID
PRIMARY DeterminationCitationID
ReferenceWorkID ReferenceWorkID, DeterminationID

Many-to-one relationships

Name Field Related table Related field
FK259B07CA47AE835E DeterminationID determination DeterminationID
FK259B07CA5327F942 ModifiedByAgentID agent AgentID
FK259B07CA69734F30 ReferenceWorkID referencework ReferenceWorkID
FK259B07CA7699B003 CreatedByAgentID agent AgentID

View: DeterminationCitation (Common)

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

View def.: DeterminationCitation

<viewdef type="form"
      name="DeterminationCitation"
      class="edu.ku.brc.specify.datamodel.DeterminationCitation"
      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>