fieldnotebookpage

Table info.

Title Field Notebook Page
Description Field Notebook Page

Fields

Name Type Required Index Hidden On form Title Pick list Description
FieldNotebookPageID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Description varchar(128) Description description
PageNumber varchar(32) MUL Page Number pageNumber
ScanDate date MUL Scan Date scanDate
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
DisciplineID int(11) MUL
FieldNotebookPageSetID int(11) MUL

Indexes

Name Fields Unique Nullable
FK162198E44CE675DE DisciplineID
FK162198E45327F942 ModifiedByAgentID
FK162198E47699B003 CreatedByAgentID
FK162198E49B34BD5A FieldNotebookPageSetID
FNBPPageNumberIDX PageNumber
FNBPScanDateIDX ScanDate
PRIMARY FieldNotebookPageID

One-to-many relationships

Name Field Related table Related field
FKC1D4635D73BF3AE0 FieldNotebookPageID collectionobject FieldNotebookPageID
FK91AA250773BF3AE0 FieldNotebookPageID fieldnotebookpageattachment FieldNotebookPageID

Many-to-one relationships

Name Field Related table Related field
FK162198E44CE675DE DisciplineID discipline UserGroupScopeId
FK162198E45327F942 ModifiedByAgentID agent AgentID
FK162198E47699B003 CreatedByAgentID agent AgentID
FK162198E49B34BD5A FieldNotebookPageSetID fieldnotebookpageset FieldNotebookPageSetID

View: FieldNotebookPage (Common)

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

View def.: FieldNotebookPage

<viewdef type="form"
      name="FieldNotebookPage"
      class="edu.ku.brc.specify.datamodel.FieldNotebookPage"
      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,p:g</columnDef>
    <columnDef os="lnx">115px,2px,125px,5px,105px,2px,100px,5px,458px,0px,p:g</columnDef>
    <columnDef os="mac">130px,2px,154px,5px,95px,2px,115px,5px,520px,0px,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</columnDef>
    <rowDef auto="true" sep="2px" cell="p"/>
    <rows>
 
        <row>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="pageNumber" uitype="text"/>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="scanDate" uitype="formattedtext" uifieldformatter="Date"/>
            <cell type="subview" id="6" name="attachments" viewname="ObjectAttachment" initialize="align=right;btn=true;icon=FieldNotebookPageAttachment;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="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>