* 修改類型 0表示crowdsourcing記錄，1表示新增，2表示整體覆寫（完整替換現有記錄，主要用於 code 表修改），3表示修改，4表示刪除，8表示記錄新增提案，9表示記錄修改提案
* 狀態 0代表是專業用戶修改的記錄，1代表crowdsourcing記錄並且已插入數據庫。
|
朱光裕 Zhu Guangyu
|
BIOG_SOURCE_DATA |
| 欄位 |
內容 |
| c_textid |
57941 |
| c_pages |
lgid=1160834 |
| c_notes |
(null) |
| c_main_source |
1 |
| c_self_bio |
1 |
| c_personid |
691669 |
|
691669-57941-lgid=1160834
|
1-新增
|
陶恒 |
2025-06-02 02:39:51 |
2025-06-02 02:39:51 |
0 |
|
朱光裕 Zhu Guangyu
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_surname_chn |
朱 |
| c_surname |
Zhu |
| c_mingzi_chn |
光裕 |
| c_mingzi |
Guangyu |
| c_surname_proper |
(null) |
| c_mingzi_proper |
(null) |
| c_surname_rm |
(null) |
| c_mingzi_rm |
(null) |
| c_name_chn |
朱光裕 |
| c_name |
Zhu Guangyu |
| c_name_proper |
|
| c_female |
0 |
| c_ethnicity_code |
(null) |
| c_dy |
20 |
| c_birthyear |
(null) |
| c_by_nh_code |
(null) |
| c_by_nh_year |
(null) |
| c_by_range |
(null) |
| c_by_intercalary |
0 |
| c_by_month |
(null) |
| c_by_day |
(null) |
| c_by_day_gz |
(null) |
| c_deathyear |
(null) |
| c_dy_nh_code |
(null) |
| c_dy_nh_year |
(null) |
| c_dy_range |
(null) |
| c_dy_intercalary |
0 |
| c_dy_month |
(null) |
| c_dy_day |
(null) |
| c_dy_day_gz |
(null) |
| c_death_age |
(null) |
| c_death_age_range |
-1 |
| c_fl_earliest_year |
(null) |
| c_fl_ey_nh_code |
(null) |
| c_fl_ey_nh_year |
(null) |
| c_fl_ey_notes |
(null) |
| c_fl_latest_year |
(null) |
| c_fl_ly_nh_code |
(null) |
| c_fl_ly_nh_year |
(null) |
| c_fl_ly_notes |
(null) |
| c_choronym_code |
(null) |
| c_household_status_code |
(null) |
| c_notes |
(null) |
| c_name_rm |
|
| c_modified_by |
陶恒 |
| c_modified_date |
20250601 |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| c_female |
(null) |
0 |
0 |
| c_dy |
(null) |
20 |
20 |
| c_by_intercalary |
(null) |
0 |
0 |
| c_dy_intercalary |
(null) |
0 |
0 |
| c_death_age_range |
(null) |
-1 |
-1 |
| c_modified_by |
(null) |
陶恒 |
陶恒 |
| c_modified_date |
(null) |
20250601 |
2025-06-01 00:00:00 |
|
691669
|
3-修改
|
陶恒 |
2025-06-02 02:39:36 |
2025-06-02 02:39:36 |
0 |
|
朱光裕 Zhu Guangyu
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_personid |
691669 |
| c_name_chn |
朱光裕 |
| c_created_by |
陶恒 |
| c_created_date |
20250601 |
| c_surname_chn |
朱 |
| c_surname |
Zhu |
| c_mingzi_chn |
光裕 |
| c_mingzi |
Guangyu |
| c_name |
Zhu Guangyu |
|
691669
|
1-新增
|
陶恒 |
2025-06-02 02:39:25 |
2025-06-02 02:39:25 |
0 |
|
黃鍾 Huang Zhong
|
POSTED_TO_OFFICE_DATA |
| 欄位 |
內容 |
| c_sequence |
0 |
| c_office_id |
87465 |
| c_inst_code |
0 |
| c_source |
57941 |
| c_pages |
lgid=1160834 |
| c_firstyear |
(null) |
| c_fy_nh_code |
(null) |
| c_fy_nh_year |
(null) |
| c_fy_range |
(null) |
| c_fy_intercalary |
0 |
| c_fy_month |
(null) |
| c_fy_day |
(null) |
| c_fy_day_gz |
(null) |
| c_lastyear |
(null) |
| c_ly_nh_code |
(null) |
| c_ly_nh_year |
(null) |
| c_ly_range |
(null) |
| c_ly_intercalary |
0 |
| c_ly_month |
(null) |
| c_ly_day |
(null) |
| c_ly_day_gz |
(null) |
| c_appt_type_code |
(null) |
| c_assume_office_code |
(null) |
| c_office_category_id |
(null) |
| c_notes |
(null) |
| c_dy |
20 |
| c_inst_name_code |
0 |
| c_posting_id |
2099629 |
| c_personid |
691668 |
| c_created_by |
陶恒 |
| c_created_date |
20250601 |
|
87465-2099629
|
1-新增
|
陶恒 |
2025-06-02 02:38:26 |
2025-06-02 02:38:26 |
0 |
|
黃鍾 Huang Zhong
|
POSTED_TO_OFFICE_DATA |
| 欄位 |
內容 |
| c_sequence |
0 |
| c_office_id |
86633 |
| c_inst_code |
0 |
| c_source |
57941 |
| c_pages |
lgid=1160834 |
| c_firstyear |
(null) |
| c_fy_nh_code |
(null) |
| c_fy_nh_year |
(null) |
| c_fy_range |
(null) |
| c_fy_intercalary |
0 |
| c_fy_month |
(null) |
| c_fy_day |
(null) |
| c_fy_day_gz |
(null) |
| c_lastyear |
(null) |
| c_ly_nh_code |
(null) |
| c_ly_nh_year |
(null) |
| c_ly_range |
(null) |
| c_ly_intercalary |
0 |
| c_ly_month |
(null) |
| c_ly_day |
(null) |
| c_ly_day_gz |
(null) |
| c_appt_type_code |
(null) |
| c_assume_office_code |
(null) |
| c_office_category_id |
(null) |
| c_notes |
(null) |
| c_dy |
20 |
| c_inst_name_code |
0 |
| c_posting_id |
2099628 |
| c_personid |
691668 |
| c_created_by |
陶恒 |
| c_created_date |
20250601 |
|
86633-2099628
|
1-新增
|
陶恒 |
2025-06-02 02:02:30 |
2025-06-02 02:02:30 |
0 |
|
黃鍾 Huang Zhong
|
POSTED_TO_OFFICE_DATA |
| 欄位 |
內容 |
| c_sequence |
0 |
| c_office_id |
87465 |
| c_inst_code |
0 |
| c_source |
57941 |
| c_pages |
lgid=1160834 |
| c_firstyear |
(null) |
| c_fy_nh_code |
(null) |
| c_fy_nh_year |
(null) |
| c_fy_range |
(null) |
| c_fy_intercalary |
0 |
| c_fy_month |
(null) |
| c_fy_day |
(null) |
| c_fy_day_gz |
(null) |
| c_lastyear |
(null) |
| c_ly_nh_code |
(null) |
| c_ly_nh_year |
(null) |
| c_ly_range |
(null) |
| c_ly_intercalary |
0 |
| c_ly_month |
(null) |
| c_ly_day |
(null) |
| c_ly_day_gz |
(null) |
| c_appt_type_code |
(null) |
| c_assume_office_code |
(null) |
| c_office_category_id |
(null) |
| c_notes |
(null) |
| c_dy |
20 |
| c_inst_name_code |
0 |
| c_posting_id |
2099627 |
| c_personid |
691668 |
| c_created_by |
陶恒 |
| c_created_date |
20250601 |
|
87465-2099627
|
1-新增
|
陶恒 |
2025-06-02 02:01:50 |
2025-06-02 02:01:50 |
0 |
|
黃鍾 Huang Zhong
|
POSTED_TO_OFFICE_DATA |
| 欄位 |
內容 |
| c_sequence |
0 |
| c_office_id |
87465 |
| c_inst_code |
0 |
| c_source |
57941 |
| c_pages |
lgid=1160834 |
| c_firstyear |
(null) |
| c_fy_nh_code |
(null) |
| c_fy_nh_year |
(null) |
| c_fy_range |
(null) |
| c_fy_intercalary |
0 |
| c_fy_month |
(null) |
| c_fy_day |
(null) |
| c_fy_day_gz |
(null) |
| c_lastyear |
(null) |
| c_ly_nh_code |
(null) |
| c_ly_nh_year |
(null) |
| c_ly_range |
(null) |
| c_ly_intercalary |
0 |
| c_ly_month |
(null) |
| c_ly_day |
(null) |
| c_ly_day_gz |
(null) |
| c_appt_type_code |
13 |
| c_assume_office_code |
(null) |
| c_office_category_id |
(null) |
| c_notes |
(null) |
| c_dy |
20 |
| c_inst_name_code |
0 |
| c_posting_id |
2099626 |
| c_personid |
691668 |
| c_created_by |
陶恒 |
| c_created_date |
20250601 |
|
87465-2099626
|
1-新增
|
陶恒 |
2025-06-02 01:57:24 |
2025-06-02 01:57:24 |
0 |
|
黃鍾 Huang Zhong
|
POSTED_TO_OFFICE_DATA |
| 欄位 |
內容 |
| c_sequence |
0 |
| c_office_id |
85485 |
| c_inst_code |
0 |
| c_source |
57941 |
| c_pages |
lgid=1160834 |
| c_firstyear |
(null) |
| c_fy_nh_code |
(null) |
| c_fy_nh_year |
(null) |
| c_fy_range |
(null) |
| c_fy_intercalary |
0 |
| c_fy_month |
(null) |
| c_fy_day |
(null) |
| c_fy_day_gz |
(null) |
| c_lastyear |
(null) |
| c_ly_nh_code |
(null) |
| c_ly_nh_year |
(null) |
| c_ly_range |
(null) |
| c_ly_intercalary |
0 |
| c_ly_month |
(null) |
| c_ly_day |
(null) |
| c_ly_day_gz |
(null) |
| c_appt_type_code |
(null) |
| c_assume_office_code |
(null) |
| c_office_category_id |
(null) |
| c_notes |
(null) |
| c_dy |
20 |
| c_inst_name_code |
0 |
| c_posting_id |
2099625 |
| c_personid |
691668 |
| c_created_by |
陶恒 |
| c_created_date |
20250601 |
|
85485-2099625
|
1-新增
|
陶恒 |
2025-06-02 01:55:11 |
2025-06-02 01:55:11 |
0 |
|
黃鍾 Huang Zhong
|
ENTRY_DATA |
| 欄位 |
內容 |
| c_sequence |
0 |
| c_entry_code |
312 |
| c_year |
1674 |
| c_nianhao_id |
660 |
| c_entry_nh_year |
13 |
| c_entry_range |
(null) |
| c_exam_rank |
(null) |
| c_attempt_count |
(null) |
| c_exam_field |
(null) |
| c_parental_status |
(null) |
| c_entry_addr_id |
0 |
| c_age |
(null) |
| c_posting_notes |
(null) |
| c_kin_code |
0 |
| c_kin_id |
0 |
| c_assoc_code |
0 |
| c_assoc_id |
0 |
| c_inst_code |
0 |
| c_source |
57941 |
| c_pages |
lgid=1160834 |
| c_notes |
(null) |
| c_personid |
691668 |
| c_created_by |
陶恒 |
| c_created_date |
20250601 |
| c_inst_name_code |
0 |
|
691668-312-0-0-0-0-1674-0-0-0
|
1-新增
|
陶恒 |
2025-06-02 01:42:19 |
2025-06-02 01:42:19 |
0 |
|
黃鍾 Huang Zhong
|
ALTNAME_DATA |
| 欄位 |
內容 |
| c_sequence |
0 |
| c_alt_name_chn |
律先 |
| c_alt_name |
Lvxian |
| c_alt_name_type_code |
4 |
| c_source |
57941 |
| c_pages |
lgid=1160834 |
| c_notes |
(null) |
| c_personid |
691668 |
| c_created_by |
陶恒 |
| c_created_date |
20250601 |
|
691668-0-律先-4
|
1-新增
|
陶恒 |
2025-06-02 01:40:56 |
2025-06-02 01:40:56 |
0 |
|
黃鍾 Huang Zhong
|
BIOG_ADDR_DATA |
| 欄位 |
內容 |
| c_sequence |
0 |
| c_addr_type |
1 |
| c_addr_id |
7756 |
| c_firstyear |
(null) |
| c_fy_nh_code |
(null) |
| c_fy_nh_year |
(null) |
| c_fy_range |
(null) |
| c_fy_intercalary |
0 |
| c_fy_month |
(null) |
| c_fy_day |
(null) |
| c_fy_day_gz |
(null) |
| c_lastyear |
(null) |
| c_ly_nh_code |
(null) |
| c_ly_nh_year |
(null) |
| c_ly_range |
(null) |
| c_ly_intercalary |
0 |
| c_ly_month |
(null) |
| c_ly_day |
(null) |
| c_ly_day_gz |
(null) |
| c_source |
57941 |
| c_pages |
lgid=1160834 |
| c_notes |
(null) |
| c_natal |
0 |
| c_personid |
691668 |
| c_created_by |
陶恒 |
| c_created_date |
20250601 |
|
691668-7756-1-0
|
1-新增
|
陶恒 |
2025-06-02 01:40:41 |
2025-06-02 01:40:41 |
0 |
|
黃鍾 Huang Zhong
|
BIOG_SOURCE_DATA |
| 欄位 |
內容 |
| c_textid |
57941 |
| c_pages |
lgid=1160834 |
| c_notes |
(null) |
| c_main_source |
1 |
| c_self_bio |
1 |
| c_personid |
691668 |
|
691668-57941-lgid=1160834
|
3-修改
|
陶恒 |
2025-06-02 01:32:17 |
2025-06-02 01:32:17 |
0 |
|
黃鍾 Huang Zhong
|
BIOG_SOURCE_DATA |
| 欄位 |
內容 |
| c_textid |
57941 |
| c_pages |
lgid=1160833 |
| c_notes |
(null) |
| c_main_source |
1 |
| c_self_bio |
1 |
| c_personid |
691668 |
|
691668-57941-lgid=1160833
|
1-新增
|
陶恒 |
2025-06-02 01:32:06 |
2025-06-02 01:32:06 |
0 |
|
黃鍾 Huang Zhong
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_surname_chn |
黃 |
| c_surname |
Huang |
| c_mingzi_chn |
鍾 |
| c_mingzi |
Zhong |
| c_surname_proper |
(null) |
| c_mingzi_proper |
(null) |
| c_surname_rm |
(null) |
| c_mingzi_rm |
(null) |
| c_name_chn |
黃鍾 |
| c_name |
Huang Zhong |
| c_name_proper |
|
| c_female |
0 |
| c_ethnicity_code |
(null) |
| c_dy |
20 |
| c_birthyear |
(null) |
| c_by_nh_code |
(null) |
| c_by_nh_year |
(null) |
| c_by_range |
(null) |
| c_by_intercalary |
0 |
| c_by_month |
(null) |
| c_by_day |
(null) |
| c_by_day_gz |
(null) |
| c_deathyear |
(null) |
| c_dy_nh_code |
(null) |
| c_dy_nh_year |
(null) |
| c_dy_range |
(null) |
| c_dy_intercalary |
0 |
| c_dy_month |
(null) |
| c_dy_day |
(null) |
| c_dy_day_gz |
(null) |
| c_death_age |
(null) |
| c_death_age_range |
-1 |
| c_fl_earliest_year |
(null) |
| c_fl_ey_nh_code |
(null) |
| c_fl_ey_nh_year |
(null) |
| c_fl_ey_notes |
(null) |
| c_fl_latest_year |
(null) |
| c_fl_ly_nh_code |
(null) |
| c_fl_ly_nh_year |
(null) |
| c_fl_ly_notes |
(null) |
| c_choronym_code |
(null) |
| c_household_status_code |
(null) |
| c_notes |
(null) |
| c_name_rm |
|
| c_modified_by |
陶恒 |
| c_modified_date |
20250601 |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| c_female |
(null) |
0 |
0 |
| c_dy |
(null) |
20 |
20 |
| c_by_intercalary |
(null) |
0 |
0 |
| c_dy_intercalary |
(null) |
0 |
0 |
| c_death_age_range |
(null) |
-1 |
-1 |
| c_modified_by |
(null) |
陶恒 |
陶恒 |
| c_modified_date |
(null) |
20250601 |
2025-06-01 00:00:00 |
|
691668
|
3-修改
|
陶恒 |
2025-06-02 01:31:45 |
2025-06-02 01:31:45 |
0 |
|
黃鍾 Huang Zhong
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_personid |
691668 |
| c_name_chn |
黃鍾 |
| c_created_by |
陶恒 |
| c_created_date |
20250601 |
| c_surname_chn |
黃 |
| c_surname |
Huang |
| c_mingzi_chn |
鍾 |
| c_mingzi |
Zhong |
| c_name |
Huang Zhong |
|
691668
|
1-新增
|
陶恒 |
2025-06-02 01:31:38 |
2025-06-02 01:31:38 |
0 |
|
阮爾詢 Ruan Erxun
|
POSTED_TO_OFFICE_DATA |
| 欄位 |
內容 |
| c_sequence |
0 |
| c_office_id |
80920 |
| c_inst_code |
0 |
| c_source |
57941 |
| c_pages |
lgid=1160833 |
| c_firstyear |
(null) |
| c_fy_nh_code |
(null) |
| c_fy_nh_year |
(null) |
| c_fy_range |
(null) |
| c_fy_intercalary |
0 |
| c_fy_month |
(null) |
| c_fy_day |
(null) |
| c_fy_day_gz |
(null) |
| c_lastyear |
(null) |
| c_ly_nh_code |
(null) |
| c_ly_nh_year |
(null) |
| c_ly_range |
(null) |
| c_ly_intercalary |
0 |
| c_ly_month |
(null) |
| c_ly_day |
(null) |
| c_ly_day_gz |
(null) |
| c_appt_type_code |
(null) |
| c_assume_office_code |
(null) |
| c_office_category_id |
(null) |
| c_notes |
廣東道監察御史 |
| c_dy |
20 |
| c_inst_name_code |
0 |
| c_posting_id |
2099624 |
| c_personid |
368671 |
| c_created_by |
陶恒 |
| c_created_date |
20250601 |
|
80920-2099624
|
1-新增
|
陶恒 |
2025-06-02 01:20:29 |
2025-06-02 01:20:29 |
0 |
|
阮爾詢 Ruan Erxun
|
BIOG_SOURCE_DATA |
| 欄位 |
內容 |
| c_textid |
57941 |
| c_pages |
lgid=1160833 |
| c_notes |
(null) |
| c_main_source |
1 |
| c_self_bio |
1 |
| c_personid |
368671 |
|
368671-57941-lgid=1160833
|
1-新增
|
陶恒 |
2025-06-02 01:19:59 |
2025-06-02 01:19:59 |
0 |
|
阮爾詢 Ruan Erxun
|
POSTED_TO_OFFICE_DATA |
| 欄位 |
內容 |
| c_sequence |
10 |
| c_office_id |
80920 |
| c_inst_name_code |
0 |
| c_inst_code |
0 |
| c_source |
9602 |
| c_pages |
tts_no=17757 |
| c_firstyear |
(null) |
| c_fy_nh_code |
660 |
| c_fy_nh_year |
(null) |
| c_fy_range |
2 |
| c_fy_intercalary |
0 |
| c_fy_month |
(null) |
| c_fy_day |
(null) |
| c_fy_day_gz |
(null) |
| c_lastyear |
(null) |
| c_ly_nh_code |
(null) |
| c_ly_nh_year |
(null) |
| c_ly_range |
(null) |
| c_ly_intercalary |
0 |
| c_ly_month |
(null) |
| c_ly_day |
(null) |
| c_ly_day_gz |
(null) |
| c_appt_type_code |
(null) |
| c_assume_office_code |
(null) |
| c_office_category_id |
(null) |
| c_notes |
河南道道監察御史 |
| c_dy |
20 |
| c_modified_by |
陶恒 |
| c_modified_date |
20250601 |
|
80920-483558
|
3-修改
|
陶恒 |
2025-06-02 01:17:44 |
2025-06-02 01:17:44 |
0 |
|
阮爾詢 Ruan Erxun
|
POSTED_TO_OFFICE_DATA |
| 欄位 |
內容 |
| c_personid |
368671 |
| c_office_id |
72158 |
| c_posting_id |
483563 |
| c_posting_id_old |
(null) |
| c_sequence |
18 |
| c_firstyear |
(null) |
| c_fy_nh_code |
660 |
| c_fy_nh_year |
43 |
| c_fy_range |
(null) |
| c_lastyear |
(null) |
| c_ly_nh_code |
(null) |
| c_ly_nh_year |
(null) |
| c_ly_range |
(null) |
| c_appt_type_code |
(null) |
| c_assume_office_code |
(null) |
| c_inst_code |
0 |
| c_inst_name_code |
0 |
| c_source |
9602 |
| c_pages |
tts_no=17757 |
| c_notes |
通政司右通政 |
| c_office_id_backup |
(null) |
| c_office_category_id |
(null) |
| c_fy_intercalary |
(null) |
| c_fy_month |
(null) |
| c_ly_intercalary |
(null) |
| c_ly_month |
(null) |
| c_fy_day |
(null) |
| c_ly_day |
(null) |
| c_fy_day_gz |
(null) |
| c_ly_day_gz |
(null) |
| c_dy |
20 |
| c_created_by |
load |
| c_created_date |
20230307 |
| c_modified_by |
(null) |
| c_modified_date |
(null) |
| c_appt_code |
(null) |
|
72158-483563
|
4-刪除
|
陶恒 |
2025-06-02 00:58:38 |
2025-06-02 00:58:38 |
0 |
|
吳文炘 Wu Wenxin
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_surname_chn |
吳 |
| c_surname |
Wu |
| c_mingzi_chn |
文炘 |
| c_mingzi |
Wenxin |
| c_surname_proper |
(null) |
| c_mingzi_proper |
(null) |
| c_surname_rm |
(null) |
| c_mingzi_rm |
(null) |
| c_name_chn |
吳文炘 |
| c_name |
Wu Wenxin |
| c_name_proper |
|
| c_female |
0 |
| c_ethnicity_code |
(null) |
| c_dy |
(null) |
| c_birthyear |
(null) |
| c_by_nh_code |
(null) |
| c_by_nh_year |
(null) |
| c_by_range |
(null) |
| c_by_intercalary |
0 |
| c_by_month |
(null) |
| c_by_day |
(null) |
| c_by_day_gz |
(null) |
| c_deathyear |
(null) |
| c_dy_nh_code |
(null) |
| c_dy_nh_year |
(null) |
| c_dy_range |
(null) |
| c_dy_intercalary |
0 |
| c_dy_month |
(null) |
| c_dy_day |
(null) |
| c_dy_day_gz |
(null) |
| c_death_age |
(null) |
| c_death_age_range |
-1 |
| c_fl_earliest_year |
(null) |
| c_fl_ey_nh_code |
(null) |
| c_fl_ey_nh_year |
(null) |
| c_fl_ey_notes |
(null) |
| c_fl_latest_year |
(null) |
| c_fl_ly_nh_code |
(null) |
| c_fl_ly_nh_year |
(null) |
| c_fl_ly_notes |
(null) |
| c_choronym_code |
(null) |
| c_household_status_code |
(null) |
| c_notes |
(null) |
| c_name_rm |
|
| c_modified_by |
陶恒 |
| c_modified_date |
20250601 |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| c_mingzi |
Wen炘 |
Wenxin |
Wenxin |
| c_name |
Wu Wen炘 |
Wu Wenxin |
Wu Wenxin |
| c_female |
(null) |
0 |
0 |
| c_by_intercalary |
(null) |
0 |
0 |
| c_dy_intercalary |
(null) |
0 |
0 |
| c_death_age_range |
(null) |
-1 |
-1 |
| c_modified_by |
(null) |
陶恒 |
陶恒 |
| c_modified_date |
(null) |
20250601 |
2025-06-01 00:00:00 |
|
691667
|
3-修改
|
陶恒 |
2025-06-02 00:56:18 |
2025-06-02 00:56:18 |
0 |