숙박 예약 설계하기
테이블 (5)
객실 (rooms)
- Room (idx) — INT — 기본 키 — NOT NULL
- Place (place_id) — INT — 외래 키 → 숙소.Place — NOT NULL
- name — VARCHAR(30)
- onedayprice (price) — INT
- Discount (discount) — INT
- State (state) — BOOLEAN
결제 (payments)
- Payment (idx) — INT — 기본 키 — NOT NULL
- Reservation (reservation_id) — INT — 외래 키 → 예약.Reservation — NOT NULL
- Name (name) — VARCHAR(30)
- Category (category) — VARCHAR(30)
- totalprice — INT
- Payment amount (payment) — INT
고객 (customers)
- Customer (idx) — INT — 기본 키 — NOT NULL
- Email (email) — VARCHAR(30)
- Name (name) — VARCHAR(30)
- Phone (number) — INT
숙소 (places)
- Place (idx) — INT — 기본 키 — NOT NULL
- Name (name) — VARCHAR(30)
- Address (address) — VARCHAR(30)
- Number (number) — VARCHAR(30)
예약 (reservations)
- Reservation (idx) — INT — 기본 키 — NOT NULL
- Room (room_id) — INT — 외래 키 → 객실.Room — NOT NULL
- Customer (customer_id) — INT — 외래 키 → 고객.Customer — NOT NULL
- Startdate (startdate) — DATE
- Enddate (enddate) — DATE
- totalprice — INT