From 52cddf9d992e228dbcbdba6bcf1aa4653ff213dd Mon Sep 17 00:00:00 2001 From: java110 <928255095@qq.com> Date: 星期四, 25 六月 2020 14:40:08 +0800 Subject: [PATCH] 优化 操作手册 --- java110-db/db/CommunityService/create_parking_space.sql | 68 ++++++++++++++++++++++++++++++++++ 1 files changed, 68 insertions(+), 0 deletions(-) diff --git a/java110-db/db/CommunityService/create_parking_space.sql b/java110-db/db/CommunityService/create_parking_space.sql index 9f40827..39f51b9 100644 --- a/java110-db/db/CommunityService/create_parking_space.sql +++ b/java110-db/db/CommunityService/create_parking_space.sql @@ -56,11 +56,79 @@ CREATE INDEX idx_ps_ps_id ON parking_space(ps_id); CREATE INDEX idx_ps_b_id ON parking_space(b_id); +-- 杞﹁締杩涘嚭鍦� +create table business_car_inout( + inout_id varchar(30) not null comment '杩涘嚭ID', + b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id', + community_id varchar(30) not null comment '灏忓尯ID', + car_num varchar(12) not null comment '杞︾墝鍙�', + state VARCHAR(12) NOT NULL COMMENT '鐘舵�侊紝100300 杩涘満鐘舵�� 100400 鏀粯瀹屾垚 100500 绂诲満鐘舵�� 100600 鏀粯瓒呮椂閲嶆柊鏀粯', + in_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '杩涘満鏃堕棿', + out_time TIMESTAMP COMMENT '绂诲満鏃堕棿', + create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + operate VARCHAR(4) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝娣诲姞ADD锛屼慨鏀筂OD 鍒犻櫎DEL' +); create table car_inout( inout_id varchar(30) not null comment '杩涘嚭ID', b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id', community_id varchar(30) not null comment '灏忓尯ID', car_num varchar(12) not null comment '杞︾墝鍙�', + state VARCHAR(12) NOT NULL COMMENT '鐘舵�侊紝100300 杩涘満鐘舵�� 100400 鏀粯瀹屾垚 100500 绂诲満鐘舵�� 100600 鏀粯瓒呮椂閲嶆柊鏀粯', + in_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '杩涘満鏃堕棿', + out_time TIMESTAMP COMMENT '绂诲満鏃堕棿', + create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥' +); +create table business_car_inout_detail( + detail_id varchar(30) not null comment '璇︽儏ID', + inout_id varchar(30) not null comment '杩涘嚭ID', + b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id', + community_id varchar(30) not null comment '灏忓尯ID', + machine_id varchar(30) not null comment '璁惧ID', + machine_code varchar(30) not null comment '璁惧缂栫爜', + car_inout varchar(12) not null comment '3306 杩涘満 3307 鍑哄満', + car_num varchar(12) not null comment '杞︾墝鍙�', + create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + operate VARCHAR(4) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝娣诲姞ADD锛屼慨鏀筂OD 鍒犻櫎DEL' +); + +create table car_inout_detail( + detail_id varchar(30) not null comment '璇︽儏ID', + inout_id varchar(30) not null comment '杩涘嚭ID', + b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id', + community_id varchar(30) not null comment '灏忓尯ID', + machine_id varchar(30) not null comment '璁惧ID', + machine_code varchar(30) not null comment '璁惧缂栫爜', + car_inout varchar(12) not null comment '3306 杩涘満 3307 鍑哄満', + car_num varchar(12) not null comment '杞︾墝鍙�', + create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥' +); + +-- 杞﹁締榛戠櫧鍚嶅崟 +create table business_car_black_white( + bw_id varchar(30) not null comment '榛戠櫧鍚嶅崟ID', + b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id', + community_id varchar(30) not null comment '灏忓尯ID', + black_white varchar(12) not null comment '榛戠櫧鍚嶅崟鏍囪瘑 1111 榛戝悕鍗� 2222 鐧藉悕鍗�', + car_num varchar(12) not null comment '杞︾墝鍙�', + start_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '寮�濮嬫椂闂�', + end_time TIMESTAMP NOT NULL COMMENT '缁撴潫鏃堕棿', + create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + operate VARCHAR(4) NOT NULL COMMENT '鏁版嵁鐘舵�侊紝娣诲姞ADD锛屼慨鏀筂OD 鍒犻櫎DEL' +); + +-- 杞﹁締榛戠櫧鍚嶅崟 +create table car_black_white( + bw_id varchar(30) not null comment '榛戠櫧鍚嶅崟ID', + b_id VARCHAR(30) NOT NULL COMMENT '涓氬姟Id', + community_id varchar(30) not null comment '灏忓尯ID', + black_white varchar(12) not null comment '榛戠櫧鍚嶅崟鏍囪瘑 1111 榛戝悕鍗� 2222 鐧藉悕鍗�', + car_num varchar(12) not null comment '杞︾墝鍙�', + start_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '寮�濮嬫椂闂�', + end_time TIMESTAMP NOT NULL COMMENT '缁撴潫鏃堕棿', + create_time TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '鍒涘缓鏃堕棿', + status_cd VARCHAR(2) NOT NULL DEFAULT '0' COMMENT '鏁版嵁鐘舵�侊紝璇︾粏鍙傝�僣_status琛紝S 淇濆瓨锛�0, 鍦ㄧ敤 1澶辨晥' ); -- Gitblit v1.8.0