Specify schema

Title	Preparation Attribute
Description	Preparation Attribute

Name	Fields	Unique	Nullable
FK984BFDE55327F942	ModifiedByAgentID
FK984BFDE57699B003	CreatedByAgentID
PrepAttrsColMemIDX	CollectionMemberID
PRIMARY	PreparationAttributeID

Name	Field	Related table	Related field
FKB198269745F8D1A8	PreparationAttributeID	preparation	PreparationAttributeID

Name	Field	Related table	Related field
FK984BFDE55327F942	ModifiedByAgentID	agent	AgentID
FK984BFDE57699B003	CreatedByAgentID	agent	AgentID

View: PreparationAttribute (Discipline)

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

View def.: PreparationAttribute

<viewdef type="form"
      name="PreparationAttribute"
      class="edu.ku.brc.specify.datamodel.PreparationAttribute"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj"
      useresourcelabels="true">
    <desc><![CDATA[Preparation for Collection Object form.]]></desc>
    <enableRules/>
    <columnDef>140px,2px,85px,5px,70px,2px,100px,5px,100px,p:g</columnDef>
    <!--columnDef>100px,2px,160px,5px,100px,2px,160px,5px,p:g</columnDef-->
	<!--columnDef>100px,2px,160px,5px,95px,2px,223px,5px,65px,2px,156px,2px,p:g</columnDef-->
	<columnDef os="lnx">115px,2px,150px,5px,120px,2px,223px,5px,90px,2px,126px,2px,75px,p:g</columnDef>
    <columnDef os="mac">130px,2px,180px,5px,130px,2px,255px,5px,100px,2px,174px,2px,70px,p:g</columnDef>
    <columnDef os="exp">p,2px,max(p;150px),5px:g,p,2px,p,5px:g,p,2px,151px,10px,p,p:g</columnDef>
    <rowDef auto="true" cell="p" sep="2dlu"/>
    <rows>
       <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" uitype="textareabrief" name="remarks" colspan="7" rows="2"/>
				</row>
				<row>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" uitype="text" name="text1" colspan="5"/>
        </row>
       <row>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" uitype="text" name="text2" colspan="3"/>
        </row>
       <row>
            <cell type="label" labelfor="4"/>
            <cell type="field" id="4" uitype="text" name="text3" colspan="7"/>
        </row>
       <row>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" uitype="textareabrief" name="text4" colspan="7" rows="2"/>
        </row>
			</rows>
</viewdef>

View: PreparationAttributes (Common)

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

View def.: PreparationAttributes

<viewdef type="form"
      name="PreparationAttributes"
      class="edu.ku.brc.specify.datamodel.PreparationAttribute"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[Form For OtherIdentifier]]></desc>
 
    <columnDef>100px,2px,195px,5px,215px,2px,308px</columnDef>
    <columnDef os="lnx">105px,2px,210px,5px,220px,2px,363px</columnDef>
    <columnDef os="mac">115px,2px,230px,5px,240px,2px,423px</columnDef>
    <columnDef os="exp">p,2px,p:g(2),5px:g,p,2px,p:g(4)</columnDef>
    <rowDef auto="true" sep="2px" cell="p"/>
    <rows>
        <row>
            <cell type="label" labelfor="t1"/>
            <cell type="field" id="t1" name="text1" uitype="text"/>
            <cell type="label" labelfor="t2"/>
            <cell type="field" id="t2" name="text2" uitype="text"/>
        </row>    
        <!--<row>
            <cell type="label" labelfor="ad"/>
            <cell type="field" id="ad" name="attrDate" uitype="formattedtext" uifieldformatter="Date"/>
            <cell type="label" labelfor="t3"/>
            <cell type="field" id="t3" name="text3" uitype="text"/>
            <cell type="label" labelfor="t4"/>
            <cell type="field" id="t4" name="text4" uitype="combobox"/>
            <cell type="label" labelfor="t5"/>
            <cell type="field" id="t5" name="text5" uitype="text"/>
        </row>
        <row>
            <cell type="label" labelfor="t6"/>
            <cell type="field" id="t6" name="text6" uitype="text"/>
            <cell type="label" labelfor="t7"/>
            <cell type="field" id="t7" name="text7" uitype="text"/>
            <cell type="label" labelfor="t8"/>
            <cell type="field" id="t8" name="text8" uitype="text"/>
            <cell type="label" labelfor="t9"/>
            <cell type="field" id="t9" name="text9" uitype="text"/>
        </row>
        <row>
            <cell type="label" labelfor="t10"/>
            <cell type="field" id="t10" name="text10" uitype="text"/>
            <cell type="label" labelfor="t11"/>
            <cell type="field" id="t11" name="text11" uitype="text"/>
            <cell type="label" labelfor="t12"/>
            <cell type="field" id="t12" name="text12" uitype="text"/>
            <cell type="label" labelfor="t13"/>
            <cell type="field" id="t13" name="text13" uitype="text"/>
        </row>
        <row>
            <cell type="label" labelfor="t14"/>
            <cell type="field" id="t14" name="text14" uitype="text"/>
            <cell type="label" labelfor="t15"/>
            <cell type="field" id="t15" name="text15" uitype="text"/>
            <cell type="label" labelfor="t16"/>
            <cell type="field" id="t16" name="text16" uitype="text"/>
            <cell type="label" labelfor="t17"/>
            <cell type="field" id="t17" name="text17" uitype="text"/>
        </row>
        <row>
            <cell type="label" labelfor="t18"/>
            <cell type="field" id="t18" name="text18" uitype="text"/>
            <cell type="label" labelfor="t19"/>
            <cell type="field" id="t19" name="text19" uitype="text"/>
            <cell type="label" labelfor="t20"/>
            <cell type="field" id="t20" name="text20" uitype="text"/>
            <cell type="label" labelfor="t21"/>
            <cell type="field" id="t21" name="text21" uitype="text"/>
        </row>
        <row>
            <cell type="label" labelfor="t22"/>
            <cell type="field" id="t22" name="text22" uitype="text"/>
            <cell type="label" labelfor="t23"/>
            <cell type="field" id="t23" name="text23" uitype="text"/>
            <cell type="label" labelfor="t24"/>
            <cell type="field" id="t24" name="text24" uitype="text"/>
            <cell type="label" labelfor="t25"/>
            <cell type="field" id="t25" name="text25" uitype="text"/>
        </row>
        <row>
            <cell type="label" labelfor="t26"/>
            <cell type="field" id="t26" name="text26" uitype="combobox"/>
            <cell type="label" labelfor="n1"/>
            <cell type="field" id="n1" name="number1" uitype="text"/>
            <cell type="label" labelfor="n2"/>
            <cell type="field" id="n2" name="number2" uitype="text"/>
            <cell type="label" labelfor="n3"/>
            <cell type="field" id="n3" name="number3" uitype="text"/>
        </row>
        <row>
            <cell type="label" labelfor="n4"/>
            <cell type="field" id="n4" name="number4" uitype="text"/>
            <cell type="label" labelfor="n5"/>
            <cell type="field" id="n5" name="number5" uitype="text"/>
            <cell type="label" labelfor="n6"/>
            <cell type="field" id="n6" name="number6" uitype="text"/>
            <cell type="label" labelfor="n7"/>
            <cell type="field" id="n7" name="number7" uitype="text"/>
        </row>
        <row>
            <cell type="label" labelfor="n8"/>
            <cell type="field" id="n8" name="number8" uitype="text"/>
            <cell type="label" labelfor="n9"/>
            <cell type="field" id="n9" name="number9" uitype="text"/>
        </row>
        <row>
            <cell type="label" labelfor="10"/>
            <cell type="field" id="10" name="remarks" uitype="textareabrief" rows="2" colspan="9"/>
        </row>
        <row>
            <cell type="field" id="yn1" name="yesNo1" uitype="checkbox" initialize="editable=true"/>
            <cell type="field" id="yn2" name="yesNo2" uitype="checkbox" initialize="editable=true"/>
            <cell type="field" id="yn3" name="yesNo3" uitype="checkbox" initialize="editable=true"/>
            <cell type="field" id="yn4" name="yesNo4" uitype="checkbox" initialize="editable=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>

Name	Type	Index	Title	Description
PreparationAttributeID	int(11)	PRI
TimestampCreated	datetime		Timestamp Created	timestampCreated
TimestampModified	datetime		Timestamp Modified	timestampModified
Version	int(11)		Version	version
CollectionMemberID	int(11)	MUL	Collection Member Id	collectionMemberId
attrdate	date		Attr Date	attrDate
Number1	float(20,10)		Number1	number1
Number2	float(20,10)		Number2	number2
Number3	float(20,10)		Number3	number3
Number4	int(11)		Number4	number4
Number5	int(11)		Number5	number5
Number6	int(11)		Number6	number6
Number7	int(11)		Number7	number7
Number8	int(11)		Number8	number8
Number9	smallint(6)		Number9	number9
Remarks	text		Remarks	remarks
Text1	text		text1
Text10	text		Text10	text10
Text11	varchar(50)		text11
Text12	varchar(50)		text12
Text13	varchar(50)		text13
Text14	varchar(50)		text14
Text15	varchar(50)		Text15	text15
Text16	varchar(50)		Text16	text16
Text17	varchar(50)		Text17	text17
Text18	varchar(50)		Text18	text18
Text19	varchar(50)		Text19	text19
Text2	text		text2
Text20	varchar(50)		Text20	text20
Text21	varchar(50)		Text21	text21
Text22	varchar(50)		Text22	text22
Text23	varchar(50)		Text23	text23
Text24	varchar(50)		Text24	text24
Text25	varchar(50)		Text25	text25
Text26	varchar(50)		Text26	text26
Text3	varchar(50)		Text3	text3
Text4	varchar(50)		Text4	text4
Text5	varchar(50)		Text5	text5
Text6	varchar(50)		Text6	text6
Text7	varchar(50)		Text7	text7
Text8	varchar(50)		Text8	text8
Text9	varchar(50)		Text9	text9
YesNo1	bit(1)		Yes No1	yesNo1
YesNo2	bit(1)		Yes No2	yesNo2
YesNo3	bit(1)		Yes No3	yesNo3
YesNo4	bit(1)		Yes No4	yesNo4
ModifiedByAgentID	int(11)	MUL
CreatedByAgentID	int(11)	MUL

MEL Specify schema browser

preparationattribute

Table info.

Fields

Indexes

One-to-many relationships

Many-to-one relationships

View: PreparationAttribute (Discipline)

View def.: PreparationAttribute

View: PreparationAttributes (Common)

View def.: PreparationAttributes