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) — 소속회사(단체)