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