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