kmit db
Tables (5)
OptionItem
- option_id — INT
- name — VARCHAR(100)
- description — TEXT
- price — DECIMAL(10,2)
Payment
- payment_id — INT
- reservation_id — INT — NOT NULL
- payment_method — VARCHAR(50)
- amount — DECIMAL(10,2)
- payment_status — ENUM('성공', '실패', '보류')
- paid_at — TIMESTAMP
Reservation
- reservation_id — INT
- customer_id — INT — NOT NULL
- room_id — INT — NOT NULL
- checkin_date — DATE — NOT NULL
- checkout_date — DATE — NOT NULL
- guest_count — INT
- total_price — DECIMAL(10,2)
- status — ENUM('예약', '취소', '완료')
- created_at — TIMESTAMP
ReservationOption
- reservation_id — INT — Primary key — NOT NULL
- option_id — INT — Primary key — NOT NULL
Review
- review_id — INT
- reservation_id — INT — NOT NULL
- customer_id — INT — NOT NULL
- rating — INT
- comment — TEXT — EX
- created_at — TIMESTAMP