ULinkContextEvent

V8 Message Definiton

METADATA

Attribute	Value
Topic	5745-tool-core
MLink Token	SystemData
Product	SRControl
accessType	SELECT

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`.`MsgULinkContextEvent` (
    `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','ESX','ANY','CXE','DXE','NXAM','NXBR','NXDUB','NXLS','NXLDN','NXML','NXMLT','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`.`MsgULinkContextEvent`
WHERE 
    /* Replace with a VARCHAR(24) */ 
    `userName` = 'Example_userName';

Doc Columns Query

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