제안
테이블 (18)
books
- id — int
- name — varchar(200)
- author — varchar(100)
- edition — varchar(100)
- created_at — datetime
- updated_at — datetime
- deleted_at — datetime
- courses_id — int(11) — 외래 키 → courses.id
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)
- order — int(11)
- 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
- Key — 외래 키 — NOT NULL
- Key (Key2) — 외래 키 — NOT NULL
- order (order2) — int(11) — 외래 키
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
- Key — 외래 키 — NOT NULL
- Key (Key2) — 외래 키 — NOT NULL
- order (order2) — int(11) — 외래 키
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