cs
Tables (20)
admin
- id — bigint — Primary key — NOT NULL
- role — varchar(255)
- user_id — bigint — Foreign key → users.id — NOT NULL
categories
- id — int — Primary key — NOT NULL
- code — varchar(50) — NOT NULL
- name — varchar(100) — NOT NULL
- display_order — int
- summary — varchar(100)
cs_concept
- id — bigint — Primary key — NOT NULL
- category — varchar(255)
- definition — text
- path — varchar(255)
- title — varchar(255)
cs_questions
- id — int — Primary key — NOT NULL
- category — varchar(30) — NOT NULL
- difficulty — varchar(10) — NOT NULL
- question — text — NOT NULL
- option_1 — varchar(200) — NOT NULL
- option_2 — varchar(200) — NOT NULL
- option_3 — varchar(200) — NOT NULL
- option_4 — varchar(200) — NOT NULL
- correct_answer — int — NOT NULL
interview_question
- id — bigint — Primary key — NOT NULL
- answer — varchar(2000)
- cs_question — tinyint(1) — NOT NULL
- question — varchar(1000)
- review_id — bigint — Foreign key → interview_review.id
interview_records
- id — int — Primary key — NOT NULL
- user_id — varchar(64) — NOT NULL
- agent_id — varchar(20) — NOT NULL
- category_root — varchar(30) — NOT NULL
- question — text — NOT NULL
- user_answer — text — NOT NULL
- is_from_question_bank — tinyint(1) — NOT NULL
- is_answer_right — tinyint(1) — NOT NULL
- category — varchar(128)
- standard_answer — text
- custom_prompt — text
- start_record_id — int — Foreign key → interview_start.id
- created_at — datetime
interview_review
- id — bigint — Primary key — NOT NULL
- category — varchar(20)
- company_name — varchar(255)
- job_title — varchar(255)
- user_id — bigint
interview_start
- id — int — Primary key — NOT NULL
- user_id — varchar(64) — NOT NULL
- agent_id — varchar(20) — NOT NULL
- category_root — varchar(30) — NOT NULL
- question — text — NOT NULL
- is_from_question_bank — tinyint(1) — NOT NULL
- hint — text
- custom_prompt — text
- created_at — datetime
learning_roadmap
- id — int — Primary key — NOT NULL
- category — varchar(30) — NOT NULL
- subcategory — varchar(50) — NOT NULL
- priority_order — int — NOT NULL
- difficulty_level — varchar(20) — NOT NULL
- description — text
past_questions
- id — bigint — Primary key — NOT NULL
- question — text — NOT NULL
- category — varchar(20) — NOT NULL
- is_cs — tinyint(1) — NOT NULL
- category_code — varchar(50)
- subcategory_code — varchar(50)
- topic_code — varchar(100)
- full_path — varchar(200)
qacomment
- id — bigint — Primary key — NOT NULL
- content — text
- created_at — datetime
- user_id — bigint — Foreign key → users.id — NOT NULL
- post_id — bigint — Foreign key → qapost.id — NOT NULL
qaimage
- id — bigint — Primary key — NOT NULL
- image_url — varchar(255)
- post_id — bigint — Foreign key → qapost.id
qapost
- id — bigint — Primary key — NOT NULL
- category — varchar(30) — NOT NULL
- content — text
- created_at — datetime
- status — varchar(20) — NOT NULL
- title — varchar(255)
- user_id — bigint — Foreign key → users.id — NOT NULL
subcategories
- id — int — Primary key — NOT NULL
- category_id — int — Foreign key → categories.id — NOT NULL
- code — varchar(50) — NOT NULL
- name — varchar(100) — NOT NULL
- display_order — int
- summary — varchar(100)
- img_url — varchar(100)
topics
- id — int — Primary key — NOT NULL
- subcategory_id — int — Foreign key → subcategories.id — NOT NULL
- code — varchar(100) — NOT NULL
- name — varchar(100) — NOT NULL
- difficulty_level — varchar(20) — NOT NULL
- display_order — int
- description — text
- summary — varchar(100)
- learning_goal — json
- lecture_url — varchar(500)
- lecture_producer — varchar(100)
- lecture_title — varchar(200)
user_learning_logs
- id — bigint — Primary key — NOT NULL
- user_id — varchar(50) — NOT NULL
- topic_code — varchar(100) — NOT NULL
- created_at — timestamp
user_learning_progress
- id — bigint — Primary key — NOT NULL
- user_id — varchar(50) — NOT NULL
- topic_code — varchar(100) — NOT NULL
- completed_at — timestamp
user_responses
- id — int — Primary key — NOT NULL
- user_id — varchar(50) — NOT NULL
- question_id — int — Foreign key → cs_questions.id — NOT NULL
- selected_answer — int — NOT NULL
- is_correct — tinyint(1) — NOT NULL
- submitted_at — timestamp
user_topics
- id — int — Primary key — NOT NULL
- user_id — varchar(50) — NOT NULL
- code — varchar(100) — NOT NULL
- description — text
- difficulty_level — varchar(20)
- display_order — int
- subcategory_id — int — Foreign key → subcategories.id — NOT NULL
- created_at — timestamp
- name_ko — varchar(200) — NOT NULL
- name_en — varchar(200)
- summary — varchar(100)
users
- id — bigint — Primary key — NOT NULL
- email — varchar(255) — NOT NULL
- pw — varchar(255) — NOT NULL
- name — varchar(255)
- student_id — varchar(255)
- profile_image — varchar(255)
- has_completed_onboarding — tinyint(1)
- created_at — timestamp
- updated_at — timestamp