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