cf20250513.sql 2.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445
  1. drop table if exists park_room_reservation;
  2. create table park_room_reservation
  3. (
  4. id varchar(255) not null
  5. primary key,
  6. park_info_id varchar(255) null comment '园区id(park_info)',
  7. park_info_name varchar(255) null comment '园区名称',
  8. park_floor_disc_id varchar(255) null comment '分期id(park_floor_disc)',
  9. park_floor_disc_name varchar(255) null comment '分期名称',
  10. mnp_building_id varchar(255) null comment '楼栋id(mnp_building)',
  11. mnp_building_no varchar(255) null comment '楼栋号',
  12. park_room_id varchar(255) null comment '房间id(park_room)',
  13. park_room_floor varchar(255) null comment '所在层',
  14. park_room_no varchar(255) null comment '户室号',
  15. buyer_name varchar(255) null comment '购房人姓名',
  16. buyer_phone varchar(255) null comment '购房人电话',
  17. buyer_gender varchar(255) null comment '购房人性别',
  18. buyer_address varchar(2000) null comment '购房人现住址',
  19. applicant_name varchar(255) null comment '申请人',
  20. applicant_phone varchar(255) null comment '申请人电话',
  21. overview_content varchar(4000) null comment '简况',
  22. reservation_date datetime null comment '看房日期',
  23. reservation_time_start varchar(255) null comment '看房时段-起(HH:mm)',
  24. reservation_time_end varchar(255) null comment '看房时段-止(HH:mm)',
  25. reservation_order int null comment '排队号',
  26. reservation_status int null comment '预约单状态(1已预约、2已取消、3待入户、4已完成)',
  27. door_pass_status int null comment '开门密码状态(1未发、2已发)',
  28. create_user varchar(255) null,
  29. create_time datetime null,
  30. update_user varchar(255) null,
  31. update_time datetime null
  32. )
  33. comment '看房预约单' row_format = DYNAMIC;
  34. drop table if exists park_room_bind_door;
  35. create table park_room_bind_door
  36. (
  37. id varchar(255) not null
  38. primary key,
  39. park_room_id varchar(255) null comment '房间id(park_room)',
  40. door_pass_id varchar(255) null comment '门锁id',
  41. create_user varchar(255) null comment '门锁id',
  42. create_time datetime null
  43. )
  44. comment '房间-门锁绑定关系表' row_format = DYNAMIC;