OptionFlexText
METADATA
| Attribute | Value |
|---|---|
| Topic | 2750-market-data-options |
| MLink Token | OptFlexPrint |
| Product | SRFlex |
| accessType | SELECT |
| MLink Endpoint | MLink-Live |
Table Definition
| Field | Type | Key | Default Value | Comment |
|---|---|---|---|---|
| recordId | CHAR(19) | PRI | '0000-0000-0000-0000' | unique FLEX text key guid |
| optExch | enum - OptExch | 'None' | OPRA participant | |
| text | TINYTEXT | '' | complete OPRA FLEX text line | |
| eventType | enum - FlexEventType | 'None' | type of event this message represents eg RFQ QTE LST | |
| parseError | TINYTEXT | '' | text parse error if any | |
| eventId | CHAR(19) | '0000-0000-0000-0000' | OpraFlexEventeventId this message is associated with if parsed | |
| netTimestamp | BIGINT | 0 | timestamp of when this message was received | |
| srcTimestamp | BIGINT | 0 | timestamp from the exchange of when this message was sent |
PRIMARY KEY DEFINITION (Unique)
| Field | Sequence |
|---|---|
| recordId | 1 |
SELECT TABLE EXAMPLE QUERY
SELECT *
FROM `SRFlex`.`MsgOptionFlexText`
WHERE
/* Replace with a CHAR(19) */
`recordId` = 'Example_recordId';
Doc Columns Query
SELECT * FROM SRFlex.doccolumns WHERE TABLE_NAME='OptionFlexText' ORDER BY ordinal_position ASC;