From f39700974d82751f4b59681124091580661387a6 Mon Sep 17 00:00:00 2001
From: mrzcc <121184950@qq.com>
Date: 星期一, 17 二月 2020 18:42:34 +0800
Subject: [PATCH] 巡检计划sql

---
 java110-db/db/CommunityService/create_inspection_plan.sql |   43 +++++++++++++++++++++++++++++++++++++++++++
 1 files changed, 43 insertions(+), 0 deletions(-)

diff --git a/java110-db/db/CommunityService/create_inspection_plan.sql b/java110-db/db/CommunityService/create_inspection_plan.sql
new file mode 100644
index 0000000..e5401a5
--- /dev/null
+++ b/java110-db/db/CommunityService/create_inspection_plan.sql
@@ -0,0 +1,43 @@
+--  宸℃璁″垝
+CREATE TABLE inspection_plan(
+    `inspection_plan_id` varchar(30) NOT NULL COMMENT '宸℃璁″垝ID',
+    `b_id` varchar(30)  NOT NULL COMMENT '涓氬姟Id',
+    `inspection_plan_name` varchar(100)  NOT NULL COMMENT '宸℃璁″垝鍚嶇О',
+    `inspection_route_id` varchar(30)  NOT NULL COMMENT '宸℃璺嚎ID',
+    `community_id` varchar(30) NOT NULL COMMENT '灏忓尯ID',
+    `start_time` timestamp NOT NULL  COMMENT '寮�濮嬫椂闂�',
+    `end_time` timestamp NOT NULL COMMENT '缁撴潫鏃堕棿',
+    `inspection_plan_period` varchar(12) NOT NULL COMMENT '鎵ц鍛ㄦ湡',
+    `staff_id` varchar(30) NOT NULL COMMENT '鍛樺伐id(鎵ц鑰�)',
+    `staff_name` varchar(30) NOT NULL COMMENT '鍛樺伐鍚嶇О',
+    `sign_type` varchar(12) NOT NULL COMMENT '绛惧埌鏂瑰紡',
+    `state` VARCHAR(12) COMMENT '褰撳墠鐘舵��',
+    `remark` VARCHAR(200) COMMENT '澶囨敞璇存槑',
+    `create_user_id` VARCHAR(30) NOT NULL COMMENT '鍒跺畾浜哄憳ID',
+    `create_user_name` VARCHAR(50) NOT NULL COMMENT '鍒跺畾浜哄憳濮撳悕',
+    `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+    `status_cd` VARCHAR(2) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僼_dict琛�0鍦ㄧ敤1澶辨晥',
+    KEY `idx_inspection_plan_id` (`inspection_plan_id`)
+);
+
+
+
+CREATE TABLE `business_inspection_plan` (
+    `inspection_plan_id` varchar(30) NOT NULL COMMENT '宸℃璁″垝ID',
+    `b_id` varchar(30)  NOT NULL COMMENT '涓氬姟Id',
+    `inspection_plan_name` varchar(100)  NOT NULL COMMENT '宸℃璁″垝鍚嶇О',
+    `inspection_route_id` varchar(30)  NOT NULL COMMENT '宸℃璺嚎ID',
+    `community_id` varchar(30) NOT NULL COMMENT '灏忓尯ID',
+    `start_time` timestamp NOT NULL  COMMENT '寮�濮嬫椂闂�',
+    `end_time` timestamp NOT NULL COMMENT '缁撴潫鏃堕棿',
+    `inspection_plan_period` varchar(12) NOT NULL COMMENT '鎵ц鍛ㄦ湡',
+    `staff_id` varchar(30) NOT NULL COMMENT '鍛樺伐id(鎵ц鑰�)',
+    `staff_name` varchar(30) NOT NULL COMMENT '鍛樺伐鍚嶇О',
+    `sign_type` varchar(12) NOT NULL COMMENT '绛惧埌鏂瑰紡',
+    `state` VARCHAR(12) COMMENT '褰撳墠鐘舵��',
+    `remark` VARCHAR(200) COMMENT '澶囨敞璇存槑',
+    `create_user_id` VARCHAR(30) NOT NULL COMMENT '鍒跺畾浜哄憳ID',
+    `create_user_name` VARCHAR(50) NOT NULL COMMENT '鍒跺畾浜哄憳濮撳悕',
+    `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿',
+    `operate` varchar(4) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝娣诲姞ADD锛屼慨鏀筂OD 鍒犻櫎DEL'
+)

--
Gitblit v1.8.0