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