List of Entities, Diagram: CDEFD Core ER-Model
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.
Association
- AssociationDoubtfulFlag
- Data element: Association Doubtful Flag
Type: LOGICAL (Y/N)
- AssociationType
- Data element: Association Type Designation
Type: CHAR()
- FirstUnit_Pt
- Data element: Unit Object Identifier
Type: LONG
- SecondUnit_Pt
- Data element: Unit Object Identifier
Type: LONG
Derived Unit
- AdditCuratorialIdentifier
- Data element: Derived Unit Curatorial Collection Number Suffix
Type: CHAR()
- Collection_Pt
- Data element: Collection or Subcollection Identifier
Type: LONG
- DerivUnitCreatEvent_Pt
- Data element: Derived Unit Creation Event Identifier
Type: LONG
- DistribRestrictNotes
- Data element: Derived Unit Distribution Restriction Notes
Type: MEMO
- DistribRestrictSetBy_Pt
- Data element: Person Team Identifier
Type: LONG
- DistribRestrictSetDate
- Data element: Derived Unit Distribution Restriction Set Date
Type: DATE
- DistribRestriction
- Data element: Unit Restriction Imposed on Distribution
Type: CHAR()
Example values: Generally available, Only to defined institutions, Only to ...
- EnsembleSetIdentifier
- Data element: Unit Object Identifier
Type: LONG
- FieldUnitShortcut_Pt
- Data element: Unit Object Identifier
Type: LONG
- ParentLinkCertainFlag
- Data element: Unit Parent Link Certain Flag
Type: LOGICAL (Y/N)
- PermanentLoanFlag
- Data element: Unit on Permanent Loan Flag
Type: LOGICAL (Y/N)
- PreparationIdentifier
- Data element: Derived Unit Preparation Number
Type: CHAR()
- Presence
- Data element: Derived Unit Presence or Accessibility in Collection
Type: CHAR()
- StorageLocationDetail
- Data element: Unit Detailed Location within Collection
Type: CHAR()
Example values: Drawer 1, 3A12, Lower right corner of herbarium sheet
- StorageMedium_Pt
- Data element: Storage Medium Identifier
Type: LONG
- StoredUnderName_Pt
- Data element: Scientific Name Object Identifier
Type: LONG
- TopmostSimilarUnit_Pt
- Data element: Unit Object Identifier
Type: LONG
Derived Unit Creation Event
- DerivUnitCreatEvent_ID
- Data element: Derived Unit Creation Event Identifier
Type: LONG
- DerivUnitCreatMethod_Pt
- Data element: Derived Unit Creation Method Identifier
Type: LONG
- EventDate
- Data element: Derived Unit Creation Event Date
Type: DATE
- EventResponsible_Pt
- Data element: Person Team Identifier
Type: LONG
- InheritTypeSimilarFlag
- Data element: Derived Unit Creation Inheritance Type Similar Flag
Type: LOGICAL (Y/N)
- ParentUnit_Pt
- Data element: Unit Object Identifier
Type: LONG
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()
Unit
- Unit_ID
- Data element: Unit Object Identifier
Type: LONG
- Confidentiality
- Data element: Unit Confidential Data Designation
Type: CHAR()
- ConfidentialityNotes
- Data element: Unit Confidentiality Assignment Notes
Type: MEMO
- ConfidentialitySetBy_Pt
- Data element: Person Team Identifier
Type: LONG
- ConfidentialitySetDate
- Data element: Unit Confidentiality Assigned on Date
Type: DATE
- DataSource
- Data element: Unit Data Source
Type: CHAR()
- MaterialCategory_Pt
- Data element: Material Category Identifier
Type: LONG
- OriginalSourceGraphics
- Data element: Unit Transcription Original Source Graphics
Type: PICTURE
- OriginalSourceText
- Data element: Unit Transcription Original Source Text
Type: MEMO
- OwnedBy_Pt
- Data element: Person(s), Institution, Company, or Organization Identifier
Type: LONG
- TranscribedFlag
- Data element: Unit Data Transcribed Flag
Type: LOGICAL (Y/N)
- TranscriptionNotes
- Data element: Unit Data Transcription Notes
Type: MEMO
This HTML document has been generated by an export function written in the scripting language of the CASE/4/0 program (MicroTool 1995).