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