* 修改類型 0表示crowdsourcing記錄,1表示新增,2表示整體覆寫(完整替換現有記錄,主要用於 code 表修改),3表示修改,4表示刪除,8表示記錄新增提案,9表示記錄修改提案
* 狀態 0代表是專業用戶修改的記錄,1代表crowdsourcing記錄並且已插入數據庫。
|
汪元佑 Wang Yuanyou
|
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 |
4565 |
| c_pages |
lgid=1166317 |
| c_notes |
(null) |
| c_personid |
692140 |
| c_created_by |
Ning Hao |
| c_created_date |
20250627 |
|
692140-0-38
|
1-新增
|
Ning Hao |
2025-06-27 19:23:10 |
2025-06-27 19:23:10 |
0 |
|
汪元佑 Wang Yuanyou
|
KIN_DATA |
| 欄位 |
內容 |
| c_kin_code |
62 |
| c_kin_id |
691645 |
| c_source |
4565 |
| c_pages |
lgid=1166317 |
| c_notes |
(null) |
| c_autogen_notes |
(null) |
| c_personid |
692140 |
| c_created_by |
Ning Hao |
| c_created_date |
20250627 |
|
692140-691645-62
|
1-新增
|
Ning Hao |
2025-06-27 19:22:41 |
2025-06-27 19:22:41 |
0 |
|
汪元佑 Wang Yuanyou
|
ALTNAME_DATA |
| 欄位 |
內容 |
| c_sequence |
1 |
| c_alt_name_chn |
承謨 |
| c_alt_name |
Chengmo |
| c_alt_name_type_code |
4 |
| c_source |
4565 |
| c_pages |
lgid=1166317 |
| c_notes |
(null) |
| c_personid |
692140 |
| c_created_by |
Ning Hao |
| c_created_date |
20250627 |
|
692140-1-承謨-4
|
1-新增
|
Ning Hao |
2025-06-27 19:17:59 |
2025-06-27 19:17:59 |
0 |
|
汪元佑 Wang Yuanyou
|
BIOG_ADDR_DATA |
| 欄位 |
內容 |
| c_sequence |
1 |
| c_addr_type |
1 |
| c_addr_id |
7758 |
| 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 |
4565 |
| c_pages |
lgid=1166317 |
| c_notes |
(null) |
| c_natal |
0 |
| c_personid |
692140 |
| c_created_by |
Ning Hao |
| c_created_date |
20250627 |
|
692140-7758-1-1
|
1-新增
|
Ning Hao |
2025-06-27 19:15:14 |
2025-06-27 19:15:14 |
0 |
|
汪元佑 Wang Yuanyou
|
BIOG_SOURCE_DATA |
| 欄位 |
內容 |
| c_textid |
4565 |
| c_pages |
lgid=1166317 |
| c_notes |
(null) |
| c_main_source |
1 |
| c_self_bio |
1 |
| c_personid |
692140 |
|
692140-4565-lgid=1166317
|
1-新增
|
Ning Hao |
2025-06-27 19:14:38 |
2025-06-27 19:14:38 |
0 |
|
汪元佑 Wang Yuanyou
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_surname_chn |
汪 |
| c_surname |
Wang |
| c_mingzi_chn |
元佑 |
| c_mingzi |
Yuanyou |
| c_surname_proper |
(null) |
| c_mingzi_proper |
(null) |
| c_surname_rm |
(null) |
| c_mingzi_rm |
(null) |
| c_name_chn |
汪元佑 |
| c_name |
Wang Yuanyou |
| 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 |
Ning Hao |
| c_modified_date |
20250627 |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| 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) |
Ning Hao |
Ning Hao |
| c_modified_date |
(null) |
20250627 |
2025-06-27 00:00:00 |
|
692140
|
3-修改
|
Ning Hao |
2025-06-27 19:14:16 |
2025-06-27 19:14:16 |
0 |
|
汪元佑 Wang Yuanyou
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_personid |
692140 |
| c_name_chn |
汪元佑 |
| c_created_by |
Ning Hao |
| c_created_date |
20250627 |
| c_surname_chn |
汪 |
| c_surname |
Wang |
| c_mingzi_chn |
元佑 |
| c_mingzi |
Yuanyou |
| c_name |
Wang Yuanyou |
|
692140
|
1-新增
|
Ning Hao |
2025-06-27 19:13:58 |
2025-06-27 19:13:58 |
0 |
|
程太祥 Cheng Taixiang
|
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 |
4565 |
| c_pages |
lgid=1166317 |
| c_notes |
(null) |
| c_personid |
692139 |
| c_created_by |
Ning Hao |
| c_created_date |
20250627 |
|
692139-0-38
|
1-新增
|
Ning Hao |
2025-06-27 19:12:50 |
2025-06-27 19:12:50 |
0 |
|
程太祥 Cheng Taixiang
|
ALTNAME_DATA |
| 欄位 |
內容 |
| c_sequence |
1 |
| c_alt_name_chn |
以平 |
| c_alt_name |
Yiping |
| c_alt_name_type_code |
4 |
| c_source |
4565 |
| c_pages |
lgid=1166317 |
| c_notes |
(null) |
| c_personid |
692139 |
| c_created_by |
Ning Hao |
| c_created_date |
20250627 |
|
692139-1-以平-4
|
1-新增
|
Ning Hao |
2025-06-27 19:12:28 |
2025-06-27 19:12:28 |
0 |
|
程太祥 Cheng Taixiang
|
BIOG_ADDR_DATA |
| 欄位 |
內容 |
| c_sequence |
1 |
| c_addr_type |
1 |
| c_addr_id |
7758 |
| 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 |
4565 |
| c_pages |
lgid=1166317 |
| c_notes |
(null) |
| c_natal |
0 |
| c_personid |
692139 |
| c_created_by |
Ning Hao |
| c_created_date |
20250627 |
|
692139-7758-1-1
|
1-新增
|
Ning Hao |
2025-06-27 19:05:18 |
2025-06-27 19:05:18 |
0 |
|
程太祥 Cheng Taixiang
|
BIOG_SOURCE_DATA |
| 欄位 |
內容 |
| c_textid |
4565 |
| c_pages |
lgid=1166317 |
| c_notes |
(null) |
| c_main_source |
1 |
| c_self_bio |
1 |
| c_personid |
692139 |
|
692139-4565-lgid=1166317
|
1-新增
|
Ning Hao |
2025-06-27 18:58:38 |
2025-06-27 18:58:38 |
0 |
|
程太祥 Cheng Taixiang
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_surname_chn |
程 |
| c_surname |
Cheng |
| c_mingzi_chn |
太祥 |
| c_mingzi |
Taixiang |
| c_surname_proper |
(null) |
| c_mingzi_proper |
(null) |
| c_surname_rm |
(null) |
| c_mingzi_rm |
(null) |
| c_name_chn |
程太祥 |
| c_name |
Cheng Taixiang |
| 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 |
Ning Hao |
| c_modified_date |
20250627 |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| 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) |
Ning Hao |
Ning Hao |
| c_modified_date |
(null) |
20250627 |
2025-06-27 00:00:00 |
|
692139
|
3-修改
|
Ning Hao |
2025-06-27 18:54:40 |
2025-06-27 18:54:40 |
0 |
|
程太祥 Cheng Taixiang
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_personid |
692139 |
| c_name_chn |
程太祥 |
| c_created_by |
Ning Hao |
| c_created_date |
20250627 |
| c_surname_chn |
程 |
| c_surname |
Cheng |
| c_mingzi_chn |
太祥 |
| c_mingzi |
Taixiang |
| c_name |
Cheng Taixiang |
|
692139
|
1-新增
|
Ning Hao |
2025-06-27 18:54:35 |
2025-06-27 18:54:35 |
0 |
|
查廷瑾 Zha Tingjin
|
ASSOC_DATA |
| 欄位 |
內容 |
| c_sequence |
(null) |
| c_kin_code |
0 |
| c_kin_id |
0 |
| c_assoc_code |
43 |
| c_assoc_id |
355005 |
| 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 |
4565 |
| c_pages |
lgid=1166317 |
| c_inst_name_code |
0 |
| c_personid |
692138 |
| c_created_by |
Ning Hao |
| c_created_date |
20250627 |
|
692138-43-355005-0-0-0-0-[n/a]
|
1-新增
|
Ning Hao |
2025-06-27 18:54:14 |
2025-06-27 18:54:14 |
0 |
|
查廷瑾 Zha Tingjin
|
ALTNAME_DATA |
| 欄位 |
內容 |
| c_sequence |
1 |
| c_alt_name_chn |
南浦先生 |
| c_alt_name |
Nanpuxiansheng |
| c_alt_name_type_code |
5 |
| c_source |
4565 |
| c_pages |
lgid=1166317 |
| c_notes |
(null) |
| c_personid |
692138 |
| c_created_by |
Ning Hao |
| c_created_date |
20250627 |
|
692138-1-南浦先生-5
|
1-新增
|
Ning Hao |
2025-06-27 18:53:38 |
2025-06-27 18:53:38 |
0 |
|
楊昇 Yang Sheng
|
ASSOC_DATA |
| 欄位 |
內容 |
| c_sequence |
(null) |
| c_kin_code |
0 |
| c_kin_id |
0 |
| c_assoc_code |
23 |
| c_assoc_id |
692138 |
| 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 |
4565 |
| c_pages |
lgid=1166317 |
| c_inst_name_code |
0 |
| c_personid |
692137 |
| c_created_by |
Ning Hao |
| c_created_date |
20250627 |
|
692137-23-692138-0-0-0-0-[n/a]
|
1-新增
|
Ning Hao |
2025-06-27 18:51:59 |
2025-06-27 18:51:59 |
0 |
|
查廷瑾 Zha Tingjin
|
BIOG_ADDR_DATA |
| 欄位 |
內容 |
| c_sequence |
1 |
| 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 |
4565 |
| c_pages |
lgid=1166317 |
| c_notes |
(null) |
| c_natal |
0 |
| c_personid |
692138 |
| c_created_by |
Ning Hao |
| c_created_date |
20250627 |
|
692138-7756-1-1
|
1-新增
|
Ning Hao |
2025-06-27 18:51:42 |
2025-06-27 18:51:42 |
0 |
|
查廷瑾 Zha Tingjin
|
BIOG_SOURCE_DATA |
| 欄位 |
內容 |
| c_textid |
4565 |
| c_pages |
lgid=1166317 |
| c_notes |
(null) |
| c_main_source |
1 |
| c_self_bio |
0 |
| c_personid |
692138 |
|
692138-4565-lgid=1166317
|
1-新增
|
Ning Hao |
2025-06-27 18:51:29 |
2025-06-27 18:51:29 |
0 |
|
查廷瑾 Zha Tingjin
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_surname_chn |
查 |
| c_surname |
Zha |
| c_mingzi_chn |
廷瑾 |
| c_mingzi |
Tingjin |
| c_surname_proper |
(null) |
| c_mingzi_proper |
(null) |
| c_surname_rm |
(null) |
| c_mingzi_rm |
(null) |
| c_name_chn |
查廷瑾 |
| c_name |
Zha Tingjin |
| 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 |
Ning Hao |
| c_modified_date |
20250627 |
| 欄位 |
原本的 |
修改後 |
目前資料 |
| 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) |
Ning Hao |
Ning Hao |
| c_modified_date |
(null) |
20250627 |
2025-06-27 00:00:00 |
|
692138
|
3-修改
|
Ning Hao |
2025-06-27 18:45:09 |
2025-06-27 18:45:09 |
0 |
|
查廷瑾 Zha Tingjin
|
BIOG_MAIN |
| 欄位 |
內容 |
| c_personid |
692138 |
| c_name_chn |
查廷瑾 |
| c_created_by |
Ning Hao |
| c_created_date |
20250627 |
| c_surname_chn |
查 |
| c_surname |
Zha |
| c_mingzi_chn |
廷瑾 |
| c_mingzi |
Tingjin |
| c_name |
Zha Tingjin |
|
692138
|
1-新增
|
Ning Hao |
2025-06-27 18:45:04 |
2025-06-27 18:45:04 |
0 |