This is an old revision of the document!
Table of Contents
Description
Table: companyinfor stores basic information of listed companies.
Data Scheme
Field | Type | NULL | Key | Default |
---|---|---|---|---|
Stkcd | MEDIUMINT(9) | -1 | ||
Id | SMALLINT(9) | |||
Crcd | MEDIUMINT(9) | -1 | ||
Stknme | VARCHAR(32) | |||
Indcd | SMALLINT(6) | |||
Indnme | VARCHAR(32) | |||
Nindcd | VARCHAR(32) | |||
Nindnme | VARCHAR(128) | |||
Listexg | TINYINT(4) | |||
Conme | VARCHAR(256) | |||
Conmee | VARCHAR(256) | |||
Estbdt | DATE | |||
Ipodt | DATE | |||
Listdt | DATE | |||
Regadd | VARCHAR(512) | |||
Reglong | DOUBLE | |||
Reglat | DOUBLE | |||
Regplc | VARCHAR | |||
Regcap1 | INT(11) | |||
Regcap2 | INT(11) | |||
Nstaff | MEDIUMINT(9) | |||
Ndrct | SMALLINT(6) | |||
Nspv | SMALLINT(6) |