ticketsystem

Tables (6)

Category (공연카테고리)

  • id (category_id) — bigInt — Primary key — NOT NULL
  • 종류 (type) — varchar(100)

Member (member)

  • 회원id (member_id) — bigInt — Primary key — NOT NULL
  • 닉네임 (username) — varchar(255)

Reservation (예약)

  • 예약id (id) — bigInt — Primary key — NOT NULL
  • 공연id (show_id) — bigInt — Foreign key → Show.공연id — NOT NULL
  • 회원id (member_id) — bigInt — Foreign key → Member.회원id — NOT NULL
  • 예약일시 (Field2)
  • 상태 (statud) — boolean

ReservationSeats (예약좌석)

  • id — bigInt — Primary key — NOT NULL
  • 좌석id (seat_id) — bigInt — Foreign key → Seats.좌석id — NOT NULL
  • 예약id (Key) — bigInt — Foreign key → Reservation.예약id — NOT NULL
  • 상태 (status) — boolean

Seats (좌석)

  • 좌석id (seat_id) — bigInt — Primary key — NOT NULL
  • 공연id (show_id) — bigInt — Foreign key → Show.공연id — NOT NULL
  • 좌석번호 (num) — varchar
  • 상태 (status) — boolean

Show (공연)

  • 공연id (show_id) — bigInt — Primary key — NOT NULL
  • 카테고리 (category_id) — bigInt — Foreign key → Category.id — NOT NULL
  • 공연이름 (title) — varchar(255)
  • 공연장소 (place) — varchar(255)
  • 공연날짜 (showDate) — date
  • 가격 (price) — int