demo

Tables (25)

admin

  • teacher_id — bigint — NOT NULL
  • classes_id_list — varchar(255)
  • status — bit — NOT NULL

chapter

  • chapter_id — bigint
  • chapter_title — varchar(255)
  • header — varchar(255)
  • video_id — bigint

classes

  • classes_id — bigint
  • created_datetime — datetime(6)
  • updated_datetime — datetime(6)
  • category — varchar(255)
  • level — varchar(255)
  • message — varchar(255)
  • order_value — int — NOT NULL
  • play_time_size — int — NOT NULL
  • price — double — NOT NULL
  • progress — varchar(255)
  • ratings — double — NOT NULL
  • finished — bit — NOT NULL
  • study_duration — bigint
  • sub_category — varchar(255)
  • thumbnail_url — varchar(255)
  • title — varchar(255)
  • total_sales_count — bigint — NOT NULL
  • teacher_id — bigint

coaching

  • coaching_id — bigint
  • created_datetime — datetime(6)
  • updated_datetime — datetime(6)
  • about — longtext
  • all_day_price — double
  • answer — varchar(255)
  • classic_price — double
  • is24hr — bit
  • is_classic — bit
  • is_live — bit
  • is_video — bit
  • live_price — double
  • progress — varchar(255)
  • question — varchar(255)
  • showcase_url — varchar(255)
  • thumbnail_url — varchar(255)
  • title — varchar(255)
  • video_price — double
  • classes_id — bigint
  • teacher_id — bigint

coaching_application

  • coaching_application_id — bigint
  • created_datetime — datetime(6)
  • updated_datetime — datetime(6)
  • coaching_status — varchar(255)
  • file_url — varchar(255)
  • is_accept — bit — NOT NULL
  • message — varchar(255)
  • reply_url — varchar(255)
  • request — varchar(255)
  • solution_type — int
  • to_name — varchar(255)
  • coaching_id — bigint
  • user_seq — bigint

custom_schedule

  • custom_schedule_id — bigint
  • created_datetime — datetime(6)
  • updated_datetime — datetime(6)
  • local_date — date
  • time_range — varchar(255)
  • teacher_id — bigint

hibernate_sequence

  • next_val — bigint

jw_player

  • jw_player_id — bigint
  • jw_player_url — varchar(255)
  • preview — bit — NOT NULL
  • title — varchar(255)
  • chapter_id — bigint

learning_material

  • learning_material_id — bigint
  • expected_completion_time — varchar(255)
  • homework_details — varchar(255)
  • homework_file_file_url — varchar(255)
  • homework_title — varchar(255)
  • syllabus_url — varchar(255)
  • classes_id — bigint

learning_material_practice_file

  • learning_material_learning_material_id — bigint — NOT NULL
  • practice_file — varchar(255)

line_banner

  • line_banner_id — int
  • created_datetime — datetime(6)
  • updated_datetime — datetime(6)
  • color — varchar(255)
  • contents1 — varchar(255)
  • contents2 — varchar(255)
  • contents3 — varchar(255)
  • contents4 — varchar(255)
  • contents5 — varchar(255)
  • ended_datetime — datetime(6)
  • expose_status — bit — NOT NULL
  • link_url — varchar(255)
  • order_value — int — NOT NULL
  • started_datetime — datetime(6)
  • title — varchar(255)
  • type — varchar(255)

main_banner

  • main_banner_id — int — NOT NULL
  • file_url — varchar(255)
  • first_line — varchar(255)
  • second_line — varchar(255)
  • sub_text — varchar(255)

metadata

  • id — int
  • data — longtext
  • data_name — varchar(255)

overview

  • overview_id — bigint
  • description — varchar(255)
  • leaning_object — longtext
  • requirements — longtext
  • classes_id — bigint

quiz

  • quiz_id — bigint
  • answer1 — varchar(255)
  • answer2 — varchar(255)
  • answer3 — varchar(255)
  • answer4 — varchar(255)
  • correct — int — NOT NULL
  • question — varchar(255)
  • chapter_id — bigint

review_of_testimonial

  • review_of_testimonials_id — bigint
  • created_datetime — datetime(6)
  • updated_datetime — datetime(6)
  • details — varchar(255)
  • job_title — varchar(255)
  • name — varchar(255)
  • photo_url — varchar(255)
  • coaching_id — bigint

room

  • id — bigint — NOT NULL
  • created_datetime — datetime(6)
  • updated_datetime — datetime(6)
  • count — int — NOT NULL
  • creator — varchar(255)
  • title — varchar(255)

schedule

  • schedule_id — bigint
  • created_datetime — datetime(6)
  • updated_datetime — datetime(6)
  • time_range — varchar(255)
  • week — varchar(255)
  • teacher_id — bigint

teacher

  • teacher_id — bigint
  • created_datetime — datetime(6)
  • updated_datetime — datetime(6)
  • a_word_from_the_author — longtext
  • about_the_author — varchar(255)
  • job_title — varchar(255)
  • ban_datetime — datetime(6)
  • banned — bit
  • withdraw — bit
  • withdraw_datetime — datetime(6)
  • admin_review — varchar(255)
  • linkedin — varchar(255)
  • twitter — varchar(255)
  • website — varchar(255)
  • email — varchar(255)
  • my_activity — bit — NOT NULL
  • promotion — bit — NOT NULL
  • first_name — varchar(255)
  • join_status — varchar(255)
  • last_login_datetime — datetime(6)
  • last_name — varchar(255)
  • city — varchar(255)
  • country — varchar(255)
  • zip_code — varchar(255)
  • nick_name — varchar(255)
  • password — varchar(255)
  • profile_image_url — varchar(255)
  • answer1 — varchar(2000)
  • answer2 — varchar(2000)
  • answer3 — varchar(2000)
  • question1 — varchar(255)
  • question2 — varchar(255)
  • question3 — varchar(255)
  • resume_file_url — varchar(255)
  • role_type — varchar(255)
  • updates — bit — NOT NULL
  • verification — bit — NOT NULL

teacher_education

  • teacher_teacher_id — bigint — NOT NULL
  • degree_type1 — varchar(255)
  • degree_type2 — varchar(255)
  • description — varchar(255)
  • ended_date — date
  • school_name — varchar(255)
  • started_date — date

teacher_experience

  • teacher_teacher_id — bigint — NOT NULL
  • company_name — varchar(255)
  • description — varchar(255)
  • end_date — datetime(6)
  • position — varchar(255)
  • start_date — datetime(6)

teacher_skill_and_certificates

  • teacher_teacher_id — bigint — NOT NULL
  • skill_and_certificates — varchar(255)

topic

  • topic_id — bigint
  • category — varchar(255)
  • sub_category — varchar(255)
  • teacher_id — bigint

user

  • user_seq — bigint
  • created_datetime — datetime(6)
  • updated_datetime — datetime(6)
  • ban_datetime — datetime(6)
  • banned — bit
  • withdraw — bit
  • withdraw_datetime — datetime(6)
  • email — varchar(255)
  • first_name — varchar(255)
  • last_name — varchar(255)
  • location — varchar(255)
  • login_datetime — datetime(6)
  • new_releases_mail — bit
  • new_releases_push — bit
  • trending_mail — bit
  • trending_push — bit
  • updated_class_mail — bit
  • updated_class_push — bit
  • password — varchar(255)
  • profile_image_url — varchar(255)
  • provider_type — varchar(255)
  • role_type — varchar(255)

video

  • video_id — bigint
  • transcript_url — varchar(255)
  • classes_id — bigint