ch5

Tables (4)

Concert (콘서트)

  • concertId (Key) — Primary key — NOT NULL

Point (포인트)

  • pointId (Key) — Primary key — NOT NULL
  • point (포인트)
  • usePoint (사용내역)
  • createdAt (Date)

Reservation (예매)

  • reservationId (Key) — Primary key — NOT NULL
  • seatNumbers (Field)

User (회원)

  • userId (Key) — Primary key — NOT NULL
  • email (이메일)
  • password (비밀번호)
  • createdAt (생성날짜)