From b28dd87895a5994a6213f0c7b6d4af5274de288d Mon Sep 17 00:00:00 2001 From: eight <641137800@qq.com> Date: 星期二, 06 八月 2024 16:14:57 +0800 Subject: [PATCH] add comments --- sql/mysql/jh.sql | 128 ++++++++++++++++++++++-------------------- 1 files changed, 66 insertions(+), 62 deletions(-) diff --git a/sql/mysql/jh.sql b/sql/mysql/jh.sql index cd123b4..c11eef2 100644 --- a/sql/mysql/jh.sql +++ b/sql/mysql/jh.sql @@ -7,32 +7,32 @@ -- ---------------------------- DROP TABLE IF EXISTS `appointment`; CREATE TABLE `appointment` ( - `id` int NOT NULL AUTO_INCREMENT, - `pat_num` varchar(30) NOT NULL, - `pat_name` varchar(10) NOT NULL, - `pat_gender` bit(1) NOT NULL, - `pat_birthday` date DEFAULT NULL, - `pat_mobile` char(11) DEFAULT NULL, - `pat_phone` varchar(20) DEFAULT NULL, + `id` int NOT NULL AUTO_INCREMENT COMMENT 'id', + `pat_id` varchar(30) NOT NULL COMMENT '鎮ｈ�呯紪鍙�', + `pat_name` varchar(10) NOT NULL COMMENT '鎮ｈ�呭鍚�', + `pat_gender` bit(1) NOT NULL COMMENT '鎮ｈ�呮�у埆', + `pat_birthday` date DEFAULT NULL COMMENT '鎮ｈ�呯敓鏃�', + `pat_mobile` char(11) DEFAULT NULL COMMENT '鎮ｈ�呮墜鏈�', + `pat_phone` varchar(20) DEFAULT NULL COMMENT '鎮ｈ�呯數璇�', `pat_identity_id` varchar(20) DEFAULT NULL COMMENT '韬唤璇佸彿', - `pat_addr` varchar(45) DEFAULT NULL, + `pat_addr` varchar(45) DEFAULT NULL COMMENT '鎮ｈ�呭湴鍧�', `pat_dept_code` varchar(45) NOT NULL COMMENT '鎮ｈ�呮墍鍦ㄧ瀹や唬鐮�', `pat_dept_desc` varchar(45) NOT NULL COMMENT '鎮ｈ�呮墍鍦ㄧ瀹ゅ悕绉�', `pat_ward_code` varchar(45) NOT NULL COMMENT '鎮ｈ�呮墍鍦ㄧ梾鍖轰唬鐮�', `pat_ward_desc` varchar(45) NOT NULL COMMENT '鎮ｈ�呮墍鍦ㄧ梾鍖哄悕绉�', `pat_bed_no` varchar(45) NOT NULL COMMENT '搴婂彿', - `book_num` varchar(45) NOT NULL, + `book_id` varchar(45) NOT NULL COMMENT '棰勭害缂栧彿', `book_period_start` datetime NOT NULL COMMENT '棰勭害妫�鏌ユ椂闂存', `book_period_end` datetime NOT NULL COMMENT '棰勭害妫�鏌ユ椂闂存', `book_time` datetime NOT NULL COMMENT '棰勭害鍙戠敓鏃堕棿', - `book_check_type` tinyint(1) DEFAULT NULL, + `book_check_type` tinyint(1) DEFAULT NULL COMMENT '棰勭害妫�鏌ョ被鍨�', `book_src` varchar(45) NOT NULL COMMENT '棰勭害鏉ユ簮锛歑绯荤粺銆佹姢澹墜鍔ㄩ绾�', - `sync_time` datetime DEFAULT NULL, - `create_time` datetime NOT NULL, - `update_time` datetime NOT NULL, - `deleted` bit(1) DEFAULT NULL, + `sync_time` datetime DEFAULT NULL COMMENT '浠庢暟鎹钩鍙板悓姝ユ椂闂�', + `create_time` datetime NOT NULL COMMENT '鍒涘缓鏃堕棿', + `update_time` datetime NOT NULL COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) DEFAULT NULL COMMENT '鍒犻櫎鏍囪', PRIMARY KEY (`id`), - UNIQUE KEY `idx_book_num` (`book_num`) + UNIQUE KEY `idx_book_id` (`book_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='棰勭害琛�'; @@ -41,23 +41,24 @@ -- ---------------------------- DROP TABLE IF EXISTS `queue`; CREATE TABLE `queue` ( - `id` int NOT NULL AUTO_INCREMENT, - `pat_id` varchar(30) NOT NULL, - `pat_name` varchar(10) NOT NULL, - `pat_gender` bit(1) DEFAULT NULL, - `book_time_slot` datetime NOT NULL, - `book_check_type` tinyint(1) DEFAULT NULL, - `seq_num` int NOT NULL COMMENT '鎺掗槦搴忓彿', + `id` int NOT NULL AUTO_INCREMENT COMMENT 'id', + `pat_id` varchar(30) NOT NULL COMMENT '鎮ｈ�呯紪鍙�', + `pat_name` varchar(10) NOT NULL COMMENT '鎮ｈ�呭鍚�', + `pat_gender` bit(1) DEFAULT NULL COMMENT '鎮ｈ�呮�у埆', + `book_period_start` datetime NOT NULL COMMENT '棰勭害妫�鏌ユ椂闂存', + `book_period_end` datetime NOT NULL COMMENT '棰勭害妫�鏌ユ椂闂存', + `book_check_type` tinyint(1) DEFAULT NULL COMMENT '棰勭害妫�鏌ョ被鍨�', + `seq_id` int NOT NULL COMMENT '鎺掗槦搴忓彿', `status` tinyint(1) NOT NULL COMMENT '10:鎺掗槦涓� 20:鍊欒瘖鍑嗗 30:灏辫瘖涓� 40:灏辫瘖瀹屾垚 50:杩囧彿 60:杩囨湡', `passed` tinyint(1) NOT NULL COMMENT '杩囧彿鏍囪', `expired` tinyint(1) NOT NULL COMMENT '棰勭害杩囨湡鏍囪', - `room_num` varchar(10) DEFAULT NULL, - `bed_num` varchar(10) DEFAULT NULL, - `create_time` datetime DEFAULT NULL, - `update_time` datetime DEFAULT NULL, + `room_num` varchar(10) DEFAULT NULL COMMENT '璇婂缂栧彿', + `bed_num` varchar(10) DEFAULT NULL COMMENT '璇婄枟搴婄紪鍙�', + `create_time` datetime DEFAULT NULL COMMENT '鍒涘缓鏃堕棿', + `update_time` datetime DEFAULT NULL COMMENT '鏇存柊鏃堕棿', PRIMARY KEY (`id`), - UNIQUE KEY `idx_seq_num` (`seq_num`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; + UNIQUE KEY `idx_seq_id` (`seq_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='鎺掗槦琛�'; -- ---------------------------- @@ -65,14 +66,14 @@ -- ---------------------------- DROP TABLE IF EXISTS `room_bed`; CREATE TABLE `room_bed` ( - `id` int NOT NULL AUTO_INCREMENT, - `room_no` varchar(10) NOT NULL, - `bed_no` varchar(10) NOT NULL, - `create_time` datetime NOT NULL, - `update_time` datetime NOT NULL, - `deleted` bit(1) DEFAULT NULL, + `id` int NOT NULL AUTO_INCREMENT COMMENT 'id', + `room_no` varchar(10) NOT NULL COMMENT '璇婂缂栧彿', + `bed_no` varchar(10) NOT NULL COMMENT '璇婄枟搴婄紪鍙�', + `create_time` datetime NOT NULL COMMENT '鍒涘缓鏃堕棿', + `update_time` datetime NOT NULL COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) DEFAULT NULL COMMENT '鍒犻櫎鏍囪', PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='璇婂鍜岃瘖鐤楀簥琛�'; -- ---------------------------- @@ -80,15 +81,15 @@ -- ---------------------------- DROP TABLE IF EXISTS `device_model`; CREATE TABLE `device_model` ( - `id` int NOT NULL, - `category` varchar(45) DEFAULT NULL, - `brand` varchar(45) DEFAULT NULL, - `model` varchar(45) DEFAULT NULL, - `create_time` datetime NOT NULL, - `update_time` datetime NOT NULL, - `deleted` bit(1) DEFAULT NULL, + `id` int NOT NULL COMMENT 'id', + `category` varchar(45) DEFAULT NULL COMMENT '鍒嗙被鍚�', + `brand` varchar(45) DEFAULT NULL COMMENT '鍝佺墝', + `model` varchar(45) DEFAULT NULL COMMENT '鍨嬪彿', + `create_time` datetime NOT NULL COMMENT '鍒涘缓鏃堕棿', + `update_time` datetime NOT NULL COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) DEFAULT NULL COMMENT '鍒犻櫎鏍囪', PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='璁惧鍨嬪彿琛�'; -- ---------------------------- @@ -96,18 +97,18 @@ -- ---------------------------- DROP TABLE IF EXISTS `device`; CREATE TABLE `device` ( - `id` int NOT NULL, - `dev_num` varchar(45) DEFAULT NULL, - `category` varchar(45) DEFAULT NULL, - `model` varchar(45) DEFAULT NULL, - `brand` varchar(45) DEFAULT NULL, - `purchase_date` date DEFAULT NULL, - `create_time` datetime NOT NULL, - `update_time` datetime NOT NULL, - `deleted` bit(1) DEFAULT NULL, + `id` int NOT NULL COMMENT 'id', + `dev_id` varchar(45) DEFAULT NULL COMMENT '璁惧缂栧彿', + `category` varchar(45) DEFAULT NULL COMMENT '鍒嗙被鍚�', + `brand` varchar(45) DEFAULT NULL COMMENT '鍝佺墝', + `model` varchar(45) DEFAULT NULL COMMENT '鍨嬪彿', + `purchase_date` date DEFAULT NULL COMMENT '閲囪喘鏃ユ湡', + `create_time` datetime NOT NULL COMMENT '鍒涘缓鏃堕棿', + `update_time` datetime NOT NULL COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) DEFAULT NULL COMMENT '鍒犻櫎鏍囪', PRIMARY KEY (`id`), - UNIQUE KEY `dev_num_UNIQUE` (`dev_num`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; + UNIQUE KEY `dev_id_UNIQUE` (`dev_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='璁惧琛�'; -- ---------------------------- @@ -115,16 +116,19 @@ -- ---------------------------- DROP TABLE IF EXISTS `dev_rent`; CREATE TABLE `dev_rent` ( - `id` int NOT NULL, - `dev_num` varchar(45) DEFAULT NULL, - `pat_num` varchar(45) DEFAULT NULL, - `pat_name` varchar(45) DEFAULT NULL, - `rent_time` datetime DEFAULT NULL, - `return_time` datetime DEFAULT NULL, + `id` int NOT NULL COMMENT 'id', + `dev_id` varchar(45) DEFAULT NULL COMMENT '璁惧缂栧彿', + `pat_id` varchar(45) DEFAULT NULL COMMENT '鎮ｈ�呯紪鍙�', + `pat_name` varchar(45) DEFAULT NULL COMMENT '鎮ｈ�呭悕绉�', + `rent_time` datetime DEFAULT NULL COMMENT '瑁呮満鏃堕棿', + `return_time` datetime DEFAULT NULL COMMENT '鎷嗘満鏃堕棿', `interference` int DEFAULT NULL COMMENT '骞叉壈鏁�', `baseline` varchar(100) DEFAULT NULL COMMENT '鍩虹嚎绮�', `detachment` varchar(100) DEFAULT NULL COMMENT '鑴辩', - `remark` varchar(100) DEFAULT NULL, + `remark` varchar(100) DEFAULT NULL COMMENT '澶囨敞', + `create_time` datetime NOT NULL COMMENT '鍒涘缓鏃堕棿', + `update_time` datetime NOT NULL COMMENT '鏇存柊鏃堕棿', + `deleted` bit(1) DEFAULT NULL, PRIMARY KEY (`id`) -) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci; +) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='瑁呮満鎷嗘満琛�'; -- Gitblit v1.9.3