List of Entities, Diagram: CDEFD Relationships of Gathering Event

Entities are listed in alphabetical order. For every entity, primary key attributes (if present) are listed first, other attributes follow in alphabetical order. Foreign keys are recognized by a _Pt suffix (pointer).
Every attribute name is followed by the name of its data element, which in many cases provides a short description of the attribute's meaning. Type and example values refer to the data element.


Field Descriptors

FieldDescriptorSet_ID
Data element: Field Descriptor Set Identifier
Type: LONG
FieldDescription
Data element: Field Descriptor: Description Text
Type: MEMO
Gathering_Pt
Data element: Gathering Object Identifier
Type: LONG


Gathering Event

GatheringEvent_ID
Data element: Gathering Event Identifier
Type: LONG
CollPermit_Pt
Data element: Permit Identifier
Type: LONG
GatheringDate
Data element: Gathering Date (Single Date or First of Period)
Type: DATE
GatheringDateModif
Data element: Gathering Date Modifier
Type: CHAR()
Example values: ca., about, presumably
GatheringDateUntil
Data element: Gathering Date (Second Date of Time Period)
Type: DATE
LegTeamAllii_Pt
Data element: Person Team Identifier
Type: LONG
LegTeamFirst_Pt
Data element: Person Team Identifier
Type: LONG
LegTeamPer_Pt
Data element: Person Team Identifier
Type: LONG
Project_Pt
Data element: Project or Expedition Identifier
Type: LONG
Site_Pt
Data element: Site Object Identifier
Type: LONG


Gathering or Field Unit

FieldCode
Data element: Field Identifier Non-Standard Number or Phrase
Type: CHAR()
FieldNo
Data element: Field Identifier Sequential Number
Type: LONG
FieldNoPrefix
Data element: Field Identifier Sequential Number Prefix
Type: CHAR()
FieldNoSuffix
Data element: Field Identifier Sequential Number Suffix
Type: CHAR()
GatheringEvent_Pt
Data element: Gathering Event Identifier
Type: LONG
GatheringMethod
Data element: Gathering Method
Type: CHAR()
IndivLocalityDescription
Data element: Gathering Individual Locality Description
Type: CHAR()


Gathering Site

Site_ID
Data element: Site Object Identifier
Type: LONG
AltitudePrecisModif
Data element: Altitude Precision Modifier
Type: CHAR(10)
Example values: estimated, ca., about
AltitudeRangeHigherValue
Data element: Altitude Higher Value of Range
Type: INTEGER
AltitudeUnit
Data element: Length Measurement Unit
Type: CHAR()
Example values: m, ft
AltitudeValue
Data element: Altitude Single Value or Lower Value of Range
Type: INTEGER()
AltitudeValueError
Data element: Altitude Value Error
Type: INTEGER
Area_Pt
Data element: Gazetteer: Area Identifier
Type: LONG
CoordinatePrecisModif
Data element: Co-ordinates Precision Modifier
Type: CHAR(10)
Example values: about, estimated, ca.
CoordinateSystem_Pt
Data element: Co-ordinate System Identifier
Type: LONG
CoordinateValueError
Data element: Co-ordinates Error
Type: DOUBLE
CoordinateXValue
Data element: Co-ordinates X-value
Type: DOUBLE
CoordinateYValue
Data element: Co-ordinates Y-value
Type: DOUBLE
GridCode
Data element: Geographical Grid System Cell Code
Type: CHAR()
GridPrecisModif
Data element: Geographical Grid Code Assignment Precision Modifier
Type: CHAR()
GridSystemName
Data element: Geographical Grid System Name
Type: CHAR()
MeasurementMethod
Data element: Geospatial Co-ordinates Measurement Method
Type: CHAR()
Example values: from map, GPS, GPS with local reference
SiteDetail
Data element: Site Localization Detail
Type: CHAR()
SiteUserDefinedName
Data element: Gathering Site User Defined Name
Type: CHAR()


Person Team

PersonTeam_ID
Data element: Person Team Identifier
Type: LONG
PersonTeamDescription
Data element: Person Team Description of Group
Type: CHAR()


Project or Expedition

Project_ID
Data element: Project or Expedition Identifier
Type: LONG
ProjectAcknowledgement
Data element: Project or Expedition Funding Acknowledgements
Type: CHAR()
ProjectNotes
Data element: Project or Expedition Description and Notes
Type: MEMO
ProjectTitle1
Data element: Project or Expedition 1st Title
Type: CHAR()
ProjectTitle2
Data element: Project or Expedition 2nd Title
Type: CHAR()

This HTML document has been generated by an export function written in the scripting language of the CASE/4/0 program (MicroTool 1995).