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