fieldnotebookpageset

Table info.

Title Field Notebook Page Set
Description Field Notebook Page Set

Fields

Name Type Required Index Hidden On form Title Pick list Description
FieldNotebookPageSetID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Description varchar(128) Description description
EndDate date MUL End Date endDate
Method varchar(64) Method method
OrderNumber smallint(6) Order Number orderNumber
StartDate date MUL Start Date startDate
FieldNotebookID int(11) MUL
DisciplineID int(11) MUL
AgentID int(11) MUL
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK6FC0C8FE384B3622 AgentID
FK6FC0C8FE4CE675DE DisciplineID
FK6FC0C8FE5327F942 ModifiedByAgentID
FK6FC0C8FE7699B003 CreatedByAgentID
FK6FC0C8FEB522A4E2 FieldNotebookID
FNBPSEndDateIDX EndDate
FNBPSStartDateIDX StartDate
PRIMARY FieldNotebookPageSetID

One-to-many relationships

Name Field Related table Related field
FK162198E49B34BD5A FieldNotebookPageSetID fieldnotebookpage FieldNotebookPageSetID
FKB1477CA19B34BD5A FieldNotebookPageSetID fieldnotebookpagesetattachment FieldNotebookPageSetID

Many-to-one relationships

Name Field Related table Related field
FK6FC0C8FE384B3622 AgentID agent AgentID
FK6FC0C8FE4CE675DE DisciplineID discipline UserGroupScopeId
FK6FC0C8FE5327F942 ModifiedByAgentID agent AgentID
FK6FC0C8FE7699B003 CreatedByAgentID agent AgentID
FK6FC0C8FEB522A4E2 FieldNotebookID fieldnotebook FieldNotebookID

View: FieldNotebookPageSet (Common)

<view name="FieldNotebookPageSet"
      class="edu.ku.brc.specify.datamodel.FieldNotebookPageSet"
      resourcelables="false">
    <desc><![CDATA[Field Notebook Page.]]></desc>
    <altviews>
        <altview name="FieldNotebookPageSet Edit" viewdef="FieldNotebookPageSet" mode="edit"/>
        <altview name="FieldNotebookPageSet View" viewdef="FieldNotebookPageSet" mode="view" default="true"/>
    </altviews>
</view>

View def.: FieldNotebookPageSet

<viewdef type="form"
      name="FieldNotebookPageSet"
      class="edu.ku.brc.specify.datamodel.FieldNotebookPageSet"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[Form For FieldNotebookPage]]></desc>
 
    <columnDef>100px,2px,131px,5px,63px,2px,103px,5px,416px,0px,10px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,125px,5px,105px,2px,100px,5px,458px,0px,10px,p:g</columnDef>
    <columnDef os="mac">130px,2px,154px,5px,95px,2px,115px,5px,524px,0px,10px,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g(2),5px:g,p,2px,p:g(2),p:g(2),p:g(2),0px,10px</columnDef>
    <rowDef auto="true" sep="2px" cell="p"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="startDate" uitype="formattedtext" uifieldformatter="Date"/>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="endDate" uitype="formattedtext" uifieldformatter="Date" initialize="align=right"/>
            <cell type="subview" id="4" name="attachments" viewname="ObjectAttachment" initialize="align=right;btn=true;icon=FieldNotebookPageSetAttachment;addsearch=true"/>
        </row>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="description" uitype="textareabrief" rows="2" colspan="8"/>
        </row>
        <row>
            <cell type="subview" id="6" name="pages" viewname="FieldNotebookPage" defaulttype="table" colspan="11"/>
        </row>
        <row>
            <cell type="separator" label="" colspan="11"/>
        </row>
        <!--<row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="orderNumber" uitype="spinner" initialize="max=2000"/>
        </row>
        <row>
            <cell type="label" labelfor="meth"/>
            <cell type="field" id="meth" name="method" uitype="text"/>
        </row>
        <row>
            <cell type="label" labelfor="sa"/>
            <cell type="field" id="sa" name="sourceAgent" uitype="querycbx" initialize="name=Agent"/>
        </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>