Ticket
Tables (9)
Coupon (쿠폰)
- coupon_id (쿠폰ID) — INT — Primary key — NOT NULL
- name (쿠폰 이름) — VARCHAR
- discount_rate (할인율) — INT
- expired_date (만료 일자) — DATETIME
- amount (수량) — INT
Event (이벤트(공연))
- event_id (이벤트 ID) — INT — Primary key — NOT NULL
- venue_id (공연장 ID) — INT — Foreign key → Venue.venue_id — NOT NULL
- name (이벤트 이름) — VARCHAR(100)
- start_time (시작 시간) — DATETIME
- end_time (종료 시간) — DATETIME
- total_tickets (총 티켓 수) — INT
- create_at (이벤트 생성일) — DATETIME
Payment (결제)
- payment_id (결제 ID) — INT — Primary key — NOT NULL
- total_price (총 결제 금액) — INT
- date (결제 일자) — DATETIME
- status (결제 상태) — VARCHAR(50)
Seat (좌석)
- seat_id (좌석 ID) — INT — Primary key — NOT NULL
- venue_id (공연장 ID) — INT — Foreign key → Venue.venue_id — NOT NULL
- section (구역) — VARCHAR(50)
- row (좌석의 열) — VARCHAR(10)
- number (좌석 번호) — INT
Seat Reservation (좌석 예매)
- reservation_id (좌석예매 ID) — INT — Primary key — NOT NULL
- event_id (이벤트 ID) — INT — Foreign key → Event.event_id — NOT NULL
- seat_id (좌석 ID) — INT — Foreign key → Seat.seat_id — NOT NULL
- status (좌석 상태) — VARCHAR(50)
- price (가격) — INT
Ticket (티켓)
- ticket_id (티켓 ID) — INT — Primary key — NOT NULL
- reservation_id (좌석예매 ID) — INT — Foreign key → Seat Reservation.reservation_id — NOT NULL
- payment_id (결제 ID) — INT — Foreign key → Payment.payment_id — NOT NULL
- status (티켓 상태) — VARCHAR(50)
User (회원)
- user_id (사용자 ID) — INT — Primary key — NOT NULL
- name (사용자 이름) — VARCHAR(100)
- password (비밀번호) — VARCHAR(255)
UserCoupon (사용자 쿠폰 발급)
- usercoupon_id (사용자쿠폰ID) — INT — Primary key — NOT NULL
- user_id (사용자 ID) — INT — Foreign key → User.user_id — NOT NULL
- coupon_id (쿠폰ID) — INT — Foreign key → Coupon.coupon_id — NOT NULL
Venue (공연장)
- venue_id (공연장 ID) — INT — Primary key — NOT NULL
- name (공연장 이름) — VARCHAR(50)
- location (위치) — VARCHAR(255)
- capacity (수용 인원) — INT