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

Attribute	Value
Topic	4335-product-definition
MLink Token	Internal
Product	SRAnalytics
accessType	SELECT
MLink Endpoint	MLink-Live

Table Definition

Field	Type	Key	Default Value	Comment
code	INT	PRI	0
indType	enum - IndType		'None'
name	TINYTEXT		''
timestamp	DATETIME(6)		'1900-01-01 00:00:00.000000'	record update timestamp

PRIMARY KEY DEFINITION (Unique)

Field	Sequence
code	1

SELECT TABLE EXAMPLE QUERY

SELECT *
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;