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 | Description |
|---|---|---|---|---|---|
| Stkcd | MEDIUMINT(9) | -1 | [证券代码] - 上海A股以上交所公布的证券代码为准，深圳A股以深交所公布的证券代码为准 | ||
| 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) |
