얍
테이블 (6)
Booking
- booking_id — INT
- booking_date — TIMESTAMP
- status — ENUM('예약 완료', '취소됨')
- payment_status — ENUM('결제 완료', '미결제')
- schedule_id — INT
- user_id — INT
- seat_id — INT
Performance
- performance_id — INT
- name — VARCHAR(100) — NOT NULL
- description — TEXT
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
Schedule
- schedule_id — INT
- date — DATE — NOT NULL
- time — TIME — NOT NULL
- performance_id — INT
- venue_id — INT
Seat
- seat_id — INT
- seat_number — VARCHAR(10) — NOT NULL
- seat_type — ENUM('VIP', '일반석') — NOT NULL
- venue_id — INT
User
- user_id — INT
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(100) — NOT NULL
- phone — VARCHAR(15) — NOT NULL
Venue
- venue_id — INT
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(255) — NOT NULL
- total_seats — INT — NOT NULL