capstone
Tables (6)
College (대학교)
- college_id (PK) — Int — Primary key — NOT NULL
- name (대학이름) — VarChar(10)
Lecture (강의)
- lecture_id (PK) — Int — Primary key — NOT NULL
- college_id (FK1) — Int — Foreign key → College.college_id — NOT NULL
- category_id (PK2) — Int — Foreign key → Subject.category_id — NOT NULL
- title (강의제목) — VarChar(20)
- tutor (교수이름) — VarChar(5)
- description (강의설명) — String
- created_at (강의 출시 일) — DateTime
- thumbnail (썸네일 주소) — String
LectureInfo (강의상세)
- lecture_info)id (PK) — Int — Primary key — NOT NULL
- lecture_id (PK2) — Int — Foreign key → Lecture.lecture_id — NOT NULL
- url (S3 주소) — String
Subject (주제)
- category_id (PK) — Int — Primary key — NOT NULL
- name (강의주제) — VarChar(20)
User (유저)
- user_id (PK) — Int — Primary key — NOT NULL
- email (이메일) — VarChar(50)
- nickname (닉네임) — VarChar(10)
Watching (시청중)
- user_id (PK1) — Int — Foreign key → User.user_id — NOT NULL
- lecture_id (PK2) — Int — Foreign key → Lecture.lecture_id — NOT NULL