hotel

Tables (8)

hotels (Untitled)

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

members (Untitled3)

  • Key (member_id) — BIGINT — Primary key — NOT NULL
  • Field (name) — VARCHAR(50) — NOT NULL

points (Untitled4)

  • Key (point_id) — BIGINT — Primary key — NOT NULL
  • Field (amount) — INT — NOT NULL
  • Field (earned_at) — DATETIME — NOT NULL
  • Field (expires_at) — DATE — NOT NULL
  • Field (status) — TINYINT — NOT NULL
  • Key (member_id) — BIGINT — Foreign key → members.Key — NOT NULL
  • Key (reservation_id) — BIGINT — Foreign key → reservations.Key

reservations (Untitled8)

  • Key (reservation_id) — BIGINT — Primary key — NOT NULL
  • Field (reservation_no) — VARCHAR(36) — NOT NULL
  • Field (check_in) — DATE — NOT NULL
  • Field (check_out) — DATE — NOT NULL
  • Field (guest_count) — TINYINT — NOT NULL
  • Field (status) — TINYINT — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Key (room_id) — BIGINT — Foreign key → rooms.Key — NOT NULL
  • Key (member_id) — BIGINT — Foreign key → members.Key — NOT NULL

review_images (Untitled7)

  • Key (image_id) — BIGINT — Primary key — NOT NULL
  • Field (image_url) — VARCHAR(255) — NOT NULL
  • Key (review_id) — BIGINT — Foreign key → reviews.Key — NOT NULL

reviews (Untitled5)

  • Key (review_id) — BIGINT — Primary key — NOT NULL
  • Field (rating) — DECIMAL(2,1) — NOT NULL
  • Field (content) — VARCHAR(1000) — NOT NULL
  • Field (visible_flag) — TINYINT(1) — NOT NULL
  • Field (created_at) — DATETIME — NOT NULL
  • Key (reservation_id) — BIGINT — Foreign key → reservations.Key — NOT NULL

room_images (Untitled6)

  • Key (image_id) — BIGINT — Primary key — NOT NULL
  • Field (image_url) — VARCHAR(255) — NOT NULL
  • Key (room_id) — BIGINT — Foreign key → rooms.Key — NOT NULL

rooms (Untitled2)

  • Key (room_id) — BIGINT — Primary 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
  • Field (price) — INT — NOT NULL
  • Key (hotel_id) — BIGINT — Foreign key → hotels.Key — NOT NULL