OpraPrintType

V8 Message Definiton

METADATA

Attribute	Value
Topic	2750-market-data-options
MLink Token	OptionDefinition
Product	SRLive
accessType	SELECT
MLink Endpoint	MLink-Live

Table Definition

Field	Type	Key	Default Value	Comment
opraPrintType	TINYINT UNSIGNED	PRI	0
printTypeChar	VARCHAR(1)		''	character value of printType
printCode	VARCHAR(4)		''	eg AUTO CANC
printCodeString	TINYTEXT		''	longer string
printCodeDescription	TINYTEXT		''	full description

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
opraPrintType	1

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRLive`.`MsgOpraPrintType` (
    `opraPrintType` TINYINT UNSIGNED NOT NULL DEFAULT 0,
    `printTypeChar` VARCHAR(1) NOT NULL DEFAULT '' COMMENT 'character value of printType',
    `printCode` VARCHAR(4) NOT NULL DEFAULT '' COMMENT 'eg, AUTO, CANC',
    `printCodeString` TINYTEXT NOT NULL DEFAULT '' COMMENT 'longer string',
    `printCodeDescription` TINYTEXT NOT NULL DEFAULT '' COMMENT 'full description',
    PRIMARY KEY USING HASH (`opraPrintType`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='';

SELECT TABLE EXAMPLE QUERY

SELECT
    `opraPrintType`,
    `printTypeChar`,
    `printCode`,
    `printCodeString`,
    `printCodeDescription`
FROM `SRLive`.`MsgOpraPrintType`
WHERE 
    /* Replace with a TINYINT UNSIGNED */ 
    `opraPrintType` = 1;

Doc Columns Query

SELECT * FROM SRLive.doccolumns WHERE TABLE_NAME='OpraPrintType' ORDER BY ordinal_position ASC;