team8

Tables (5)

Authority (Untitled5)

  • Role_user (Field) — Authority
  • Role_admin (Field2)

BANNER (Untitled3)

  • banner_id (Key) — Long — Primary key — NOT NULL
  • banerImg (Field) — String
  • bannerTitle (Field2) — String
  • bannerText (Field3) — String

LECTURE (Untitled2)

  • Lecture_id (Key) — Long — Primary key — NOT NULL
  • title (Field) — String
  • instructor (Field2) — String
  • originprice (Field4) — String
  • discountprice (Field5) — String
  • lectureImg (Field6) — String
  • description (Field3) — String
  • level (Field7) — String
  • skill (Field8) — String

MEMBER (Untitled)

  • Member_id (Key) — Long — Primary key — NOT NULL
  • EMAIL (Field) — String
  • PASSWORD (Field2) — String
  • nickname (Field3) — String
  • provider (Field4) — String
  • Authority (Field5) — Authority

Review (Untitled4)

  • Review_id (Key) — Long — Primary key — NOT NULL
  • Member_id (Key2) — Long — Foreign key → MEMBER.Member_id — NOT NULL
  • Lecture_id (Key3) — Long — Foreign key → LECTURE.Lecture_id — NOT NULL
  • CreatedAt (Field) — LocalDate
  • Star (Field2) — int
  • Review (Field3) — String