eventprefmag Columns

ColumnName	Domain	Datatype	NULL	Definition
magtype		VARCHAR2(6)	NO	Magnitude type. This character string is used to specify the type of the magnitude measure
evid		NUMBER(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
magid		NUMBER(15, 0)	NO	Magnitude identifier. This key is used to identify a magnitude in the Netmag relation. It is required for every magnitude
lddate		DATE	YES	Load date. Date and time that the record was created, in Oracle date datatype

eventprefmag Primary and Unique Keys

Key Name	Key Type	Keys
EventPrefMag_PK	PrimaryKey	magtype, evid

eventprefmag Foreign Keys

Parent Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype	Deferrable	Initially Deferred
event	Non-Identifying	One To Zero or More	Epm_Eve			evid	NO	NO	NO
netmag	Non-Identifying	One To Zero or More	Epm_Net			magid	NO	NO	NO

Child Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Deferrable

Initially Deferred

eventprefmag Check Constraints

Check Constraint Name	CheckConstraint
EventPrefMag_CHKTYP	magtype in ('p','a','b','e','l','l1','l2','lg','c','s','w','z','B', 'un','d','h','n','dl','lr')