inforequest

Table info.

Title Information Request
Description Information Request

Fields

Name Type Required Index Hidden On form Title Pick list Description
InfoRequestID 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
Email varchar(50) Email Email of agent requesting the information.
Firstname varchar(50) First Name firstName
InfoReqNumber varchar(32) Info Req Number Number of Information Request.
Institution varchar(127) Institution institution
Lastname varchar(50) Last Name lastName
Remarks text Remarks Additional Comments.
ReplyDate date Reply Date replyDate
RequestDate date Request Date requestDate
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
AgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK68918E21384B3622 AgentID
FK68918E215327F942 ModifiedByAgentID
FK68918E217699B003 CreatedByAgentID
IRColMemIDX CollectionMemberID
PRIMARY InfoRequestID

One-to-many relationships

Name Field Related table Related field
FK3B38A27110D22B7A InfoRequestID recordset InfoRequestID

Many-to-one relationships

Name Field Related table Related field
FK68918E21384B3622 AgentID agent AgentID
FK68918E215327F942 ModifiedByAgentID agent AgentID
FK68918E217699B003 CreatedByAgentID agent AgentID

View: InfoRequest (Common)

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

View def.: InfoRequest

<viewdef type="form"
      name="InfoRequest"
      class="edu.ku.brc.specify.datamodel.InfoRequest"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[The Info Request form.]]></desc>
    <enableRules/>
 
    <columnDef>100px,2px,142px,5px,89px,2px,80px,5px,70px,2px,83px,5px,45px,2px,195px,0px,15px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,115px,5px,94px,2px,110px,5px,90px,2px,110px,5px,65px,2px,195px,0px,15px,p:g</columnDef>
    <columnDef os="mac">130px,2px,p,5px,111px,2px,120px,5px,101px,2px,120px,5px,81px,2px,220px,0px,15px,p,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g(2),5px:g,p,2px,p:g(2),5px:g,p,2px,p:g(2),5px:g,p,2px,p:g(2),0px,p,p:g</columnDef>            
    <rowDef>p,2dlu,p,2dlu,p,2dlu,p,2dlu,200px,2dlu,p</rowDef>&gt;
 
    <rows>
        <row>
            <cell type="label" labelfor="7"/>
            <cell type="field" id="7" name="infoReqNumber" uitype="formattedtext" uifieldformatter="InfoRequestNumber" isrequired="false"/>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="requestDate" uitype="formattedtext" uifieldformatter="Date" default="today"/>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="replyDate" uitype="formattedtext" uifieldformatter="Date"/>
            <cell type="label" labelfor="6"/>
            <cell type="field" id="6" name="agent" uitype="querycbx" initialize="name=Agent" isrequired="false"/>
        </row>
        <row>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="remarks" uitype="textareabrief" rows="2" colspan="14"/>
        </row>
        <row>
            <cell type="subview" id="4" viewname="InfoRequestColObj" name="recordSets" colspan="16" rows="6"/>
        </row>
        <row>
            <cell type="field" uitype="checkbox" id="5" name="sendEMail" label="Send Email on Save" ignore="true" default="true" colspan="6"/>
        </row>
        <!--<row>
            <cell type="label" labelfor="email"/>
            <cell type="field" id="email" name="email" uitype="text" />
            <cell type="label" labelfor="fn"/>
            <cell type="field" id="fn" name="firstName" uitype="text"/>
            <cell type="label" labelfor="ln"/>
            <cell type="field" id="ln" name="lastName" uitype="text"/>
        </row>
        <row>
            <cell type="label" labelfor="inst"/>
            <cell type="field" id="inst" name="institution" 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>-->
    </rows>
</viewdef>