Scout Database Model (CR)
Table: ConsoleAction
Console actions are a integral part of the internal communications between Scout components. Table entries should never be manually added, removed or changed.
ColumnName | DataType | Key | Not Null | Default Value | Comment |
---|---|---|---|---|---|
ConsoleActionID | INTEGER IDENTITY(1,1) | PK | NN | Unique ID of console action entry | |
Type | INTEGER | NN | |||
ConsoleID | INTEGER | (FK) | NN | Target console of the action (refers to EntityID of table Entity) | |
MemberType | INTEGER | ||||
MemberID | INTEGER | ||||
StringParameter | NVARCHAR(255) | ||||
IntParameter | INTEGER | ||||
StringParameter2 | NVARCHAR(255) | ||||
IntParameter2 | INTEGER | ||||
StringParameter3 | NVARCHAR(255) | ||||
IntParameter3 | INTEGER | ||||
StringParameter4 | NVARCHAR(255) | ||||
IntParameter4 | INTEGER | ||||
StringParameter5 | NVARCHAR(255) | ||||
IntParameter5 | INTEGER | ||||
IntParameter6 | INTEGER | ||||
IntParameter7 | INTEGER | ||||
IntParameter8 | INTEGER | ||||
ReservedString1 | NVARCHAR(255) | ||||
ReservedString2 | NVARCHAR(255) | ||||
ReservedInt1 | INTEGER | ||||
ReservedInt2 | INTEGER |
IndexName | IndexType | Columns |
---|---|---|
PRIMARY | PRIMARY | ConsoleActionID |
How to create
CREATE TABLE ConsoleAction(
ConsoleActionID INTEGER NOT NULL,
Type INTEGER NOT NULL,
ConsoleID INTEGER,
MemberType INTEGER,
MemberID INTEGER,
StringParameter NVARCHAR(255),
IntParameter INTEGER,
StringParameter2 NVARCHAR(255),
IntParameter2 INTEGER,
StringParameter3 NVARCHAR(255),
IntParameter3 INTEGER,
StringParameter4 NVARCHAR(255),
IntParameter4 INTEGER,
StringParameter5 NVARCHAR(255),
IntParameter5 INTEGER,
IntParameter6 INTEGER,
IntParameter7 INTEGER,
IntParameter8 INTEGER,
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
PRIMARY KEY (ConsoleActionID));
Table: ConsoleAction
In this article
Copied!
Failed!