Touchstone 4.0 Database Documentation
tScript Table
Description

Stores the script used when dynamically creating databases.

The content of the script is available in tScriptContent Table.

Properties
Creation Date12/8/2011 10:47 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows1753
Data Space Used208.00 KB
Index Space Used184.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ScriptSIDUnique system-generated sequential identifier for the script record.Integer4   
 ScriptTypeCode

Code that represents the script file type.

For a complete list of codes, see tScriptType Table.

VarChar10   
 DataSourceTypeCode

Code that represents the data source type.

For a complete list of codes, see tDataSourceType Table.

VarChar10   
 NameName of the script.VarChar255   
 VersionVersion of the script.VarChar10   
 CodeVersionVersion number for the code.VarChar10   
 ReleasedDateDate and time when the script will be released for use.DBTimeStamp4   
 ParentScriptSID

Unique system-generated sequential identifier for the parent script record.

For a complete list of records, see the ScriptSID column.

Integer4  
 SeqNumOrder number of the script. For example, 2 means that this is the second script to be executed in the script order.SmallInt2   
 DescriptionDescription of the script.VarChar4000  
 IsActive

Indicates whether the script is in use.

  • 1 = Yes (in use)
  • 0 = No (script is deprecated)
Boolean1 
((1))
 
 EnteredDateDate and time when the script was created.DBTimeStamp4 
(getutcdate())
 
 EditedDateDate and time when the script was last modified.DBTimeStamp4 
(getutcdate())
 
 ExistingVersionReserved for future use.VarChar10  
 ExistingCodeVersionReserved for future use.VarChar10  
Check Constraints
NameDescriptionExpression
CKC_ISACTIVE_TSCRIPT 
([IsActive]>=(0) AND [IsActive]<=(1))
Objects that depend on tScript
 Database ObjectObject TypeDescriptionDep Level
tScriptContent tabletScriptContentTable

Stores the content of the script used when dynamically creating databases. 

Information regarding the script is available in tScript Table.

1
See Also

Related Objects

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