assoctypecat

Logical Entity Name | assoctypecat
Default Table Name | assoctypecat
Definition | Data associating event types with categories

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