Stores detailed information about each event in the catalog for the Canada Severe Thunderstorm Model (Model 26)
AIREvents Database Documentation
TblModel26 Table
| Creation Date | 2/23/2022 12:17 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 5 |
| 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. HIST = Historical | 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. | varchar | 200 | | |||
| StartDate | Day (within the Year) that the event began. | int | 4 | | |||
| EndDate | Day (within the Year) that the event ended. | int | 4 | | |||
| TornCount | Total number of tornadoes that were a source of damage during the event. | int | 4 | | |||
| HailCount | Total number of hail storms that were a source of damage during the event. | int | 4 | | |||
| WindCount | Total number of wind storms that were a source of damage during the event. | int | 4 | | |||
| TornLossPct | Total percentage of industry loss caused by tornado damage during this event. | int | 4 | | |||
| HailLossPct | Total percentage of industry loss caused by hail damage during this event. | int | 4 | | |||
| WindLossPct | Total percentage of industry loss caused by wind damage during this event. | int | 4 | |