collectionobjectattribute

Table info.

Title Collection Object Attribute
Description Collection Object Attribute

Fields

Name Type Required Index Hidden On form Title Pick list Description
CollectionObjectAttributeID int(11) PRI
TimestampCreated datetime Created timestampCreated
TimestampModified datetime Last edited timestampModified
Version int(11) Version version
CollectionMemberID int(11) MUL Collection Member Id collectionMemberId
Number1 float(20,10) number1
Number10 float(20,10) Number10 number10
Number11 float(20,10) Number11 number11
Number12 float(20,10) Number12 number12
Number13 float(20,10) Number13 number13
Number14 float(20,10) Number14 number14
Number15 float(20,10) Number15 number15
Number16 float(20,10) Number16 number16
Number17 float(20,10) Number17 number17
Number18 float(20,10) Number18 number18
Number19 float(20,10) Number19 number19
Number2 float(20,10) number2
Number20 float(20,10) Number20 number20
Number21 float(20,10) Number21 number21
Number22 float(20,10) Number22 number22
Number23 float(20,10) Number23 number23
Number24 float(20,10) Number24 number24
Number25 float(20,10) Number25 number25
Number26 float(20,10) Number26 number26
Number27 float(20,10) Number27 number27
Number28 float(20,10) Number28 number28
Number29 float(20,10) Number29 number29
Number3 float(20,10) number3
number30 int(11) Translation confidence TranslationConfidence
  • Native or bilingual proficiency
  • Full proficiency
  • Limited proficiency
  • Dictionary translation
  • Online translation service
 An indication of the confidence of the translation. If more than one method of translating was used, pick the most appropriate confidence level.
Number31 float(20,10) Number31 number31
Number32 float(20,10) Number32 number32
Number33 float(20,10) Number33 number33
Number34 float(20,10) Number34 number34
Number35 float(20,10) Number35 number35
Number36 float(20,10) Number36 number36
Number37 float(20,10) Number37 number37
Number38 float(20,10) Number38 number38
Number39 float(20,10) Number39 number39
Number4 float(20,10) number4
Number40 float(20,10) Number40 number40
Number41 float(20,10) Number41 number41
Number42 float(20,10) Number42 number42
Number5 float(20,10) number5
Number6 float(20,10) number6
Number7 float(20,10) Number7 number7
number8 int(11) Number8 number8
Number9 float(20,10) Number9 number9
Remarks text Ethnobotanical info. Notes about the ethnobotanical usage of the plant, alga or fungus, if provided by the collector
Text1 text Curation notes Notes about the specimen that are only of relevance for internal curation purposes, e.g. missing specimens, notes about MEL numbers being reassigned. Data in this field will not be delivered to AVH.
Text10 varchar(50) text10
Text11 varchar(50) RBG Accession Number Use the RBGC or RBGM acronym, followed by the 6 digit accession number, followed by a full stop and then the counter number. This field should only be used for material collected from plants growing in the RBGV.
Text12 varchar(50) Common name The common name for the plant, alga or fungus, as provided by the collector
Text13 varchar(50) Flowers Flowers
  • Yes
  • No
 Is the specimen bearing flowers?
Text14 varchar(50) Fruit Fruit
  • Yes
  • No
 Is the specimen bearing fruit?
Text15 varchar(64) Buds Buds
  • Yes
  • No
 Is the specimen in bud?
Text2 text Notes Notes about a missing specimen, e.g. attempt to look for it, date it was noticed missing, date found.
Text3 text Toxicity Information about the toxicity of the specimen, if provided by the collector
Text4 varchar(50) Curation sponsor The sponsor of the curation and/or databasing of the specimen (e.g. CASS Foundation). Only include the name of the sponsor; the following prefix will be printed on labels 'The curation of this specimen was generously sponsored by'.
Text5 varchar(50) Label language The language(s) in which the original collecting information was provided. Separate multiple languages with a space and a comma, e.g. 'Spanish, German, English'.
Text6 varchar(100) Destructive sampling Previously used for information about when and why the specimen was sampled destructively. This information is now in conservEvent fields.
Text7 varchar(100) Original collection The name of the exsiccata set or personal herbarium from which the specimen originates. This is a temporary field until the Exsiccata table is working properly.
Text8 varchar(50) Fascicle The fascicle number in the exsiccata series. This is a temporary field until the Exsiccata table is working properly.
Text9 varchar(50) Number The number in the exsiccata series. This is a temporary field until the Exsiccata table is working properly.
YesNo1 bit(1) Digital image To indicate that there is a digital image associated with the specimen. This is legacy data from Texpress; digital images for new records will be stored as collection object attachments.
YesNo2 bit(1) Illustration To indicate if there is an illustration associated with the specimen
YesNo3 bit(1) Extra An indication that there is additional information associated with the specimen that has not been databased. This is legacy data from Texpress; if there are additional things that could or should be databased, we will add fields for them.
YesNo4 bit(1) Specimen missing Used to flag if a specimen is missing. Please untick this box if the specimen is found.
YesNo5 bit(1) Photograph To indicate that there is a printed photograph associated with the specimen
YesNo6 bit(1) Voucher An indication of whether the specimen was collected as a voucher for a project (legacy data from Texpress). Project information for new records will be entered in the Project table.
YesNo7 bit(1) Spore print Tick the box if there is a spore print with the specimen. Notes about spore print colour, e.g. 'spore print brown', should be entered in Descriptive notes.
CreatedByAgentID int(11) MUL
ModifiedByAgentID int(11) MUL
BottomDistance float Bottom Distance bottomDistance
Direction varchar(32) Direction direction
DistanceUnits varchar(16) Distance Units distanceUnits
PositionState varchar(32) Position State positionState
TopDistance float Top Distance topDistance
Integer1 int(11) integer1
Integer10 int(11) Integer10 integer10
Integer2 int(11) integer2
Integer3 int(11) integer3
Integer4 int(11) integer4
Integer5 int(11) integer5
Integer6 int(11) integer6
Integer7 int(11) Integer7 integer7
Integer8 int(11) Integer8 integer8
Integer9 int(11) Integer9 integer9
Text16 text Leafless Leafless
  • Yes
  • No
 Is the specimen leafless?
Text17 text Fertile Fertile
  • Yes
  • No
 Is the specimen fertile?
Text18 text Sterile Sterile
  • Yes
  • No
 Is the specimen sterile?
Text19 text Seedling Legacy data from the Seedling field in Texpress (this needs cleaning)
Text20 text Usage Any remarks about the usage of the common name, such as the language in which the common name is given, or the ethnic group who uses the name.
Text21 text Date last looked for The date that a missing specimen was last looked for. Please enter the date as dd/mm/yyyy, and also include it in any notes in the Notes field.
Text22 text Other
Text23 text Notes
Text24 text Signage
Text25 text Data generalisations Actions taken to make the shared data less specific or complete than in its original form. Suggests that alternative data of higher quality may be available on request (see http://rs.tdwg.org/dwc/terms/dataGeneralizations).
Text26 text Information withheld Additional information that exists, but that has not been shared in the given record (see: http://rs.tdwg.org/dwc/terms/informationWithheld).
Text27 text Sensitive data The precise data that is generalised or withheld, as indicated in the 'Data generalisations' and 'Information withheld' fields.
Text28 text Reproductive Condition Darwin Core reproductiveCondition: list made up from Flowers, Fruit, Buds, Fertile and Sterile fields for delivery to AVH
Text29 text iNaturalist URL Please enter the entire URL: https://inaturalist.org/observations/.
Text30 text Text30 text30
YesNo10 bit(1) Current research
YesNo11 bit(1) Weed
YesNo12 bit(1) Attractive
YesNo13 bit(1) Yes No13 yesNo13
YesNo14 bit(1) Yes No14 yesNo14
YesNo15 bit(1) Hort. Ref. Set Indicates whether the specimen is in the Hort. Ref. Set.
YesNo16 bit(1) Yes No16 yesNo16
YesNo17 bit(1) Yes No17 yesNo17
YesNo18 bit(1) Yes No18 yesNo18
YesNo19 bit(1) Yes No19 yesNo19
YesNo20 bit(1) Yes No20 yesNo20
YesNo8 bit(1) Collector(s)
YesNo9 bit(1) Historical
Date1 date Date translated The date when the collecting information was translated
Date1Precision tinyint(4) Date1 Precision date1Precision
Agent1ID int(11) MUL

Indexes

Name Fields Unique Nullable
COLOBJATTRSColMemIDX CollectionMemberID
FK32E0BFDF5327F942 ModifiedByAgentID
FK32E0BFDF7699B003 CreatedByAgentID
FK32E0BFDFCF197B29 Agent1ID
PRIMARY CollectionObjectAttributeID

One-to-many relationships

Name Field Related table Related field
FKC1D4635DA141B896 CollectionObjectAttributeID collectionobject CollectionObjectAttributeID

Many-to-one relationships

Name Field Related table Related field
FK32E0BFDF5327F942 ModifiedByAgentID agent AgentID
FK32E0BFDF7699B003 CreatedByAgentID agent AgentID
FK32E0BFDFCF197B29 Agent1ID agent AgentID

View: CollectionObjectAttribute (Collection)

<view name="CollectionObjectAttribute"
      class="edu.ku.brc.specify.datamodel.CollectionObjectAttribute"
      resourcelabels="false">
    <desc><![CDATA[Subform within the Collection Object form.]]></desc>
    <altviews>
        <altview name="CollectionObjectAttribute View" viewdef="CollectionObjectAttribute" mode="view"/>
        <altview name="CollectionObjectAttribute Edit" viewdef="CollectionObjectAttribute" mode="edit" default="true"/>
    </altviews>
</view>

View def.: CollectionObjectAttribute

<viewdef name="CollectionObjectAttribute"
      type="form"
      class="edu.ku.brc.specify.datamodel.CollectionObjectAttribute"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[Form For OtherIdentifier]]></desc>
    <!--columnDef>100px,2px,115px,5px,85px,2px,92px,5px,95px,2px,93px,5px,94px,2px,115px,0px,p:g</columnDef-->
    <columnDef>135px,2px,30px,5px,65px,2px,30px,5px,65px,2px,30px,5px,65px,2px,30px,5px,65px,2px,30px,5px,65px,2px,30px,5px,0px,p:g</columnDef>
    <!--columnDef>135px,2px,115px,5px,95px,2px,115px,5px,95px,2px,115px,5px,0px,p:g</columnDef-->
    <!--columnDef os="lnx">115px,2px,120px,5px,95px,2px,120px,5px,115px,2px,120px,5px,89px,2px,120px,0px,p:g</columnDef>
    <columnDef os="mac">130px,2px,140px,5px,100px,2px,140px,5px,125px,2px,140px,5px,109px,2px,150px,0px,p:g</columnDef>
    <columnDef os="exp">p,2px,max(p;130px),5px:g,p,2px,120px,5px:g,p,2px,130px,5px:g,p,2px,max(p;130px),p:g</columnDef-->
    <rowDef auto="true" sep="2px" cell="p"/>
    <rows>
        <row>
            <cell type="separator" label="Phenology" colspan="24"/>
        </row>
        <row>
            <cell type="label" labelfor="8"/>
            <cell type="field" id="8" name="number1" uitype="text"/>
            <cell type="label" labelfor="9"/>
            <cell type="field" id="9" name="number2" uitype="text"/>
            <cell type="label" labelfor="10"/>
            <cell type="field" id="10" name="number3" uitype="text"/>
            <cell type="label" labelfor="11"/>
            <cell type="field" id="11" name="number4" uitype="text"/>
            <cell type="label" labelfor="12"/>
            <cell type="field" id="12" name="number5" uitype="text"/>
            <cell type="label" labelfor="13"/>
            <cell type="field" id="13" name="number6" uitype="text"/>
        </row>
        <row>
            <cell type="separator" label="Label data" colspan="24"/>
        </row>
        <row>
            <cell type="label" labelfor="14"/>
            <cell type="field" id="14" name="remarks" uitype="textareabrief" rows="2" colspan="21"/>
        </row>
        <!--row>
            <cell type="label" labelfor="16"/>
            <cell type="field" id="16" name="text2" uitype="textareabrief" rows="2" colspan="21"/>
        </row-->
        <row>
            <cell type="label" labelfor="17"/>
            <cell type="field" id="17" name="text3" uitype="textareabrief" rows="2" colspan="21"/>
        </row>
        <row>
            <cell type="label" labelfor="22"/>
            <cell type="field" id="22" name="text12" uitype="text" colspan="9"/>
            <cell type="label" labelfor="23"/>
            <cell type="field" id="23" name="text15" uitype="text" colspan="9"/>
        </row>
        <row>
            <cell type="label" labelfor="24"/>
            <cell type="field" id="24" name="text5" uitype="text" colspan="15"/>
        </row>
        <row>
            <cell type="label" labelfor="44"/>
            <cell type="field" id="44" name="number30" uitype="combobox" colspan="7"/>
            <cell type="label" labelfor="45" colspan="3"/>
            <cell type="field" id="45" name="text10" uitype="text" colspan="9"/>
        </row>
        <row>
            <cell type="separator" label="Data entry notes" colspan="24"/>
        </row>
        <row>
            <cell type="label" labelfor="15"/>
            <cell type="field" id="15" name="text1" uitype="textareabrief" rows="2" colspan="21"/>
        </row>
        <row>
            <cell type="label" labelfor="36"/>
            <cell type="field" id="36" name="text4" uitype="text" colspan="15"/>
        </row>
        <row>
            <cell type="separator" label="Other" colspan="24"/>
        </row>
        <row>
            <cell type="label" labelfor="40"/>
            <cell type="field" id="40" name="text6" uitype="text" colspan="21"/>
        </row>
        <row>
            <cell type="label" labelfor="41"/>
            <cell type="field" id="41" name="text7" uitype="text" colspan="17"/>
        </row>
        <row>
            <cell type="label" labelfor="42"/>
            <cell type="field" id="42" name="text8" uitype="text" colspan="5"/>
            <cell type="label" labelfor="43"/>
            <cell type="field" id="43" name="text9" uitype="text" colspan="5"/>
        </row>
        <row>
            <cell type="label" label=""/>
            <cell type="field" id="27" name="yesNo2" uitype="checkbox" colspan="3"/>
            <cell type="label" label=""/>
            <cell type="field" id="29" name="yesNo5" uitype="checkbox" colspan="3"/>
            <cell type="label" label=""/>
            <cell type="field" id="28" name="yesNo7" uitype="checkbox" colspan="3"/>
        </row>		
    </rows>
</viewdef>
 

View: PlantAttributes (Discipline)

<view name="PlantAttributes"
      class="edu.ku.brc.specify.datamodel.CollectionObjectAttribute"
      resourcelabels="false">
    <desc><![CDATA[Subform within the Collection Object form.]]></desc>
    <altviews>
        <altview name="PlantAttributes View" viewdef="PlantAttributes" mode="view"/>
        <altview name="PlantAttributes Edit" viewdef="PlantAttributes" mode="edit" default="true"/>
    </altviews>
</view>

View def.: PlantAttributes

<viewdef type="form"
      name="PlantAttributes"
      class="edu.ku.brc.specify.datamodel.CollectionObjectAttribute"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[Form For OtherIdentifier]]></desc>
 
    <columnDef>100px,2px,115px,5px,85px,2px,92px,5px,95px,2px,93px,5px,94px,2px,115px,0px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,120px,5px,95px,2px,120px,5px,115px,2px,120px,5px,89px,2px,120px,0px,p:g</columnDef>
    <columnDef os="mac">130px,2px,140px,5px,100px,2px,140px,5px,125px,2px,140px,5px,109px,2px,150px,0px,p:g</columnDef>
    <columnDef os="exp">p,2px,max(p;130px),5px:g,p,2px,120px,5px:g,p,2px,130px,5px:g,p,2px,max(p;130px),p:g</columnDef>
    <rowDef auto="true" sep="2px" cell="p"/>
    <rows>
        <row>
            <cell type="label" label=""/>
            <cell type="field" id="8" name="yesNo1" uitype="checkbox"/>
            <cell type="field" id="9" name="yesNo2" uitype="checkbox"/>
            <cell type="field" id="10" name="yesNo3" uitype="checkbox"/>
            <cell type="field" id="11" name="yesNo4" uitype="checkbox"/>
            <cell type="field" id="12" name="yesNo5" uitype="checkbox"/>
            <cell type="field" id="13" name="yesNo6" uitype="checkbox"/>
        </row>
    </rows>
</viewdef>