referencework

Table info.

Title Reference Work
Description Reference Work

Fields

Name Type Required Index Hidden On form Title Pick list Description
ReferenceWorkID 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
GUID varchar(128) MUL GUID guid
IsPublished bit(1) Is Published isPublished
ISBN varchar(16) MUL ISBN isbn
LibraryNumber varchar(50) Library Number libraryNumber
Number1 float(20,10) Number1 User definable
Number2 float(20,10) Number2 User definable
Pages varchar(50) Pages Number of pages or Page range for Journal articles
PlaceOfPublication varchar(50) Place Of Publication placeOfPublication
Publisher varchar(250) MUL Publisher publisher
ReferenceWorkType tinyint(4) Type ReferenceWorkType
  • Technical Report
  • Thesis
  • Paper
  • Section in Book
  • Electronic Media
  • Book
  • Exsiccata Series
Type of Reference (Book(0), Electronic Media(1), Paper(2), Technical Report(3), Thesis(4), Section in book(5))
Remarks text Remarks Additional Comments
Text1 text Text1 User definable
Text2 text Text2 User definable
Title varchar(255) MUL Title Title of reference
URL text Url url
Volume varchar(25) Volume Volume/Issue for Journal articles
WorkDate varchar(25) Work Date workDate
YesNo1 bit(1) Yes No1 User definable
YesNo2 bit(1) Yes No2 User definable
ModifiedByAgentID int(11) MUL
JournalID int(11) MUL
InstitutionID int(11) MUL
CreatedByAgentID int(11) MUL
ContainedRFParentID int(11) MUL
Doi text Doi doi
Uri text Uri uri

Indexes

Name Fields Unique Nullable
FK5F7C68DC1B806665 ContainedRFParentID
FK5F7C68DC5327F942 ModifiedByAgentID
FK5F7C68DC748AEC6 JournalID
FK5F7C68DC7699B003 CreatedByAgentID
FK5F7C68DC81223908 InstitutionID
ISBNIDX ISBN
PRIMARY ReferenceWorkID
RefWrkGuidIDX GUID
RefWrkPublisherIDX Publisher
RefWrkTitleIDX Title

One-to-many relationships

Name Field Related table Related field
FK9ED8DF0B69734F30 ReferenceWorkID accessioncitation ReferenceWorkID
FKAC2D218B69734F30 ReferenceWorkID author ReferenceWorkID
FKAB9FC14469734F30 ReferenceWorkID collectionobjectcitation ReferenceWorkID
FK829B50E169734F30 ReferenceWorkID commonnametxcitation ReferenceWorkID
FK259B07CA69734F30 ReferenceWorkID determinationcitation ReferenceWorkID
FK24CEBD69734F30 ReferenceWorkID dnasequencingruncitation ReferenceWorkID
FKACC7DD8569734F30 ReferenceWorkID exsiccata ReferenceWorkID
FK9877F54A69734F30 ReferenceWorkID localitycitation ReferenceWorkID
FK5F7C68DC1B806665 ReferenceWorkID referencework ContainedRFParentID
FK14242FB169734F30 ReferenceWorkID taxoncitation ReferenceWorkID

Many-to-one relationships

Name Field Related table Related field
FK5F7C68DC1B806665 ContainedRFParentID referencework ReferenceWorkID
FK5F7C68DC5327F942 ModifiedByAgentID agent AgentID
FK5F7C68DC748AEC6 JournalID journal JournalID
FK5F7C68DC7699B003 CreatedByAgentID agent AgentID
FK5F7C68DC81223908 InstitutionID institution UserGroupScopeId

View: ReferenceWork (Discipline)

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

View def.: ReferenceWork

<viewdef type="form"
      name="ReferenceWork"
      class="edu.ku.brc.specify.datamodel.ReferenceWork"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[The ReferenceWork form]]></desc>
 
    <columnDef>100px,2px,170px,5px,90px,2px,150px,5px,140px,2px,161px,15px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,176px,5px,100px,2px,175px,5px,160px,2px,175px,15px,p:g</columnDef>
    <columnDef os="mac">130px,2px,208px,5px,100px,2px,208px,5px,175px,2px,195px,15px,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g(2),5px:g,p,2px,p:g(2),5px:g,p,2px,p:g(2),p,p:g</columnDef>
    <rowDef auto="true" cell="p" sep="2dlu"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="8"/>
            <cell type="field" id="8" name="referenceWorkType" uitype="combobox"/>
        </row>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="title" uitype="text" colspan="9"/>
        </row>
        <row>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="publisher" uitype="text" colspan="5"/>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="placeOfPublication" uitype="text"/>
        </row>
        <row>
            <cell type="label" labelfor="4"/>
            <cell type="field" id="4" name="workDate" uitype="text"/>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="volume" uitype="text"/>
            <cell type="label" labelfor="6"/>
            <cell type="field" id="6" name="pages" uitype="text"/>
        </row>
        <row>
            <cell type="label" labelfor="18"/>
            <cell type="field" id="18" name="journal" uitype="querycbx" initialize="name=Journal;title=Journal" colspan="5"/>
            <cell type="label" labelfor="7"/>
            <cell type="field" id="7" name="libraryNumber" uitype="text"/>
        </row>
        <row>
            <cell type="subview" viewname="Authors" id="10" name="authors" initialize="name=Agent" colspan="12" rows="3"/>
        </row>
        <row>
            <cell type="subview" id="attachments" viewname="ObjectAttachment" name="referenceWorkAttachments" colspan="6" initialize="btn=true;icon=ReferenceWorkAttachment"/>
        </row>
        <!--<row>
            <cell type="label" labelfor="guid"/>
            <cell type="field" id="guid" name="guid" uitype="text" colspan="5" readonly="true"/>
        </row>
        <row>
            <cell type="label" labelfor="isbn"/>
            <cell type="field" id="isbn" name="isbn" uitype="text"/>
            <cell type="field" id="ic" name="isPublished" uitype="checkbox"/>
            <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="rem"/>
            <cell type="field" id="rem" name="remarks" uitype="textareabrief" rows="2" colspan="14"/>
        </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>-->
    </rows>
</viewdef>