ULinkContextGateway

V8 Message Definiton

METADATA

Attribute	Value
Topic	5120-srse-gateway
MLink Token	Internal
Product	SRControl
accessType	SELECT,UPDATE,INSERT,DELETE

Table Definition

Field	Type	Key	Default Value	Comment
userName	VARCHAR(24)	PRI	''
clientFirm	VARCHAR(16)		''
accnt	VARCHAR(16)		''	most recent SR accnt optional
ticker_at	enum - AssetType		'None'	most recent symbol optional
ticker_ts	enum - TickerSrc		'None'	most recent symbol optional
ticker_tk	VARCHAR(12)		''	most recent symbol optional
source	VARCHAR(16)		''	source tool name eg SV CT BBLink SRSE etc
ulinkEvent	VARCHAR(8)		''	ulink event eg F1 F2 Enter etc if any
ulinkDetail	TINYTEXT		''	additional ulink context detail if any
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'	timestamp of ulink initiation

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
userName	1

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRControl`.`MsgULinkContextGateway` (
    `userName` VARCHAR(24) NOT NULL DEFAULT '',
    `clientFirm` VARCHAR(16) NOT NULL DEFAULT '',
    `accnt` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'most recent SR accnt (optional)',
    `ticker_at` ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') NOT NULL DEFAULT 'None' COMMENT 'most recent symbol (optional)',
    `ticker_ts` ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') NOT NULL DEFAULT 'None' COMMENT 'most recent symbol (optional)',
    `ticker_tk` VARCHAR(12) NOT NULL DEFAULT '' COMMENT 'most recent symbol (optional)',
    `source` VARCHAR(16) NOT NULL DEFAULT '' COMMENT 'source tool name (eg. SV, CT, BBLink, SRSE, etc)',
    `ulinkEvent` VARCHAR(8) NOT NULL DEFAULT '' COMMENT 'ulink event (eg: F1, F2, Enter, etc) (if any)',
    `ulinkDetail` TINYTEXT NOT NULL DEFAULT '' COMMENT 'additional ulink context detail (if any)',
    `timestamp` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000' COMMENT 'timestamp of ulink initiation',
    PRIMARY KEY USING HASH (`userName`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='';

SELECT TABLE EXAMPLE QUERY

SELECT
    `userName`,
    `clientFirm`,
    `accnt`,
    `ticker_at`,
    `ticker_ts`,
    `ticker_tk`,
    `source`,
    `ulinkEvent`,
    `ulinkDetail`,
    `timestamp`
FROM `SRControl`.`MsgULinkContextGateway`
WHERE 
    /* Replace with a VARCHAR(24) */ 
    `userName` = 'Example_userName';

UPDATE TABLE EXAMPLE QUERY

UPDATE `SRControl`.`MsgULinkContextGateway` 
SET
    /* Replace with a VARCHAR(16) */ 
    `clientFirm` = 'Example_clientFirm',
    /* Replace with a VARCHAR(16) */ 
    `accnt` = 'Example_accnt',
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */ 
    `ticker_at` = 'None',
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */ 
    `ticker_ts` = 'None',
    /* Replace with a VARCHAR(12) */ 
    `ticker_tk` = 'Example_ticker_tk',
    /* Replace with a VARCHAR(16) */ 
    `source` = 'Example_source',
    /* Replace with a VARCHAR(8) */ 
    `ulinkEvent` = 'Example_ulinkEvent',
    /* Replace with a TINYTEXT */ 
    `ulinkDetail` = 'dummy tiny text',
    /* Replace with a DATETIME(6) */
    `timestamp` = '2022-01-01 12:34:56.000000'
WHERE
    /* Replace with a VARCHAR(24) */ 
    `userName` = 'Example_userName';

INSERT TABLE EXAMPLE QUERY

INSERT INTO `SRControl`.`MsgULinkContextGateway`(
    /* Replace with a VARCHAR(24) */ 
    `userName`,
    /* Replace with a VARCHAR(16) */ 
    `clientFirm`,
    /* Replace with a VARCHAR(16) */ 
    `accnt`,
    /* Replace with a ENUM('None','EQT','IDX','BND','CUR','COM','FUT','SYN','WAR','FLX','MUT','SPD','MM','MF','COIN','TOKEN','ANY') */ 
    `ticker_at`,
    /* Replace with a ENUM('None','SR','NMS','CME','ICE','CFE','CBOT','NYMEX','COMEX','RUT','CIDX','ARCA','NYSE','OTC','NSDQ','MFQS','MIAX','DJI','CUSIP','ISIN','BXE','EUX','ANY','CXE','DXE','NXAM','NXBR','NXLS','NXML','NXOS','NXP','EUREX','CEDX','ICEFE') */ 
    `ticker_ts`,
    /* Replace with a VARCHAR(12) */ 
    `ticker_tk`,
    /* Replace with a VARCHAR(16) */ 
    `source`,
    /* Replace with a VARCHAR(8) */ 
    `ulinkEvent`,
    /* Replace with a TINYTEXT */ 
    `ulinkDetail`,
    /* Replace with a DATETIME(6) */
    `timestamp`
) 
VALUES(
    'Example_userName',
    'Example_clientFirm',
    'Example_accnt',
    'None',
    'None',
    'Example_ticker_tk',
    'Example_source',
    'Example_ulinkEvent',
    'dummy tiny text',
    '2022-01-01 12:34:56.000000'
);

DELETE TABLE EXAMPLE QUERY

DELETE FROM `SRControl`.`MsgULinkContextGateway` 
WHERE
    /* Replace with a VARCHAR(24) */ 
    `userName` = 'Example_userName';

Doc Columns Query

SELECT * FROM SRControl.doccolumns WHERE TABLE_NAME='ULinkContextGateway' ORDER BY ordinal_position ASC;