drop table if exists park_room_reservation; create table park_room_reservation ( id varchar(255) not null primary key, park_info_id varchar(255) null comment '园区id(park_info)', park_info_name varchar(255) null comment '园区名称', park_floor_disc_id varchar(255) null comment '分期id(park_floor_disc)', park_floor_disc_name varchar(255) null comment '分期名称', mnp_building_id varchar(255) null comment '楼栋id(mnp_building)', mnp_building_no varchar(255) null comment '楼栋号', park_room_id varchar(255) null comment '房间id(park_room)', park_room_floor varchar(255) null comment '所在层', park_room_no varchar(255) null comment '户室号', buyer_name varchar(255) null comment '购房人姓名', buyer_phone varchar(255) null comment '购房人电话', buyer_gender varchar(255) null comment '购房人性别', buyer_address varchar(2000) null comment '购房人现住址', applicant_name varchar(255) null comment '申请人', applicant_phone varchar(255) null comment '申请人电话', overview_content varchar(4000) null comment '简况', reservation_date datetime null comment '看房日期', reservation_time_start varchar(255) null comment '看房时段-起(HH:mm)', reservation_time_end varchar(255) null comment '看房时段-止(HH:mm)', reservation_order int null comment '排队号', reservation_status int null comment '预约单状态(1已预约、2已取消、3待入户、4已完成)', door_pass_status int null comment '开门密码状态(1未发、2已发)', create_user varchar(255) null, create_time datetime null, update_user varchar(255) null, update_time datetime null ) comment '看房预约单' row_format = DYNAMIC; drop table if exists park_room_bind_door; create table park_room_bind_door ( id varchar(255) not null primary key, park_room_id varchar(255) null comment '房间id(park_room)', door_pass_id varchar(255) null comment '门锁id', create_user varchar(255) null comment '门锁id', create_time datetime null ) comment '房间-门锁绑定关系表' row_format = DYNAMIC;