Tickethub

Tables (4)

Performance (공연)

  • performanceId (공연아이디) — long — Primary key — NOT NULL
  • name (공연이름) — String

Seat (좌석)

  • seatId (좌석 아이디) — long — Primary key — NOT NULL
  • performanceId (공연아이디) — long — Foreign key → Performance.performanceId — NOT NULL
  • seatNumebr (좌석 번호) — int
  • tag (태그) — Tag(enum)

Ticket (티켓)

  • ticketId (티켓아이디) — long — Primary key — NOT NULL
  • performanceId (공연아이디) — long — Foreign key → Performance.performanceId — NOT NULL
  • userId (유저아이디) — long — Foreign key → User.userId — NOT NULL
  • time (공연시간) — LocalDateTime
  • seatNumber (좌석번호) — int
  • token (토큰) — String

User (유저)

  • userId (유저아이디) — long — Primary key — NOT NULL
  • name (이름) — String
  • email (이메일) — String
  • identifier (아이디) — String
  • password (비밀번호) — String
  • jwtToken (인증 토큰) — String