exchangeinprep

Table info.

Title Exchange In Prep
Description Exchange In Prep

Fields

Name Type Required Index Hidden On form Title Pick list Description
ExchangeInPrepID 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
ExchangeInID int(11) MUL
CreatedByAgentID int(11) MUL
PreparationID int(11) MUL
ModifiedByAgentID int(11) MUL
DisciplineID int(11) MUL

Indexes

Name Fields Unique Nullable
FK9A0BCB518627F06 PreparationID
FK9A0BCB51E18122E ExchangeInID
FK9A0BCB54CE675DE DisciplineID
FK9A0BCB55327F942 ModifiedByAgentID
FK9A0BCB57699B003 CreatedByAgentID
PRIMARY ExchangeInPrepID

Many-to-one relationships

Name Field Related table Related field
FK9A0BCB518627F06 PreparationID preparation PreparationID
FK9A0BCB51E18122E ExchangeInID exchangein ExchangeInID
FK9A0BCB54CE675DE DisciplineID discipline UserGroupScopeId
FK9A0BCB55327F942 ModifiedByAgentID agent AgentID
FK9A0BCB57699B003 CreatedByAgentID agent AgentID

View: ExchangeInPrep (Common)

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

View def.: ExchangeInPrep Table

<viewdef type="formtable"
      name="ExchangeInPrep Table"
      class="edu.ku.brc.specify.datamodel.ExchangeInPrep"
      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>ExchangeInPrep</definition>
</viewdef>