리조트 예약시스템
테이블 (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)