Stores detailed information about each event in the catalog for the Pandemic Model (Model 81).
AIREvents Database Documentation
TblModel81 Table
| Creation Date | 4/11/2019 3:03 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 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. | varchar | 200 | | |||
| Transmissibility_R0 | The transmissibility of the disease (how easily it spreads from person to person). | numeric | 9 (18,4) | | |||
| CaseFatalityRatio_CFR | The case fatality ratio or virulence (the severity of the illness). | numeric | 9 (18,9) | | |||
| AgeProfile | The age group most affected by the event.
| char | 1 | | |||
| Top5CountriesAffected | Top five countries that were most affected by the event. | varchar | 14 | | |||
| Disease_Type | Disease type associated with the event. | char | 6 | |