리조트 예약시스템

테이블 (7)

Banquet

  • banquet Id (banquet_id) — int(1) — 기본 키 — NOT NULL
  • reservation Id (reservation_id) — int(1) — 외래 키 → Reservation.reservation Id — NOT NULL
  • banquet number (banquet_num)
  • reservation method (reserve_method)
  • people number (people_num)

Card (card)

  • card Id (card_id) — int(1) — 기본 키 — NOT NULL
  • CustomerId (customer_id) — int(1) — 외래 키 → customer.CustomerId — NOT NULL
  • payment Id (payment_id) — int(1)
  • total payment (total_payment)

Payment (payment)

  • Key (payment Id) — key — 기본 키 — NOT NULL
  • CustomerId (customer_id) — int(1) — 외래 키 → Card.CustomerId — NOT NULL
  • card Id (card_id) — int(1) — 외래 키 → Card.card Id — NOT NULL
  • Field (business Id) — int(1)
  • Field (payment content)
  • Field (payment)

Reservation (reservation)

  • reservation Id (reservation_id) — int(1) — 기본 키 — NOT NULL
  • reservation date (reservation_date)
  • CustomerId (customer_id) — int(1) — 외래 키 → customer.CustomerId — NOT NULL
  • checkin date (checkin_date)
  • checkout date (checkout_date)
  • room type (room_type) — CHAR(1)
  • room Id (room_id) — int(1)
  • banquet Id (banquet_id) — int(1)
  • Field

Room reservation (Untitled)

  • room Id (room_id) — int(1) — 기본 키 — NOT NULL
  • reservation Id (reservation_id) — int(1) — 외래 키 → Reservation.reservation Id — NOT NULL
  • room type (room_type) — CHAR(1)
  • Field

Room type (room type)

  • room type (room_type) — CHAR(1) — 기본 키 — NOT NULL
  • fee
  • service
  • room Id (room_id) — int(1) — 외래 키 → Room reservation.room Id — NOT NULL
  • reservation Id (reservation_id) — int(1) — 외래 키 → Room reservation.reservation Id — NOT NULL

customer (Customer)

  • CustomerId (customer_id) — int(1) — 기본 키 — NOT NULL
  • card Id (card_id) — int(1)
  • reserveation Id (reservation_id) — int(1)
  • Telephone (telephone)
  • Name (name)