before

Tables (19)

books

  • id — int
  • name — varchar(200)
  • author — varchar(100)
  • edition — varchar(100)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • lecture_id — int(11) — Foreign key → lectures.id

course_pages

  • id — int
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • course_id — int(11) — Foreign key → courses.id
  • active — int(11)
  • thumbnail — varchar(300)
  • note_info — text
  • problem_info — text
  • pv_count — int(11)
  • uv_count — int(11)

courses

  • id — int
  • title — varchar(100)
  • description — varchar(100)
  • year — varchar(4)
  • semester — varchar(2)
  • book — varchar(200)
  • course_code — varchar(100)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • department_id — int(11) — Foreign key → departments.id
  • professor_id — int(11) — Foreign key → professors.id

departments

  • id — int
  • name — varchar(200)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • school_id — int(11) — Foreign key → schools.id

exam_problem_chapters

  • id — int
  • title — varchar(100)
  • created_at — datetime
  • updated_at — datetime
  • course_page_id — int(11) — Foreign key → course_pages.id
  • tutor_id — int(11)
  • exam_problem_content_id — int(11) — Foreign key → 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_page_id — int(11) — Foreign key → course_pages.id
  • tutor_id — int(11)

exam_problems

  • id — int
  • content — mediumtext
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • course_page_id — int(11) — Foreign key → course_pages.id
  • tutor_id — int(11)
  • exam_problem_chapter_id — int(11) — Foreign key → 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) — Foreign key → exam_problems.id
  • view — mediumtext

lectures

  • id — int
  • name — varchar(100)
  • lecture_code — varchar(100)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • department_id — int(11) — Foreign key → departments.id

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) — Foreign key → 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_page_id — int(11) — Foreign key → course_pages.id
  • tutor_id — int(11)
  • chapter_list — longtext

problem_chapters

  • id — int
  • title — varchar(100)
  • created_at — datetime
  • updated_at — datetime
  • course_page_id — int(11) — Foreign key → course_pages.id
  • tutor_id — int(11)
  • problem_content_id — int(11) — Foreign key → 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_page_id — int(11) — Foreign key → course_pages.id
  • tutor_id — int(11)

problems

  • id — int
  • content — mediumtext
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • course_page_id — int(11) — Foreign key → course_pages.id
  • tutor_id — int(11)
  • problem_chapter_id — int(11) — Foreign key → 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
  • lecture_id — int(11) — Foreign key → lectures.id
  • school_id — int(11) — Foreign key → 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) — Foreign key → problems.id
  • view — mediumtext

user_departments

  • id — int
  • class_year — int(11)
  • created_at — datetime
  • updated_at — datetime
  • deleted_at — datetime
  • user_id — int(11) — Foreign key → users.id
  • school_id — int(11) — Foreign key → schools.id
  • department_id — int(11) — Foreign key → departments.id

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)