This is an old revision of the document!


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)

Record Example

Change Log

 
projs/clans/docs/dataset_db_companyinfor.1390788407.txt.gz · Last modified: 2014/01/27 10:06 by yoyoliliu     Back to top