개인프로젝트

테이블 (7)

Category_Lecture (카테고리에 해당하는 강의들)

  • Long (id) — 기본 키 — NOT NULL
  • List<Lecture> (lectures)
  • Field2
  • Field3

InterestCategory (관심목록)

  • Long (id) — 기본 키 — NOT NULL
  • Member (member) — 외래 키 → Member.Long — NOT NULL
  • String (categoryName)
  • String (videoTiem)
  • String (orgName)

Lecture (총강의목록)

  • Long (id) — 기본 키 — NOT NULL
  • MyLecture (myLecture) — 외래 키 → mylecture.Long — NOT NULL
  • Long (id2) — 외래 키 → InterestCategory.Long — NOT NULL
  • Member (member) — 외래 키 → InterestCategory.Member — NOT NULL
  • String (name)
  • String (shortDescription)
  • String (startDisplay)
  • String (mobileAvailable)
  • String (teachers)
  • String (orgName)
  • String (category)
  • String (middleCategory)
  • String (language)
  • String (effortTime)
  • String (videoTime)

Member (사용자)

  • Long (id) — 기본 키 — NOT NULL
  • String (name)
  • String (password)
  • List<String> (roles)
  • Mylecture (mylecture)
  • interestCategory (lnterestCategory)
  • recommend

mylecture (나의 강의 목록)

  • Long (id) — 기본 키 — NOT NULL
  • Member (member) — 외래 키 → Member.Long — NOT NULL
  • String (name)
  • String (startDisplay)

recommend (추천강의)

  • Long (id) — 기본 키 — NOT NULL
  • Long (id2) — 외래 키 → Member.Long — NOT NULL
  • Long (lecture_id)

recommend_lecture (Untitled)

  • Long (id) — 기본 키 — NOT NULL
  • recommendLecture (recommend_id) — 외래 키 → recommend.Long — NOT NULL
  • Lecture (lecture_id) — 외래 키 → Lecture.MyLecture — NOT NULL
  • Long (id2) — 외래 키 → Lecture.Long — NOT NULL
  • Member (member) — 외래 키 → Lecture.Member — NOT NULL
  • int (count)