호텔예약 시스템

테이블 (4)

Hotels

  • hotel_id (Key) — 기본 키 — NOT NULL
  • name (Field2) — VARCHAR

Reservation

  • reservation_id (Key) — BIGINT — 기본 키 — NOT NULL
  • reservation_code (Field) — TINYINT
  • user_id (Field2)
  • room_id (Field3)
  • check_in_date (Field4)
  • check_out_date (Field5)
  • guest_count (Field6)
  • status (Field7)
  • Field8
  • Field9

Rooms

  • room_id (Key) — BIGINT — 기본 키 — NOT NULL
  • name (Field2) — VARCHAR
  • capacity (Field3) — TINYINT
  • floor (Field4) — TINYINT
  • bathtub_flag (Field5) — TINYINT
  • view_type (Field6) — TINYINT
  • created_at (Field) — DATETIME
  • hotel_id (Key2) — 외래 키 → Hotels.hotel_id — NOT NULL

Users

  • user_id (Key) — BIGINT — 기본 키 — NOT NULL
  • email (Field) — VARCHAR
  • password (Field2) — VARCHAR
  • name (Field3) — VARCHAR
  • created_at (Field4) — DATETIME