fieldnotebook

Table info.

Title Field Notebook
Description Field Notebook

Fields

Name Type Required Index Hidden On form Title Pick list Description
FieldNotebookID int(11) PRI
TimestampCreated datetime Timestamp Created timestampCreated
TimestampModified datetime Timestamp Modified timestampModified
Version int(11) Version version
Description text Description description
EndDate date MUL End Date endDate
Storage varchar(64)
Name varchar(32) MUL Name name
StartDate date MUL Start Date startDate
CollectionID int(11) MUL
AgentID int(11) MUL
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
DisciplineID int(11) MUL

Indexes

Name Fields Unique Nullable
FK4647A8D5384B3622 AgentID
FK4647A8D54CE675DE DisciplineID
FK4647A8D55327F942 ModifiedByAgentID
FK4647A8D57699B003 CreatedByAgentID
FK4647A8D58C2288BA CollectionID
FNBEndDateIDX EndDate
FNBNameIDX Name
FNBStartDateIDX StartDate
PRIMARY FieldNotebookID

One-to-many relationships

Name Field Related table Related field
FKDC15BBB8B522A4E2 FieldNotebookID fieldnotebookattachment FieldNotebookID
FK6FC0C8FEB522A4E2 FieldNotebookID fieldnotebookpageset FieldNotebookID

Many-to-one relationships

Name Field Related table Related field
FK4647A8D5384B3622 AgentID agent AgentID
FK4647A8D54CE675DE DisciplineID discipline UserGroupScopeId
FK4647A8D55327F942 ModifiedByAgentID agent AgentID
FK4647A8D57699B003 CreatedByAgentID agent AgentID
FK4647A8D58C2288BA CollectionID collection UserGroupScopeId

View: FieldNotebook (Common)

<view name="FieldNotebook"
      class="edu.ku.brc.specify.datamodel.FieldNotebook"
      busrules="edu.ku.brc.specify.datamodel.busrules.FieldNotebookBusRules"
      isinternal="false">
    <desc><![CDATA[Field Notebook Form.]]></desc>
    <altviews>
        <altview name="FieldNotebook Edit" viewdef="FieldNotebook" mode="edit"/>
        <altview name="FieldNotebook View" viewdef="FieldNotebook" mode="view" default="true"/>
    </altviews>
</view>

View def.: FieldNotebook

<viewdef type="form"
      name="FieldNotebook"
      class="edu.ku.brc.specify.datamodel.FieldNotebook"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[Form For FieldNotebook]]></desc>
 
    <columnDef>100px,2px,131px,5px,63px,2px,100px,5px,65px,2px,100px,5px,50px,2px,195px,0px,15px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,144px,5px,85px,2px,95px,5px,80px,2px,95px,5px,70px,2px,210px,0px,15px,p:g</columnDef>
    <columnDef os="mac">130px,2px,154px,5px,95px,2px,115px,5px,95px,2px,115px,5px,90px,2px,215px,0px,15px,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g(4),5px:g,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="4"/>
            <cell type="field" id="4" name="name" uitype="text"/>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="startDate" uitype="formattedtext" uifieldformatter="Date"/>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="endDate" uitype="formattedtext" uifieldformatter="Date"/>           
            <cell type="label" labelfor="8"/>
            <cell type="field" id="8" name="ownerAgent" uitype="querycbx" initialize="name=Agent"/>
        </row>
        <row>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="location" uitype="text" colspan="14"/>
        </row>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="description" uitype="textareabrief" rows="2" colspan="14"/>
        </row>
        <row>
            <cell type="subview" id="11" name="pageSets" viewname="FieldNotebookPageSet" colspan="17"/>
        </row>
        <row>
            <cell type="separator" label="Attachments" colspan="17"/>
        </row>
        <row>
            <cell type="subview" id="6" name="attachments" viewname="ObjectAttachment" initialize="btn=true;icon=FieldNotebookAttachment;addsearch=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>