hotel

Tables (9)

Hotels (hotels)

  • Key (hotel_id) — bigint — Primary key — NOT NULL
  • Field (name) — varchar(100) — NOT NULL

Point (point)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
  • Key (point_history_id) — bigint — Foreign key → Point_History.Key — NOT NULL

Point_History (point_history)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (point) — bigint — NOT NULL
  • Field (created_at) — datetime — NOT NULL

Reservation (reservation)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (check_in) — datetime — NOT NULL
  • Field (check_out) — datetime — NOT NULL
  • Field (headcount) — tinyint — NOT NULL
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
  • Field (created_at) — datetime — NOT NULL
  • Key (room_id) — bigint — Foreign key → Rooms.Key — NOT NULL

Review (review)

  • Key (id) — bigint — Primary key — NOT NULL
  • Key (user_id) — bigint — Foreign key → User.Key — NOT NULL
  • Key (room_id) — bigint — Foreign key → Rooms.Key — NOT NULL
  • Field (text) — text — NOT NULL

Review_Image (review_image)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (image_name) — varchar(255) — NOT NULL
  • Key (review_id) — bigint — Foreign key → Review.Key — NOT NULL
  • Field (view_flag) — tinyint(1) — NOT NULL

Rooms (rooms)

  • Key (room_id) — bigint — Primary key — NOT NULL
  • Key (hotel_id) — bigint — Foreign key → Hotels.Key — NOT NULL
  • Field (name) — varchar(100) — NOT NULL
  • Field (capacity) — tinyint — NOT NULL
  • Field (floor) — tinyint — NOT NULL
  • Field (bathtub_flag) — tinyint(1) — NOT NULL
  • Field (view_type) — tinyint — NOT NULL
  • Field (created_at) — datetime — NOT NULL

Rooms_Image (rooms_image)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (image_name) — varchar(255) — NOT NULL
  • Key (room_id) — bigint — Foreign key → Rooms.Key — NOT NULL

User (user)

  • Key (id) — bigint — Primary key — NOT NULL
  • Field (username) — varchar(150) — NOT NULL
  • Field2 (password) — varchar(150) — NOT NULL