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