Touchstone 4.0 Database Documentation
tCatalog Table
Description

Stores information about the catalogs available in Touchstone. 

Information regarding catalogs that contain custom, user-defined event footprints is available in tCatalogDetail Table.

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows286
Data Space Used56.00 KB
Index Space Used64.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key CatalogSID

Unique system-generated sequential identifier for the catalog record.

Integer4   
 BusinessUnitSID

Unique system-generated sequential identifier for the business unit.

Integer4   
 CatalogTypeCode

Code that represents the catalog type.

For a complete list of codes, see tCatalogType Table.

VarChar10   
 CatalogName of the catalog.VarChar255   
 VersionVersion number of the catalog.VarChar20   
 ModelCode

Code that represents the model in Touchstone.

For a complete list of codes, see tModel Table.

UnsignedTinyInt1   
 ModelVersionVersion number of the model.VarChar20   
 YearMaxMaximum number of years in the catalog.Integer4   
 YearCount

Total number of simulated years in the catalog.

Note that "year" in this context represent simulation years only and do not represent an actual date

Integer4   
 EventMaxMaximum number of simulated events in the catalog.Integer4   
 EventCountTotal number of simulated events in the catalog.Integer4   
 BaseNameFormatted name of the catalog.VarChar255  
 EnteredDateDate and time when the catalog was created.VarWChar10 
(getutcdate())
 
 EditedDateDate and time when the catalog was last modified.VarWChar10 
(getutcdate())
 
 StatusCode

System-provided status code for the record in the table. 

For a complete list of codes, see dbo.tStatus Table.

VarChar10 
('A')
 
Objects that depend on tCatalog
 Database ObjectObject TypeDescriptionDep Level
tCatalogDetail tabletCatalogDetailTable

AreaStores information about the catalogs that contain custom, user-defined events.

Information regarding the AIR-provided catalogs is available in tCatalog Table.

1
tEventSetCatalogXref tabletEventSetCatalogXrefTableSystem reference table used to identify the events sets that are associated with specific catalogs.1
See Also

Related Objects

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