제안2

테이블 (19)

books

  • id — int
  • name — varchar(200)
  • author — varchar(100)
  • edition — varchar(100)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime

course_books

  • id — int
  • courses_id — int(11) — 외래 키 → courses.id
  • book_id — int(11) — 외래 키 → books.id
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime

course_professors

  • id — int
  • name — varchar(100)
  • profile_image_url — varchar(300)
  • bibography — varchar(500)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • course_id — int(11) — 외래 키 → courses.id
  • professor_id — int(11) — 외래 키 → professors.id

course_thumbnails

  • id — int
  • thumbnail_url — varchar(300)
  • first_category — varchar(40)
  • second_category — varchar(40)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime

courses

  • id — int
  • title — varchar(100)
  • active — varchar(4)
  • code — varchar(100)
  • course_thumbnail_id — int(11) — 외래 키 → course_thumbnails.id
  • school_id — int(11) — 외래 키 → schools.id
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime

departments

  • id — int
  • name — varchar(200)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • school_id — int(11) — 외래 키 → schools.id

exam_problem_chapters

  • id — int
  • title — varchar(100)
  • created_at — datetime
  • updated_at — datetime
  • course_id — int(11) — 외래 키 → courses.id
  • tutor_id — int(11)
  • exam_problem_content_id — int(11) — 외래 키 → exam_problem_contents.id
  • order — int(3)
  • deleted_at — datetime

exam_problem_contents

  • id — int
  • status — int(3)
  • title — varchar(100)
  • cover_image_url — varchar(300)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • course_id — int(11) — 외래 키 → courses.id
  • tutor_id — int(11)

exam_problems

  • id — int
  • content — mediumtext
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • course_id — int(11) — 외래 키 → courses.id
  • tutor_id — int(11)
  • exam_problem_chapter_id — int(11) — 외래 키 → exam_problem_chapters.id
  • order — int(3)
  • view — mediumtext

exam_solutions

  • id — int
  • content — mediumtext
  • order — int(3)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • tutor_id — int(11)
  • exam_problem_id — int(11) — 외래 키 → exam_problems.id
  • view — mediumtext

note_chapters

  • id — int
  • title — varchar(100)
  • content — mediumtext
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • tutor_id — int(11)
  • note_content_id — int(11) — 외래 키 → note_contents.id
  • order — int(3)
  • view — mediumtext

note_contents

  • id — int
  • status — int(3)
  • title — varchar(100)
  • cover_image_url — varchar(300)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • course_id — int(11) — 외래 키 → courses.id
  • tutor_id — int(11)
  • chapter_list — longtext

problem_chapters

  • id — int
  • title — varchar(100)
  • created_at — datetime
  • updated_at — datetime
  • course_id — int(11) — 외래 키 → courses.id
  • tutor_id — int(11)
  • problem_content_id — int(11) — 외래 키 → problem_contents.id
  • order — int(3)
  • deleted_at — datetime

problem_contents

  • id — int
  • status — int(3)
  • title — varchar(100)
  • cover_image_url — varchar(300)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • course_id — int(11) — 외래 키 → courses.id
  • tutor_id — int(11)

problems

  • id — int
  • content — mediumtext
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • course_id — int(11) — 외래 키 → courses.id
  • tutor_id — int(11)
  • problem_chapter_id — int(11) — 외래 키 → problem_chapters.id
  • order — int(3)
  • view — mediumtext

professors

  • id — int
  • name — varchar(100)
  • profile_image_url — varchar(300)
  • bibography — varchar(500)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • school_id — int(11) — 외래 키 → schools.id

schools

  • id — int
  • name — varchar(200)
  • logo_image_url — varchar(300)
  • address — varchar(40)
  • address_detail — varchar(40)
  • postcode — varchar(10)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • order — int(5)

solutions

  • id — int
  • content — mediumtext
  • order — int(3)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • tutor_id — int(11)
  • problem_id — int(11) — 외래 키 → problems.id
  • view — mediumtext

users

  • id — int
  • login_provider — int(11)
  • login_user_id — varchar(20)
  • name — varchar(15)
  • email — varchar(40)
  • password — varchar(100)
  • nickname — varchar(15)
  • phone_number — varchar(15)
  • birth — varchar(15)
  • gender — int(11)
  • profile_image_id — int(11)
  • class_year — int(11)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • deleted_reason — varchar(300)
  • ad_active — tinyint(1)
  • department_id — int(11) — 외래 키 → departments.id