Table of Contents
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
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
