Touchstone 4.0 Database Documentation
tGeoRegion Table
Description
Stores region information.
Properties
Creation Date5/10/2011 11:10 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows10
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key GeoRegionSIDUnique system-generated sequential identifier for the geographic region record.Integer4   
 Region

Region name.

  • 0 = Unknown
  • 1 = North America
  • 2 = Europe
  • 3 = Pacific Rim
  • 4 = South America
  • 5 = Central America
  • 6 = Africa
  • 7 = Asia
  • 8 = Oceania
  • 9 = World
VarChar255  
 DescriptionRegion description, often an abbreviation. For example, CA for Central America. VarChar4000  
 guidExternalGUID of the boundary as supplied from tblAreaExternalBinary16  
 IsUsedInGeoFilter

Indicates whether the region is to be used in a geographic region filter.   

  • 1 = Yes (use in a filter)
  • 0 = No (do not use)
Boolean1  
Objects that depend on tGeoRegion
 Database ObjectObject TypeDescriptionDep Level
tCountryGeoRegionXref tabletCountryGeoRegionXrefTable

System reference table used to map countries to geographic regions.  

1
See Also

Related Objects

AIRGeography 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.