Specify schema

Title	Collecting Event Attribute
Description	Collecting Event Attribute

Name	Fields	Unique	Nullable
COLEVATSDispIDX	DisciplineID
FK9AD681BA32C0CDC4	HostTaxonID
FK9AD681BA4CE675DE	DisciplineID
FK9AD681BA5327F942	ModifiedByAgentID
FK9AD681BA7699B003	CreatedByAgentID
PRIMARY	CollectingEventAttributeID

Name	Field	Related table	Related field
FKFEB30F22FEB93AB2	CollectingEventAttributeID	collectingevent	CollectingEventAttributeID

Name	Field	Related table	Related field
FK9AD681BA32C0CDC4	HostTaxonID	taxon	TaxonID
FK9AD681BA4CE675DE	DisciplineID	discipline	UserGroupScopeId
FK9AD681BA5327F942	ModifiedByAgentID	agent	AgentID
FK9AD681BA7699B003	CreatedByAgentID	agent	AgentID

View: collectingEventAttribute (Discipline)

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

View def.: collectingEventAttribute

<viewdef name="collectingEventAttribute"
      type="form"
      class="edu.ku.brc.specify.datamodel.CollectingEventAttribute"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[Collecting event attribute]]></desc>
    <columnDef>p,2px,160px,5px,60px,2px,120px,5px,40px,2px,75px,p,p:g</columnDef>
    <rowDef auto="true" cell="p" sep="2px"/>
 
    <rows>
        <row>
            <cell type="separator" label="Label data" colspan="11"/>
        </row>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="text1" uitype="text" colspan="9"/>
        </row>
        <row>
            <cell type="label" label=""/>
            <cell type="field" id="24" name="yesNo2" uitype="checkbox" colspan="1"/>
            <cell type="field" id="25" name="yesNo3" uitype="checkbox" colspan="3"/>
            <cell type="field" id="26" name="yesNo4" uitype="checkbox" colspan="3"/>
        </row>
        <row>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="text6" uitype="text" cols="10"/>
					<cell type="label" label=""/>
            <cell type="field" id="23" name="yesNo1" uitype="checkbox" cols="3"/>
        </row>
        <row>
            <cell type="separator" label="Plant origin" colspan="11"/>
        </row>
        <row>
            <cell type="label" labelfor="6"/>
            <cell type="field" id="6" name="text11" uitype="combobox"/>
            <cell type="label" label="Source:" initialize="align=right"/>
            <cell type="field" id="7" name="text12" uitype="combobox" colspan="1"/>
            <cell type="label" label="Date:" initialize="align=right"/>
            <cell type="field" id="13" name="text15" uitype="text" colspan="1"/>
        </row>
        <row>
            <cell type="label" labelfor="8"/>
            <cell type="field" id="8" name="text13" uitype="combobox"/>
            <cell type="label" label="Source:" initialize="align=right"/>
            <cell type="field" id="9" name="text14" uitype="combobox" colspan="1"/>
            <cell type="label" label="Date:" initialize="align=right"/>
            <cell type="field" id="14" name="text16" uitype="text" colspan="1"/>
       </row>
        <row>
            <cell type="label" labelfor="12"/>
            <cell type="field" id="12" name="text3" uitype="textareabrief" rows="2" colspan="11"/>
        </row>
        <row>
            <cell type="separator" label="Habitat" colspan="11"/>
        </row>
        <row>
            <cell type="label" labelfor="22"/>
            <cell type="field" id="22" name="text2" uitype="textareabrief" rows="2" colspan="9"/>
        </row>
        <row>
            <!--cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="hostTaxon" uitype="querycbx" initialize="name=Taxon" colspan="7"/-->
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="text5" uitype="text" colspan="9"/>
        </row>
        <row>
            <cell type="label" labelfor="4"/>
            <cell type="field" id="4" name="text10" uitype="text" colspan="5"/>
        </row>
        <row>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" name="text4" uitype="text" colspan="5"/>
        </row>
    </rows>
</viewdef>

Name	Type	Index	Title	Pick list	Description
CollectingEventAttributeID	int(11)	PRI
TimestampCreated	datetime		Created		timestampCreated
TimestampModified	datetime		Last edited		timestampModified
Version	int(11)		Version		version
Number1	float(20,10)		Number1		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
Number2	float(20,10)		Number2		number2
Number3	float(20,10)		Number3		number3
Number4	float(20,10)		Number4		number4
Number5	float(20,10)		Number5		number5
Number6	float(20,10)		Number6		number6
Number7	float(20,10)		Number7		number7
Number8	float(20,10)		Number8		number8
Number9	float(20,10)		Number9		number9
Remarks	text		Coll. prev. recorded as		How the collector's name was previously recorded in the database. Used to preserve a link between a collecting event and an agent record that is being merged with another (e.g. B. Rye being merged with B.L. Rye)
Text1	text		Verbatim collectors		The collectors' names exactly as they appear on the label, without interpretation. Only complete this field if the names entered in the collectors field have been interpreted, or if the name on the label provides additional information.
Text10	varchar(50)		Host common name		The common name for the host taxon, as provided by the collector
Text11	varchar(50)		Introduced status	IntroducedStatus Native Not native Unknown	The introduced status of the plant at the collecting locality. If this field is completed, the Introduced source field must also be completed.
Text12	varchar(50)		Introduced source	IntroducedSource Collector Exchange data NGW VS JCR Label data	Source of the introduced status information
Text13	varchar(50)		Cultivated status	CultivatedStatus Not cultivated Cultivated Possibly cultivated Unknown Presumably cultivated	The cultivated status of the specimen. If this field is filled in, the Cultivated source field must also be completed.
Text14	varchar(50)		Cult. source	CultivatedSource Collector Data entry person Exchange data Other Label data	Source of the cultivated status information
Text15	varchar(50)		Introduced status date		The date that the introduced status was determined
Text16	varchar(50)		Cultivated status date		The date that the cultivated status was determined
Text17	varchar(50)		Text17		text17
Text2	text		Associated taxa		A list of other plants, algae or fungi growing in association with the specimen, where provided by the collector and prefixed with 'Associated species', 'Growing in association with' etc.
Text3	text		Provenance		The provenance of a cultivated plant specimen, if provided by the collector
Text4	varchar(100)		Substrate		The substrate on which the specimen was growing
Text5	varchar(100)		Host taxon		The scientific name of the specimen's host
Text6	varchar(50)		Verbatim collecting date		A non-standard collecting date, e.g. 'Christmas', 'Summer 1860', 'early April 1978'. Where the non-standard date includes a year, or a year and a month, these should also be record in the collecting date fields.
Text7	varchar(50)		Establishment means		Darwin Core establishment means; currently derived from Introduced status and Cultivated status.
Text8	varchar(50)		Text8		text8
Text9	varchar(50)		Text9		text9
YesNo1	bit(1)		Date inferred		Indicates that the collecting date has been inferred. Notes about how the date has been inferred can be entered in Misc. notes.
YesNo2	bit(1)		Collector inferred		Tick this box if the collector has been inferred
YesNo3	bit(1)		Collector unknown		Tick this box if the collector's name is not on the sheet, and hasn't been inferred. If it says 'Unknown' on the sheet, enter 'Unknown' in the Verbatim collectors field.
YesNo4	bit(1)		Collector illegible		Tick this box if the collector's name is on the sheet, but is illegible
YesNo5	bit(1)		Yes No5		yesNo5
ModifiedByAgentID	int(11)	MUL
DisciplineID	int(11)	MUL
CreatedByAgentID	int(11)	MUL
HostTaxonID	int(11)	MUL
Integer1	int(11)		Integer1		integer1
Integer10	int(11)		Integer10		integer10
Integer2	int(11)		Integer2		integer2
Integer3	int(11)		Integer3		integer3
Integer4	int(11)		Integer4		integer4
Integer5	int(11)		Integer5		integer5
Integer6	int(11)		Integer6		integer6
Integer7	int(11)		Integer7		integer7
Integer8	int(11)		Integer8		integer8
Integer9	int(11)		Integer9		integer9

MEL Specify schema browser

collectingeventattribute

Table info.

Fields

Indexes

One-to-many relationships

Many-to-one relationships

View: collectingEventAttribute (Discipline)

View def.: collectingEventAttribute