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)