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: System

System properties are stored as a combination of parameter name and value. It is highly recommended not to change any entry.

ColumnName DataType Key Not Null Default Value Comment
SystemID INTEGER PK NN    
ParamName NVARCHAR(255)   NN    
ParamVal NVARCHAR(255)   NN    
IndexName IndexType Columns
PRIMARY PRIMARY SystemID

How to create

CREATE TABLE System( SystemID INTEGER NOT NULL, ParamName NVARCHAR(255) NOT NULL, ParamVal NVARCHAR(255) NOT NULL, PRIMARY KEY (SystemID));
Table: System