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