nhn-exam-hotel

테이블 (3)

Untitled (hotel)

  • Key (hotel_id) — bigint — 기본 키 — NOT NULL
  • Field (name) — varchar(100) — NOT NULL

Untitled2 (room)

  • Key (room_id) — bigint — 기본 키 — NOT NULL
  • Key (hotel_id) — bigint — 외래 키 → Untitled.Key — NOT NULL
  • Field (name) — varchar(100) — NOT NULL
  • Field (capacity) — tinyint — NOT NULL
  • Field (floor) — tinyint — NOT NULL
  • Field2 (bathtub_flag) — tinyint(1) — NOT NULL
  • Field3 (view_type) — tinyint — NOT NULL
  • Field4 (created_at) — datetime — NOT NULL

예약 (reservation)

  • 예약 키 (reservation_id) — bigint — 기본 키 — NOT NULL
  • Field (check_in) — date — NOT NULL
  • Field2 (check_out) — date — NOT NULL
  • Field3 (people_count) — int — NOT NULL
  • Key (room_id) — bigint — 외래 키 → Untitled2.Key — NOT NULL
  • Field (user_id) — bigint — NOT NULL