hotel

Tables (7)

Hotels

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

Rate

  • Key (rate_id) — BIGINT — Primary key — NOT NULL
  • Field (season) — VARCHAR(20)
  • Field (price) — INTEGER
  • Field (start_date) — DATE
  • Field (end_date) — DATE
  • Key (room_id) — BIGINT — Foreign key → Rooms.Key — NOT NULL

Reservations

  • Key (reservation_id) — BIGINT — Primary key — NOT NULL
  • Field (check_in) — DATE
  • Field2 (check_out) — DATE
  • Field (guest_count) — INTEGER
  • Field (reservation_people_name) — VARCHAR(30)
  • Field (phone_number) — VARCHAR(20)
  • Field (reservation_number) — VARCHAR(100)
  • Field2 (reservation_status) — VARCHAR(50)
  • Key (user_id) — VARCHAR(50) — Foreign key → Users.Key — NOT NULL
  • Key (room_id) — BIGINT — Foreign key → Rooms.Key — NOT NULL

Rooms

  • Key (room_id) — BIGINT — Primary key — NOT NULL
  • Field (name) — VARCHAR(100)
  • Field (capacity) — TINYINT
  • Field (floor) — TINYINT
  • Field (bathtub_flag) — TINYINT(1)
  • Field (view_type) — TINYINT
  • Field (created_at) — DATETIME
  • Key (hotel_id) — BIGINT — Foreign key → Hotels.Key — NOT NULL

Untitled (point)

  • Key (point_id) — BIGINT — Primary key — NOT NULL
  • Field (amount) — INTEGER
  • Field2 (created_at) — DATE
  • Key (user_id) — VARCHAR(50) — Foreign key → Users.Key — NOT NULL

Untitled (reviews)

  • Key (review_id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — VARCHAR(50) — Foreign key → Users.Key — NOT NULL
  • Key (hotel_id) — BIGINT — Foreign key → Hotels.Key — NOT NULL
  • Field (title) — VARCHAR(100)
  • Field2 (content) — TEXT
  • Field (review_image) — VARCHAR(255)
  • Field (created_at) — DATE
  • Field (is_outbreak) — BOOLEAN

Users

  • Key (user_id) — VARCHAR(50) — Primary key — NOT NULL
  • Field (name) — VARCHAR(50)
  • Field (password) — VARCHAR(50)
  • Field (role) — VARCHAR(30)