| assoctypecat |
| Logical Entity Name | assoctypecat |
| Default Table Name | assoctypecat |
| Definition | Data associating event types with categories |
| assoctypecat Attributes |
| Attribute/Logical Rolename | Domain | Datatype | NULL | Definition |
etype |
VARCHAR(2) | NO | This attribute is used to identify the type of seismic event | |
catid |
NUMERIC(0, 0) | NO | Category identifier |
| assoctypecat Keys |
| Key Name | Key Type | Keys |
| AssocTypeCatKey01 | PrimaryKey | etype, catid |
| assoctypecat Relationships |
| Parent Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Supertype |
| eventtype | Non-Identifying | One To Zero or More | etype | NO | |||
| eventcategory | Non-Identifying | One To Zero or More | catid | NO |
| Child Relationships: |
| Entity Name | Type | Cardinality | Business Name | VerbPhrase | InversePhrase | Foreign Keys | Is Subtype |
| assoctypecat Check Constraints |
| Check Constraint Name | CheckConstraint |