Skip to main content
Version: 8.4.08.4

IndustryDefinition

V8 Message Definiton

This table contains the definitions of ind (00), sub (0000), grp (000000), and nbr (00000000) numeric codes are used in the SpiderRock platform.

METADATA

AttributeValue
Topic4335-product-definition
MLink TokenSystemData
ProductSRAnalytics
accessTypeSELECT

Table Definition

FieldTypeKeyDefault ValueComment
codeINTPRI0
indTypeenum - IndType'None'
nameTINYTEXT''
timestampDATETIME(6)'1900-01-01 00:00:00.000000'record update timestamp

PRIMARY KEY DEFINITION (Unique)

FieldSequence
code1

CREATE TABLE EXAMPLE QUERY

CREATE TABLE `SRAnalytics`.`MsgIndustryDefinition` (
`code` INT NOT NULL DEFAULT 0,
`indType` ENUM('None','Ind','Sub','Grp','Nbr') NOT NULL DEFAULT 'None',
`name` TINYTEXT NOT NULL DEFAULT '',
`timestamp` DATETIME(6) NOT NULL DEFAULT '1900-01-01 00:00:00.000000' COMMENT 'record update timestamp',
PRIMARY KEY USING HASH (`code`)
) ENGINE=SRSE DEFAULT CHARSET=LATIN1 COMMENT='This table contains the definitions of ind (00), sub (0000), grp (000000), and nbr (00000000) numeric codes are used in the SpiderRock platform.';

SELECT TABLE EXAMPLE QUERY

SELECT
`code`,
`indType`,
`name`,
`timestamp`
FROM `SRAnalytics`.`MsgIndustryDefinition`
WHERE
/* Replace with a INT */
`code` = 5;

Doc Columns Query

SELECT * FROM SRAnalytics.doccolumns WHERE TABLE_NAME='IndustryDefinition' ORDER BY ordinal_position ASC;