1118

Tables (11)

Hotels (hotels)

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

Point (points)

  • point_id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → Users.user_id — NOT NULL
  • amount — decimal
  • expired_at — datetime

Price (prices)

  • price_id — bigint — Primary key — NOT NULL
  • amount — decimal
  • room_id — bigint — Foreign key → Rooms.room_id — NOT NULL

Reservation (reservations)

  • reservation_id — bigint — Primary key — NOT NULL
  • room_id — bigint — Foreign key → Rooms.room_id — NOT NULL
  • user_id — bigint — Foreign key → Users.user_id — NOT NULL
  • headcount — tinyint
  • checkin_at — datetime
  • reserved_at — datetime
  • checkout_at — datetime

Reservation_Point (reservation_points)

  • point_id — bigint — Foreign key → Point.point_id — NOT NULL
  • reservation_id — bigint — Foreign key → Reservation.reservation_id — NOT NULL

Review (reviews)

  • review_id — bigint — Primary key — NOT NULL
  • room_id — bigint — Foreign key → Rooms.room_id — NOT NULL
  • user_id — bigint — Foreign key → Users.user_id — NOT NULL
  • reservation_id — bigint — Foreign key → Reservation.reservation_id — NOT NULL
  • content — text
  • expose_flag — tinyint
  • created_at (create_at) — datetime

Review_Point (review_points)

  • point_id — bigint — Foreign key → Point.point_id — NOT NULL
  • review_id — bigint — Foreign key → Review.review_id — NOT NULL

Room_Images (room_images)

  • image_id — bigint — Primary key — NOT NULL
  • room_id — bigint — Foreign key → Rooms.room_id — NOT NULL
  • path — varchar(100)

Rooms (rooms)

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

State (states)

  • state_id — bigint — Primary key — NOT NULL
  • room_id — bigint — Foreign key → Rooms.room_id — NOT NULL
  • name — varchar(100)

Users (users)

  • user_id — bigint — Primary key — NOT NULL
  • username — varchar(100)
  • password — varchar(100)