Specify schema

Title	Collecting Information
Description	Collecting Event

Name	Fields	Unique	Nullable
CEEndDateIDX	EndDate
CEGuidIDX	GUID
CEStartDateIDX	StartDate
CEStationFieldNumberIDX	StationFieldNumber
FKFEB30F224CE675DE	DisciplineID
FKFEB30F225327F942	ModifiedByAgentID
FKFEB30F22697B3F98	CollectingTripID
FKFEB30F227699B003	CreatedByAgentID
FKFEB30F227BF1F70B	VisibilitySetByID
FKFEB30F2297ECD2B2	PaleoContextID
FKFEB30F22A666A5C4	LocalityID
FKFEB30F22FEB93AB2	CollectingEventAttributeID
PRIMARY	CollectingEventID

Name	Field	Related table	Related field
FK32C365C5B237E2BC	CollectingEventID	collectingeventattachment	CollectingEventID
FK42A08813B237E2BC	CollectingEventID	collectingeventattr	CollectingEventID
FK67DBF897B237E2BC	CollectingEventID	collectingeventauthorization	CollectingEventID
FKC1D4635DB237E2BC	CollectingEventID	collectionobject	CollectingEventID
FK7043CC8DB237E2BC	CollectingEventID	collector	CollectingEventID

Name	Field	Related table	Related field
FKFEB30F224CE675DE	DisciplineID	discipline	UserGroupScopeId
FKFEB30F225327F942	ModifiedByAgentID	agent	AgentID
FKFEB30F22697B3F98	CollectingTripID	collectingtrip	CollectingTripID
FKFEB30F227699B003	CreatedByAgentID	agent	AgentID
FKFEB30F227BF1F70B	VisibilitySetByID	specifyuser	SpecifyUserID
FKFEB30F2297ECD2B2	PaleoContextID	paleocontext	PaleoContextID
FKFEB30F22A666A5C4	LocalityID	locality	LocalityID
FKFEB30F22FEB93AB2	CollectingEventAttributeID	collectingeventattribute	CollectingEventAttributeID

View: CollectingEvent (Discipline)

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

View def.: CollectingEvent

<viewdef type="form"
      name="CollectingEvent"
      class="edu.ku.brc.specify.datamodel.CollectingEvent"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
 
    <desc><![CDATA[Collecting Event]]></desc>
    <columnDef>100px,2px,158px,5px,100px,2px,220px,240px,15px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,170px,5px,110px,2px,220px,293px,15px,p:g</columnDef>
    <columnDef os="mac">130px,2px,200px,5px,100px,2px,255px,363px,15px,p:g</columnDef>
    <columnDef os="exp">p,2px,200px,5px,100px,2px,p,p:g,p</columnDef>
    <rowDef auto="true" cell="p" sep="2px"/>
 
    <rows>
        <row>
            <cell type="subview" viewname="Collectors" id="5" name="collectors" colspan="9" rows="3"/>
        </row>
        <row>
            <cell type="subview" viewname="CollectionObjectSub" id="11" colspan="9" rows="3" name="collectionObjects" initialize="addsearch=true"/>
        </row>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="stationFieldNumber" uitype="text"/>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" uitype="plugin" name="this" initialize="name=PartialDateUI;df=startDate;tp=startDatePrecision" uifieldformatter="Date"/>
    </row>
        <row>
            <cell type="label" labelfor="4"/>
            <cell type="field" id="4" name="locality" uitype="querycbx" initialize="name=Locality;title=Locality" colspan="6"/>
        </row>
        <row>
            <cell type="separator" label="Attachments" colspan="9"/>
        </row>
        <row>
            <cell type="subview" id="attachments" viewname="ObjectAttachment" name="collectingEventAttachments" colspan="8" initialize="btn=true;icon=CollectingEventAttachment"/>
        </row>
    </rows>
</viewdef>

View: CollectingEventSub (Discipline)

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

View def.: CollectingEventSub

<viewdef name="CollectingEventSub"
      type="form"
      class="edu.ku.brc.specify.datamodel.CollectingEvent"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[Collecting Event]]></desc>
    <columnDef>100px,2px,125px,5px,90px,2px,203px,5px,90px,2px,99px,5px,99px,0px,p:g</columnDef>
    <!--columnDef>100px,2px,125px,5px,90px,2px,203px,5px,90px,2px,99px,5px,99px,0px,p:g</columnDef-->
    <rowDef auto="true" cell="p" sep="2px"/>
 
    <rows>
        <row>
            <cell type="subview" viewname="Collectors" id="1" name="collectors" colspan="14"/>
        </row>
        <row>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" name="stationFieldNumber" uitype="text"/>
            <cell type="label" labelfor="4"/>
            <cell type="field" id="4" uitype="plugin" name="this" initialize="name=PartialDateUI;df=startDate;tp=startDatePrecision" uifieldformatter="Date"/>
            <cell type="label" labelfor="5"/>
            <cell type="field" id="5" uitype="plugin" name="this" initialize="name=PartialDateUI;df=endDate;tp=endDatePrecision" uifieldformatter="Date" colspan="3"/>
        </row>
        <row>
            <cell type="label" labelfor="43"/>
            <cell type="field" id="43" name="collectingTrip" uitype="querycbx" initialize="name=CollectingTrip;title=Collecting trip" colspan="12"/> 
        </row>
        <row>
            <cell type="label" labelfor="57" label="Geography"/>
            <cell type="field" id="57" name="locality.geography.fullName" uitype="dsptextfield" readonly="true" colspan="12"/>			  	
        </row>
        <row>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="locality" uitype="querycbx" initialize="name=Locality;title=Locality;clonebtn=true" colspan="12"/> 
        </row>
        <!--row>
            <cell type="subview" viewname="LocalitySubForm" id="44" label="Locality" name="locality" colspan="14"/>
        </row>			
        <row>
            <cell type="separator" label="Collecting information" colspan="14"/>
        </row-->
        <row>
            <cell type="label" labelfor="8"/>
            <cell type="field" id="8" name="remarks" uitype="textareabrief" rows="2" colspan="12"/>
        </row>
        <row>
            <cell type="label" labelfor="25"/>
            <cell type="field" id="25" name="verbatimLocality" uitype="textareabrief" rows="2" colspan="12"/>
        </row>
        <row>
            <cell type="label" label="" colspan="7"/>
            <cell type="subview" id="9" name="collectingEventAttribute" viewname="collectingEventAttribute" initialize="align=right;btn=true" colspan="3"/>
            <cell type="subview" id="attachments" viewname="CollectingEventAttachmentMEL" name="collectingEventAttachments" initialize="align=right;btn=true;icon=CollectingEventAttachment"/>
        </row>
    </rows>
</viewdef>

View: CollectingEventSubform (Common)

<view name="CollectingEventSubform"
      class="edu.ku.brc.specify.datamodel.CollectingEvent"
      busrules="edu.ku.brc.specify.datamodel.busrules.CollectingEventBusRules">
    <desc><![CDATA[CollectingEvent Form]]></desc>
    <altviews>
        <altview name="CollectingEventSubform View" viewdef="CollectingEventSubform" mode="view" default="true"/>
        <altview name="CollectingEventSubform Edit" viewdef="CollectingEventSubform" mode="edit"/>
    </altviews>
</view>

View def.: CollectingEventSubform

<viewdef type="form"
      name="CollectingEventSubform"
      class="edu.ku.brc.specify.datamodel.CollectingEvent"
      gettable="edu.ku.brc.af.ui.forms.DataGetterForObj"
      settable="edu.ku.brc.af.ui.forms.DataSetterForObj">
    <desc><![CDATA[Collecting Event]]></desc>
 
    <columnDef>100px,2px,210px,5px,75px,2px,210px,5px,90px,2px,126px,0px,p:g</columnDef>
    <columnDef os="lnx">115px,2px,210px,5px,105px,2px,210px,5px,125px,2px,136px,0px,p:g</columnDef>
    <columnDef os="mac">130px,2px,230px,5px,95px,2px,255px,5px,125px,2px,181px,0px,p:g</columnDef>
    <columnDef os="exp">p,2px,p:g,5px:g,p,2px,p:g,5px:g,p,2px,p:g(2),0px</columnDef>
    <rowDef auto="true" cell="p" sep="2px"/>
 
    <rows>
        <row>
            <cell type="label" labelfor="1"/>
            <cell type="field" id="1" name="stationFieldNumber" uitype="text"/>
            <cell type="label" labelfor="2"/>
            <cell type="field" id="2" uitype="plugin" name="this" initialize="name=PartialDateUI;df=startDate;tp=startDatePrecision" uifieldformatter="Date"/>
            <cell type="label" labelfor="3"/>
            <cell type="field" id="3" name="method" uitype="combobox" dspuitype="dsptextfield" picklist="CollectingMethod"/>
        </row>
        <row>
            <cell type="label" labelfor="4"/>
            <cell type="field" id="4" name="locality" uitype="querycbx" initialize="name=Locality" colspan="10"/>
        </row>
        <row>
            <cell type="label" labelfor="6"/>
            <cell type="field" id="6" name="remarks" uitype="textareabrief" rows="2" colspan="10"/>
        </row>
        <row>
            <cell type="subview" viewname="Collectors" id="5" name="collectors" colspan="12" rows="3"/>
        </row>
        <row>
            <cell type="subview" id="attachments" viewname="ObjectAttachment" name="collectingEventAttachments" colspan="11" initialize="btn=true;icon=CollectingEventAttachment"/>
        </row>
    </rows>
</viewdef>

Name	Type	Index	Title	Pick list	Description
CollectingEventID	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
EndDate	date	MUL	End date		If the collecting date is given as a range, enter the end date here
EndDatePrecision	tinyint(4)		End Date Precision		endDatePrecision
EndDateVerbatim	varchar(50)		End Date Verbatim		endDateVerbatim
EndTime	smallint(6)		End Time		End time in military format.
Method	varchar(50)		Method	CollectingMethod cut	A method, such as net or trap, which is used to obtain the specimen.
Remarks	text		Habitat		General description of the habitat the plant, alga or fungus was growing in
StartDate	date	MUL	Start date		The date of collection. If the collecting date is given as a range, enter the start date here.
StartDatePrecision	tinyint(4)		Start Date Precision		startDatePrecision
StartDateVerbatim	varchar(50)		Start Date Verbatim		startDateVerbatim
StartTime	smallint(6)		Start Time		Start time in military format.
StationFieldNumber	varchar(50)	MUL	Collecting no.		The collecting number of the primary collector(s)
VerbatimDate	varchar(50)		Verbatim Date		Date which collector recorded in field book, exactly as reported by the collector. Should indicate whether reported as range, season, month, etc.
VerbatimLocality	text		Collecting notes		Any notes provided by the collector that do not belong in other fields (e.g. info. about distribution or abundance). Annotations made by someone other than the collector and notes made by data entry staff should be entered in Misc. notes or Curation notes
Visibility	tinyint(4)		Visibility		visibility
CreatedByAgentID	int(11)	MUL
CollectingTripID	int(11)	MUL
VisibilitySetByID	int(11)	MUL
ModifiedByAgentID	int(11)	MUL
LocalityID	int(11)	MUL
CollectingEventAttributeID	int(11)	MUL
DisciplineID	int(11)	MUL
SGRStatus	tinyint(4)		Sgr Status		sgrStatus
GUID	varchar(128)	MUL	Guid		guid
Integer1	int(11)		Integer1		integer1
Integer2	int(11)		Integer2		integer2
ReservedInteger3	int(11)		Reserved Integer3		reservedInteger3
ReservedInteger4	int(11)		Reserved Integer4		reservedInteger4
ReservedText1	varchar(128)		Reserved Text1		reservedText1
ReservedText2	varchar(128)		Reserved Text2		reservedText2
Text1	text		dwc:habitat		Combines habitat and substrate for delivery to ALA.
Text2	text		dwc:occurrenceRemarks		Combines collecting notes, descriptive notes, toxicology notes, ethnobotanical notes and miscellaneous notes for delivery to ALA.
PaleoContextID	int(11)	MUL
StationFieldNumberModifier1	varchar(50)		Station Field Number Modifier1		stationFieldNumberModifier1
StationFieldNumberModifier2	varchar(50)		Station Field Number Modifier2		stationFieldNumberModifier2
StationFieldNumberModifier3	varchar(50)		Station Field Number Modifier3		stationFieldNumberModifier3
Text3	text		Text3		text3
Text4	text		Text4		text4
Text5	text		Text5		text5

MEL Specify schema browser

collectingevent

Table info.

Fields

Indexes

One-to-many relationships

Many-to-one relationships

View: CollectingEvent (Discipline)

View def.: CollectingEvent

View: CollectingEventSub (Discipline)

View def.: CollectingEventSub

View: CollectingEventSubform (Common)

View def.: CollectingEventSubform