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 이미지 경로