Table: SAP

Each entry describes an application of type APPLTYPE_SAPGUI.

ColumnName DataType Key Not Null Default Value Comment
ApplicationID INTEGER PK, FK NN   Unique application ID (foreign key refers to table Application)
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 ApplicationID

 

how to create

CREATE TABLE SAP(
ApplicationID INTEGER NOT NULL,
SapClassic SMALLINT,
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
CONSTRAINT FK_SAP_ApplicationID_Application_ApplicationID FOREIGN KEY (ApplicationID) REFERENCES Application (ApplicationID),
PRIMARY KEY (ApplicationID));