booking

Tables (7)

EventCategories (이벤트 카테고리)

  • category_id (카테고리_id) — PRIMARY KEY — Primary key — NOT NULL
  • category_name (카테고리 이름) — NOT NULL
  • description TEXT (카테고리 설명)

Payments (결제)

  • payment_id (결제_id) — PRIMARY KEY — Primary key — NOT NULL
  • amount (결제금액) — NOT NULL
  • payment_date (결제시간) — DEFAULT CURRENT_TIMESTAMP
  • payment_method (결제방법) — VARCHAR
  • booking_id (예약_id2) — FOREIGN KEY — Foreign key → bookings.booking_id — NOT NULL

Tickets (티켓)

  • ticket_id (티켓_id) — PRIMARY KEY — Primary key — NOT NULL
  • price (가격) — NOT NULL
  • event_id (이벤트_id) — FOREIGN KEY — Foreign key → event.event_id — NOT NULL
  • seat_id (좌석_id2) — FOREIGN KEY — Foreign key → seats.seat_id — NOT NULL

bookings (예약)

  • booking_id (예약_id) — PRIMARY KEY — Primary key — NOT NULL
  • booking_date (예약날짜)
  • user_id (사용자_id2) — FOREIGN KEY — Foreign key → users.user_id — NOT NULL
  • ticket_id (티켓_id2) — FOREIGN KEY — Foreign key → Tickets.ticket_id — NOT NULL

event (이벤트)

  • event_id (이벤트_id) — PRIMARY KEY — Primary key — NOT NULL
  • title (제목) — NOT NULL
  • description (설명)
  • event_date (날짜 및 시간) — NOT NULL
  • venue (장소) — NOT NULL
  • category_id (카테고리_id) — FOREIGN KEY — Foreign key → EventCategories.category_id — NOT NULL

seats (좌석)

  • seat_id (좌석_id) — VARCHAR — Primary key — NOT NULL
  • seat_number (좌석번호) — NOT NULL — NOT NULL
  • seat_type (좌석종류)
  • venue (장소) — NOT NULL

users (사용자)

  • user_id (사용자_id) — PRIMARY KEY — Primary key — NOT NULL
  • username (사용자 이름) — UNIQUE NOT NULL
  • password (사용자비밀번호) — NOT NULL
  • email (사용자 이메일) — UNIQUE NOT NULL
  • phone (사용자전화번호) — VARCHAR