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