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