exam

Tables (15)

Hotels

  • 호텔 식별번호 (hotel_id) — BIGINT — Primary key — NOT NULL
  • 호텔 이름 (name) — VARCHAR(100)

Images

  • image_id — BIGINT — Primary key — NOT NULL
  • path — VARCHAR(255)

Reservations

  • reservation_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → Untitled.user_id — NOT NULL
  • room_id — BIGINT — Foreign key → Rooms.room_id — NOT NULL
  • Field (check_in_at) — DATE
  • Field (check_out_at) — DATE
  • Field (number_of_people) — TINYINT
  • Field (created_at) — DATETIME
  • Field (status) — TINYINT

Reviews

  • review_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → Untitled.user_id — NOT NULL
  • 호텔 식별번호 (hotel_id) — BIGINT — Foreign key → Hotels.호텔 식별번호 — NOT NULL
  • exposure — TINYINT(1)
  • content — TEXT
  • Field (created_at) — DATETIME

Rooms

  • room_id — BIGINT — Primary key — NOT NULL
  • 호텔 식별번호 (hotel_id) — BIGINT — Foreign key → Hotels.호텔 식별번호 — 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
  • Field (status) — TINYINT(1)
  • Field (smoke) — TINYINT(1)
  • Field (bath_type) — TINYINT
  • Field

Untitled (Users)

  • user_id — BIGINT — Primary key — NOT NULL
  • Key (role_id) — TINYINT — Foreign key → Untitled.Key — NOT NULL
  • Field (name) — VARCHAR(50)
  • Field (phone) — CHAR(11)
  • Field (loginId) — VARCHAR(50)
  • Field2 (password) — VARCHAR(60)

Untitled (Roles)

  • Key (role_id) — TINYINT — Primary key — NOT NULL
  • Field (name) — VARCHAR(20)

Untitled (room_image)

  • image_id — BIGINT — Foreign key → Images.image_id — NOT NULL
  • room_id — BIGINT — Foreign key → Rooms.room_id — NOT NULL

Untitled (peak_season)

  • Key (peak_season_id) — BIGINT — Primary key — NOT NULL
  • Key (day_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (price) — INT

Untitled (low_season)

  • Key (low_season_id) — BIGINT — Primary key — NOT NULL
  • Key (day_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL
  • Field (price) — INT

Untitled (day)

  • Key (day_id) — BIGINT — Primary key — NOT NULL
  • Field (name) — CAHR(3)

Untitled (low_season_fee)

  • Key (low_season_fee_id) — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → Rooms.room_id — NOT NULL
  • Key (low_season_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

Untitled (peak_season_fee)

  • Key (peak_season_fee_id) — BIGINT — Primary key — NOT NULL
  • room_id — BIGINT — Foreign key → Rooms.room_id — NOT NULL
  • Key (peak_season_id) — BIGINT — Foreign key → Untitled.Key — NOT NULL

points

  • point_id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → Untitled.user_id — NOT NULL
  • reservation_id — BINARY(16) — Foreign key → Reservations.reservation_id — NOT NULL
  • point — INT
  • created_at — DATETIME

review_images (review_image)

  • review_id — BIGINT — Foreign key → Reviews.review_id — NOT NULL
  • image_id — BIGINT — Foreign key → Images.image_id — NOT NULL