Stores detailed information about each event in the catalog for the Earthquake Model for South America (Model 70).
AIREvents Database Documentation
TblModel70 Table
| Creation Date | 4/11/2019 3:03 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 109 |
| Data Space Used | 24.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 represent 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 country 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) | | |||
| EQ_Source_Type | Source of the event.
| varchar | 200 | | |||
| EQ_Fault_Name | When EQ_Source_Type is Crustal Fault or Subduction-Fault, this identifies the name of the fault associated with the event. Otherwise this field is not applicable. | varchar | 200 | | |||
| 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 | | |||
| TsunamiEvent | Indicates whether this event triggered a tsunami.
| char | 1 | |