=====Description=====
Table newdata_peopleinfor stores new data for work, bought by Prof ZHANG.
The table has 84859 records.

=====Table format=====
^ Field               ^ Type             ^ Null ^ Key ^ Default ^ Extra          ^
| id                        | int(10) unsigned | NO   | PRI | NULL    | auto_increment |
| name                      | varchar(50)      | NO   |     |         |                |
| npid                      | int(11)          | NO   |     | NULL    |                |
| stock_id                  | varchar(10)      | NO   |     |         |                |
| stock_name                | varchar(100)     | NO   |     |         |                |
| if_current_employed       | tinyint(1)       | NO   |     | NULL    |                |
| gender                    | int(11)          | NO   |     | NULL    |                |
| birthday                  | date             | YES  |     | NULL    |                |
| high_degree               | int(11)          | YES  |     | NULL    |                |
| race                      | int(11)          | YES  |     | NULL    |                |
| politics_status           | int(11)          | YES  |     | NULL    |                |
| if_reported_report_period | varchar(100)     | NO   |     |         |                |
| if_reported_fund_holding  | varchar(100)     | NO   |     |         |                |
| if_reported_annual_pay    | varchar(100)     | NO   |     |         |                |
| title                     | varchar(100)     | NO   |     |         |                |
| vocation_certificate      | varchar(1000)    | NO   |     |         |                |
| books                     | varchar(1000)    | NO   |     |         |                |


=====record example=====



^ id    ^ name      ^ npid      ^ stock_id ^ stock_name   ^ if_current_employed ^ gender ^ birthday   ^ high_degree ^ race ^ politics_status ^ if_reported_report_period ^ if_reported_fund_holding ^ if_reported_annual_pay ^ title  ^ vocation_certificate ^ books ^
|     2 | 储一昀    | 301038370 | 000001   | 平安银行     |                   0 |      1 | 1964-12-15 |           2 |    0 |               1 |                           |                          |                        | 教授   |                      |       |
| 11316 | 储一昀    | 301038370 | 000793   | 华闻传媒     |                   1 |      1 | 1964-12-15 |           2 |    0 |               1 |                           |                          |                        | 教授   |                      |       |
| 40458 | 储一昀    | 301038370 | 300233   | 金城医药     |                   0 |      1 | 1964-12-15 |           2 |    0 |               1 |                           |                          |                        | 教授   |                      |       |
| 54540 | 储一昀    | 301038370 | 600176   | 中国玻纤     |                   0 |      1 | 1964-12-15 |           2 |    0 |               1 |                           |                          |                        | 教授   |                      |       |
| 66620 | 储一昀    | 301038370 | 600616   | 金枫酒业     |                   0 |      1 | 1964-12-15 |           2 |    0 |               1 |                           |                          |                        | 教授   |                      |       |
| 74236 | 储一昀    | 301038370 | 600841   | 上柴股份     |                   1 |      1 | 1964-12-15 |           2 |    0 |               1 |                           |                          |                        | 教授   |                      |       |
| 83725 | 储一昀    | 301038370 | 900920   | 上柴B股      |                   1 |      1 | 1964-12-15 |           2 |    0 |               1 |                           |                          |                        | 教授   |                      |       |

=====change log=====
newly built
<code>
newdata_peopleinfor | CREATE TABLE `newdata_peopleinfor` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL DEFAULT '',
  `npid` int(11) NOT NULL,
  `stock_id` varchar(10) NOT NULL DEFAULT '',
  `stock_name` varchar(100) NOT NULL DEFAULT '',
  `if_current_employed` tinyint(1) NOT NULL,
  `gender` int(11) NOT NULL,
  `birthday` date DEFAULT NULL,
  `high_degree` int(11) DEFAULT NULL,
  `race` int(11) DEFAULT NULL,
  `politics_status` int(11) DEFAULT NULL,
  `if_reported_report_period` varchar(100) NOT NULL DEFAULT '',
  `if_reported_fund_holding` varchar(100) NOT NULL DEFAULT '',
  `if_reported_annual_pay` varchar(100) NOT NULL DEFAULT '',
  `title` varchar(100) NOT NULL DEFAULT '',
  `vocation_certificate` varchar(1000) NOT NULL DEFAULT '',
  `books` varchar(1000) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=84860 DEFAULT CHARSET=utf8
</code>