onlineConcertTicketingService

Tables (5)

CONCERT (Untitled2)

  • id (Key) — int — Primary key — NOT NULL
  • concertName (Field) — varchar(100)
  • maxReservation (Field5) — int
  • currentReservation (Field6) — int
  • concertDate (Field2) — varchar(100)
  • concertTime (Field3) — varchar(100)
  • concertDetail (Field4) — varchar(200)
  • id (Key2) — int — Foreign key → RESERVATION.id — NOT NULL

POINT (Untitled3)

  • id (Key) — int — Primary key — NOT NULL
  • reservationId (Field) — int
  • point (Field3) — bigInt
  • paymentHistory (Field4) — text
  • createdAt (Field5) — datetime

RESERVATION (Untitled4)

  • id (Key) — int — Primary key — NOT NULL
  • userId (Key2) — int — Foreign key → USER.id — NOT NULL
  • concertId (Field2) — int
  • reserveTime (Field3) — dateTime

USER (Untitled)

  • id (Key) — int — Primary key — NOT NULL
  • email (Field) — varchar(100)
  • userName (Field2) — varchar(100)
  • password (Field3) — varchar(100)
  • point (Field4) — bigInt

USER-CONCERT (Untitled5)

  • userId (Key3) — int — Foreign key → USER.id — NOT NULL
  • concertId (Key4) — int — Foreign key → CONCERT.id — NOT NULL