project

Table info.

Title Project
Description Project

Fields

Name Type Required Index Hidden On form Title Pick list Description
ProjectID int(11) PRI
TimestampCreated datetime Created The timestamp the record was created.
TimestampModified datetime Last edited The timestamp the record was last modified.
Version int(11) Version version
CollectionMemberID int(11) Collection Member Id collectionMemberId
EndDate date End date The date the project finished
GrantAgency varchar(64) Grant Agency grantAgency
GrantNumber varchar(64) Grant Number grantNumber
Number1 float(20,10) Number1 User definable
Number2 float(20,10) Number2 User definable
ProjectDescription varchar(255) Description Description of the project
ProjectName varchar(128) MUL Project name Name of the project which the specimen has been used for
ProjectNumber varchar(64) MUL Number projectNumber
Remarks text Comments Any results from, or other comments about, the project
StartDate date Start date The date the project began
Text1 text Text1 User definable
Text2 text Text2 User definable
URL text Web link A link to a website about the project
YesNo1 bit(1) Yes No1 User definable
YesNo2 bit(1) Yes No2 User definable
ModifiedByAgentID int(11) MUL
ProjectAgentID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FKED904B195327F942 ModifiedByAgentID
FKED904B195DDECE9 ProjectAgentID
FKED904B197699B003 CreatedByAgentID
PRIMARY ProjectID
ProjectNameIDX ProjectName
ProjectNumberIDX ProjectNumber

One-to-many relationships

Name Field Related table Related field
FK1E416F5DAF28760A ProjectID project_colobj ProjectID

Many-to-one relationships

Name Field Related table Related field
FKED904B195327F942 ModifiedByAgentID agent AgentID
FKED904B195DDECE9 ProjectAgentID agent AgentID
FKED904B197699B003 CreatedByAgentID agent AgentID

View: Project (Common)

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

View def.: Project

<viewdef type="form"
      name="Project"
      class="edu.ku.brc.specify.datamodel.Project"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[Form For Project]]></desc>
 
    <columnDef>100px,2px,195px,5px,93px,2px,90px,5px,65px,2px,86px,5px,85px,2px,90px,0px,15px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,195px,5px,115px,2px,80px,5px,84px,2px,100px,5px,105px,2px,100px,0px,15px,p:g</columnDef>
    <columnDef os="mac">130px,2px,215px,5px,125px,2px,115px,5px,90px,2px,109px,5px,115px,2px,110px,0px,15px,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g,5px:g,p,2px,p:g(2),5px:g,p,2px,p:g(2),5px:g,p,2px,p:g(2),0px,p,p:g</columnDef>
    <rowDef auto="true" sep="2px" cell="p"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="projectName" uitype="text"/>
            <cell type="label" labelfor="6"/>
            <cell type="field" id="6" name="projectNumber" uitype="text"/>
            <cell type="label" labelfor="8"/>
            <cell type="field" id="8" name="startDate" uitype="formattedtext" uifieldformatter="Date"/>                   
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="endDate" uitype="formattedtext" uifieldformatter="Date"/>
        </row>   
        <row>
            <cell type="label" labelfor="10"/>
            <cell type="field" id="10" name="agent" uitype="querycbx" initialize="name=Agent"/>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="grantAgency" uitype="text" colspan="5"/>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="grantNumber" uitype="text"/>
        </row>
        <row>
            <cell type="label" labelfor="4"/>
            <cell type="field" id="4" name="projectDescription" uitype="textareabrief" rows="2" colspan="14"/>
        </row>
        <row>
            <cell type="label" labelfor="7"/>
            <cell type="field" id="7" name="remarks" uitype="textareabrief" rows="2" colspan="14"/>
        </row>
        <row>
            <cell type="subview" viewname="CollectionObjectSub" id="11" colspan="17" name="collectionObjects" initialize="addsearch=true"/>
        </row>
    </rows>
        <!--<row>
            <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"/>
        </row>
        <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"/>
            <cell type="label" labelfor="url"/>
            <cell type="field" id="url" name="url" uitype="text"/>
        </row>
        <row>
            <cell type="field" id="20" name="yesNo1" uitype="checkbox" initialize="editable=true"/>
            <cell type="field" id="20" name="yesNo2" 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>-->
</viewdef>
 

View: ProjectSub (Common)

<view name="ProjectSub"
      class="edu.ku.brc.specify.datamodel.Project">
    <desc><![CDATA[Project form.]]></desc>
    <altviews>
        <altview name="ProjectSub Table View" viewdef="ProjectSub Table" mode="view" default="true"/>
    </altviews>
</view>

View def.: ProjectSub Table

<viewdef type="formtable"
      name="ProjectSub Table"
      class="edu.ku.brc.specify.datamodel.Project"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[Project Subform for Collection Object.]]></desc>
    <definition>ProjectSub</definition>
</viewdef>