Table: SAPTemplate

To allow working with application templates, application template tables are provided. They contain the same fields as the application tables.

ColumnName DataType Key Not Null Default Value Comment
ApplicationTemplateID INTEGER PK, FK NN   Unique application template ID (foreign key refers to table ApplicationTemplate)
SapClassic SMALLINT(6)       Use classic look and feel
0|1
ReservedString1 NVARCHAR(255)        
ReservedString2 NVARCHAR(255)        
ReservedInt1 INTEGER        
ReservedInt2 INTEGER        
IndexName IndexType Colums
PRIMARY PRIMARY ApplicationTemplateID

 

how to create

CREATE TABLE SAPTemplate(
ApplicationTemplateID INTEGER NOT NULL,
SapClassic SMALLINT,
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
CONSTRAINT FK_BrowserTemplate_ApplicationTemplateID_ApplicationTemplate_ApplicationTemplateID FOREIGN KEY (ApplicationTemplateID) REFERENCES ApplicationTemplate (ApplicationTemplateID),
PRIMARY KEY (ApplicationTemplateID ));