appraisal

Table info.

Title Appraisal
Description Appraisal

Fields

Name Type Required Index Hidden On form Title Pick list Description
AppraisalID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
AppraisalDate date MUL Appraisal Date Date of the appraisal.
AppraisalNumber varchar(64) UNI Appraisal Number Unique number for the appraisal.
AppraisalValue decimal(12,2) Appraisal Value Monetary value of the appraisal.
MonetaryUnitType varchar(8) Monetary Unit Type Type of monetary unit.
Notes text Notes Additional comments.
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
AgentID int(11) MUL
AccessionID int(11) MUL

Indexes

Name Fields Unique Nullable
AppraisalDateIDX AppraisalDate
AppraisalNumber AppraisalNumber
AppraisalNumberIDX AppraisalNumber
FK8D3C72E5384B3622 AgentID
FK8D3C72E53925EE20 AccessionID
FK8D3C72E55327F942 ModifiedByAgentID
FK8D3C72E57699B003 CreatedByAgentID
PRIMARY AppraisalID

One-to-many relationships

Name Field Related table Related field
FKC1D4635DB15CB762 AppraisalID collectionobject AppraisalID

Many-to-one relationships

Name Field Related table Related field
FK8D3C72E5384B3622 AgentID agent AgentID
FK8D3C72E53925EE20 AccessionID accession AccessionID
FK8D3C72E55327F942 ModifiedByAgentID agent AgentID
FK8D3C72E57699B003 CreatedByAgentID agent AgentID

View: Appraisal (Common)

<view name="Appraisal"
      class="edu.ku.brc.specify.datamodel.Appraisal"
      busrules="edu.ku.brc.specify.datamodel.busrules.AppraisalBusRules"
      isinternal="false">
    <desc><![CDATA[The appraisal subform.]]></desc>
    <altviews>
        <altview name="Appraisal View" viewdef="Appraisal" mode="view" default="true"/>
        <altview name="Appraisal Edit" viewdef="Appraisal" mode="edit"/>
    </altviews>
</view>

View def.: Appraisal

<viewdef type="form"
      name="Appraisal"
      class="edu.ku.brc.specify.datamodel.Appraisal"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[Form For Appraisal]]></desc>
 
    <columnDef>100px,2px,130px,5px,151px,2px,130px,5px,90px,2px,210px,0px,15px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,150px,5px,155px,2px,170px,5px,95px,2px,216px,0px,15px,p:g</columnDef>
    <columnDef os="mac">130px,2px,165px,5px,175px,2px,190px,5px,111px,2px,245px,0px,15px,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g(2),5px:g,p,2px,p:g(2),5px:g,p,2px,p:g,0px,p,p:g</columnDef>
    <rowDef auto="true" sep="2px" cell="p"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="appraisalDate" uitype="formattedtext" uifieldformatter="Date" default="today"/>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="appraisalNumber" uitype="text"/>
            <cell type="label" labelfor="7"/>
            <cell type="field" id="7" name="agent" uitype="querycbx" initialize="name=Agent"/>
        </row>
        <row>
            <cell type="label" labelfor="8"/>
            <cell type="field" id="8" name="appraisalValue" uitype="text"/>
            <cell type="label" labelfor="4"/>
            <cell type="field" id="4" name="monetaryUnitType" uitype="text"/>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="accession" uitype="querycbx" initialize="name=AccessionCO;title=AccessionCO" isrequired="false"/>
        </row>
        <row>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="notes" uitype="textareabrief" rows="2" colspan="10"/>
        </row>
        <row> 
            <cell type="subview" viewname="CollectionObjectSub" id="25" desc="Collection Object" name="collectionObjects" colspan="13" initialize="addsearch=true"/>
        </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>