eventprefmec

Logical Entity Name | eventprefmec
Default Table Name | eventprefmec
Definition | Summary information on preferred mechanisms for an event

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