1.1數據庫表 · API接口

~~~ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for hp_area -- ---------------------------- DROP TABLE IF EXISTS `hp_area`; CREATE TABLE `hp_area` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `add_time` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='面積'; -- ---------------------------- -- Table structure for hp_cases -- ---------------------------- DROP TABLE IF EXISTS `hp_cases`; CREATE TABLE `hp_cases` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(11) DEFAULT NULL COMMENT '醫生ID', `m_id` int(11) DEFAULT NULL COMMENT '患者ID', `state` tinyint(2) DEFAULT NULL COMMENT '是否住院 0為不住院 1為住院', `clinic_date` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '就診日期', `record` text COLLATE utf8mb4_general_ci COMMENT '記錄', `add_time` int(11) DEFAULT NULL, `length_time` varchar(11) COLLATE utf8mb4_general_ci DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='就診記錄表'; -- ---------------------------- -- Table structure for hp_diseases -- ---------------------------- DROP TABLE IF EXISTS `hp_diseases`; CREATE TABLE `hp_diseases` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `add_time` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='病種'; -- ---------------------------- -- Table structure for hp_instrument -- ---------------------------- DROP TABLE IF EXISTS `hp_instrument`; CREATE TABLE `hp_instrument` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8mb4_general_ci DEFAULT '' COMMENT '儀器名稱', `add_time` int(11) DEFAULT NULL, `status` tinyint(2) DEFAULT NULL COMMENT '儀器狀態 0為停用 1為正常 ', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- ---------------------------- -- Table structure for hp_instrument_buy -- ---------------------------- DROP TABLE IF EXISTS `hp_instrument_buy`; CREATE TABLE `hp_instrument_buy` ( `id` int(11) NOT NULL AUTO_INCREMENT, `instrument_id` int(11) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `m_id` int(11) DEFAULT NULL, `buy_time` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL, `number` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL, `add_time` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci; -- ---------------------------- -- Table structure for hp_instrument_record -- ---------------------------- DROP TABLE IF EXISTS `hp_instrument_record`; CREATE TABLE `hp_instrument_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `m_id` int(11) DEFAULT NULL COMMENT '患者ＩＤ', `user_id` int(11) DEFAULT NULL COMMENT '使用者', `instrument_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '儀器名稱', `location` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '部位', `operation_time` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作時長', `operation_doctor` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '操作醫生', `feedback` tinytext COLLATE utf8mb4_general_ci COMMENT '反饋', `add_time` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='儀器使用記錄'; -- ---------------------------- -- Table structure for hp_medicine_record -- ---------------------------- DROP TABLE IF EXISTS `hp_medicine_record`; CREATE TABLE `hp_medicine_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `add_time` int(11) DEFAULT NULL, `title` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '藥品名稱', `length_time` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '拿藥時長', `user_id` int(11) DEFAULT NULL COMMENT '醫生ID', `m_id` int(11) DEFAULT NULL COMMENT '患者ID', `visit_time` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '回訪時間', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='拿藥記錄'; -- ---------------------------- -- Table structure for hp_members -- ---------------------------- DROP TABLE IF EXISTS `hp_members`; CREATE TABLE `hp_members` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '姓名', `sex` tinyint(2) DEFAULT NULL COMMENT '1為男 2為女 0為未知', `birthday` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '生日', `phone` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL, `diseases` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '病種', `location` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '患病部位', `area` varchar(20) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '面積', `way` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '來院途徑', `type` tinyint(2) DEFAULT NULL COMMENT '就診類型', `address` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '住址', `history` tinytext COLLATE utf8mb4_general_ci COMMENT '即往史', `family` tinytext COLLATE utf8mb4_general_ci COMMENT '家族史', `serial_number` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '編號', `id_card` varchar(19) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '身份證', `doctor_id` int(11) DEFAULT NULL COMMENT '醫生ID', `user_id` int(11) DEFAULT NULL COMMENT '操作人 ID', `add_time` int(11) DEFAULT NULL COMMENT '添加時間', `age` int(11) DEFAULT NULL COMMENT '年齡', PRIMARY KEY (`id`) ) ENGINE=MyISAM AUTO_INCREMENT=28 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='患者登記表'; -- ---------------------------- -- Table structure for hp_photographs -- ---------------------------- DROP TABLE IF EXISTS `hp_photographs`; CREATE TABLE `hp_photographs` ( `id` int(11) NOT NULL AUTO_INCREMENT, `photo` text COLLATE utf8mb4_general_ci COMMENT '照片記錄', `results` text COLLATE utf8mb4_general_ci COMMENT '結果記錄', `add_time` int(11) DEFAULT NULL, `m_id` int(11) DEFAULT NULL COMMENT '用戶ID', `user_id` int(11) DEFAULT NULL COMMENT '醫生ID', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='照片記錄'; -- ---------------------------- -- Table structure for hp_photographs_results -- ---------------------------- DROP TABLE IF EXISTS `hp_photographs_results`; CREATE TABLE `hp_photographs_results` ( `id` int(11) NOT NULL AUTO_INCREMENT, `photo` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT '照片記錄', `add_time` int(11) DEFAULT NULL, `m_id` int(11) DEFAULT NULL COMMENT '用戶ID', `user_id` int(11) DEFAULT NULL COMMENT '醫生ID', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='照片記錄'; -- ---------------------------- -- Table structure for hp_place_copy -- ---------------------------- DROP TABLE IF EXISTS `hp_place_copy`; CREATE TABLE `hp_place_copy` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `add_time` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='部位'; -- ---------------------------- -- Table structure for hp_project -- ---------------------------- DROP TABLE IF EXISTS `hp_project`; CREATE TABLE `hp_project` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `add_time` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='化驗項目'; -- ---------------------------- -- Table structure for hp_record -- ---------------------------- DROP TABLE IF EXISTS `hp_record`; CREATE TABLE `hp_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `m_id` int(11) DEFAULT NULL, `user_id` int(11) DEFAULT NULL, `add_time` int(11) DEFAULT NULL, `type` int(11) DEFAULT NULL COMMENT '就診類型', `to_time` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '來院時間', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='來院記錄'; -- ---------------------------- -- Table structure for hp_results -- ---------------------------- DROP TABLE IF EXISTS `hp_results`; CREATE TABLE `hp_results` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL, `add_time` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='回訪結果'; -- ---------------------------- -- Table structure for hp_return_record -- ---------------------------- DROP TABLE IF EXISTS `hp_return_record`; CREATE TABLE `hp_return_record` ( `id` int(11) NOT NULL AUTO_INCREMENT, `return` text COLLATE utf8mb4_general_ci COMMENT '回訪記錄', `results` text COLLATE utf8mb4_general_ci COMMENT '結果', `user_id` int(11) DEFAULT NULL COMMENT '操作員', `m_id` int(11) DEFAULT NULL COMMENT '患者ID', `add_time` int(11) DEFAULT NULL, `visit_time` varchar(30) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '下次回訪時間', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='回訪記錄'; -- ---------------------------- -- Table structure for hp_user -- ---------------------------- DROP TABLE IF EXISTS `hp_user`; CREATE TABLE `hp_user` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '姓名', `password` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `status` int(11) DEFAULT NULL, `add_time` int(11) DEFAULT NULL, `department_id` tinyint(2) DEFAULT NULL COMMENT '部門ID 1為醫生站 2為咨詢臺 3為照片處 4為醫技科室 5為領導端', `phone` varchar(12) COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '手機號碼', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='管理員'; -- ---------------------------- -- Table structure for hp_way -- ---------------------------- DROP TABLE IF EXISTS `hp_way`; CREATE TABLE `hp_way` ( `id` int(11) NOT NULL AUTO_INCREMENT, `title` varchar(255) COLLATE utf8mb4_general_ci DEFAULT NULL, `add_time` int(11) DEFAULT NULL, PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='來院途徑'; ~~~