Unicon documentation migration is in progress. You might find some broken links or experience minor issues in the documentation. We are working on resolving these issues.

X

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