Stores detailed information about each event in the catalog for the Earthquake Model for Mexico (Model 72).
AIREvents Database Documentation
TblModel72 Table
| Creation Date | 4/11/2019 3:03 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 6 |
| Data Space Used | 8.00 KB |
| Index Space Used | 8.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| Actual_Year | Year the event occurred. | int | 4 |  | |||
| Event_Name | Name of the event. | varchar | 255 | | |||
| Catalog_Type | Code that represents the catalog type.
| varchar | 4 | | |||
| EventID | Unique system-provided identifier for the event. | int | 4 | | |||
| ModelID | Code that represents the model. | int | 4 | | |||
| Event | Identifier of the event. | int | 4 | | |||
| Year | Year in the catalog that the event occurred. | int | 4 | | |||
| Day | Day (within the Year) that the event occurred. | int | 4 | | |||
| EventDescription | Name/description of the event. Note that the description includes both the magnitude and the area code(s) affected by the earthquake. For more information regarding the specific area affected by an event, see fields:
| varchar | 200 | | |||
| EQ_Depth | Depth of the earthquake's epicenter, measured in kilometers. | numeric | 9 (6,1) | | |||
| Epicenter | Indicates whether the epicenter occurred inland or offshore.
| char | 1 | | |||
| Magnitude | Moment magnitude value for the strength of the earthquake at its epicenter. | numeric | 9 (6,3) | | |||
| Longitude | Longitude coordinate where the epicenter of the event occurred. Values will be negative for locations west of the prime meridian up to the international date line. They will be positive for locations east of the prime meridian. | numeric | 9 (8,3) | | |||
| Latitude | Latitude coordinate where the epicenter of the event occurred. Values will be positive for locations north of the equator and negative south of the equator. | numeric | 9 (8,3) | | |||
| AreaName | Area where the event occurred. | varchar | 60 | | |||
| SubAreaName | Subarea where the event occurred. | varchar | 60 | |