Touchstone 4.0 Database Documentation
tCatalogDetail Table
Description

AreaStores information about the catalogs that contain custom, user-defined events.

Information regarding the AIR-provided catalogs is available in tCatalog Table.

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

Unique system-generated sequential identifier for the record of the catalog containing custom, user-defined event footprints.

For a complete list of records, see tCatalog Table.

Integer4   
Primary Key EventIDIdentifier for the custom, user-defined event.Integer4   
 EventNameName of the custom, user-defined event.VarChar1000   
 AddressStreet address where the event occurred.VarChar255  
 City

City where the event occurred.

VarChar255  
 CountryCode

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

For a complete list of codes, see tCountry Table.

VarChar15 
('')
 
 CRESTACode

CRESTA code for the location, when applicable. If CRESTA is not applicable for this country,use the AreaCode column.

For a complete list of codes, see tGeography Table.

VarChar15 
('')
 
 AreaCode

Area code for where the event occurred.

For a complete list of codes, see tGeography Table.

VarChar15   
 SubareaCode

Subarea code for where the event occurred.

For a complete list of codes, see tGeography Table.

VarChar15 
('')
 
 PostalCode

Postal code for where the event occurred.

For a complete list of codes, see tGeography Table.

VarChar15  
 LatitudeLatitude coordinate for where the event occurred.  Values will be positive for locations north of the equator and negative south of the equator.Numeric9 (9,6)   
 LongitudeLongitude coordinate for where the event occurred.  Values will be negative for locations west of the prime meridian up to the international date line. They will be positive for locations east of the prime meridian.Numeric9 (9,6)   
 TerrorismWeaponTypeCode

Code that represents the weapon type used during the user-defined terrorism event.

For a complete list of codes, see tEventFilterTerrorismWeaponType Table.

VarChar10  
 TerrorismWeaponTypeName of the weapon type used in the terrorism event.VarChar40  
 StoriesNumber of stories in the building where the event occurred.SmallInt2  
 LandmarkSID

Unique system-generated sequential identifier for the landmark record that was affected by the user-defined event.

For a complete list of records, see TblProminentLandmarks Table.

Integer4  
 LandmarkName of the landmark.VarChar255  
Objects that tCatalogDetail depends on
 Database ObjectObject TypeDescriptionDep Level
tCatalog tabletCatalogTable

Stores information about the catalogs available in Touchstone. 

Information regarding catalogs that contain custom, user-defined event footprints is available in tCatalogDetail Table.

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.