Stores information about the catalogs that contain custom, user-defined events.
For more information about the AIR-provided catalogs, see tCatalog Table.
Touchstone 2022 Database Reference
tCatalogDetail Table
Stores information about the catalogs that contain custom, user-defined events.
For more information about the AIR-provided catalogs, see tCatalog Table.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | 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. | int | 4 | |||
| | EventID | Identifier for the custom, user-defined event. | int | 4 | |||
| EventName | Name of the custom, user-defined event. | varchar | 1000 | ||||
| Address | Street address where the event occurred. | varchar | 255 |  | |||
| City | City where the event occurred. | varchar | 255 | | |||
| CountryCode | ISO 2-character code for the country in which the location resides. For a complete list of codes, see tCountry Table. | varchar | 15 | ('') | |||
| 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. | varchar | 15 | ('') | |||
| AreaCode | Area code for where the event occurred. For a complete list of codes, see tGeography Table. | varchar | 15 | ||||
| SubareaCode | Subarea code for where the event occurred. For a complete list of codes, see tGeography Table. | varchar | 15 | ('') | |||
| PostalCode | Postal code for where the event occurred. For a complete list of codes, see tGeography Table. | varchar | 15 | | |||
| Latitude | Latitude coordinate for where the event occurred. Values will be positive for locations north of the equator and negative south of the equator. | numeric | 9 (9,6) | ||||
| Longitude | Longitude 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. | numeric | 9 (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. | varchar | 10 | | |||
| TerrorismWeaponType | Name of the weapon type used in the terrorism event. | varchar | 40 | | |||
| Stories | Number of stories in the building where the event occurred. | smallint | 2 | | |||
| 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. | int | 4 | | |||
| Landmark | Name of the landmark. | varchar | 255 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tCatalog | Table | Stores information about the catalogs available in Touchstone. Information regarding catalogs that contain custom, user-defined event footprints is available in tCatalogDetail Table. | 1 |