Scout Database Model (CR)
Table: ServerAction
Server 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 |
---|---|---|---|---|---|
ServerActionID | INTEGER IDENTITY(1,1) | PK | NN | Unique ID of server action entry | |
Type | INTEGER | NN | |||
ServerID | INTEGER | (FK) | NN | Target server of the action Refers to EntityID of table Entity | |
StartTime | INTEGER | NN | |||
MemberType | INTEGER | ||||
MemberID | INTEGER | ||||
RequestingConsole | 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 | ||||
LongStringParameter | NVARCHAR(max) | ||||
ReservedString1 | NVARCHAR(255) | ||||
ReservedString2 | NVARCHAR(255) | ||||
ReservedInt1 | INTEGER | ||||
ReservedInt2 | INTEGER |
IndexName | IndexType | Columns |
---|---|---|
PRIMARY | PRIMARY | ServerActionID |
How to create
CREATE TABLE ServerAction(
ServerActionID INTEGER NOT NULL,
Type INTEGER NOT NULL,
ServerID INTEGER,
StartTime INTEGER NOT NULL,
MemberType INTEGER,
MemberID INTEGER,
RequestingConsole 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,
LongStringParameter NVARCHAR(max),
ReservedString1 NVARCHAR(255),
ReservedString2 NVARCHAR(255),
ReservedInt1 INTEGER,
ReservedInt2 INTEGER,
PRIMARY KEY (ServerActionID));
Table: ServerAction
In this article
Copied!
Failed!