Differences
This shows you the differences between two versions of the page.
projs:clans:docs:dataset_db_company_employee [2014/01/27 11:02] yoyoliliu |
projs:clans:docs:dataset_db_company_employee [2014/01/28 00:52] (current) yoyoliliu |
||
---|---|---|---|
Line 2: | Line 2: | ||
Table: company_employee stores information of companies' employee. | Table: company_employee stores information of companies' employee. | ||
====== Data Schema ====== | ====== Data Schema ====== | ||
- | ^ Field ^ Type ^ NULL ^Key ^Default ^Extra | + | ^ Field ^ Type ^ NULL ^Key ^Default ^Extra ^ |
- | | id | INT(11) | | | | | | + | | id | INT(11) | | | | the unique identifier of every record in this table| |
+ | | stock_id | INT(11) | | | | 证券代码| | ||
+ | | pid | INT(11) | | | | | | ||
+ | | position_rank | INT(11) | | | | | | ||
+ | | position | VARCHAR(128) | | | | | | ||
+ | | year | INT(11) | | | | | | ||
+ | | position_id | INT(11) | | | | | | ||
====== Record Example ====== | ====== Record Example ====== | ||
+ | ^id ^stock_id ^pid ^position_rank ^position ^year ^position_id ^ | ||
+ | | 1 | 1 | 0 | 深发展A | 1 | 金融 | I01 | 银行业 | ||
+ | | 2 | 2 | 200002 | 深万科A | 3 | 房地产 | J01 | 房地产开发与经营业 | ||
+ | | 3 | 3 | 200003 | 深金田A | 4 | 综合 | M | 综合类 | ||
+ | | 4 | 4 | 0 | 深安达A | 2 | 公用事业 | F03 | 公路运输业 | ||
+ | | 5 | 5 | 0 | 深原野A | 4 | 综合 | M | 综合类 | ||
+ | | 6 | 6 | 0 | 深振业A | 3 | 房地产 | J01 | 房地产开发与经营业 | ||
+ | | 7 | 7 | 0 | 深达声 | 3 | 房地产 | J01 | 房地产开发与经营业 | ||
+ | | 8 | 8 | 0 | 深锦兴A | 2 | 公用事业 | G87 | 计算机应用服务业 | ||
+ | | 9 | 9 | 0 | 深宝安A | 4 | 综合 | M | 综合类 | ||
+ | | 10 | 10 | 0 | 深华新A | 6 | 商业 | H21 | 商业经纪与代理业 | ||
+ | |||
====== Change Log ====== | ====== Change Log ====== |