Format for Entity Descriptions in this Section
Entity Name:The Name of the Entity
Supertype: If Entity is a subtype, the Entity to which it is a subtype is noted here
Definition: A description of the kind of information that Entity covers
Source: A reference to the authorship of this Entity if it draws substantialy from another data
model.
Primary Key: The Name of the Primary Key of Entity (if any)
Definition: A description of the primary key
Domain: Description of the kind of information that can be found in the key
Domains may include
Key
Integers
Real Numbers
String: Character string
Boolean: Logical True False
Lists of values: e.g. 'North, South, East, West'
Buisness Rules: Rules for the assignment of values to the key
Foreign Keys:
The names of any Foreign Keys in Entity, along with their:
Target Entity: The Entity to which the Foreign key refers
Definition:
Domain:
Buisness Rules:
Other Attributes:
The names of all other attributes in Entity, along with their:
Definition:
Domain:
Buisness Rules:
Notes: any pertanant notes concering implementation or why the entity was designed in the
way that it was.
Entity Name:Article
Supertype: Literature Reference
Definition:Bibliographic Reference information pertaning to an article in a serial publication.
Source: Paleobank entity: Journal Article
Foreign Key:
Journal_Id
Target Entity: Journal
Definition: The Journal or Series in which the Article appears.
Domain: Journal_Id Primary Key of Journal.
Buisness Rules: 1) Required entry from an authority list
Other Attributes:
Volume_Number
First_Page_of_ Article
Last_Page_of_Article
Issue_Number
First_Figure_Number
Last_Figure_Number
First_Plate_Number
Last_Plate_Number
Entity Name: Authority
Definition: A source for information found in the database
Primary Key: Authority_Id
Definition: Unique identifier for an Authority
Domain: Key
Buisness Rules: Automatic Assignment
Foreign Keys:
Literature_Id
Target Entity: Literature_Reference
Person_Id
Target Entity: Person
Lot_ID
Target Entity: Museum_Lot
Other Attributes:
Kind_Of_Authority
Domain: Literature, Person, Specimen
Remarks
Definition: Authorataive statements made by a Person and not otherwise documented in
the literature or on a museum label.
Buisness Rules: Manual Entry Required for Kind_of_Authority = Person. No entry
allowed for other values of Kind_of_Authority
Entity Name: Book
Supertype:Literature Reference
Definition:
Source: PaleoBank
Primary Key: _
Definition:
Domain:
Buisness Rules:
Foreign Keys:
_
Target Entity:
Definition:
Domain:
Buisness Rules:
Other Attributes:
_
_
Entity Name: Definition
Definition: Definition of a morphological term
Primary Key: Definition_Id
Definition: Unique Identifier for a Definition
Domain: Key
Buisness Rules: Automatic Assignment
Foreign Keys:
Authority_Id
Target Entity: Literature_Reference
Definition: Reference to source of Definition
Other Attributes:
Text_of_Definition
Entity Name: Def-Illust (Associative Entity)
Definition: Entity Relating Definitions to Illustations
Foreign Keys:
Definition_Id
Target Entity: Definition
Illustration_Id
Target Entity: Illustration
Other Attributes:
-None-
Entity Name: Geographic_Coordinate
Definition: A pair of coordinates specifying a unique location on the surface of the Earth.
Source: Modified from ASC model entity Geometric_Coordinate
Primary Key: Coordinate_Id
Definition: Unique Identifier for a Geographic Coordinate pair
Domain: Key
Buisness Rules: Automatic Assignment
Foreign Keys:
Next_Coordinate (Recursive Reference)
Target Entity: Geographic_Coordinate
Other Attributes:
Coordinate_Type
Domain: 'Latitude and Longitude' or 'UTM'
Buisness Rules: Required entry from pick list, automatic assignment after first entry in list
of coordinates. Default value is Lat & Lon.
Position_in_List
Domain: Point, First, Last, Middle
Buisness Rules: Automatic Assignment based upon value in Geographic_Place -->
Number_of_Coordinates.
Note: This duplicates Geographic_Place-->Number_of_Coordinates for error checking
purposes. One or the other of these attributes could be ommited.
Subtypes:
Latitude_and_Longitude
UTM_Coordinate
Note: By linking a series of instances of Geographic_Coordinate a line or an area on the
surface of the earth can be specified as a linked list of coordinates.
Entity Name: Geographic_Entity
Supertype: Geographic_Place
Definition: A geographic entity (location or place) whose name is in common use. Preferably
the name should appear on one or more published maps.
Source: Modified from ASC Model entity Named-Place
Primary Key: Geographic_Entity_id
Definition: Unique Identifier
Domain: Key
Buisness Rules: Automatic Assignment
Foreign Keys:
Within_Entity_Id (Recursive Relationship)
Target Entity: Geographic_Entity