exchangeoutprep

Table info.

Title Exchange Out Prep
Description Exchange Out Prep

Fields

Name Type Required Index Hidden On form Title Pick list Description
ExchangeOutPrepID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Comments text Comments comments
DescriptionOfMaterial varchar(255) Description Of Material descriptionOfMaterial
Number1 int(11) Number1 number1
Quantity int(11) Quantity quantity
Text1 text Text1 text1
Text2 text Text2 text2
ExchangeOutID int(11) MUL
PreparationID int(11) MUL
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
DisciplineID int(11) MUL

Indexes

Name Fields Unique Nullable
FK7405CEF818627F06 PreparationID
FK7405CEF84CE675DE DisciplineID
FK7405CEF85327F942 ModifiedByAgentID
FK7405CEF87699B003 CreatedByAgentID
FK7405CEF8A542314E ExchangeOutID
PRIMARY ExchangeOutPrepID

Many-to-one relationships

Name Field Related table Related field
FK7405CEF818627F06 PreparationID preparation PreparationID
FK7405CEF84CE675DE DisciplineID discipline UserGroupScopeId
FK7405CEF85327F942 ModifiedByAgentID agent AgentID
FK7405CEF87699B003 CreatedByAgentID agent AgentID
FK7405CEF8A542314E ExchangeOutID exchangeout ExchangeOutID

View: ExchangeOutPrep (Common)

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

View def.: ExchangeOutPrep Table

<viewdef type="formtable"
      name="ExchangeOutPrep Table"
      class="edu.ku.brc.specify.datamodel.ExchangeOutPrep"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[Preparation subform table for Collection Object form.]]></desc>
    <definition>ExchangeOutPrep</definition>
</viewdef>