Touchstone 4.0 Database Documentation
TblAreaSchemePath Table
Description
Stores the scheme path definition, including its chain.
Properties
Creation Date9/8/2004 2:11 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows137
Data Space Used16.00 KB
Index Space Used80.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key tuidSchemePathIdentifier for the area scheme path code.SmallInt2   
 strNameName of the area scheme path.VarChar30   
 strDescDescription of the area scheme path.VarChar100  
 tuidSchemeL0Schema for the region.SmallInt2   
 tuidSchemeL1Schema for the country.SmallInt2 
(0)
 
 tuidSchemeL2Schema for the area or CRESTA.SmallInt2 
(0)
 
 tuidSchemeL3Schema for the subarea.SmallInt2 
(0)
 
 tuidSchemeL4Schema for the postal code.SmallInt2 
(0)
 
 tuidSchemePathL0Scheme path for the region.SmallInt2  
 tuidSchemePathL1Scheme path for the country.SmallInt2  
 tuidSchemePathL2Scheme path for the area or CRESTA.SmallInt2  
 tuidSchemePathL3Scheme path for the subarea.SmallInt2  
 tuidSchemePathL4Scheme path for the postal code.SmallInt2  
 tuidUserSchemeL3Users's scheme path for the subarea, for use with legacy code. When tuidSchemePathL3 contains a postal code, this value is usually 0.SmallInt2  
 tuidUserSchemeL4User's scheme path for the postal code, for use with legacy code. When tuidSchemePathL3 contains a postal code, the postal code is included in this field as well.  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.