collectionobjectcitation

Table info.

Title Collection Object Citation
Description Collection Object Citation

Fields

Name Type Required Index Hidden On form Title Pick list Description
CollectionObjectCitationID int(11) PRI
TimestampCreated datetime Timestamp Created The timestamp the record was created.
TimestampModified datetime Timestamp Modified The timestamp the record was last modified.
Version int(11) Version version
CollectionMemberID int(11) MUL Collection Member Id collectionMemberId
IsFigured bit(1) Is Figured isFigured
Remarks text Remarks Additional Comments.
ModifiedByAgentID int(11) MUL
CreatedByAgentID int(11) MUL
CollectionObjectID int(11) MUL
ReferenceWorkID int(11) MUL
FigureNumber varchar(50) Figure Number figureNumber
PageNumber varchar(50) Page Number pageNumber
PlateNumber varchar(50) Plate Number plateNumber

Indexes

Name Fields Unique Nullable
COCITColMemIDX CollectionMemberID
FKAB9FC1445327F942 ModifiedByAgentID
FKAB9FC14469734F30 ReferenceWorkID
FKAB9FC14475E37458 CollectionObjectID
FKAB9FC1447699B003 CreatedByAgentID
PRIMARY CollectionObjectCitationID

Many-to-one relationships

Name Field Related table Related field
FKAB9FC1445327F942 ModifiedByAgentID agent AgentID
FKAB9FC14469734F30 ReferenceWorkID referencework ReferenceWorkID
FKAB9FC14475E37458 CollectionObjectID collectionobject CollectionObjectID
FKAB9FC1447699B003 CreatedByAgentID agent AgentID

View: CollectionObjectCitation (Common)

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

View def.: CollectionObjectCitation

<viewdef type="form"
      name="CollectionObjectCitation"
      class="edu.ku.brc.specify.datamodel.CollectionObjectCitation"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[Form For CollectionObjectCitation]]></desc>
 
    <columnDef>100px,2px,610px,25px,90px,0px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,685px,25px,95px,0px,p:g</columnDef>
    <columnDef os="mac">130px,2px,705px,25px,95px,0px,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g(4),p:g,p,0px</columnDef>
    <rowDef auto="true" sep="2px" cell="p"/>
 
    <rows>
      <row>
            <cell type="label" labelfor="6"/>
            <cell type="field" id="6" name="referenceWork" uitype="querycbx" initialize="name=ReferenceWork;title=ReferenceWork"/>
            <cell type="field" id="1" name="isFigured" uitype="checkbox"/>
        </row>
        <row>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="remarks" uitype="textareabrief" rows="2" colspan="4"/>
        </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>