* 修改類型 0表示crowdsourcing記錄,1表示新增,2表示整體覆寫(完整替換現有記錄,主要用於 code 表修改),3表示修改,4表示刪除,8表示記錄新增提案,9表示記錄修改提案
* 狀態 0代表是專業用戶修改的記錄,1代表crowdsourcing記錄並且已插入數據庫。
|
陶澤 Tao Ze
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_surname_chn |
陶 |
| c_mingzi_chn |
澤 |
| c_surname |
Tao |
| c_mingzi |
Ze |
| c_surname_proper |
(null) |
| c_mingzi_proper |
(null) |
| c_surname_rm |
(null) |
| c_mingzi_rm |
(null) |
| c_name_chn |
陶澤 |
| c_name |
Tao Ze |
| c_name_proper |
|
| c_name_rm |
|
| c_female |
0 |
| c_ethnicity_code |
(null) |
| c_dy |
19 |
| 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_index_year |
(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_modified_by |
劉慧楠 |
| c_modified_date |
2026-01-12T14:41:44.834163Z |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| c_female |
(null) |
0 |
0 |
| c_dy |
(null) |
19 |
19 |
| 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) |
2026-01-12T14:41:44.834163Z |
2026-01-12 22:41:44 |
|
698095
|
3-修改
|
劉慧楠 |
2026-01-12 22:41:44 |
2026-01-12 22:41:44 |
0 |
|
陶澤 Tao Ze
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_personid |
698095 |
| c_name_chn |
陶澤 |
| c_created_by |
劉慧楠 |
| c_created_date |
2026-01-12T14:41:31.951835Z |
| c_surname_chn |
陶 |
| c_surname |
Tao |
| c_mingzi_chn |
澤 |
| c_mingzi |
Ze |
| c_name |
Tao Ze |
|
698095
|
1-新增
|
劉慧楠 |
2026-01-12 22:41:31 |
2026-01-12 22:41:31 |
0 |
|
惲紹芳 Yun Shaofang
|
POSTED_TO_OFFICE_DATA |
| 欄位 |
內容 |
| c_sequence |
2 |
| c_office_id |
70088 |
| c_inst_code |
0 |
| c_source |
39136 |
| c_pages |
lgid=152272 |
| 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_code |
(null) |
| c_assume_office_code |
1 |
| c_office_category_id |
(null) |
| c_notes |
(null) |
| c_dy |
19 |
| c_inst_name_code |
0 |
| c_posting_id |
2104087 |
| c_personid |
131268 |
| c_created_by |
劉慧楠 |
| c_created_date |
2026-01-12T14:32:32.042168Z |
|
70088-2104087
|
1-新增
|
劉慧楠 |
2026-01-12 22:32:32 |
2026-01-12 22:32:32 |
0 |
|
惲紹芳 Yun Shaofang
|
POSTED_TO_ADDR_DATA |
| 欄位 |
內容 |
| rows |
[{"c_personid":131268,"c_posting_id":2104087,"c_office_id":70088,"c_addr_id":5976}] |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| 人物 ID |
131268
|
131268
|
131268
|
| 官名 ID |
70088
|
70088
|
70088
|
| Posting ID |
2104087
|
2104087
|
2104087
|
| 地址 ID |
原本的 |
修改後 |
目前資料 |
| 5976 |
—
|
5976 福建布政司
|
5976 福建布政司
|
|
70088-2104087
|
1-新增
|
劉慧楠 |
2026-01-12 22:32:32 |
2026-01-12 22:32:32 |
0 |
|
惲紹芳 Yun Shaofang
|
POSTED_TO_OFFICE_DATA |
| 欄位 |
內容 |
| c_sequence |
1 |
| c_office_id |
71155 |
| c_inst_code |
0 |
| c_source |
39136 |
| c_pages |
lgid=152272 |
| 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_code |
(null) |
| c_assume_office_code |
1 |
| c_office_category_id |
(null) |
| c_notes |
(null) |
| c_dy |
19 |
| c_inst_name_code |
0 |
| c_posting_id |
2104086 |
| c_personid |
131268 |
| c_created_by |
劉慧楠 |
| c_created_date |
2026-01-12T14:31:45.948443Z |
|
71155-2104086
|
1-新增
|
劉慧楠 |
2026-01-12 22:31:45 |
2026-01-12 22:31:45 |
0 |
|
惲紹芳 Yun Shaofang
|
POSTED_TO_ADDR_DATA |
| 欄位 |
內容 |
| rows |
[{"c_personid":131268,"c_posting_id":2104086,"c_office_id":71155,"c_addr_id":0}] |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| 人物 ID |
131268
|
131268
|
131268
|
| 官名 ID |
71155
|
71155
|
71155
|
| Posting ID |
2104086
|
2104086
|
2104086
|
| 地址 ID |
原本的 |
修改後 |
目前資料 |
| 0 |
—
|
0 [未詳]
|
0 [未詳]
|
|
71155-2104086
|
1-新增
|
劉慧楠 |
2026-01-12 22:31:45 |
2026-01-12 22:31:45 |
0 |
|
惲紹芳 Yun Shaofang
|
BIOG_SOURCE_DATA |
| 欄位 |
內容 |
| c_textid |
39136 |
| c_pages |
lgid=152272 |
| c_main_source |
0 |
| c_self_bio |
1 |
| c_notes |
(null) |
| c_personid |
131268 |
| c_created_by |
劉慧楠 |
| c_created_date |
2026-01-12T14:23:18.306970Z |
|
131268-39136-lgid=152272
|
1-新增
|
劉慧楠 |
2026-01-12 22:23:18 |
2026-01-12 22:23:18 |
0 |
|
葉材 Ye Cai
|
POSTED_TO_OFFICE_DATA |
| 欄位 |
內容 |
| c_sequence |
2 |
| c_office_id |
70487 |
| c_inst_code |
0 |
| c_source |
39136 |
| c_pages |
lgid=152272 |
| 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_code |
(null) |
| c_assume_office_code |
1 |
| c_office_category_id |
(null) |
| c_notes |
(null) |
| c_dy |
19 |
| c_inst_name_code |
0 |
| c_posting_id |
2104085 |
| c_personid |
203545 |
| c_created_by |
劉慧楠 |
| c_created_date |
2026-01-12T14:22:23.007780Z |
|
70487-2104085
|
1-新增
|
劉慧楠 |
2026-01-12 22:22:23 |
2026-01-12 22:22:23 |
0 |
|
葉材 Ye Cai
|
POSTED_TO_ADDR_DATA |
| 欄位 |
內容 |
| rows |
[{"c_personid":203545,"c_posting_id":2104085,"c_office_id":70487,"c_addr_id":0}] |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| 人物 ID |
203545
|
203545
|
203545
|
| 官名 ID |
70487
|
70487
|
70487
|
| Posting ID |
2104085
|
2104085
|
2104085
|
| 地址 ID |
原本的 |
修改後 |
目前資料 |
| 0 |
—
|
0 [未詳]
|
0 [未詳]
|
|
70487-2104085
|
1-新增
|
劉慧楠 |
2026-01-12 22:22:23 |
2026-01-12 22:22:23 |
0 |
|
葉材 Ye Cai
|
POSTED_TO_OFFICE_DATA |
| 欄位 |
內容 |
| c_sequence |
1 |
| c_office_id |
70307 |
| c_inst_code |
0 |
| c_source |
39136 |
| c_pages |
lgid=152272 |
| 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_code |
(null) |
| c_assume_office_code |
1 |
| c_office_category_id |
(null) |
| c_notes |
(null) |
| c_dy |
19 |
| c_inst_name_code |
0 |
| c_posting_id |
2104084 |
| c_personid |
203545 |
| c_created_by |
劉慧楠 |
| c_created_date |
2026-01-12T14:15:01.699339Z |
|
70307-2104084
|
1-新增
|
劉慧楠 |
2026-01-12 22:15:01 |
2026-01-12 22:15:01 |
0 |
|
葉材 Ye Cai
|
POSTED_TO_ADDR_DATA |
| 欄位 |
內容 |
| rows |
[{"c_personid":203545,"c_posting_id":2104084,"c_office_id":70307,"c_addr_id":5385}] |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| 人物 ID |
203545
|
203545
|
203545
|
| 官名 ID |
70307
|
70307
|
70307
|
| Posting ID |
2104084
|
2104084
|
2104084
|
| 地址 ID |
原本的 |
修改後 |
目前資料 |
| 5385 |
—
|
5385 處州府
|
5385 處州府
|
|
70307-2104084
|
1-新增
|
劉慧楠 |
2026-01-12 22:15:01 |
2026-01-12 22:15:01 |
0 |
|
葉材 Ye Cai
|
ALTNAME_DATA |
| 欄位 |
內容 |
| c_sequence |
1 |
| c_alt_name_chn |
木菴 |
| c_alt_name |
muan |
| c_alt_name_type_code |
5 |
| c_source |
39136 |
| c_pages |
lgid=152272 |
| c_notes |
(null) |
| c_personid |
203545 |
| c_created_by |
劉慧楠 |
| c_created_date |
2026-01-12T14:13:12.115623Z |
|
203545-1-木菴-5
|
1-新增
|
劉慧楠 |
2026-01-12 22:13:12 |
2026-01-12 22:13:12 |
0 |
|
葉材 Ye Cai
|
BIOG_SOURCE_DATA |
| 欄位 |
內容 |
| c_textid |
39136 |
| c_pages |
lgid=152272 |
| c_main_source |
0 |
| c_self_bio |
0 |
| c_notes |
(null) |
| c_personid |
203545 |
| c_created_by |
劉慧楠 |
| c_created_date |
2026-01-12T14:12:23.208150Z |
|
203545-39136-lgid=152272
|
1-新增
|
劉慧楠 |
2026-01-12 22:12:23 |
2026-01-12 22:12:23 |
0 |
|
王仲騰 Wang Zhongteng
|
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=1160953 |
| c_notes |
(null) |
| c_natal |
0 |
| c_personid |
698094 |
| c_created_by |
陶恒 |
| c_created_date |
2026-01-12T13:18:16.078116Z |
|
698094-7756-1-0
|
1-新增
|
陶恒 |
2026-01-12 21:18:16 |
2026-01-12 21:18:16 |
0 |
|
王仲騰 Wang Zhongteng
|
BIOG_SOURCE_DATA |
| 欄位 |
內容 |
| c_textid |
57941 |
| c_pages |
lgid=1160953 |
| c_main_source |
1 |
| c_self_bio |
1 |
| c_notes |
(null) |
| c_personid |
698094 |
| c_created_by |
陶恒 |
| c_created_date |
2026-01-12T13:18:03.615898Z |
|
698094-57941-lgid=1160953
|
1-新增
|
陶恒 |
2026-01-12 21:18:03 |
2026-01-12 21:18:03 |
0 |
|
王仲騰 Wang Zhongteng
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_surname_chn |
王 |
| c_mingzi_chn |
仲騰 |
| c_surname |
Wang |
| c_mingzi |
Zhongteng |
| c_surname_proper |
(null) |
| c_mingzi_proper |
(null) |
| c_surname_rm |
(null) |
| c_mingzi_rm |
(null) |
| c_name_chn |
王仲騰 |
| c_name |
Wang Zhongteng |
| c_name_proper |
|
| c_name_rm |
|
| 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_index_year |
(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_modified_by |
陶恒 |
| c_modified_date |
2026-01-12T13:17:14.795948Z |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| 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) |
2026-01-12T13:17:14.795948Z |
2026-01-12 21:17:14 |
|
698094
|
3-修改
|
陶恒 |
2026-01-12 21:17:14 |
2026-01-12 21:17:14 |
0 |
|
王仲騰 Wang Zhongteng
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_personid |
698094 |
| c_name_chn |
王仲騰 |
| c_created_by |
陶恒 |
| c_created_date |
2026-01-12T13:17:09.316694Z |
| c_surname_chn |
王 |
| c_surname |
Wang |
| c_mingzi_chn |
仲騰 |
| c_mingzi |
Zhongteng |
| c_name |
Wang Zhongteng |
|
698094
|
1-新增
|
陶恒 |
2026-01-12 21:17:09 |
2026-01-12 21:17:09 |
0 |
|
畢氏(李廷獻母) Bi Shi(Mother of Li Tingxian )
|
KIN_DATA |
| 欄位 |
內容 |
| c_kin_code |
180 |
| c_kin_id |
698091 |
| c_source |
57941 |
| c_pages |
lgid=1160953 |
| c_notes |
(null) |
| c_autogen_notes |
(null) |
| c_personid |
698093 |
| c_created_by |
陶恒 |
| c_created_date |
2026-01-12T13:03:30.288714Z |
|
698093-698091-180
|
1-新增
|
陶恒 |
2026-01-12 21:03:30 |
2026-01-12 21:03:30 |
0 |
|
畢氏(李廷獻母) Bi Shi(Mother of Li Tingxian )
|
BIOG_SOURCE_DATA |
| 欄位 |
內容 |
| c_textid |
57941 |
| c_pages |
lgid=1160953 |
| c_main_source |
0 |
| c_self_bio |
0 |
| c_notes |
(null) |
| c_personid |
698093 |
| c_created_by |
陶恒 |
| c_created_date |
2026-01-12T13:03:04.005663Z |
|
698093-57941-lgid=1160953
|
1-新增
|
陶恒 |
2026-01-12 21:03:04 |
2026-01-12 21:03:04 |
0 |
|
畢氏(李廷獻母) Bi Shi(Mother of Li Tingxian )
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_surname_chn |
畢 |
| c_mingzi_chn |
氏(李廷獻母) |
| c_surname |
Bi |
| c_mingzi |
Shi(Mother of Li Tingxian ) |
| c_surname_proper |
(null) |
| c_mingzi_proper |
(null) |
| c_surname_rm |
(null) |
| c_mingzi_rm |
(null) |
| c_name_chn |
畢氏(李廷獻母) |
| c_name |
Bi Shi(Mother of Li Tingxian ) |
| c_name_proper |
|
| c_name_rm |
|
| 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_index_year |
(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_modified_by |
陶恒 |
| c_modified_date |
2026-01-12T13:02:55.214180Z |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| c_surname_chn |
(null) |
畢 |
畢 |
| c_mingzi_chn |
畢氏(李廷獻母)(Bi Shi(Mother of Li Tingxian )) |
氏(李廷獻母) |
氏(李廷獻母) |
| c_surname |
(null) |
Bi |
Bi |
| c_mingzi |
Bishi(litingxianmu)(Bi Shi(Mother of Li Tingxian )) |
Shi(Mother of Li Tingxian ) |
Shi(Mother of Li Tingxian ) |
| c_name_chn |
畢氏(李廷獻母)(Bi Shi(Mother of Li Tingxian )) |
畢氏(李廷獻母) |
畢氏(李廷獻母) |
| c_name |
Bishi(litingxianmu)(Bi Shi(Mother of Li Tingxian )) |
Bi Shi(Mother of Li Tingxian ) |
Bi Shi(Mother of Li Tingxian ) |
| 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) |
2026-01-12T13:02:55.214180Z |
2026-01-12 21:02:55 |
|
698093
|
3-修改
|
陶恒 |
2026-01-12 21:02:55 |
2026-01-12 21:02:55 |
0 |