* 修改類型 0表示crowdsourcing記錄，1表示新增，2表示整體覆寫（完整替換現有記錄，主要用於 code 表修改），3表示修改，4表示刪除，8表示記錄新增提案，9表示記錄修改提案
* 狀態 0代表是專業用戶修改的記錄，1代表crowdsourcing記錄並且已插入數據庫。
|
張宅相 Zhang Zhaixiang
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_surname_chn |
張 |
| c_surname |
Zhang |
| c_mingzi_chn |
宅相 |
| c_mingzi |
Zhaixiang |
| c_surname_proper |
(null) |
| c_mingzi_proper |
(null) |
| c_surname_rm |
(null) |
| c_mingzi_rm |
(null) |
| c_name_chn |
張宅相 |
| c_name |
Zhang Zhaixiang |
| 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 |
1393 |
| c_dy_nh_code |
639 |
| c_dy_nh_year |
1393 |
| c_dy_range |
0 |
| 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 |
20251214 |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| c_deathyear |
(null) |
1393 |
1393 |
| c_dy_nh_code |
(null) |
639 |
639 |
| c_dy_nh_year |
(null) |
1393 |
1393 |
| c_dy_range |
(null) |
0 |
0 |
|
697013
|
3-修改
|
李格非 |
2025-12-14 16:35:49 |
2025-12-14 16:35:49 |
0 |
|
張宅相 Zhang Zhaixiang
|
STATUS_DATA |
| 欄位 |
內容 |
| c_sequence |
0 |
| c_status_code |
38 |
| c_supplement |
(null) |
| c_firstyear |
(null) |
| c_fy_nh_code |
(null) |
| c_fy_nh_year |
(null) |
| c_fy_range |
(null) |
| c_lastyear |
(null) |
| c_ly_nh_code |
(null) |
| c_ly_nh_year |
(null) |
| c_ly_range |
(null) |
| c_source |
38685 |
| c_pages |
lgid=356675 |
| c_notes |
所居鄉官寺田多重租，小民不堪，遂以己田均其租。洪武甲子歲大飢，發倉賑索賴以全活者數十家。 |
| c_personid |
697013 |
| c_created_by |
李格非 |
| c_created_date |
20251214 |
|
697013-0-38
|
1-新增
|
李格非 |
2025-12-14 16:34:00 |
2025-12-14 16:34:00 |
0 |
|
張宅相 Zhang Zhaixiang
|
KIN_DATA |
| 欄位 |
內容 |
| c_kin_code |
75 |
| c_kin_id |
107187 |
| c_source |
38685 |
| c_pages |
lgid=356675 |
| c_notes |
(null) |
| c_autogen_notes |
(null) |
| c_personid |
697013 |
| c_created_by |
李格非 |
| c_created_date |
20251214 |
|
697013-107187-75
|
1-新增
|
李格非 |
2025-12-14 16:27:40 |
2025-12-14 16:27:40 |
0 |
|
張惟賢 Zhang Weixian
|
POSTED_TO_OFFICE_DATA |
| 欄位 |
內容 |
| c_sequence |
(null) |
| c_office_id |
65038 |
| c_inst_code |
0 |
| c_source |
38685 |
| c_pages |
lgid=356675 |
| 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 |
(null) |
| c_office_category_id |
(null) |
| c_notes |
海道巡防義兵萬戶 |
| c_dy |
18 |
| c_inst_name_code |
0 |
| c_posting_id |
2103078 |
| c_personid |
107187 |
| c_created_by |
李格非 |
| c_created_date |
20251214 |
|
65038-2103078
|
1-新增
|
李格非 |
2025-12-14 16:24:20 |
2025-12-14 16:24:20 |
0 |
|
張惟賢 Zhang Weixian
|
POSTED_TO_ADDR_DATA |
| 欄位 |
內容 |
| rows |
[{"c_personid":107187,"c_posting_id":2103078,"c_office_id":65038,"c_addr_id":0}] |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| 人物 ID |
107187
|
107187
|
107187
|
| 官名 ID |
65038
|
65038
|
65038
|
| Posting ID |
2103078
|
2103078
|
2103078
|
| 地址 ID |
原本的 |
修改後 |
目前資料 |
| 0 |
—
|
0 [未詳]
|
0 [未詳]
|
|
65038-2103078
|
1-新增
|
李格非 |
2025-12-14 16:24:20 |
2025-12-14 16:24:20 |
0 |
|
張惟賢 Zhang Weixian
|
BIOG_SOURCE_DATA |
| 欄位 |
內容 |
| c_textid |
38685 |
| c_pages |
lgid=356675 |
| c_notes |
(null) |
| c_main_source |
0 |
| c_self_bio |
0 |
| c_personid |
107187 |
| c_created_by |
李格非 |
| c_created_date |
2025-12-14T08:23:06.225743Z |
|
107187-38685-lgid=356675
|
1-新增
|
李格非 |
2025-12-14 16:23:06 |
2025-12-14 16:23:06 |
0 |
|
張宅相 Zhang Zhaixiang
|
KIN_DATA |
| 欄位 |
內容 |
| c_kin_code |
62 |
| c_kin_id |
697100 |
| c_source |
38685 |
| c_pages |
lgid=356675 |
| c_notes |
(null) |
| c_autogen_notes |
(null) |
| c_personid |
697013 |
| c_created_by |
李格非 |
| c_created_date |
20251214 |
|
697013-697100-62
|
1-新增
|
李格非 |
2025-12-14 16:07:30 |
2025-12-14 16:07:30 |
0 |
|
張漢章 Zhang Hanzhang
|
POSTED_TO_OFFICE_DATA |
| 欄位 |
內容 |
| c_sequence |
(null) |
| c_office_id |
64334 |
| c_inst_code |
0 |
| c_source |
38685 |
| c_pages |
lgid=356675 |
| 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 |
(null) |
| c_office_category_id |
(null) |
| c_notes |
(null) |
| c_dy |
18 |
| c_inst_name_code |
0 |
| c_posting_id |
2103077 |
| c_personid |
697100 |
| c_created_by |
李格非 |
| c_created_date |
20251214 |
|
64334-2103077
|
1-新增
|
李格非 |
2025-12-14 16:03:17 |
2025-12-14 16:03:17 |
0 |
|
張漢章 Zhang Hanzhang
|
POSTED_TO_ADDR_DATA |
| 欄位 |
內容 |
| rows |
[{"c_personid":697100,"c_posting_id":2103077,"c_office_id":64334,"c_addr_id":17584}] |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| 人物 ID |
697100
|
697100
|
697100
|
| 官名 ID |
64334
|
64334
|
64334
|
| Posting ID |
2103077
|
2103077
|
2103077
|
| 地址 ID |
原本的 |
修改後 |
目前資料 |
| 17584 |
—
|
17584 清河
|
17584 清河
|
|
64334-2103077
|
1-新增
|
李格非 |
2025-12-14 16:03:17 |
2025-12-14 16:03:17 |
0 |
|
張漢章 Zhang Hanzhang
|
BIOG_ADDR_DATA |
| 欄位 |
內容 |
| c_sequence |
0 |
| c_addr_type |
1 |
| c_addr_id |
12649 |
| 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 |
38685 |
| c_pages |
lgid=356675 |
| c_notes |
(null) |
| c_natal |
0 |
| c_personid |
697100 |
| c_created_by |
李格非 |
| c_created_date |
20251214 |
|
697100-12649-1-0
|
1-新增
|
李格非 |
2025-12-14 15:57:46 |
2025-12-14 15:57:46 |
0 |
|
張漢章 Zhang Hanzhang
|
BIOG_SOURCE_DATA |
| 欄位 |
內容 |
| c_textid |
38685 |
| c_pages |
lgid=356675 |
| c_notes |
(null) |
| c_main_source |
0 |
| c_self_bio |
0 |
| c_personid |
697100 |
| c_created_by |
李格非 |
| c_created_date |
2025-12-14T07:56:46.255994Z |
|
697100-38685-lgid=356675
|
1-新增
|
李格非 |
2025-12-14 15:56:46 |
2025-12-14 15:56:46 |
0 |
|
張漢章 Zhang Hanzhang
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_surname_chn |
張 |
| c_surname |
Zhang |
| c_mingzi_chn |
漢章 |
| c_mingzi |
Hanzhang |
| c_surname_proper |
(null) |
| c_mingzi_proper |
(null) |
| c_surname_rm |
(null) |
| c_mingzi_rm |
(null) |
| c_name_chn |
張漢章 |
| c_name |
Zhang Hanzhang |
| c_name_proper |
|
| c_name_rm |
|
| c_female |
0 |
| c_ethnicity_code |
(null) |
| c_dy |
18 |
| 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 |
20251214 |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| c_female |
(null) |
0 |
0 |
| c_dy |
(null) |
18 |
18 |
| 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) |
20251214 |
20251214 |
|
697100
|
3-修改
|
李格非 |
2025-12-14 15:55:07 |
2025-12-14 15:55:07 |
0 |
|
張漢章 Zhang Hanzhang
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_personid |
697100 |
| c_name_chn |
張漢章 |
| c_created_by |
李格非 |
| c_created_date |
20251214 |
| c_surname_chn |
張 |
| c_surname |
Zhang |
| c_mingzi_chn |
漢章 |
| c_mingzi |
Hanzhang |
| c_name |
Zhang Hanzhang |
|
697100
|
1-新增
|
李格非 |
2025-12-14 15:53:06 |
2025-12-14 15:53:06 |
0 |
|
蔡勖 Cai Xu
|
ASSOC_DATA |
| 欄位 |
內容 |
| c_sequence |
0 |
| c_kin_code |
0 |
| c_kin_id |
0 |
| c_assoc_code |
43 |
| c_assoc_id |
41353 |
| c_assoc_kin_code |
0 |
| c_assoc_kin_id |
0 |
| c_assoc_first_year |
-9999 |
| c_assoc_fy_nh_code |
(null) |
| c_assoc_fy_nh_year |
(null) |
| c_assoc_fy_range |
(null) |
| c_assoc_fy_intercalary |
0 |
| c_assoc_fy_month |
(null) |
| c_assoc_fy_day |
(null) |
| c_assoc_fy_day_gz |
(null) |
| c_assoc_last_year |
(null) |
| c_assoc_ly_nh_code |
(null) |
| c_assoc_ly_nh_year |
(null) |
| c_assoc_ly_range |
(null) |
| c_assoc_ly_intercalary |
0 |
| c_assoc_ly_month |
(null) |
| c_assoc_ly_day |
(null) |
| c_assoc_ly_day_gz |
(null) |
| c_notes |
(null) |
| c_topic_code |
(null) |
| c_occasion_code |
(null) |
| c_text_title |
[n/a] |
| c_assoc_count |
1 |
| c_tertiary_personid |
0 |
| c_tertiary_type_notes |
(null) |
| c_assoc_claimer_id |
0 |
| c_addr_id |
0 |
| c_inst_code |
0 |
| c_source |
64847 |
| c_pages |
蔡勖墓誌 |
| c_inst_name_code |
0 |
| c_personid |
697054 |
| c_created_by |
谢洁薇 |
| c_created_date |
20251214 |
|
697054-43-41353-0-0-0-0-[n/a]
|
1-新增
|
谢洁薇 |
2025-12-14 15:38:28 |
2025-12-14 15:38:28 |
0 |
|
吳申 Wu Shen
|
POSTED_TO_OFFICE_DATA |
| 欄位 |
內容 |
| c_sequence |
0 |
| c_office_id |
2908 |
| c_inst_code |
0 |
| c_source |
64847 |
| c_pages |
蔡勖墓誌 |
| 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 |
46 |
| c_assume_office_code |
(null) |
| c_office_category_id |
(null) |
| c_notes |
(null) |
| c_dy |
15 |
| c_inst_name_code |
0 |
| c_posting_id |
2103076 |
| c_personid |
41353 |
| c_created_by |
谢洁薇 |
| c_created_date |
20251214 |
|
2908-2103076
|
1-新增
|
谢洁薇 |
2025-12-14 15:37:25 |
2025-12-14 15:37:25 |
0 |
|
吳申 Wu Shen
|
POSTED_TO_ADDR_DATA |
| 欄位 |
內容 |
| rows |
[{"c_personid":41353,"c_posting_id":2103076,"c_office_id":2908,"c_addr_id":0}] |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| 人物 ID |
41353
|
41353
|
41353
|
| 官名 ID |
2908
|
2908
|
2908
|
| Posting ID |
2103076
|
2103076
|
2103076
|
| 地址 ID |
原本的 |
修改後 |
目前資料 |
| 0 |
—
|
0 [未詳]
|
0 [未詳]
|
|
2908-2103076
|
1-新增
|
谢洁薇 |
2025-12-14 15:37:25 |
2025-12-14 15:37:25 |
0 |
|
吳申 Wu Shen
|
POSTED_TO_OFFICE_DATA |
| 欄位 |
內容 |
| c_sequence |
0 |
| c_office_id |
177 |
| c_inst_code |
0 |
| c_source |
64847 |
| c_pages |
蔡勖墓誌 |
| 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 |
(null) |
| c_office_category_id |
(null) |
| c_notes |
(null) |
| c_dy |
15 |
| c_inst_name_code |
0 |
| c_posting_id |
2103075 |
| c_personid |
41353 |
| c_created_by |
谢洁薇 |
| c_created_date |
20251214 |
|
177-2103075
|
1-新增
|
谢洁薇 |
2025-12-14 15:35:24 |
2025-12-14 15:35:24 |
0 |
|
吳申 Wu Shen
|
POSTED_TO_ADDR_DATA |
| 欄位 |
內容 |
| rows |
[{"c_personid":41353,"c_posting_id":2103075,"c_office_id":177,"c_addr_id":0}] |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| 人物 ID |
41353
|
41353
|
41353
|
| 官名 ID |
177
|
177
|
177
|
| Posting ID |
2103075
|
2103075
|
2103075
|
| 地址 ID |
原本的 |
修改後 |
目前資料 |
| 0 |
—
|
0 [未詳]
|
0 [未詳]
|
|
177-2103075
|
1-新增
|
谢洁薇 |
2025-12-14 15:35:24 |
2025-12-14 15:35:24 |
0 |
|
吳申 Wu Shen
|
POSTED_TO_OFFICE_DATA |
| 欄位 |
內容 |
| c_sequence |
0 |
| c_office_id |
1108 |
| c_inst_code |
0 |
| c_source |
64847 |
| c_pages |
蔡勖墓誌 |
| 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 |
2 |
| c_assume_office_code |
(null) |
| c_office_category_id |
(null) |
| c_notes |
(null) |
| c_dy |
15 |
| c_inst_name_code |
0 |
| c_posting_id |
2103074 |
| c_personid |
41353 |
| c_created_by |
谢洁薇 |
| c_created_date |
20251214 |
|
1108-2103074
|
1-新增
|
谢洁薇 |
2025-12-14 15:34:06 |
2025-12-14 15:34:06 |
0 |
|
吳申 Wu Shen
|
POSTED_TO_ADDR_DATA |
| 欄位 |
內容 |
| rows |
[{"c_personid":41353,"c_posting_id":2103074,"c_office_id":1108,"c_addr_id":101068}] |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| 人物 ID |
41353
|
41353
|
41353
|
| 官名 ID |
1108
|
1108
|
1108
|
| Posting ID |
2103074
|
2103074
|
2103074
|
| 地址 ID |
原本的 |
修改後 |
目前資料 |
| 101068 |
—
|
101068 邢州
|
101068 邢州
|
|
1108-2103074
|
1-新增
|
谢洁薇 |
2025-12-14 15:34:06 |
2025-12-14 15:34:06 |
0 |