List of Entities, Diagram: CDEFD Nomenclatural Types
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.
Nomenclatural Type
- Type_ID
- Data element: Nomenclatural Type Internal Identifier
Type: LONG
- DataSource
- Data element: Nomenclatural Type Source of Recorded Data
Type: CHAR()
- IllustrationRefDetail_Pt
- Data element: Reference Detail Identifier
Type: LONG
- LectotypificRefDetail_Pt
- Data element: Reference Detail Identifier
Type: LONG
- OriginalTypeUnit_Pt
- Data element: Unit Object Identifier
Type: LONG
- ProtologueRefDetail_Pt
- Data element: Reference Detail Identifier
Type: LONG
- ScientificName_Pt
- Data element: Scientific Name Object Identifier
Type: LONG
- TypeStatus
- Data element: Nomenclatural Type Status
Type: CHAR(16)
Value range: Holotypus, Isolectotypus, Isoneotypus, Isoparalectotypus, Isoparatypus, Isosyntypus, Isotypus, Lectotypus, Neotypus, Paralectotypus, Paratypus, Syntypus, Typus
- Unit_Pt
- Data element: Unit Object Identifier
Type: LONG
- VerificationComment
- Data element: Nomenclatural Type Verification Note or Comment
- VerifiedFlag
- Data element: Nomenclatural Type Checked Against Protologue Flag
Type: LOGICAL (Y/N)
Reference Detail
- RefDetl_ID
- Data element: Reference Detail Identifier
Type: LONG
- ItemDetail
- Data element: Reference Detail Item Designator
Type: CHAR(30)
Example values: plate 1, map 22 grid a15, fig. 10b
- PreciPgCit
- Data element: Reference Precise Page Citation
Type: CHAR(30)
- Title_Pt
- Data element: Reference Title Identifier
Type: LONG
- UpdatBy_Pt
- Data element: User Identifier
Type: LONG
- UpdateDate
- Data element: Last Date of Write-Access to Record
Type: DATE
Scientific Name
- FullNam_ID
- Data element: Scientific Name Object Identifier
Type: LONG
- BaExAut_Pt
- Data element: Person Team Identifier
Type: LONG
- BasiAut_Pt
- Data element: Reference Detail Identifier
Type: LONG
- CoExAut_Pt
- Data element: Person Team Identifier
Type: LONG
- CombRef_Pt
- Data element: Reference Detail Identifier
Type: LONG
- HomnymFlag
- Data element: Homonym Flag
Type: LOGICAL Y/N
- HybridQual
- Data element: Hybrid or Graft-Chimera Qualifier
Type: CHAR(3)
Default value: 0
Value range: (x), +, 0, x
- MisWrnFlag
- Data element: Missapplication Warning Flag
Type: LOGICAL Y/N
- NameElmnt
- Data element: Name Element (Epithet, Generic or Other Taxon Monomial)
Type: CHAR(33)
- NameStruct
- Data element: Name Structure
Type: CHAR(1)
Value range: B, H, M, T, U
- OblgTax_Pt
- Data element: Potential Taxon Name Object Identifier
Type: LONG
- Rank_No
- Data element: Rank Identifier and Taxonomic Sequence Number
Type: INTEGER(2)
- UpdatBy_Pt
- Data element: User Identifier
Type: LONG
- UpdateDate
- Data element: Last Date of Write-Access to Record
Type: DATE
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).