* 修改類型 0表示crowdsourcing記錄,1表示新增,2表示整體覆寫(完整替換現有記錄,主要用於 code 表修改),3表示修改,4表示刪除,8表示記錄新增提案,9表示記錄修改提案
* 狀態 0代表是專業用戶修改的記錄,1代表crowdsourcing記錄並且已插入數據庫。
(本修改不涉及人物)
TEXT_CODES
內容快照
比較
欄位
內容
c_textid
8548
c_title_chn
楚州圖經:二卷
c_title
Chuzhou Tujing
c_title_trans
(null)
c_text_type_id
01021302
c_text_year
(null)
c_text_nh_code
0
c_text_nh_year
(null)
c_text_range_code
(null)
c_bibl_cat_code
117
c_extant
2
c_text_country
1
c_text_dy
15
c_source
70614
c_pages
1360
c_url_api
(null)
c_url_api_coda
(null)
c_url_homepage
(null)
c_notes
(null)
c_title_alt_chn
(null)
c_created_by
BDGSX
c_created_date
20070702
c_modified_by
Hongsu Wang
c_modified_date
20251219
c_created_date_timestamp_temporary
2007-07-02 00:00:00
c_modified_date_timestamp_temporary
2025-12-19 19:37:40
欄位
原本的
修改後
目前資料
c_text_type_id
(null)
01021302
(未取得)
c_bibl_cat_code
0
117
(未取得)
c_source
0
70614
(未取得)
c_pages
(null)
1360
(未取得)
c_modified_date_timestamp_temporary
2025-12-19 19:01:44
2025-12-19 19:37:40
(未取得)
8548
2-整體覆寫
Hongsu Wang
2025-12-19 19:37:40
2025-12-19 19:37:40
0
(本修改不涉及人物)
TEXT_CODES
內容快照
比較
欄位
內容
c_textid
70564
c_title_chn
楚州圖經:二卷
c_title
chu zhou tu jing: er juan
c_title_trans
(null)
c_text_type_id
01021302
c_text_year
(null)
c_text_nh_code
(null)
c_text_nh_year
(null)
c_text_range_code
(null)
c_bibl_cat_code
117
c_extant
2
c_text_country
(null)
c_text_dy
15
c_source
70614
c_pages
1360
c_url_api
(null)
c_url_api_coda
(null)
c_url_homepage
(null)
c_notes
(null)
c_title_alt_chn
(null)
c_created_by
Li Yitian
c_created_date
20251217
c_modified_by
(null)
c_modified_date
(null)
c_created_date_timestamp_temporary
(null)
c_modified_date_timestamp_temporary
(null)
{"c_textid":70564,"c_title_chn":"楚州圖經:二卷","c_title":"chu zhou tu jing: er juan","c_title_trans":null,"c_text_type_id":"01021302","c_text_year":null,"c_text_nh_code":null,"c_text_nh_year":null,"c_text_range_code":null,"c_bibl_cat_code":117,"c_extant":2,"c_text_country":null,"c_text_dy":15,"c_source":70614,"c_pages":"1360","c_url_api":null,"c_url_api_coda":null,"c_url_homepage":null,"c_notes":null,"c_title_alt_chn":null,"c_created_by":"Li Yitian","c_created_date":"20251217","c_modified_by":null,"c_modified_date":null,"c_created_date_timestamp_temporary":null,"c_modified_date_timestamp_temporary":null}
70564
4-刪除
Hongsu Wang
2025-12-19 19:37:35
2025-12-19 19:37:35
0
錢之望 Qian Zhiwang
BIOG_TEXT_DATA
內容快照
比較
欄位
內容
c_textid
8548
c_role_id
1
c_source
70614
c_pages
1360
c_notes
(null)
c_modified_by
Hongsu Wang
c_modified_date
20251219
c_modified_date_timestamp_temporary
2025-12-19T11:35:36.427802Z
c_personid
16270
欄位
原本的
修改後
目前資料
c_textid
70564
8548
(未取得)
c_modified_by
(null)
Hongsu Wang
(未取得)
c_modified_date
(null)
20251219
(未取得)
c_modified_date_timestamp_temporary
(null)
2025-12-19T11:35:36.427802Z
(未取得)
16270-8548-1
3-修改
Hongsu Wang
2025-12-19 19:35:36
2025-12-19 19:35:36
0
(本修改不涉及人物)
TEXT_CODES
內容快照
比較
欄位
內容
c_textid
8548
c_title_chn
楚州圖經:二卷
c_title
Chuzhou Tujing
c_title_trans
(null)
c_text_type_id
(null)
c_text_year
(null)
c_text_nh_code
0
c_text_nh_year
(null)
c_text_range_code
(null)
c_bibl_cat_code
0
c_extant
2
c_text_country
1
c_text_dy
15
c_source
0
c_pages
(null)
c_url_api
(null)
c_url_api_coda
(null)
c_url_homepage
(null)
c_notes
(null)
c_title_alt_chn
(null)
c_created_by
BDGSX
c_created_date
20070702
c_modified_by
Hongsu Wang
c_modified_date
20251219
c_created_date_timestamp_temporary
2007-07-02 00:00:00
c_modified_date_timestamp_temporary
2025-12-19 19:01:44
欄位
原本的
修改後
目前資料
c_title_chn
楚州圖經
楚州圖經:二卷
(未取得)
c_modified_by
(null)
Hongsu Wang
(未取得)
c_modified_date
(null)
20251219
(未取得)
c_modified_date_timestamp_temporary
(null)
2025-12-19 19:01:44
(未取得)
8548
2-整體覆寫
Hongsu Wang
2025-12-19 19:01:44
2025-12-19 19:01:44
0
雷楚材 Lei Chucai
ENTRY_DATA
內容快照
比較
欄位
內容
c_sequence
0
c_entry_code
47
c_year
0
c_nianhao_id
(null)
c_entry_nh_year
(null)
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
0
c_pages
(null)
c_notes
(null)
c_personid
697525
c_created_by
kainixiong
c_created_date
20251219
c_created_date_timestamp_temporary
2025-12-19T09:45:48.329880Z
c_inst_name_code
0
697525-47-0-0-0-0-0-0-0-0
1-新增
kainixiong
2025-12-19 17:45:48
2025-12-19 17:45:48
0
雷楚材 Lei Chucai
ALTNAME_DATA
內容快照
比較
欄位
內容
c_sequence
0
c_alt_name_chn
菊溪子
c_alt_name
Juxizi
c_alt_name_type_code
5
c_source
70615
c_pages
(null)
c_notes
(null)
c_modified_by
kainixiong
c_modified_date
20251219
c_modified_date_timestamp_temporary
2025-12-19T09:44:42.474469Z
欄位
原本的
修改後
目前資料
c_alt_name
juxizi
Juxizi
(未取得)
c_modified_by
(null)
kainixiong
(未取得)
c_modified_date
(null)
20251219
(未取得)
c_modified_date_timestamp_temporary
(null)
2025-12-19T09:44:42.474469Z
(未取得)
697525-0-菊溪子-5
3-修改
kainixiong
2025-12-19 17:44:42
2025-12-19 17:44:42
0
雷楚材 Lei Chucai
ALTNAME_DATA
內容快照
比較
欄位
內容
c_sequence
0
c_alt_name_chn
蘭樵
c_alt_name
Lanqiao
c_alt_name_type_code
4
c_source
70615
c_pages
(null)
c_notes
(null)
c_modified_by
kainixiong
c_modified_date
20251219
c_modified_date_timestamp_temporary
2025-12-19T09:44:19.247261Z
欄位
原本的
修改後
目前資料
c_alt_name
lanqiao
Lanqiao
(未取得)
c_modified_date_timestamp_temporary
2025-12-19 17:33:35
2025-12-19T09:44:19.247261Z
(未取得)
697525-0-蘭樵-4
3-修改
kainixiong
2025-12-19 17:44:19
2025-12-19 17:44:19
0
雷楚材 Lei Chucai
ALTNAME_DATA
內容快照
比較
欄位
內容
c_sequence
0
c_alt_name_chn
蘭樵
c_alt_name
Lanqiao
c_alt_name_type_code
4
c_source
70615
c_pages
(null)
c_notes
(null)
c_modified_by
kainixiong
c_modified_date
20251219
c_modified_date_timestamp_temporary
2025-12-19T09:44:19.706364Z
欄位
原本的
修改後
目前資料
c_modified_date_timestamp_temporary
2025-12-19 17:44:19
2025-12-19T09:44:19.706364Z
(未取得)
697525-0-蘭樵-4
3-修改
kainixiong
2025-12-19 17:44:19
2025-12-19 17:44:19
0
雷楚材 Lei Chucai
BIOG_ADDR_DATA
內容快照
比較
欄位
內容
c_sequence
0
c_addr_type
1
c_addr_id
8208
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
(null)
c_pages
(null)
c_notes
(null)
c_natal
0
c_personid
697525
c_created_by
kainixiong
c_created_date
20251219
c_created_date_timestamp_temporary
2025-12-19T09:38:22.567516Z
697525-8208-1-0
1-新增
kainixiong
2025-12-19 17:38:22
2025-12-19 17:38:22
0
雷楚材 Lei Chucai
ALTNAME_DATA
內容快照
比較
欄位
內容
c_sequence
0
c_alt_name_chn
菊溪子
c_alt_name
juxizi
c_alt_name_type_code
5
c_source
70615
c_pages
(null)
c_notes
(null)
c_personid
697525
c_created_by
kainixiong
c_created_date
20251219
c_created_date_timestamp_temporary
2025-12-19T09:35:14.891331Z
697525-0-菊溪子-5
1-新增
kainixiong
2025-12-19 17:35:14
2025-12-19 17:35:14
0
雷楚材 Lei Chucai
ALTNAME_DATA
內容快照
比較
欄位
內容
c_sequence
0
c_alt_name_chn
蘭樵
c_alt_name
lanqiao
c_alt_name_type_code
4
c_source
70615
c_pages
(null)
c_notes
(null)
c_modified_by
kainixiong
c_modified_date
20251219
c_modified_date_timestamp_temporary
2025-12-19T09:33:35.053226Z
欄位
原本的
修改後
目前資料
c_sequence
1
0
(未取得)
c_modified_by
(null)
kainixiong
(未取得)
c_modified_date
(null)
20251219
(未取得)
c_modified_date_timestamp_temporary
(null)
2025-12-19T09:33:35.053226Z
(未取得)
697525-0-蘭樵-4
3-修改
kainixiong
2025-12-19 17:33:35
2025-12-19 17:33:35
0
雷楚材 Lei Chucai
ALTNAME_DATA
內容快照
比較
欄位
內容
c_sequence
1
c_alt_name_chn
蘭樵
c_alt_name
lanqiao
c_alt_name_type_code
4
c_source
70615
c_pages
(null)
c_notes
(null)
c_personid
697525
c_created_by
kainixiong
c_created_date
20251219
c_created_date_timestamp_temporary
2025-12-19T09:32:23.026378Z
697525-1-蘭樵-4
1-新增
kainixiong
2025-12-19 17:32:23
2025-12-19 17:32:23
0
雷楚材 Lei Chucai
BIOG_SOURCE_DATA
內容快照
比較
欄位
內容
c_textid
70615
c_pages
0
c_notes
(null)
c_main_source
1
c_self_bio
1
c_personid
697525
c_created_by
Hongsu Wang
c_created_date
2025-12-19T09:30:46.707451Z
697525-70615-0
1-新增
Hongsu Wang
2025-12-19 17:30:46
2025-12-19 17:30:46
0
雷楚材 Lei Chucai
BIOG_TEXT_DATA
內容快照
比較
欄位
內容
c_textid
70615
c_role_id
1
c_source
70615
c_pages
(null)
c_notes
(null)
c_personid
697525
c_created_by
Hongsu Wang
c_created_date
20251219
c_created_date_timestamp_temporary
2025-12-19T09:28:30.000953Z
697525-70615-1
1-新增
Hongsu Wang
2025-12-19 17:28:30
2025-12-19 17:28:30
0
雷楚材 Lei Chucai
BIOG_MAIN
內容快照
比較
欄位
內容
c_surname_chn
雷
c_mingzi_chn
楚材
c_surname
Lei
c_mingzi
Chucai
c_surname_proper
(null)
c_mingzi_proper
(null)
c_surname_rm
(null)
c_mingzi_rm
(null)
c_name_chn
雷楚材
c_name
Lei Chucai
c_name_proper
c_name_rm
c_female
0
c_ethnicity_code
(null)
c_dy
20
c_birthyear
1747
c_by_nh_code
662
c_by_nh_year
12
c_by_range
(null)
c_by_intercalary
0
c_by_month
(null)
c_by_day
(null)
c_by_day_gz
(null)
c_deathyear
1822
c_dy_nh_code
664
c_dy_nh_year
2
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
Hongsu Wang
c_modified_date
20251219
c_modified_date_timestamp_temporary
2025-12-19T09:27:35.641993Z
欄位
原本的
修改後
目前資料
c_dy
(null)
20
20
c_modified_date_timestamp_temporary
2025-12-19 17:27:20
2025-12-19T09:27:35.641993Z
2025-12-19 17:27:35
697525
3-修改
Hongsu Wang
2025-12-19 17:27:35
2025-12-19 17:27:35
0
雷楚材 Lei Chucai
BIOG_MAIN
內容快照
比較
欄位
內容
c_surname_chn
雷
c_mingzi_chn
楚材
c_surname
Lei
c_mingzi
Chucai
c_surname_proper
(null)
c_mingzi_proper
(null)
c_surname_rm
(null)
c_mingzi_rm
(null)
c_name_chn
雷楚材
c_name
Lei Chucai
c_name_proper
c_name_rm
c_female
0
c_ethnicity_code
(null)
c_dy
(null)
c_birthyear
1747
c_by_nh_code
662
c_by_nh_year
12
c_by_range
(null)
c_by_intercalary
0
c_by_month
(null)
c_by_day
(null)
c_by_day_gz
(null)
c_deathyear
1822
c_dy_nh_code
664
c_dy_nh_year
2
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
Hongsu Wang
c_modified_date
20251219
c_modified_date_timestamp_temporary
2025-12-19T09:27:20.954718Z
欄位
原本的
修改後
目前資料
c_ethnicity_code
1
(null)
(null)
c_dy
20
(null)
20
c_by_nh_year
3
12
12
c_dy_nh_year
3
2
2
c_death_age
76
(null)
(null)
c_death_age_range
0
-1
-1
c_choronym_code
0
(null)
(null)
c_modified_by
kainixiong
Hongsu Wang
Hongsu Wang
c_modified_date_timestamp_temporary
2025-12-19 17:26:51
2025-12-19T09:27:20.954718Z
2025-12-19 17:27:35
697525
3-修改
Hongsu Wang
2025-12-19 17:27:20
2025-12-19 17:27:20
0
雷楚材 Lei Chucai
BIOG_MAIN
內容快照
比較
欄位
內容
c_surname_chn
雷
c_mingzi_chn
楚材
c_surname
Lei
c_mingzi
Chucai
c_surname_proper
(null)
c_mingzi_proper
(null)
c_surname_rm
(null)
c_mingzi_rm
(null)
c_name_chn
雷楚材
c_name
Lei Chucai
c_name_proper
c_name_rm
c_female
0
c_ethnicity_code
1
c_dy
20
c_birthyear
1747
c_by_nh_code
662
c_by_nh_year
3
c_by_range
(null)
c_by_intercalary
0
c_by_month
(null)
c_by_day
(null)
c_by_day_gz
(null)
c_deathyear
1822
c_dy_nh_code
664
c_dy_nh_year
3
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
76
c_death_age_range
0
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
0
c_household_status_code
(null)
c_notes
(null)
c_modified_by
kainixiong
c_modified_date
20251219
c_modified_date_timestamp_temporary
2025-12-19T09:26:51.420356Z
欄位
原本的
修改後
目前資料
c_female
(null)
0
0
c_ethnicity_code
(null)
1
(null)
c_dy
(null)
20
20
c_birthyear
(null)
1747
1747
c_by_nh_code
(null)
662
662
c_by_nh_year
(null)
3
12
c_by_intercalary
(null)
0
0
c_deathyear
(null)
1822
1822
c_dy_nh_code
(null)
664
664
c_dy_nh_year
(null)
3
2
c_dy_intercalary
(null)
0
0
c_death_age
(null)
76
(null)
c_death_age_range
(null)
0
-1
c_choronym_code
(null)
0
(null)
c_modified_by
(null)
kainixiong
Hongsu Wang
c_modified_date
(null)
20251219
20251219
c_modified_date_timestamp_temporary
(null)
2025-12-19T09:26:51.420356Z
2025-12-19 17:27:35
697525
3-修改
kainixiong
2025-12-19 17:26:51
2025-12-19 17:26:51
0
雷楚材 Lei Chucai
BIOG_MAIN
內容快照
比較
欄位
內容
c_personid
697525
c_name_chn
雷楚材
c_created_by
kainixiong
c_created_date
20251219
c_created_date_timestamp_temporary
2025-12-19T09:03:15.487337Z
c_surname_chn
雷
c_surname
Lei
c_mingzi_chn
楚材
c_mingzi
Chucai
c_name
Lei Chucai
697525
1-新增
kainixiong
2025-12-19 17:03:15
2025-12-19 17:03:15
0
(本修改不涉及人物)
TEXT_CODES
內容快照
比較
欄位
內容
c_textid
70615
c_title_chn
漢南詩約: 二十卷
c_title
han nan shi yue
c_title_trans
(null)
c_text_type_id
0104
c_text_year
(null)
c_text_nh_code
(null)
c_text_nh_year
(null)
c_text_range_code
(null)
c_bibl_cat_code
(null)
c_extant
(null)
c_text_country
1
c_text_dy
20
c_source
(null)
c_pages
(null)
c_url_api
(null)
c_url_api_coda
(null)
c_url_homepage
(null)
c_notes
(null)
c_title_alt_chn
(null)
c_created_by
Hongsu Wang
c_created_date
20251219
c_modified_by
(null)
c_modified_date
(null)
c_created_date_timestamp_temporary
2025-12-19 16:53:11
c_modified_date_timestamp_temporary
(null)
70615
1-新增
Hongsu Wang
2025-12-19 16:53:11
2025-12-19 16:53:11
0
余氏(吳公寬母)(Yu Shi(Mother of Wu Gongkuan )) Yu Shi(Mother of Wu Gongkuan )
BIOG_MAIN
內容快照
比較
欄位
內容
c_surname_chn
余
c_mingzi_chn
氏(吳公寬母)(Yu Shi(Mother of Wu Gongkuan ))
c_surname
Yu
c_mingzi
Shi(Mother of Wu Gongkuan )
c_surname_proper
(null)
c_mingzi_proper
(null)
c_surname_rm
(null)
c_mingzi_rm
(null)
c_name_chn
余氏(吳公寬母)(Yu Shi(Mother of Wu Gongkuan ))
c_name
Yu Shi(Mother of Wu Gongkuan )
c_name_proper
c_name_rm
c_female
1
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_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
20251219
c_modified_date_timestamp_temporary
2025-12-19T03:09:25.811933Z
欄位
原本的
修改後
目前資料
c_surname_chn
(null)
余
余
c_mingzi_chn
余氏(吳公寬母)(Yu Shi(Mother of Wu Gongkuan ))
氏(吳公寬母)(Yu Shi(Mother of Wu Gongkuan ))
氏(吳公寬母)(Yu Shi(Mother of Wu Gongkuan ))
c_surname
(null)
Yu
Yu
c_mingzi
Yushi(wugongkuanmu)(Yu Shi(Mother of Wu Gongkuan ))
Shi(Mother of Wu Gongkuan )
Shi(Mother of Wu Gongkuan )
c_name
Yushi(wugongkuanmu)(Yu Shi(Mother of Wu Gongkuan ))
Yu Shi(Mother of Wu Gongkuan )
Yu Shi(Mother of Wu Gongkuan )
c_female
(null)
1
1
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)
20251219
20251219
c_modified_date_timestamp_temporary
(null)
2025-12-19T03:09:25.811933Z
2025-12-19 11:09:25
697524
3-修改
陶恒
2025-12-19 11:09:25
2025-12-19 11:09:25
0