agentgeography

Table info.

Title Agent Geography
Description Agent Geography

Fields

Name Type Required Index Hidden On form Title Pick list Description
AgentGeographyID int(11) PRI
TimestampCreated datetime Created timestampCreated
TimestampModified datetime Last edited timestampModified
Version int(11) Version version
Remarks text Comments Any comments about the agent's interest in the geographic region
Role varchar(64) Role AgentRole
  • Determiner
  • Collector
 Role of the agent as "author" or "collector" within the geography.
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
AgentID int(11) MUL
GeographyID int(11) MUL

Indexes

Name Fields Unique Nullable
FK89CDCA17384B3622 AgentID
FK89CDCA175327F942 ModifiedByAgentID
FK89CDCA177699B003 CreatedByAgentID
FK89CDCA17D649F6D0 GeographyID
PRIMARY AgentGeographyID

Many-to-one relationships

Name Field Related table Related field
FK89CDCA17384B3622 AgentID agent AgentID
FK89CDCA175327F942 ModifiedByAgentID agent AgentID
FK89CDCA177699B003 CreatedByAgentID agent AgentID
FK89CDCA17D649F6D0 GeographyID geography GeographyID

View: AgentGeographies (Discipline)

<view name="AgentGeographies"
      class="edu.ku.brc.specify.datamodel.AgentGeography"
      resourcelabels="false">
    <desc><![CDATA[AgentGeographies subform within the Agent form.]]></desc>
    <altviews defaultmode="view">
        <altview name="AgentGeographies View" title="AgentGeographies" viewdef="AgentGeographies" mode="view" validated="false"/>
        <altview name="AgentGeographies Edit" title="AgentGeographies" viewdef="AgentGeographies" mode="edit" validated="true" default="true"/>
        <altview name="AgentGeographies Table View" viewdef="AgentGeographies Table" label="Table View" mode="view"/>
        <altview name="AgentGeographies Table Edit" viewdef="AgentGeographies Table" label="Table Edit" mode="edit"/>
    </altviews>
</view>

View def.: AgentGeographies

<viewdef name="AgentGeographies"
      type="form"
      class="edu.ku.brc.specify.datamodel.AgentGeography"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[The AgentGeographies form.]]></desc>
    <enableRules/>
 
    <columnDef>120px,2px,190px,5px,50px,2px,404px,p,p:g</columnDef>
    <!--columnDef os="lnx">115px,2px,200px,5px,70px,2px,523px,p,p:g</columnDef>
    <columnDef os="mac">130px,2px,150px,5px,80px,2px,663
    <columnDef os="exp">p,2px,max(p;190px),5px,100px,2px,p:g</columnDef>
    px,p:g</columnDef-->
    <rowDef auto="true" cell="p" sep="2px"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="1"/>
            <!--cell type="label" label="Geography:" initialize="align=right"/-->
            <cell type="field" id="1" name="geography" uitype="querycbx" initialize="name=Geography" colspan="5"/>
        </row>
        <row>
            <cell type="label" labelfor="3"/>
            <!--cell type="label" label="Remarks:" initialize="align=right"/-->
            <cell type="field" id="3" name="remarks" uitype="textareabrief" colspan="5"/>
        </row>
    </rows>
</viewdef>