Touchstone 4.0 Database Documentation
tEventSetInfo Table
Description

Stores information about the event sets that are available in Touchstone. 

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows7174
Data Space Used328.00 KB
Index Space Used424.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key EventSetSID

Unique system-generated sequential identifier for the event set record.

For a complete list of records, see tEventSet Table.

Integer4   
Primary Key ModelCode

Code that represents the model in Touchstone.

For a complete list of codes, see tModel Table.

UnsignedTinyInt1   
Primary Key CountryCode

ISO 2-character code for the country in which the location resides. 

For a complete list of codes, see tCountry Table.

VarChar15   
 YearYear the event set for the model and country was released.SmallInt2  
 SequenceSequence order.UnsignedTinyInt1  
 Type

Type of event set.

  • STD = Standard
  • ALT = Alternate
  • NEA = Near Term
  • HTI = HERP Time Independent
  • HIS = Historical
  • RDS = Realistic Disaster Scenarios
VarChar10   
Objects that tEventSetInfo depends on
 Database ObjectObject TypeDescriptionDep Level
tEventSet tabletEventSetTable

Stores the event sets that are available in Touchstone. 

1
See Also

Related Objects

AIRUserSetting Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.