숙박예약 서비스

테이블 (3)

Reservation (Untitled3)

  • reservation_id (Key) — 기본 키 — NOT NULL
  • userid (Key2) — 외래 키 → user.user_id — NOT NULL
  • room_id (Key3) — 외래 키 → Room.room_id — NOT NULL
  • payment_check (Field)
  • payment_date (Field2)

Room (Untitled2)

  • room_id (Key) — 기본 키 — NOT NULL
  • room_name (Field)
  • location (Field2)
  • price (Field3)
  • number_rooms (Field4)
  • number_people (Field9)
  • checkin (Field5)
  • checkout (Field6)
  • information (Field7)
  • created_at (Field8)
  • Field10

user (Untitled)

  • user_id (Key) — 기본 키 — NOT NULL
  • ID (Field)
  • password (Field2)
  • email (Field3)
  • nickname (Field4)
  • auth (Field5)
  • created_at (Field6)