개인프로젝트
테이블 (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)