AIREvents Database Documentation
TblModel43 Table
AIREventsHistorical Database : TblModel43 Table
Description

Stores detailed information about each event in the catalog for the Severe Thunderstorm Model for Europe (Model 43).

Countries modeled include Austria, Belgium, Czech Republic, Denmark, Estonia, Finland, France, Monaco, Germany, Hungary, Ireland, Latvia, Liechtenstein, Lithuania, Luxembourg, Netherlands, Norway, Poland, Slovakia, Slovenia, Sweden, Switzerland, and the United Kingdom.

Properties
Creation Date4/11/2019 3:03 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows11
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
 Year the event occurred.int4  
 Name of the event.varchar255  
 

Code that represents the catalog type.

  • HIST = Historical
  • EDS = Extreme Disaster Scenarios
  • RDS = Lloyd's Realistic Disaster Scenarios
  • GOVT = Government
varchar4  
 Unique system-provided identifier for the event.int4  
 Code that represents the model.int4  
 Identifier for the event.int4  
 Year in the catalog that the event occurred.int4  
 Day (within the Year) that the event occurred.int4  
 

Description of the event.

Note that the descripton includes the area codes affected by the event.

varchar200  
 Day (within the Year) that the event began.int4  
 Day (within the Year) that the event ended.int4  
 Total number of tornadoes that were a source of damage during the event.int4  
 Total number of hail storms that were a source of damage during the event.int4  
 Total number of wind storms that were a source of damage during the event.int4  
See Also

Related Objects

AIREventsHistorical Database