ULinkContextEvent
METADATA
| Attribute | Value |
|---|---|
| Topic | 5745-tool-core |
| MLink Token | SRLink |
| Product | SRControl |
| accessType | SELECT |
| MLink Endpoint | MLink-Live |
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 |
SELECT TABLE EXAMPLE QUERY
SELECT *
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;