treatmentevent

Table info.

Title Treatment Event
Description Treatment Event

Fields

Name Type Required Index Hidden On form Title Pick list Description
TreatmentEventID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
DateBoxed date Date Boxed dateBoxed
DateCleaned date Date Cleaned dateCleaned
DateCompleted date Date Completed dateCompleted
DateReceived date MUL Date Received dateReceived
DateToIsolation date Date To Isolation dateToIsolation
DateTreatmentEnded date End Date dateTreatmentEnded
DateTreatmentStarted date MUL Start Date dateTreatmentStarted
FieldNumber varchar(50) MUL Field Number fieldNumber
Storage varchar(64)
Remarks text Remarks remarks
TreatmentNumber varchar(32) MUL Treat Number treatmentNumber
Type varchar(128) Type TreatmentType
  • Bug Room
  • CO2
 type
DivisionID int(11) MUL
AccessionID int(11) MUL
CollectionObjectID int(11) MUL
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
Number1 int(11) Number1 number1
Number2 int(11) Number2 number2
Number3 float Number3 number3
Number4 float Number4 number4
Number5 float Number5 number5
Text1 text Text1 text1
Text2 text Text2 text2
Text3 text Text3 text3
Text4 text Text4 text4
Text5 text Text5 text5
YesNo1 bit(1) Yes No1 yesNo1
YesNo2 bit(1) Yes No2 yesNo2
YesNo3 bit(1) Yes No3 yesNo3
AuthorizedByID int(11) MUL
PerformedByID int(11) MUL

Indexes

Name Fields Unique Nullable
FK577D85223925EE20 AccessionID
FK577D8522410EB2B4 PerformedByID
FK577D85225327F942 ModifiedByAgentID
FK577D852275E37458 CollectionObjectID
FK577D85227699B003 CreatedByAgentID
FK577D85227D49A30F AuthorizedByID
FK577D852297C961D8 DivisionID
PRIMARY TreatmentEventID
TEDateReceivedIDX DateReceived
TEDateTreatmentStartedIDX DateTreatmentStarted
TEFieldNumberIDX FieldNumber
TETreatmentNumberIDX TreatmentNumber

One-to-many relationships

Name Field Related table Related field
FK1725BC52BE40B22 TreatmentEventID treatmenteventattachment TreatmentEventID

Many-to-one relationships

Name Field Related table Related field
FK577D85223925EE20 AccessionID accession AccessionID
FK577D8522410EB2B4 PerformedByID agent AgentID
FK577D85225327F942 ModifiedByAgentID agent AgentID
FK577D852275E37458 CollectionObjectID collectionobject CollectionObjectID
FK577D85227699B003 CreatedByAgentID agent AgentID
FK577D85227D49A30F AuthorizedByID agent AgentID
FK577D852297C961D8 DivisionID division UserGroupScopeId

View: TreatmentEvent (Common)

<view name="TreatmentEvent"
      class="edu.ku.brc.specify.datamodel.TreatmentEvent"
      isinternal="false">
    <desc><![CDATA[Treatment Event form.]]></desc>
    <altviews>
        <altview name="TreatmentEvent View" viewdef="TreatmentEvent" mode="view" default="true"/>
        <altview name="TreatmentEvent Edit" viewdef="TreatmentEvent" mode="edit"/>
    </altviews>
</view>

View def.: TreatmentEvent

<viewdef type="form"
      name="TreatmentEvent"
      class="edu.ku.brc.specify.datamodel.TreatmentEvent"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[Form For Treatment Event]]></desc>
 
    <columnDef>100px,2px,138px,5px,115px,2px,143px,5px,110px,2px,205px,0px,15px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,155px,5px,135px,2px,155px,5px,136px,2px,205px,0px,15px,p:g</columnDef>
    <columnDef os="mac">130px,2px,170px,5px,155px,2px,170px,5px,150px,2px,239px,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="11"/>
            <cell type="field" id="11" name="treatmentNumber" uitype="text"/>
            <cell type="label" labelfor="12"/>
            <cell type="field" id="12" name="type" uitype="combobox" picklist="TreatmentType"/>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="collectionObject" uitype="querycbx" initialize="name=CollectionObject;editbtn=false;newbtn=false"/>
        </row>
        <row> 
            <cell type="label" labelfor="7"/>
            <cell type="field" id="7" name="dateTreatmentStarted" uitype="formattedtext" uifieldformatter="Date"/> 
            <cell type="label" labelfor="6"/>
            <cell type="field" id="6" name="dateTreatmentEnded" uitype="formattedtext" uifieldformatter="Date"/>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="accession" uitype="querycbx" initialize="name=AccessionCO;title=AccessionCO" isrequired="false"/>
        </row>
        <row>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="dateToIsolation" uitype="formattedtext" uifieldformatter="Date"/> 
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="dateCompleted" uitype="formattedtext" uifieldformatter="Date"/> 
            <cell type="label" labelfor="4"/>
            <cell type="field" id="4" name="location" uitype="text"/>
        </row>           
        <row>
            <cell type="label" labelfor="10"/>
            <cell type="field" id="10" name="remarks" uitype="textareabrief" rows="2" colspan="10"/>
        </row>          
        <!--<row>
            <cell type="label" labelfor="db"/>
            <cell type="field" id="db" name="dateBoxed" uitype="formattedtext" uifieldformatter="Date"/> 
            <cell type="label" labelfor="dc"/>
            <cell type="field" id="dc" name="dateCleaned" uitype="formattedtext" uifieldformatter="Date"/> 
            <cell type="label" labelfor="dr"/>
            <cell type="field" id="dr" name="dateReceived" uitype="formattedtext" uifieldformatter="Date"/> 
        </row>
        <row>
            <cell type="label" labelfor="fn"/>
            <cell type="field" id="fn" name="fieldNumber" 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>