Touchstone 4.0 Database Documentation
TblAreaModel Table
Description
Stores the mapping between an area and its corresponding model for the current Touchstone version.
Properties
Creation Date1/22/2015 6:44 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows501934
Data Space Used46,504.00 KB
Index Space Used173,144.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key guidUserGUID of the user.Binary16   
 intUserLevel1User's country.SmallInt2   
 strUserLevel2User's area or CRESTA.VarChar15  
 strUserLevel3User's subarea.VarChar15  
 strUserLevel4User's postal code.VarChar15  
 guidModelGUID of the model record.Binary16   
 intModelLevel1Model's country.SmallInt2   
 strModelLevel2Model's area or CRESTA.VarChar15  
 strModelLevel3Model's subarea.VarChar15  
 strModelLevel4Model's postal code.VarChar15  
 tuidSchemePathIdentifier for the area's scheme path code.SmallInt2  
 tuidModelSchemePathIdentifier for the model's scheme path code.SmallInt2  
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.