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));