AccountConfigRiskTemplate

V8 Message Definiton

METADATA

Attribute	Value
Topic	5120-srse-gateway
MLink Token	ConfigGateway
Product	SRConfigGateway
accessType	SELECT,UPDATE,INSERT,DELETE
MLink Endpoint	MLink-Live

Table Definition

Field	Type	Key	Default Value	Comment
templateName	VARCHAR(32)	PRI	''
clientFirm	VARCHAR(16)	PRI	''
RiskLevelList	JSON		'JSON_ARRAY()'

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
templateName	1
clientFirm	2

JSON Block (RiskLevelList)

Field	Type	Comment
riskLevel	enum - MarRiskLevel
customGroup	enum - customGroup

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRConfigGateway`.`MsgAccountConfigRiskTemplate` (
    `templateName` VARCHAR(32) NOT NULL DEFAULT '',
    `clientFirm` VARCHAR(16) NOT NULL DEFAULT '',
    `RiskLevelList` JSON NOT NULL DEFAULT JSON_ARRAY() CHECK(JSON_VALID(RiskLevelList)),
    PRIMARY KEY USING HASH (`templateName`,`clientFirm`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='';

SELECT TABLE EXAMPLE QUERY

SELECT
    `templateName`,
    `clientFirm`,
    `RiskLevelList`
FROM `SRConfigGateway`.`MsgAccountConfigRiskTemplate`
WHERE 
    /* Replace with a VARCHAR(32) */ 
    `templateName` = 'Example_templateName'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm';

UPDATE TABLE EXAMPLE QUERY

UPDATE `SRConfigGateway`.`MsgAccountConfigRiskTemplate` 
SET
    /* Replace with a JSON */
    `RiskLevelList` = '{"key": "value"}'
WHERE
    /* Replace with a VARCHAR(32) */ 
    `templateName` = 'Example_templateName'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm';

INSERT TABLE EXAMPLE QUERY

INSERT INTO `SRConfigGateway`.`MsgAccountConfigRiskTemplate`(
    /* Replace with a VARCHAR(32) */ 
    `templateName`,
    /* Replace with a VARCHAR(16) */ 
    `clientFirm`,
    /* Replace with a JSON */
    `RiskLevelList`
) 
VALUES(
    'Example_templateName',
    'Example_clientFirm',
    '{"key": "value"}'
);

DELETE TABLE EXAMPLE QUERY

DELETE FROM `SRConfigGateway`.`MsgAccountConfigRiskTemplate` 
WHERE
    /* Replace with a VARCHAR(32) */ 
    `templateName` = 'Example_templateName'
  AND
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm';

Doc Columns Query

SELECT * FROM SRConfigGateway.doccolumns WHERE TABLE_NAME='AccountConfigRiskTemplate' ORDER BY ordinal_position ASC;