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