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).