Differences
This shows you the differences between two versions of the page.
projs:clans:docs:dataset_db_newdata_people_edu [2014/01/21 09:20] cheungzeecn created |
projs:clans:docs:dataset_db_newdata_people_edu [2014/01/21 09:23] (current) cheungzeecn |
||
---|---|---|---|
Line 1: | Line 1: | ||
=====Description===== | =====Description===== | ||
table newdata_people_edu stores new data for education, bought by Prof ZHANG. | table newdata_people_edu stores new data for education, bought by Prof ZHANG. | ||
+ | About 83527 records(2014-01-21). | ||
=====Table format===== | =====Table format===== | ||
- | ^Field ^Type ^ Null ^Key ^Default ^Extra ^ | + | ^ Field ^ Type ^ Null ^ Key ^ Default ^ Extra ^ |
| name | varchar(100) | NO | | | | | | name | varchar(100) | NO | | | | | ||
| npid | int(11) | NO | | NULL | | | | npid | int(11) | NO | | NULL | | | ||
Line 20: | Line 21: | ||
^name ^ npid ^ stock_id ^ stock_name ^ if_current_employed ^ degree ^ major ^ college ^ start_date ^ end_date ^ | ^name ^ npid ^ stock_id ^ stock_name ^ if_current_employed ^ degree ^ major ^ college ^ start_date ^ end_date ^ | ||
- | +-----------+-----------+----------+--------------+---------------------+--------+-----------+--------------------+------------+------------+ | ||
| 储一昀 | 301038370 | 000001 | 平安银行 | 0 | 2 | 会计学 | 上海财经大学 | 0000-00-00 | 1999-07-00 | | | 储一昀 | 301038370 | 000001 | 平安银行 | 0 | 2 | 会计学 | 上海财经大学 | 0000-00-00 | 1999-07-00 | | ||
| 储一昀 | 301038370 | 000001 | 平安银行 | 0 | 3 | 经济学 | 上海财经大学 | 0000-00-00 | 1993-07-00 | | | 储一昀 | 301038370 | 000001 | 平安银行 | 0 | 3 | 经济学 | 上海财经大学 | 0000-00-00 | 1993-07-00 | | ||
Line 42: | Line 42: | ||
| 储一昀 | 301038370 | 900920 | 上柴B股 | 1 | 3 | 经济学 | 上海财经大学 | 0000-00-00 | 1993-07-00 | | | 储一昀 | 301038370 | 900920 | 上柴B股 | 1 | 3 | 经济学 | 上海财经大学 | 0000-00-00 | 1993-07-00 | | ||
| 储一昀 | 301038370 | 900920 | 上柴B股 | 1 | 4 | 经济学 | 上海财经大学 | 0000-00-00 | 1986-07-00 | | | 储一昀 | 301038370 | 900920 | 上柴B股 | 1 | 4 | 经济学 | 上海财经大学 | 0000-00-00 | 1986-07-00 | | ||
+ | |||
=====change log===== | =====change log===== | ||
newly built | newly built |