From 2c86a8bd60deed0dd0e044bad6fb83f75d19a332 Mon Sep 17 00:00:00 2001 From: wlzboy <66905212@qq.com> Date: 星期日, 26 十月 2025 15:05:50 +0800 Subject: [PATCH] Merge branch 'feature-task' --- sql/sys_task_emergency.sql | 57 +++++++++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 57 insertions(+), 0 deletions(-) diff --git a/sql/sys_task_emergency.sql b/sql/sys_task_emergency.sql new file mode 100644 index 0000000..8db1baf --- /dev/null +++ b/sql/sys_task_emergency.sql @@ -0,0 +1,57 @@ +-- ---------------------------- +-- 鎬ユ晳杞繍浠诲姟鎵╁睍琛� +-- 鐢ㄤ簬瀛樺偍鎬ユ晳杞繍鍜岀绁夎溅浠诲姟鐨勪笓灞炲瓧娈� +-- ---------------------------- + +DROP TABLE IF EXISTS sys_task_emergency; +CREATE TABLE sys_task_emergency ( + id BIGINT PRIMARY KEY AUTO_INCREMENT COMMENT '涓婚敭ID', + task_id BIGINT NOT NULL UNIQUE COMMENT '浠诲姟ID', + + -- 鎮ｈ�呬俊鎭� + patient_contact VARCHAR(100) COMMENT '鎮ｈ�呰仈绯讳汉', + patient_phone VARCHAR(20) COMMENT '鎮ｈ�呰仈绯荤數璇�', + patient_name VARCHAR(100) COMMENT '鎮ｈ�呭鍚�', + patient_gender VARCHAR(10) COMMENT '鎮ｈ�呮�у埆:male-鐢�,female-濂�', + patient_id_card VARCHAR(18) COMMENT '鎮ｈ�呰韩浠借瘉鍙�', + patient_condition TEXT COMMENT '鎮ｈ�呯梾鎯呮弿杩�', + + -- 杞嚭鍖婚櫌淇℃伅 + hospital_out_name VARCHAR(200) COMMENT '杞嚭鍖婚櫌鍚嶇О', + hospital_out_department VARCHAR(100) COMMENT '杞嚭鍖婚櫌绉戝', + hospital_out_bed_number VARCHAR(50) COMMENT '杞嚭鍖婚櫌搴婂彿', + hospital_out_address VARCHAR(500) COMMENT '杞嚭鍖婚櫌鍦板潃', + hospital_out_longitude DECIMAL(10,7) COMMENT '杞嚭鍖婚櫌缁忓害', + hospital_out_latitude DECIMAL(10,7) COMMENT '杞嚭鍖婚櫌绾害', + + -- 杞叆鍖婚櫌淇℃伅 + hospital_in_name VARCHAR(200) COMMENT '杞叆鍖婚櫌鍚嶇О', + hospital_in_department VARCHAR(100) COMMENT '杞叆鍖婚櫌绉戝', + hospital_in_bed_number VARCHAR(50) COMMENT '杞叆鍖婚櫌搴婂彿', + hospital_in_address VARCHAR(500) COMMENT '杞叆鍖婚櫌鍦板潃', + hospital_in_longitude DECIMAL(10,7) COMMENT '杞叆鍖婚櫌缁忓害', + hospital_in_latitude DECIMAL(10,7) COMMENT '杞叆鍖婚櫌绾害', + + -- 璐圭敤淇℃伅 + transfer_distance DECIMAL(8,2) COMMENT '杞繍鍏噷鏁�', + transfer_price DECIMAL(10,2) COMMENT '鎴愪氦浠�(鍏�)', + + -- 绂忕杞︿笓鐢ㄥ瓧娈� + passenger_contact VARCHAR(100) COMMENT '涔樺鑱旂郴浜�', + passenger_phone VARCHAR(20) COMMENT '涔樺鑱旂郴鐢佃瘽', + + -- 鐥呮儏璇婃柇淇℃伅 + disease_ids VARCHAR(500) COMMENT '鐥呮儏ID鍒楄〃锛圛CD-10鐤剧梾ID鍒楄〃锛岄�楀彿鍒嗛殧锛岀敤浜庡悓姝ヨ皟搴﹀崟鐨凮rdICD_ID鍙傛暟锛�', + + -- 绯荤粺瀛楁 + create_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + update_time DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '鏇存柊鏃堕棿', + create_by VARCHAR(64) COMMENT '鍒涘缓鑰�', + update_by VARCHAR(64) COMMENT '鏇存柊鑰�', + + INDEX idx_task_id (task_id), + INDEX idx_patient_name (patient_name), + INDEX idx_hospital_out_name (hospital_out_name), + INDEX idx_hospital_in_name (hospital_in_name), + FOREIGN KEY (task_id) REFERENCES sys_task(task_id) ON DELETE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='鎬ユ晳杞繍浠诲姟鎵╁睍淇℃伅琛�'; -- Gitblit v1.9.1