test

Tables (6)

customer

  • user_id — BIGINT — Primary key
  • customer_password — VARCHAR
  • role — ENUM
  • customer_id — VARCHAR — NOT NULL
  • reservation_count — TinyInt
  • reservation_code — VARCHAR

hotels

  • hotel_id — BIGINT — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL

point

  • user_id — BIGINT — Foreign key → customer.user_id
  • amount — BIGINT
  • created_at — DATETIME

reservation

  • reservation_id — auto_increment — Primary key — NOT NULL
  • check_in — DATETIME
  • check_out — DATETIME
  • amount — TINYINT
  • reservation_code — VARCHAR(100)
  • room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • user_id — BIGINT

review

  • room_id — BIGINT — Foreign key → rooms.room_id — NOT NULL
  • user_id — BIGINT — Foreign key → customer.user_id
  • image — VARCHAR
  • see — BOOLEAN

rooms

  • room_id — BIGINT — Primary key — NOT NULL
  • hotel_id — BIGINT — Foreign key → hotels.hotel_id — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • capacity — TINYINT — NOT NULL
  • floor — TINYINT — NOT NULL
  • bathtub_flag — TINYINT(1) — NOT NULL
  • view_type — TINYINT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • available_reservation (abaliable_reservation) — BOOLEAN