홈 탐색 도움말
로그인
zhangtao
/
programs_info
Watch 1
Star 0
포크 0
파일 이슈 0 풀 리퀘스트 0 위키
트리: 099f5d4f5a
브랜치 태그
programs_info
/
无锡市生命线项目
/
数据库备份
/
删除前备份
/
导出文件
/
linkage_coordinate.sql

linkage_coordinate.sql 8.0 KB
히스토리 Raw

12345678910 
  1. INSERT INTO "linkage_coordinate" ("id", "event_number", "scene", "event_name", "event_rank", "occur_time", "occur_site", "area", "issue_time", "manage_dept", "manage_dept_id", "coordinate_dept", "coordinate_dept_id", "disposal_progress", "disposal_time", "disposal_complete_time", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "remark", "event_id", "coordinate_source", "sms_phone", "sms_content", "attachments") VALUES ('1169659332095115264', '20202020202', '1', '这是一个事件名称', '1', '2023-11-02 00:00:00', '无锡市XXXXXXXX路XX号', '2', NULL, '这是一个主管部门名称', NULL, '部门A，部门B，部门C', NULL, '3', '2023-11-02 15:29:00', '2023-11-02 15:29:22', NULL, NULL, 1, '2023-11-02 15:28:35.991', 'admin', '2023-11-02 15:29:23.112', 'admin', NULL, NULL, NULL, NULL, NULL, NULL);
    2. 

  2. INSERT INTO "linkage_coordinate" ("id", "event_number", "scene", "event_name", "event_rank", "occur_time", "occur_site", "area", "issue_time", "manage_dept", "manage_dept_id", "coordinate_dept", "coordinate_dept_id", "disposal_progress", "disposal_time", "disposal_complete_time", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "remark", "event_id", "coordinate_source", "sms_phone", "sms_content", "attachments") VALUES ('1169659720953233408', '22555852366', '3', '第三方破坏事件001', '3', '2023-11-01 02:02:02', '无锡市12134567亚特发的撒', '4', NULL, '部门AAA', NULL, '44444444444444 ', NULL, '3', '2023-11-04 09:20:02', '2023-11-04 09:20:13', NULL, NULL, 1, '2023-11-02 15:30:08.702', 'admin', '2023-11-04 09:20:13.686', 'admin', NULL, NULL, NULL, NULL, NULL, NULL);
    3. 

  3. INSERT INTO "linkage_coordinate" ("id", "event_number", "scene", "event_name", "event_rank", "occur_time", "occur_site", "area", "issue_time", "manage_dept", "manage_dept_id", "coordinate_dept", "coordinate_dept_id", "disposal_progress", "disposal_time", "disposal_complete_time", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "remark", "event_id", "coordinate_source", "sms_phone", "sms_content", "attachments") VALUES ('1170403807717228544', '1', '0', '2', '0', '2023-11-04 16:46:45', '11', '0', '2023-11-04 16:47:01', '22', NULL, '11', NULL, '1', NULL, NULL, NULL, NULL, 1, '2023-11-04 16:46:52.811', 'admin', '2023-11-04 16:47:02.124', 'admin', NULL, NULL, NULL, NULL, NULL, NULL);
    4. 

  4. INSERT INTO "linkage_coordinate" ("id", "event_number", "scene", "event_name", "event_rank", "occur_time", "occur_site", "area", "issue_time", "manage_dept", "manage_dept_id", "coordinate_dept", "coordinate_dept_id", "disposal_progress", "disposal_time", "disposal_complete_time", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "remark", "event_id", "coordinate_source", "sms_phone", "sms_content", "attachments") VALUES ('1170402750832312320', '11', '0', '22', '0', '2023-11-03 00:00:00', '111', '0', NULL, '111', NULL, '去去去', NULL, '3', '2023-11-04 16:47:10', '2023-11-04 16:47:19', NULL, NULL, 1, '2023-11-04 16:42:40.83', 'admin', '2023-11-04 16:47:19.59', 'admin', NULL, NULL, NULL, NULL, NULL, NULL);
    5. 

  5. INSERT INTO "linkage_coordinate" ("id", "event_number", "scene", "event_name", "event_rank", "occur_time", "occur_site", "area", "issue_time", "manage_dept", "manage_dept_id", "coordinate_dept", "coordinate_dept_id", "disposal_progress", "disposal_time", "disposal_complete_time", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "remark", "event_id", "coordinate_source", "sms_phone", "sms_content", "attachments") VALUES ('1171451538778882048', '001002', '2', '事件名称A', '1', '2023-11-07 08:12:02', '无锡市梁溪区朝阳区', '3', '2023-11-07 14:12:20', '主管部门', NULL, '联动部门', NULL, '3', '2023-11-07 14:13:04', '2023-11-07 14:13:40', NULL, NULL, 1, '2023-11-07 14:10:11.362', 'admin', '2023-11-07 14:13:41.119', 'admin', NULL, NULL, NULL, NULL, NULL, NULL);
    6. 

  6. INSERT INTO "linkage_coordinate" ("id", "event_number", "scene", "event_name", "event_rank", "occur_time", "occur_site", "area", "issue_time", "manage_dept", "manage_dept_id", "coordinate_dept", "coordinate_dept_id", "disposal_progress", "disposal_time", "disposal_complete_time", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "remark", "event_id", "coordinate_source", "sms_phone", "sms_content", "attachments") VALUES ('1171813978951647232', 'LD20231108006', '0', '燃气爆炸', '0', '2023-11-08 14:10:13', '海岸城', '320211', '2023-11-08 15:12:23', '城管', NULL, '园林局', NULL, '2', '2023-11-08 15:12:34', NULL, NULL, NULL, 1, '2023-11-08 14:10:23.833', 'admin', '2023-11-08 15:12:35.32', 'admin', NULL, NULL, NULL, NULL, NULL, NULL);
    7. 

  7. INSERT INTO "linkage_coordinate" ("id", "event_number", "scene", "event_name", "event_rank", "occur_time", "occur_site", "area", "issue_time", "manage_dept", "manage_dept_id", "coordinate_dept", "coordinate_dept_id", "disposal_progress", "disposal_time", "disposal_complete_time", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "remark", "event_id", "coordinate_source", "sms_phone", "sms_content", "attachments") VALUES ('1171830056385773568', '0000', '0', '000', '0', '2023-11-08 00:00:00', '00', '320214', NULL, '000', NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, 1, '2023-11-08 15:14:16.993', 'admin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    8. 

  8. INSERT INTO "linkage_coordinate" ("id", "event_number", "scene", "event_name", "event_rank", "occur_time", "occur_site", "area", "issue_time", "manage_dept", "manage_dept_id", "coordinate_dept", "coordinate_dept_id", "disposal_progress", "disposal_time", "disposal_complete_time", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "remark", "event_id", "coordinate_source", "sms_phone", "sms_content", "attachments") VALUES ('1172469429187903488', 'LD20231110008', '4', '地下管线断裂', '1', '2023-11-10 13:01:00', '梁溪区', '320213', NULL, '管线部门', NULL, NULL, NULL, '0', NULL, NULL, NULL, NULL, 1, '2023-11-10 09:34:55.347', 'admin', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL);
    9. 

  9. INSERT INTO "linkage_coordinate" ("id", "event_number", "scene", "event_name", "event_rank", "occur_time", "occur_site", "area", "issue_time", "manage_dept", "manage_dept_id", "coordinate_dept", "coordinate_dept_id", "disposal_progress", "disposal_time", "disposal_complete_time", "geom_data", "defined", "deleted", "created_at", "created_by", "updated_at", "updated_by", "remark", "event_id", "coordinate_source", "sms_phone", "sms_content", "attachments") VALUES ('1210590152682897408', 'LD20240223009', '3', '毁损燃气设施', '1', '2023-09-07 08:00:00', '锡山区东盛路', '320205', '2024-02-23 07:36:39', '测试部门', NULL, NULL, NULL, '1', NULL, NULL, '010100000084661216FE1E5E40107E3E605C9A3F40', NULL, 1, '2024-02-23 06:13:04.077', 'admin', '2024-02-23 07:30:39.863', 'admin', '', '9dd5e4387d8635aeac7952ce7456fdaa', '0', '15601521886,15601521886(小于),13921168677(test),15601521886(测试人员)', '联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。联动协调  短信功能测试。', NULL);
    10. 

  10.