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