IndustryDefinition
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 | SystemData |
Product | SRAnalytics |
accessType | SELECT |
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 |
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;