eventprefmec Attributes

Attribute/Logical Rolename	Domain	Datatype	NULL	Definition
mechtype		VARCHAR(2)	NO	Mechanism type
evid		NUMERIC(15, 0)	NO	Event identifier. Each event is assigned a unique integer which identifies it in a database. It is possible for several records in the Origin relation to have the same evid. This indicates there are several opinions about the location of the event. The evid does not have to be identical to the local network’s event identifier, which is stored in the Origin table. This allows merging data for a single event from multiple sources without insisting that database evid is identical to the source’s local event identifier
mecid		NUMERIC(15, 0)	YES	Mechanism identification. Each mechanism is assigned a unique positive integer which identifies it in the database
lddate		DATE	YES	Load date. Date and time that the record was created, in Oracle date datatype

eventprefmec Keys

Key Name	Key Type	Keys
EventPrefMec_PK	PrimaryKey	mechtype, evid

eventprefmec Relationships

Parent Relationships:

Entity Name	Type	Cardinality	Business Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype
mec	Non-Identifying	Zero or One to Zero or More				mecid	NO
event	Non-Identifying	Zero or One to Zero or More				evid	NO

Child Relationships:

Entity Name

Type

Cardinality

Business Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

eventprefmec Check Constraints

Check Constraint Name	CheckConstraint
EvPMec01	evid > 0
EvPMec02	mecid > 0
EvPMec03	mechtype IN ('FP','MT')