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