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