Stores detailed information about each event in the catalog for the Inland Flood Model for Great Britain (Model 92).
AIREvents Database Documentation
TblModel92 Table
Stores detailed information about each event in the catalog for the Inland Flood Model for Great Britain (Model 92).
| Creation Date | 4/11/2019 3:03 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 3 |
| 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 the area code(s) that were affected by the flood. | varchar | 200 | | |||
| Affected_Streamlink | Total number of stream links that were affected by the event. | float | 9 | | |||
| Affected_Catchment | Total number of catchments that were affected by the event. | float | 9 | | |||
| Duration | Total duration of the event, in hours. | int | 4 | | |||
| Mean_Rainfall | Mean of event rainfall over all affected catchments. Measured in mm/hr. | float | 9 | | |||
| Mean_Runoff | Mean of event rainfall-excess over all affected catchments. Measured in mm/hour. | float | 9 | | |||
| Mean_NormDischarge | Mean of normalized peak flows (normalized by Q2) among affected river links. Because of normalization, this value is dimensionless. | float | 9 | |