ticket_camp
Tables (7)
Event (Untitled3)
- id (Key) — BIGINT — Primary key — NOT NULL
- venue_id (2) — BIGINT — Foreign key → Venues.id — NOT NULL
- name (Field) — VARCHAR(255) — 공연 이름
- event_date (Field2) — DATETIME — 공연 날짜
- ticketing_date (Field3) — DATETIME — 티켓팅 날짜
EventSeat (Untitled5)
- id (Key) — BIGINT — Primary key — NOT NULL
- event_id (Key2) — BIGINT — Foreign key → Event.id — NOT NULL
- seat_id (Key3) — BIGINT — Foreign key → Seats.id — NOT NULL
- section_id (Key4) — BIGINT — Foreign key → Section.id — NOT NULL
Reservation (Untitled7)
- id (Key) — BIGINT — Primary key — NOT NULL
- user_id (Key2) — BIGINT — Foreign key → User.id — NOT NULL
- event_seat_id (Key3) — BIGINT — Foreign key → EventSeat.id — NOT NULL
Seats
- id — BIGINT — Primary key — NOT NULL
- venue_id — BIGINT — Foreign key → Venues.id — NOT NULL
- location — VARCHAR(50) — 좌석위치
Section (Untitled4)
- id (Key) — BIGINT — Primary key — NOT NULL
- event_id (Key2) — BIGINT — Foreign key → Event.id — NOT NULL
- grade (Field) — VARCHAR(50) — 좌석 등급(VIP,R,S)
- price (Field2) — INTEGER — 가격
User (Untitled6)
- id (Key) — BIGINT — Primary key — NOT NULL
Venues
- id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(255) — 공연장 이름
- svgUrl (Field) — VARCHAR(500) — SVG 이미지 경로