external_table_field.sql 76 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365
  1. -- ============================================================
  2. -- table_field 插入语句
  3. -- 数据来源:external_tables.sql (13张外部数据表)
  4. -- ============================================================
  5. -- 1. 出入境证件信息 (cert_info)
  6. INSERT INTO table_info (id, main_id, table_name_cn, table_name_en, func_regex, line_no, headers, classify, has_inner, has_table, create_time) VALUES(51, 51, '出入境证件信息', 'cert_info', NULL, 1, '', '公安数据库', 1, 1, '2025-05-15 10:21:39.919');
  7. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(51, 'cert_info', '身份证号', 'cid', 'TEXT', 0, 0, 0, NULL, 1, 0);
  8. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(51, 'cert_info', '出生日期', 'birth', 'TEXT', 0, 0, 0, NULL, 2, 0);
  9. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(51, 'cert_info', '证件类型', 'certType', 'TEXT', 0, 0, 0, NULL, 3, 0);
  10. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(51, 'cert_info', '证件号码', 'certNo', 'TEXT', 0, 0, 0, NULL, 4, 0);
  11. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(51, 'cert_info', '出生地国家/地区', 'bplace', 'TEXT', 0, 0, 0, NULL, 5, 0);
  12. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(51, 'cert_info', '户籍所在地', 'regAddr', 'TEXT', 0, 0, 0, NULL, 6, 0);
  13. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(51, 'cert_info', '所属派出所', 'pcs', 'TEXT', 0, 0, 0, NULL, 7, 0);
  14. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(51, 'cert_info', '前往地国家/地区', 'dplace', 'TEXT', 0, 0, 0, NULL, 8, 0);
  15. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(51, 'cert_info', '签发机关', 'issOrg', 'TEXT', 0, 0, 0, NULL, 9, 0);
  16. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(51, 'cert_info', '出境事由', 'exitReason', 'TEXT', 0, 0, 0, NULL, 10, 0);
  17. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(51, 'cert_info', '签发日期', 'issDate', 'TEXT', 0, 0, 0, NULL, 11, 0);
  18. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(51, 'cert_info', '截止日期', 'expDate', 'TEXT', 0, 0, 0, NULL, 12, 0);
  19. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(51, 'cert_info', '入库时间', 'storeTime', 'TEXT', 0, 0, 0, NULL, 13, 0);
  20. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(51, 'cert_info', '照片', 'photo', 'TEXT', 0, 0, 0, NULL, 14, 0);
  21. -- 2. 出入境记录信息 (entry_rec)
  22. INSERT INTO table_info (id, main_id, table_name_cn, table_name_en, func_regex, line_no, headers, classify, has_inner, has_table, create_time) VALUES(52, 52, '出入境记录信息', 'entry_rec', NULL, 1, '', '公安数据库', 1, 1, '2025-05-15 10:21:39.919');
  23. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(52, 'entry_rec', '证件类别', 'certType', 'TEXT', 0, 0, 0, NULL, 1, 0);
  24. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(52, 'entry_rec', '证件号码', 'certNo', 'TEXT', 0, 0, 0, NULL, 2, 0);
  25. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(52, 'entry_rec', '性别', 'gender', 'TEXT', 0, 0, 0, NULL, 3, 0);
  26. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(52, 'entry_rec', '国籍', 'nation', 'TEXT', 0, 0, 0, NULL, 4, 0);
  27. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(52, 'entry_rec', '签证种类', 'visaType', 'TEXT', 0, 0, 0, NULL, 5, 0);
  28. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(52, 'entry_rec', '身份证号', 'cid', 'TEXT', 0, 0, 0, NULL, 6, 0);
  29. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(52, 'entry_rec', '出生日期', 'birth', 'TEXT', 0, 0, 0, NULL, 7, 0);
  30. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(52, 'entry_rec', '出入日期', 'ioDate', 'TEXT', 0, 0, 0, NULL, 8, 0);
  31. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(52, 'entry_rec', '出入时间', 'ioTime', 'TEXT', 0, 0, 0, NULL, 9, 0);
  32. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(52, 'entry_rec', '出入口岸', 'port', 'TEXT', 0, 0, 0, NULL, 10, 0);
  33. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(52, 'entry_rec', '交通方式', 'transport', 'TEXT', 0, 0, 0, NULL, 11, 0);
  34. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(52, 'entry_rec', '交通工具', 'vehicle', 'TEXT', 0, 0, 0, NULL, 12, 0);
  35. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(52, 'entry_rec', '签证号码', 'visaNo', 'TEXT', 0, 0, 0, NULL, 13, 0);
  36. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(52, 'entry_rec', '前往/归来国家', 'country', 'TEXT', 0, 0, 0, NULL, 14, 0);
  37. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(52, 'entry_rec', '照片', 'photo', 'TEXT', 0, 0, 0, NULL, 15, 0);
  38. -- 3. 机动车信息 (vehicle_info)
  39. INSERT INTO table_info (id, main_id, table_name_cn, table_name_en, func_regex, line_no, headers, classify, has_inner, has_table, create_time) VALUES(53, 53, '机动车信息', 'vehicle_info', NULL, 1, '', '公安数据库', 1, 1, '2025-05-15 10:21:39.919');
  40. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(53, 'vehicle_info', '机动车发动机型号', 'engModel', 'TEXT', 0, 0, 0, NULL, 1, 0);
  41. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(53, 'vehicle_info', '机动车能源种类', 'fuelType', 'TEXT', 0, 0, 0, NULL, 2, 0);
  42. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(53, 'vehicle_info', '机动车发动机排量', 'engCc', 'TEXT', 0, 0, 0, NULL, 3, 0);
  43. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(53, 'vehicle_info', '机动车发动机功率', 'engPwr', 'TEXT', 0, 0, 0, NULL, 4, 0);
  44. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(53, 'vehicle_info', '机动车核定载质量', 'loadCap', 'TEXT', 0, 0, 0, NULL, 5, 0);
  45. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(53, 'vehicle_info', '机动车核定载客人数', 'seatCnt', 'TEXT', 0, 0, 0, NULL, 6, 0);
  46. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(53, 'vehicle_info', '出厂日期', 'madeDate', 'TEXT', 0, 0, 0, NULL, 7, 0);
  47. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(53, 'vehicle_info', '住所地址', 'addr', 'TEXT', 0, 0, 0, NULL, 8, 0);
  48. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(53, 'vehicle_info', '暂住地址', 'tmpAddr', 'TEXT', 0, 0, 0, NULL, 9, 0);
  49. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(53, 'vehicle_info', '照片', 'photo', 'TEXT', 0, 0, 0, NULL, 10, 0);
  50. -- 4. 驾驶证信息 (lic_info)
  51. INSERT INTO table_info (id, main_id, table_name_cn, table_name_en, func_regex, line_no, headers, classify, has_inner, has_table, create_time) VALUES(54, 54, '驾驶证信息', 'lic_info', NULL, 1, '', '公安数据库', 1, 1, '2025-05-15 10:21:39.919');
  52. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(54, 'lic_info', '国籍/地区', 'nation', 'TEXT', 0, 0, 0, NULL, 1, 0);
  53. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(54, 'lic_info', '初次领证日期', 'firstDate', 'TEXT', 0, 0, 0, NULL, 2, 0);
  54. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(54, 'lic_info', '暂住证编号', 'tmpResNo', 'TEXT', 0, 0, 0, NULL, 3, 0);
  55. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(54, 'lic_info', '准驾车型', 'vehType', 'TEXT', 0, 0, 0, NULL, 4, 0);
  56. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(54, 'lic_info', '原准驾车型', 'origType', 'TEXT', 0, 0, 0, NULL, 5, 0);
  57. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(54, 'lic_info', '发证机关', 'issOrg', 'TEXT', 0, 0, 0, NULL, 6, 0);
  58. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(54, 'lic_info', '驾驶证期限', 'licTerm', 'TEXT', 0, 0, 0, NULL, 7, 0);
  59. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(54, 'lic_info', '驾驶证状态', 'status', 'TEXT', 0, 0, 0, NULL, 8, 0);
  60. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(54, 'lic_info', '驾驶证超分日期', 'overScoreDate', 'TEXT', 0, 0, 0, NULL, 9, 0);
  61. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(54, 'lic_info', '累积记分', 'score', 'TEXT', 0, 0, 0, NULL, 10, 0);
  62. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(54, 'lic_info', '登记住所详址', 'regAddr', 'TEXT', 0, 0, 0, NULL, 11, 0);
  63. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(54, 'lic_info', '驾驶证档案编号', 'fileNo', 'TEXT', 0, 0, 0, NULL, 12, 0);
  64. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(54, 'lic_info', '联系住所详址', 'contactAddr', 'TEXT', 0, 0, 0, NULL, 13, 0);
  65. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(54, 'lic_info', '照片', 'photo', 'TEXT', 0, 0, 0, NULL, 14, 0);
  66. -- 5. 机动车违章信息 (veh_violation)
  67. INSERT INTO table_info (id, main_id, table_name_cn, table_name_en, func_regex, line_no, headers, classify, has_inner, has_table, create_time) VALUES(55, 55, '机动车违章信息', 'veh_violation', NULL, 1, '', '公安数据库', 1, 1, '2025-05-15 10:21:39.919');
  68. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(55, 'veh_violation', '当事人', 'person', 'TEXT', 0, 0, 0, NULL, 1, 0);
  69. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(55, 'veh_violation', '驾驶证号', 'licNo', 'TEXT', 0, 0, 0, NULL, 2, 0);
  70. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(55, 'veh_violation', '号牌种类', 'plateType', 'TEXT', 0, 0, 0, NULL, 3, 0);
  71. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(55, 'veh_violation', '号牌号码', 'plateNo', 'TEXT', 0, 0, 0, NULL, 4, 0);
  72. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(55, 'veh_violation', '违法时间', 'violTime', 'TEXT', 0, 0, 0, NULL, 5, 0);
  73. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(55, 'veh_violation', '违法地址', 'violAddr', 'TEXT', 0, 0, 0, NULL, 6, 0);
  74. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(55, 'veh_violation', '处理时间', 'dealTime', 'TEXT', 0, 0, 0, NULL, 7, 0);
  75. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(55, 'veh_violation', '处理机关', 'dealOrg', 'TEXT', 0, 0, 0, NULL, 8, 0);
  76. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(55, 'veh_violation', '违法行为', 'violAct', 'TEXT', 0, 0, 0, NULL, 9, 0);
  77. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(55, 'veh_violation', '照片', 'photo', 'TEXT', 0, 0, 0, NULL, 10, 0);
  78. -- 6. 同户人 (household)
  79. INSERT INTO table_info (id, main_id, table_name_cn, table_name_en, func_regex, line_no, headers, classify, has_inner, has_table, create_time) VALUES(56, 56, '同户人', 'household', NULL, 1, '', '公安数据库', 1, 1, '2025-05-15 10:21:39.919');
  80. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(56, 'household', '年龄', 'age', 'TEXT', 0, 0, 0, NULL, 1, 0);
  81. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(56, 'household', '身高', 'height', 'TEXT', 0, 0, 0, NULL, 2, 0);
  82. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(56, 'household', '职业', 'job', 'TEXT', 0, 0, 0, NULL, 3, 0);
  83. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(56, 'household', '文化程度', 'edu', 'TEXT', 0, 0, 0, NULL, 4, 0);
  84. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(56, 'household', '人员状态', 'status', 'TEXT', 0, 0, 0, NULL, 5, 0);
  85. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(56, 'household', '籍贯国家', 'originCountry', 'TEXT', 0, 0, 0, NULL, 6, 0);
  86. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(56, 'household', '从业单位', 'company', 'TEXT', 0, 0, 0, NULL, 7, 0);
  87. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(56, 'household', '与户主关系', 'relation', 'TEXT', 0, 0, 0, NULL, 8, 0);
  88. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(56, 'household', '户籍地区划', 'regDist', 'TEXT', 0, 0, 0, NULL, 9, 0);
  89. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(56, 'household', '出身地国家/地区', 'birthCountry', 'TEXT', 0, 0, 0, NULL, 10, 0);
  90. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(56, 'household', '出生地区划', 'birthDist', 'TEXT', 0, 0, 0, NULL, 11, 0);
  91. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(56, 'household', '兵役情况', 'milStatus', 'TEXT', 0, 0, 0, NULL, 12, 0);
  92. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(56, 'household', '婚姻状况', 'marital', 'TEXT', 0, 0, 0, NULL, 13, 0);
  93. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(56, 'household', '死亡日期', 'deathDate', 'TEXT', 0, 0, 0, NULL, 14, 0);
  94. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(56, 'household', '照片', 'photo', 'TEXT', 0, 0, 0, NULL, 15, 0);
  95. -- 7. 同住址 (co_resident)
  96. INSERT INTO table_info (id, main_id, table_name_cn, table_name_en, func_regex, line_no, headers, classify, has_inner, has_table, create_time) VALUES(57, 57, '同住址', 'co_resident', NULL, 1, '', '公安数据库', 1, 1, '2025-05-15 10:21:39.919');
  97. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '姓名', 'name', 'TEXT', 0, 0, 0, NULL, 1, 0);
  98. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '性别', 'gender', 'TEXT', 0, 0, 0, NULL, 2, 0);
  99. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '出生日期', 'birth', 'TEXT', 0, 0, 0, NULL, 3, 0);
  100. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '身份证号', 'cid', 'TEXT', 0, 0, 0, NULL, 4, 0);
  101. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '民族', 'ethnicity', 'TEXT', 0, 0, 0, NULL, 5, 0);
  102. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '籍贯', 'origin', 'TEXT', 0, 0, 0, NULL, 6, 0);
  103. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '户籍地', 'regAddr', 'TEXT', 0, 0, 0, NULL, 7, 0);
  104. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '曾用名', 'aka', 'TEXT', 0, 0, 0, NULL, 8, 0);
  105. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '年龄', 'age', 'TEXT', 0, 0, 0, NULL, 9, 0);
  106. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '身高', 'height', 'TEXT', 0, 0, 0, NULL, 10, 0);
  107. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '职业', 'job', 'TEXT', 0, 0, 0, NULL, 11, 0);
  108. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '文化程度', 'edu', 'TEXT', 0, 0, 0, NULL, 12, 0);
  109. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '人员状态', 'status', 'TEXT', 0, 0, 0, NULL, 13, 0);
  110. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '籍贯国家', 'originCountry', 'TEXT', 0, 0, 0, NULL, 14, 0);
  111. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '从业单位', 'company', 'TEXT', 0, 0, 0, NULL, 15, 0);
  112. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '与户主关系', 'relation', 'TEXT', 0, 0, 0, NULL, 16, 0);
  113. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '户籍地区划', 'regDist', 'TEXT', 0, 0, 0, NULL, 17, 0);
  114. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '出身地国家/地区', 'birthCountry', 'TEXT', 0, 0, 0, NULL, 18, 0);
  115. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '出生地区划', 'birthDist', 'TEXT', 0, 0, 0, NULL, 19, 0);
  116. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '兵役情况', 'milStatus', 'TEXT', 0, 0, 0, NULL, 20, 0);
  117. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '婚姻状况', 'marital', 'TEXT', 0, 0, 0, NULL, 21, 0);
  118. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '死亡日期', 'deathDate', 'TEXT', 0, 0, 0, NULL, 22, 0);
  119. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(57, 'co_resident', '照片', 'photo', 'TEXT', 0, 0, 0, NULL, 23, 0);
  120. -- 8. 同车违章 (co_veh_viol)
  121. INSERT INTO table_info (id, main_id, table_name_cn, table_name_en, func_regex, line_no, headers, classify, has_inner, has_table, create_time) VALUES(58, 58, '同车违章', 'co_veh_viol', NULL, 1, '', '公安数据库', 1, 1, '2025-05-15 10:21:39.919');
  122. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(58, 'co_veh_viol', '车牌号码', 'plateNo', 'TEXT', 0, 0, 0, NULL, 1, 0);
  123. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(58, 'co_veh_viol', '姓名', 'name', 'TEXT', 0, 0, 0, NULL, 1, 0);
  124. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(58, 'co_veh_viol', '身份证号', 'cid', 'TEXT', 0, 0, 0, NULL, 2, 0);
  125. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(58, 'co_veh_viol', '车号牌', 'plateNo', 'TEXT', 0, 0, 0, NULL, 3, 0);
  126. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(58, 'co_veh_viol', '同次数', 'coCount', 'TEXT', 0, 0, 0, NULL, 4, 0);
  127. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(58, 'co_veh_viol', '照片', 'photo', 'TEXT', 0, 0, 0, NULL, 5, 0);
  128. -- 9. 违法犯罪人员信息 (criminal)
  129. INSERT INTO table_info (id, main_id, table_name_cn, table_name_en, func_regex, line_no, headers, classify, has_inner, has_table, create_time) VALUES(59, 59, '违法犯罪人员信息', 'criminal', NULL, 1, '', '公安数据库', 1, 1, '2025-05-15 10:21:39.919');
  130. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '姓名', 'name', 'TEXT', 0, 0, 0, NULL, 1, 0);
  131. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '别名绰号', 'alias', 'TEXT', 0, 0, 0, NULL, 2, 0);
  132. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '性别', 'gender', 'TEXT', 0, 0, 0, NULL, 3, 0);
  133. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '身份证号', 'cid', 'TEXT', 0, 0, 0, NULL, 4, 0);
  134. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '民族', 'ethnicity', 'TEXT', 0, 0, 0, NULL, 5, 0);
  135. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '出生日期', 'birth', 'TEXT', 0, 0, 0, NULL, 6, 0);
  136. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '身高', 'height', 'TEXT', 0, 0, 0, NULL, 7, 0);
  137. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '足长', 'footLen', 'TEXT', 0, 0, 0, NULL, 8, 0);
  138. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '文化程度', 'edu', 'TEXT', 0, 0, 0, NULL, 9, 0);
  139. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '户口所在地区划', 'regDist', 'TEXT', 0, 0, 0, NULL, 10, 0);
  140. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '体表标记', 'bodyMark', 'TEXT', 0, 0, 0, NULL, 11, 0);
  141. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '专长', 'skill', 'TEXT', 0, 0, 0, NULL, 12, 0);
  142. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '个人身份', 'identity', 'TEXT', 0, 0, 0, NULL, 13, 0);
  143. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '案件类别', 'caseType', 'TEXT', 0, 0, 0, NULL, 14, 0);
  144. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '简要案情', 'caseBrief', 'TEXT', 0, 0, 0, NULL, 15, 0);
  145. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '警情处理结果', 'result', 'TEXT', 0, 0, 0, NULL, 16, 0);
  146. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '办案单位', 'unit', 'TEXT', 0, 0, 0, NULL, 17, 0);
  147. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '法律文书号', 'docNo', 'TEXT', 0, 0, 0, NULL, 18, 0);
  148. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '抓获/入所日期', 'catchDate', 'TEXT', 0, 0, 0, NULL, 19, 0);
  149. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '刑期', 'sentence', 'TEXT', 0, 0, 0, NULL, 20, 0);
  150. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '出所日期', 'outDate', 'TEXT', 0, 0, 0, NULL, 21, 0);
  151. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '出所去向', 'outTo', 'TEXT', 0, 0, 0, NULL, 22, 0);
  152. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '出所原因', 'outReason', 'TEXT', 0, 0, 0, NULL, 23, 0);
  153. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '入所原因', 'inReason', 'TEXT', 0, 0, 0, NULL, 24, 0);
  154. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '户口所在地详址', 'regDetail', 'TEXT', 0, 0, 0, NULL, 25, 0);
  155. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '现居住地', 'curAddr', 'TEXT', 0, 0, 0, NULL, 26, 0);
  156. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '备注', 'remark', 'TEXT', 0, 0, 0, NULL, 27, 0);
  157. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(59, 'criminal', '照片', 'photo', 'TEXT', 0, 0, 0, NULL, 28, 0);
  158. -- 10. 在逃人员登记信息 (fugitive)
  159. INSERT INTO table_info (id, main_id, table_name_cn, table_name_en, func_regex, line_no, headers, classify, has_inner, has_table, create_time) VALUES(60, 60, '在逃人员登记信息', 'fugitive', NULL, 1, '', '公安数据库', 1, 1, '2025-05-15 10:21:39.919');
  160. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '姓名', 'name', 'TEXT', 0, 0, 0, NULL, 1, 0);
  161. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '性别', 'gender', 'TEXT', 0, 0, 0, NULL, 2, 0);
  162. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '民族', 'ethnicity', 'TEXT', 0, 0, 0, NULL, 3, 0);
  163. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '证件号码', 'certNo', 'TEXT', 0, 0, 0, NULL, 4, 0);
  164. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '出生日期', 'birth', 'TEXT', 0, 0, 0, NULL, 5, 0);
  165. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '职业类别', 'jobType', 'TEXT', 0, 0, 0, NULL, 6, 0);
  166. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '身高上限', 'heightMax', 'TEXT', 0, 0, 0, NULL, 7, 0);
  167. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '身高下限', 'heightMin', 'TEXT', 0, 0, 0, NULL, 8, 0);
  168. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '口音', 'accent', 'TEXT', 0, 0, 0, NULL, 9, 0);
  169. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '在逃人员编号', 'fugiNo', 'TEXT', 0, 0, 0, NULL, 10, 0);
  170. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '人员类型', 'personType', 'TEXT', 0, 0, 0, NULL, 11, 0);
  171. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '十指指纹编号', 'fprintNo', 'TEXT', 0, 0, 0, NULL, 12, 0);
  172. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '在逃人员DNA编号', 'dnaNo', 'TEXT', 0, 0, 0, NULL, 13, 0);
  173. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '逃跑时间', 'fleeTime', 'TEXT', 0, 0, 0, NULL, 14, 0);
  174. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '通缉令编号', 'warrantNo', 'TEXT', 0, 0, 0, NULL, 15, 0);
  175. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '案件编号', 'caseNo', 'TEXT', 0, 0, 0, NULL, 16, 0);
  176. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '案件类别', 'caseType', 'TEXT', 0, 0, 0, NULL, 17, 0);
  177. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '立案单位分类', 'caseUnitType', 'TEXT', 0, 0, 0, NULL, 18, 0);
  178. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '立案单位', 'caseUnit', 'TEXT', 0, 0, 0, NULL, 19, 0);
  179. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '立案日期', 'caseDate', 'TEXT', 0, 0, 0, NULL, 20, 0);
  180. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '督捕级别', 'huntLevel', 'TEXT', 0, 0, 0, NULL, 21, 0);
  181. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '抓逃奖金', 'bounty', 'TEXT', 0, 0, 0, NULL, 22, 0);
  182. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '登记审批姓名', 'regName', 'TEXT', 0, 0, 0, NULL, 23, 0);
  183. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '登记审批时间', 'regTime', 'TEXT', 0, 0, 0, NULL, 24, 0);
  184. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '在逃人员修改处理时间', 'modTime', 'TEXT', 0, 0, 0, NULL, 25, 0);
  185. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '主办单位分类', 'mainUnitType', 'TEXT', 0, 0, 0, NULL, 26, 0);
  186. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '主办人姓名', 'officer', 'TEXT', 0, 0, 0, NULL, 27, 0);
  187. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '主办单位联系电话', 'phone', 'TEXT', 0, 0, 0, NULL, 28, 0);
  188. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '登记单位公安机关名称', 'regOrg', 'TEXT', 0, 0, 0, NULL, 29, 0);
  189. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '主办单位公安机关名称', 'mainOrg', 'TEXT', 0, 0, 0, NULL, 30, 0);
  190. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '户籍地区划', 'regDist', 'TEXT', 0, 0, 0, NULL, 31, 0);
  191. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '户籍地', 'regAddr', 'TEXT', 0, 0, 0, NULL, 32, 0);
  192. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '现住址区划', 'curDist', 'TEXT', 0, 0, 0, NULL, 33, 0);
  193. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '现住址', 'curAddr', 'TEXT', 0, 0, 0, NULL, 34, 0);
  194. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '籍贯', 'origin', 'TEXT', 0, 0, 0, NULL, 35, 0);
  195. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '逃跑方向简要情况', 'fleeDir', 'TEXT', 0, 0, 0, NULL, 36, 0);
  196. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '简要案情', 'caseBrief', 'TEXT', 0, 0, 0, NULL, 37, 0);
  197. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(60, 'fugitive', '照片', 'photo', 'TEXT', 0, 0, 0, NULL, 38, 0);
  198. -- 11. 在逃人员撤销信息 (fugi_revoke)
  199. INSERT INTO table_info (id, main_id, table_name_cn, table_name_en, func_regex, line_no, headers, classify, has_inner, has_table, create_time) VALUES(61, 61, '在逃人员撤销信息', 'fugi_revoke', NULL, 1, '', '公安数据库', 1, 1, '2025-05-15 10:21:39.919');
  200. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '姓名', 'name', 'TEXT', 0, 0, 0, NULL, 1, 0);
  201. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '性别', 'gender', 'TEXT', 0, 0, 0, NULL, 2, 0);
  202. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '民族', 'ethnicity', 'TEXT', 0, 0, 0, NULL, 3, 0);
  203. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '证件号码', 'certNo', 'TEXT', 0, 0, 0, NULL, 4, 0);
  204. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '出生日期', 'birth', 'TEXT', 0, 0, 0, NULL, 5, 0);
  205. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '籍贯', 'origin', 'TEXT', 0, 0, 0, NULL, 6, 0);
  206. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '身高上限', 'heightMax', 'TEXT', 0, 0, 0, NULL, 7, 0);
  207. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '身高下限', 'heightMin', 'TEXT', 0, 0, 0, NULL, 8, 0);
  208. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '在逃人员编号', 'fugiNo', 'TEXT', 0, 0, 0, NULL, 9, 0);
  209. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '人员类型', 'personType', 'TEXT', 0, 0, 0, NULL, 10, 0);
  210. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '职业类别', 'jobType', 'TEXT', 0, 0, 0, NULL, 11, 0);
  211. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '口音', 'accent', 'TEXT', 0, 0, 0, NULL, 12, 0);
  212. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '十指指纹编号', 'fprintNo', 'TEXT', 0, 0, 0, NULL, 13, 0);
  213. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '在逃人员DNA编号', 'dnaNo', 'TEXT', 0, 0, 0, NULL, 14, 0);
  214. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '通缉令编号', 'warrantNo', 'TEXT', 0, 0, 0, NULL, 15, 0);
  215. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '案件编号', 'caseNo', 'TEXT', 0, 0, 0, NULL, 16, 0);
  216. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '案件类别', 'caseType', 'TEXT', 0, 0, 0, NULL, 17, 0);
  217. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '逃跑时间', 'fleeTime', 'TEXT', 0, 0, 0, NULL, 18, 0);
  218. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '逃跑方向简要情况', 'fleeDir', 'TEXT', 0, 0, 0, NULL, 19, 0);
  219. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '立案单位分类', 'caseUnitType', 'TEXT', 0, 0, 0, NULL, 20, 0);
  220. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '立案单位', 'caseUnit', 'TEXT', 0, 0, 0, NULL, 21, 0);
  221. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '立案日期', 'caseDate', 'TEXT', 0, 0, 0, NULL, 22, 0);
  222. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '抓逃奖金', 'bounty', 'TEXT', 0, 0, 0, NULL, 23, 0);
  223. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '抓获日期', 'catchDate', 'TEXT', 0, 0, 0, NULL, 24, 0);
  224. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '抓获地点区划', 'catchDist', 'TEXT', 0, 0, 0, NULL, 25, 0);
  225. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '抓获方式', 'catchWay', 'TEXT', 0, 0, 0, NULL, 26, 0);
  226. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '抓获单位', 'catchUnit', 'TEXT', 0, 0, 0, NULL, 27, 0);
  227. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '登记审批姓名', 'regName', 'TEXT', 0, 0, 0, NULL, 28, 0);
  228. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '登记审批时间', 'regTime', 'TEXT', 0, 0, 0, NULL, 29, 0);
  229. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '登记单位', 'regOrg', 'TEXT', 0, 0, 0, NULL, 30, 0);
  230. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '撤销人姓名', 'revokeName', 'TEXT', 0, 0, 0, NULL, 31, 0);
  231. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '撤销时间', 'revokeTime', 'TEXT', 0, 0, 0, NULL, 32, 0);
  232. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '撤销审批人姓名', 'revokeApprover', 'TEXT', 0, 0, 0, NULL, 33, 0);
  233. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '主办单位分类', 'mainUnitType', 'TEXT', 0, 0, 0, NULL, 34, 0);
  234. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '主办单位', 'mainUnit', 'TEXT', 0, 0, 0, NULL, 35, 0);
  235. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '主办人姓名', 'officer', 'TEXT', 0, 0, 0, NULL, 36, 0);
  236. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '主办人联系电话', 'phone', 'TEXT', 0, 0, 0, NULL, 37, 0);
  237. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '抓获地点行政区划代码', 'catchDistCode', 'TEXT', 0, 0, 0, NULL, 38, 0);
  238. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '代码', 'code', 'TEXT', 0, 0, 0, NULL, 39, 0);
  239. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '户籍地区划', 'regDist', 'TEXT', 0, 0, 0, NULL, 40, 0);
  240. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '户籍地', 'regAddr', 'TEXT', 0, 0, 0, NULL, 41, 0);
  241. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '现住地区划', 'curDist', 'TEXT', 0, 0, 0, NULL, 42, 0);
  242. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '现住地址', 'curAddr', 'TEXT', 0, 0, 0, NULL, 43, 0);
  243. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '简要案情', 'caseBrief', 'TEXT', 0, 0, 0, NULL, 44, 0);
  244. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(61, 'fugi_revoke', '照片', 'photo', 'TEXT', 0, 0, 0, NULL, 45, 0);
  245. -- 12. 在逃同案人员 (fugi_co)
  246. INSERT INTO table_info (id, main_id, table_name_cn, table_name_en, func_regex, line_no, headers, classify, has_inner, has_table, create_time) VALUES(62, 62, '在逃同案人员', 'fugi_co', NULL, 1, '', '公安数据库', 1, 1, '2025-05-15 10:21:39.919');
  247. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '姓名', 'name', 'TEXT', 0, 0, 0, NULL, 1, 0);
  248. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '性别', 'gender', 'TEXT', 0, 0, 0, NULL, 2, 0);
  249. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '出生日期', 'birth', 'TEXT', 0, 0, 0, NULL, 3, 0);
  250. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '证件号码', 'certNo', 'TEXT', 0, 0, 0, NULL, 4, 0);
  251. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '民族', 'ethnicity', 'TEXT', 0, 0, 0, NULL, 5, 0);
  252. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '籍贯', 'origin', 'TEXT', 0, 0, 0, NULL, 6, 0);
  253. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '户籍地', 'regAddr', 'TEXT', 0, 0, 0, NULL, 7, 0);
  254. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '通缉令编号', 'warrantNo', 'TEXT', 0, 0, 0, NULL, 8, 0);
  255. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '在逃人员编号', 'fugiNo', 'TEXT', 0, 0, 0, NULL, 9, 0);
  256. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '案件编号', 'caseNo', 'TEXT', 0, 0, 0, NULL, 10, 0);
  257. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '登记审批姓名', 'regName', 'TEXT', 0, 0, 0, NULL, 11, 0);
  258. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '登记人员姓名', 'regPerson', 'TEXT', 0, 0, 0, NULL, 12, 0);
  259. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '登记单位公安机关名称', 'regOrg', 'TEXT', 0, 0, 0, NULL, 13, 0);
  260. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '登记时间', 'regTime', 'TEXT', 0, 0, 0, NULL, 14, 0);
  261. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '登记审批时间', 'approveTime', 'TEXT', 0, 0, 0, NULL, 15, 0);
  262. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '审批未通过原因', 'rejectReason', 'TEXT', 0, 0, 0, NULL, 16, 0);
  263. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '身高上限', 'heightMax', 'TEXT', 0, 0, 0, NULL, 17, 0);
  264. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '身高下限', 'heightMin', 'TEXT', 0, 0, 0, NULL, 18, 0);
  265. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '户籍地区划', 'regDist', 'TEXT', 0, 0, 0, NULL, 19, 0);
  266. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '口音', 'accent', 'TEXT', 0, 0, 0, NULL, 20, 0);
  267. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '十指指纹编号', 'fprintNo', 'TEXT', 0, 0, 0, NULL, 21, 0);
  268. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '抓逃奖金', 'bounty', 'TEXT', 0, 0, 0, NULL, 22, 0);
  269. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '立案日期', 'caseDate', 'TEXT', 0, 0, 0, NULL, 23, 0);
  270. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '立案单位分类', 'caseUnitType', 'TEXT', 0, 0, 0, NULL, 24, 0);
  271. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '立案单位', 'caseUnit', 'TEXT', 0, 0, 0, NULL, 25, 0);
  272. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '主办人姓名', 'officer', 'TEXT', 0, 0, 0, NULL, 26, 0);
  273. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '主办单位分类', 'mainUnitType', 'TEXT', 0, 0, 0, NULL, 27, 0);
  274. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '主办单位公安机关名称', 'mainOrg', 'TEXT', 0, 0, 0, NULL, 28, 0);
  275. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '主办单位联系电话', 'phone', 'TEXT', 0, 0, 0, NULL, 29, 0);
  276. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '简要案情', 'caseBrief', 'TEXT', 0, 0, 0, NULL, 30, 0);
  277. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '现住址区划', 'curDist', 'TEXT', 0, 0, 0, NULL, 31, 0);
  278. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '现住址', 'curAddr', 'TEXT', 0, 0, 0, NULL, 32, 0);
  279. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '案件类别', 'caseType', 'TEXT', 0, 0, 0, NULL, 33, 0);
  280. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '部督捕级别', 'huntLevel', 'TEXT', 0, 0, 0, NULL, 34, 0);
  281. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '职业类别', 'jobType', 'TEXT', 0, 0, 0, NULL, 35, 0);
  282. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '在逃人员类型', 'personType', 'TEXT', 0, 0, 0, NULL, 36, 0);
  283. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '在逃人员修改处理时间', 'modTime', 'TEXT', 0, 0, 0, NULL, 37, 0);
  284. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '在逃人员DNA编号', 'dnaNo', 'TEXT', 0, 0, 0, NULL, 38, 0);
  285. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '逃跑时间', 'fleeTime', 'TEXT', 0, 0, 0, NULL, 39, 0);
  286. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '逃跑方向简要情况', 'fleeDir', 'TEXT', 0, 0, 0, NULL, 40, 0);
  287. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(62, 'fugi_co', '照片', 'photo', 'TEXT', 0, 0, 0, NULL, 41, 0);
  288. -- 13. 在逃同案撤销人员 (fugi_co_revoke)
  289. INSERT INTO table_info (id, main_id, table_name_cn, table_name_en, func_regex, line_no, headers, classify, has_inner, has_table, create_time) VALUES(63, 63, '在逃同案撤销人员', 'fugi_co_revoke', NULL, 1, '', '公安数据库', 1, 1, '2025-05-15 10:21:39.919');
  290. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '姓名', 'name', 'TEXT', 0, 0, 0, NULL, 1, 0);
  291. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '性别', 'gender', 'TEXT', 0, 0, 0, NULL, 2, 0);
  292. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '出生日期', 'birth', 'TEXT', 0, 0, 0, NULL, 3, 0);
  293. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '证件号码', 'certNo', 'TEXT', 0, 0, 0, NULL, 4, 0);
  294. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '民族', 'ethnicity', 'TEXT', 0, 0, 0, NULL, 5, 0);
  295. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '籍贯', 'origin', 'TEXT', 0, 0, 0, NULL, 6, 0);
  296. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '户籍地', 'regAddr', 'TEXT', 0, 0, 0, NULL, 7, 0);
  297. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '撤销时间', 'revokeTime', 'TEXT', 0, 0, 0, NULL, 8, 0);
  298. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '撤销处理时间', 'revokeProcTime', 'TEXT', 0, 0, 0, NULL, 9, 0);
  299. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '撤销人姓名', 'revokeName', 'TEXT', 0, 0, 0, NULL, 10, 0);
  300. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '通缉令编号', 'warrantNo', 'TEXT', 0, 0, 0, NULL, 11, 0);
  301. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '在逃人员编号', 'fugiNo', 'TEXT', 0, 0, 0, NULL, 12, 0);
  302. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '案件编号', 'caseNo', 'TEXT', 0, 0, 0, NULL, 13, 0);
  303. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '登记审批姓名', 'regName', 'TEXT', 0, 0, 0, NULL, 14, 0);
  304. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '登记人员姓名', 'regPerson', 'TEXT', 0, 0, 0, NULL, 15, 0);
  305. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '登记单位', 'regOrg', 'TEXT', 0, 0, 0, NULL, 16, 0);
  306. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '登记时间', 'regTime', 'TEXT', 0, 0, 0, NULL, 17, 0);
  307. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '登记审批时间', 'approveTime', 'TEXT', 0, 0, 0, NULL, 18, 0);
  308. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '审批未通过原因', 'rejectReason', 'TEXT', 0, 0, 0, NULL, 19, 0);
  309. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '身高上限', 'heightMax', 'TEXT', 0, 0, 0, NULL, 20, 0);
  310. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '身高下限', 'heightMin', 'TEXT', 0, 0, 0, NULL, 21, 0);
  311. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '户籍地区划', 'regDist', 'TEXT', 0, 0, 0, NULL, 22, 0);
  312. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '口音', 'accent', 'TEXT', 0, 0, 0, NULL, 23, 0);
  313. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '十指指纹编号', 'fprintNo', 'TEXT', 0, 0, 0, NULL, 24, 0);
  314. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '抓逃奖金', 'bounty', 'TEXT', 0, 0, 0, NULL, 25, 0);
  315. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '立案日期', 'caseDate', 'TEXT', 0, 0, 0, NULL, 26, 0);
  316. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '立案单位分类', 'caseUnitType', 'TEXT', 0, 0, 0, NULL, 27, 0);
  317. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '立案单位', 'caseUnit', 'TEXT', 0, 0, 0, NULL, 28, 0);
  318. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '主办人姓名', 'officer', 'TEXT', 0, 0, 0, NULL, 29, 0);
  319. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '主办单位分类', 'mainUnitType', 'TEXT', 0, 0, 0, NULL, 30, 0);
  320. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '主办单位', 'mainUnit', 'TEXT', 0, 0, 0, NULL, 31, 0);
  321. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '主办单位联系电话', 'phone', 'TEXT', 0, 0, 0, NULL, 32, 0);
  322. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '现住址区划', 'curDist', 'TEXT', 0, 0, 0, NULL, 33, 0);
  323. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '逃跑时间', 'fleeTime', 'TEXT', 0, 0, 0, NULL, 34, 0);
  324. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '现住址', 'curAddr', 'TEXT', 0, 0, 0, NULL, 35, 0);
  325. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '案件类别', 'caseType', 'TEXT', 0, 0, 0, NULL, 36, 0);
  326. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '部督捕级别', 'huntLevel', 'TEXT', 0, 0, 0, NULL, 37, 0);
  327. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '职业类别', 'jobType', 'TEXT', 0, 0, 0, NULL, 38, 0);
  328. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '在逃人员类型', 'personType', 'TEXT', 0, 0, 0, NULL, 39, 0);
  329. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '在逃人员修改处理时间', 'modTime', 'TEXT', 0, 0, 0, NULL, 40, 0);
  330. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '在逃人员DNA编号', 'dnaNo', 'TEXT', 0, 0, 0, NULL, 41, 0);
  331. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '撤销审批人姓名', 'revokeApprover', 'TEXT', 0, 0, 0, NULL, 42, 0);
  332. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '抓获日期', 'catchDate', 'TEXT', 0, 0, 0, NULL, 43, 0);
  333. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '抓获方式', 'catchWay', 'TEXT', 0, 0, 0, NULL, 44, 0);
  334. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '抓获单位', 'catchUnit', 'TEXT', 0, 0, 0, NULL, 45, 0);
  335. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '抓获地点', 'catchPlace', 'TEXT', 0, 0, 0, NULL, 46, 0);
  336. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '逃跑方向简要情况', 'fleeDir', 'TEXT', 0, 0, 0, NULL, 47, 0);
  337. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '简要案情', 'caseBrief', 'TEXT', 0, 0, 0, NULL, 48, 0);
  338. INSERT INTO table_field (table_id, table_name_en, field_name_cn, field_name_en, field_type, required, field_len, "matched", direction_conf, field_sort, zf) VALUES(63, 'fugi_co_revoke', '照片', 'photo', 'TEXT', 0, 0, 0, NULL, 49, 0);