Touchstone 4.0 Database Documentation
tUSCity Table
Description
Stores city information for the United States.
Properties
Creation Date2/6/2014 3:05 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows41169
Data Space Used2,568.00 KB
Index Space Used1,648.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key GeographySID

Unique system-generated sequential identifier for the geographic record.

For a complete list of records, see tGeography Table.

Integer4   
 GuidExternalGUID of the boundary as supplied from tblAreaExternalBinary16   
 OldCountryCode

 CLASIC/2 identifier for the country.

SmallInt2   
 CountryCode

ISO 2-character code for the country. 

For a complete list of codes, see tCountry Table.

VarChar15   
 AreaCode

Area code for the city.

For a complete list of codes, see tGeography Table.

VarChar15   
 SubareaCode

Subarea code for the city.

For a complete list of codes, see tGeography Table.

VarChar15   
 PostalCode

Postal code for the city.

For a complete list of codes, see tGeography Table.

VarChar15   
Primary Key CityNameName of the city.VarChar60   
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.