project

Tables (6)

comment (댓글)

  • id (인조키) — int — Primary key — NOT NULL
  • user_id (댓글러) — int — Foreign key → user.id — NOT NULL
  • community_id (게시글id) — int — Foreign key → community.id — NOT NULL
  • content (댓글) — text
  • createAt (생성일시) — datetime

community (커뮤니티 게시글)

  • id (인조키) — int — Primary key — NOT NULL
  • user_id (생성자) — int — Foreign key → user.id — NOT NULL
  • title (제목) — varchar(32)
  • content (내용) — text
  • createAt (생성일시) — datetime

course (강의)

  • id (강의id) — int — Primary key — NOT NULL
  • user_id (유저id) — int — Foreign key → user.id — NOT NULL
  • teacher_id (선생님 ID) — int
  • category_id (카테고리ID) — int
  • photo (강의 사진 URL) — varchar
  • title (강의명) — varchar
  • description (강의설명) — text
  • reference (참고자료 링크) — varchar
  • link (강의 링크) — varchar

course_category (강의 카테고리)

  • id (인조키) — int — Primary key — NOT NULL
  • name (카테고리명) — varchar

syllabus (강의 계획)

  • id (인조키) — int — Primary key — NOT NULL
  • course_id (강의id) — int — Foreign key → course.id — NOT NULL
  • week (주차) — int
  • content (강의 내용) — text

user (유저)

  • id (인조키) — int — Primary key — NOT NULL
  • login_id (아이디) — varchar(32)
  • password (패스워드) — varchar(32)
  • name (이름) — varchar(32)
  • email (이메일) — varchar(32)
  • usertype (권한) — varchar