assoctypecat Columns

ColumnName	Domain	Datatype	NULL	Definition
etype		VARCHAR2(2)	NO	This attribute is used to identify the type of seismic event
catid		NUMBER	NO	Category identifier

assoctypecat Primary and Unique Keys

Key Name	Key Type	Keys
AssocTypeCatKey01	PrimaryKey	etype, catid

assoctypecat Foreign Keys

Parent Relationships:

Table Name	Type	Cardinality	Constraint Name	VerbPhrase	InversePhrase	Foreign Keys	Is Supertype	Deferrable	Initially Deferred
eventcategory	Non-Identifying	One To Zero or More				catid	NO	NO	NO
eventtype	Non-Identifying	One To Zero or More				etype	NO	NO	NO

Child Relationships:

Table Name

Type

Cardinality

Constraint Name

VerbPhrase

InversePhrase

Foreign Keys

Is Subtype

Deferrable

Initially Deferred

assoctypecat Check Constraints

Check Constraint Name

CheckConstraint