ed
Tables (6)
Untitled (lecture_category)
- Key (id) — int — Primary key — NOT NULL
- Field (title) — varchar(191)
- Field (status) — tinyint
- Field (created_at) — timestamp
- Field (updated_at) — timestamp
- Field (template_name) — varchar(191)
- Field (slug) — varchar(191)
- Field
exam
- id — bigint — Primary key — NOT NULL
- title — varchar(191) — NOT NULL
- lecture_id — int
- status_id — int
- start_date — date
- end_date — date
- description — mediumtext
- question_quantity — int
- min_point — int
- min_percent — int
- max_duration — int
- users_count — int
- passed_count — int
- failed_count — int
- created_at — timestamp
- updated_at — timestamp
- lesson_id — int
- category_id — int
- video_percent — int
- video_count — int
- question_count — int
- question_per_point — double
- exam_code — varchar(191)
- problem_types — varchar(191)
- subject_code_1 — varchar(191)
- subject_name_1 — varchar(191)
- subject_score_1 — tinyint
- subject_code_2 — varchar(191)
- subject_name_2 — varchar(191)
- subject_score_2 — tinyint
- subject_code_3 — varchar(191)
- subject_name_3 — varchar(191)
- subject_score_3 — tinyint
- subject_code_4 — varchar(191)
- subject_name_4 — varchar(191)
- subject_score_4 — tinyint
- subject_code_5 — varchar(191)
- subject_name_5 — varchar(191)
- subject_score_5 — tinyint
- subject_code_6 — varchar(191)
- subject_name_6 — varchar(191)
- subject_score_6 — tinyint
lecture
- id — bigint — Primary key — NOT NULL
- Key (id2) — int — Foreign key → Untitled.Key — NOT NULL
- title — varchar(191) — NOT NULL
- price — int — NOT NULL
- period — int — NOT NULL
- is_best — tinyint(1) — NOT NULL
- is_hot — tinyint(1) — NOT NULL
- is_new — tinyint(1) — NOT NULL
- status — tinyint — NOT NULL
- main_image — varchar(191)
- sub_image — varchar(191)
- menu_image — varchar(191)
- custom_view — varchar(191)
- excerpt — text
- description — mediumtext
- order_no — tinyint — NOT NULL
- is_scheduled — tinyint(1) — NOT NULL
- start_date — date
- end_date — date
- is_counted — tinyint(1) — NOT NULL
- quantity — int — NOT NULL
- memo — varchar(191)
- created_at — timestamp
- updated_at — timestamp
- category_id — bigint — NOT NULL
- teacher_id — bigint
- slug — varchar(191)
- custom_view_mobile — varchar(191)
- is_feedback — tinyint(1) — NOT NULL
- fake_price — int
- sale_percent — tinyint
- quota_month — tinyint
- can_rebuy — tinyint(1) — NOT NULL
- can_pause — tinyint(1) — NOT NULL
- is_only_mar_users — tinyint(1) — NOT NULL
- is_hidden — tinyint(1) — NOT NULL
- youtube_link — varchar(191)
- sub_category_id — int
- product_id — int
- teacher_money — decimal(10,2)
- teacher_percent — double(8,2)
- njn_uuid — varchar(255)
- exam_attemp — int
- exam_rate — int
- exam_available_at — int
- cert_available_at — int
- is_live — tinyint(1) — NOT NULL
- live_start_at — datetime
- live_link — varchar(191)
- lecture_available_days — int
- views — int — NOT NULL
- has_quest — tinyint(1) — NOT NULL
- quest_point — varchar(191)
- quest_days — varchar(191)
- refund_percent — int — NOT NULL
- watch_max_day — int
- passing_score — int — NOT NULL
- required_view_percentage — int — NOT NULL
- exam_score_comp — int
- teacher_names — varchar(600)
- … +1
user_exams
- id — bigint — Primary key — NOT NULL
- id (exam_id) — bigint — Foreign key → exam.id — NOT NULL
- start_date — datetime
- end_date — datetime
- answers — mediumtext
- point — int
- percent — int
- is_passed — tinyint(1) — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- exam_lecture_id — int
- exam_package_id — int
- subject_code — varchar(191)
user_lecture
- id — bigint — Primary key — NOT NULL
- id (middle_exam_id) — bigint — Foreign key → user_exams.id — NOT NULL
- id (last_exam_id) — bigint — Foreign key → user_exams.id — NOT NULL
- id (user_id) — bigint — Foreign key → users.id — NOT NULL
- id (product_id) — bigint — Foreign key → lecture.id — NOT NULL
- Key (id2) — int — Foreign key → lecture.Key — NOT NULL
- product_type — varchar(191) — NOT NULL
- start_date — date — NOT NULL
- end_date — date — NOT NULL
- created_at — timestamp
- updated_at — timestamp
- paused_at — date
- pause_end_at — date
- pause_start_at — date
- percent — double(8,2) — NOT NULL
- pause_count — tinyint — NOT NULL
- last_index — int
- pause_day — int — NOT NULL
- quest_file — varchar(191)
- quest_status — varchar(191)
- quest_submit_date — varchar(191)
- quest_submit_end_date — varchar(191)
- quest_point — int
- quest_result_point — int
- body — varchar(191)
- teacher_text — varchar(191)
- last_video_id — int
- last_video_percent — double(8,2)
- last_exam_point — double(8,2)
- middle_exam_point — double(8,2)
- middle_exam_max_point — double(8,2)
- middle_exam_percent — double(8,2)
- last_exam_max_point — double(8,2)
- last_exam_percent — double(8,2)
- package_id — int
- is_split — tinyint(1) — NOT NULL
- refund_order_id — int
- order_id — int
- order_detail_id — int
users
- id — bigint — Primary key — NOT NULL
- name — varchar(191) — NOT NULL
- phone — varchar(50) — NOT NULL
- email — varchar(191) — NOT NULL
- email_verified_at — timestamp
- password — varchar(191) — NOT NULL
- confirmation_code — varchar(20)
- code_date — int
- marketing_inf — tinyint(1) — NOT NULL
- total_payment — int — NOT NULL
- last_logged_at — datetime
- remember_token — varchar(100)
- created_at — timestamp
- updated_at — timestamp
- admin_id — bigint
- status — tinyint — NOT NULL
- withdraw_date — date
- type — tinyint — NOT NULL
- password_set — tinyint(1) — NOT NULL
- withdraw_reason — tinyint
- point — int
- gender — varchar(191)
- birth_day — date
- city — varchar(191)
- country — varchar(191)
- education — varchar(191)
- verify_code — varchar(191)
- requestnumber — varchar(191)
- responsenumber — varchar(191)
- position — varchar(191)
- responsibility — varchar(191)
- dda_education — varchar(191)
- address — varchar(191)
- ltkn — varchar(191)
- ltkn_date — datetime
- interest — varchar(400)
- addres_detail — varchar(400)
- week_attend — int — NOT NULL
- week_watch_video — int — NOT NULL
- week_login — int — NOT NULL
- week_config_date — timestamp
- gubun — tinyint — NOT NULL — 회원구분, 1:일반회원, 2:내일배움카드
- belongs — varchar(100) — 소속회사(단체)