aducation

Tables (12)

career_reco_result

  • result_id — BIGINT — Primary key — NOT NULL
  • recommended_career — VARCHAR(255)
  • reason — TEXT
  • created_at — TIMESTAMP
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL

content_ingestion

  • content_id — BIGINT — Primary key — NOT NULL
  • content_type — ENUM('video','audio','document')
  • original_url — TEXT
  • transcript — LONGTEXT
  • summary — LONGTEXT
  • created_at — TIMESTAMP
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL

passwordless_token

  • token_id — BIGINT — Primary key — NOT NULL
  • token — VARCHAR(255)
  • expires_at — TIMESTAMP
  • used — BOOLEAN
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL

quiz

  • quiz_id — BIGINT — Primary key — NOT NULL
  • question — TEXT
  • option_a — VARCHAR(255)
  • option_b — VARCHAR(255)
  • option_c — VARCHAR(255)
  • option_d — VARCHAR(255)
  • correct_option — CHAR(1)
  • content_id — BIGINT — Foreign key → content_ingestion.content_id — NOT NULL

quiz_attempt

  • attempt_id — BIGINT — Primary key — NOT NULL
  • selected_option — CHAR(1)
  • is_correct — BOOLEAN
  • attempted_at — TIMESTAMP
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • quiz_id — BIGINT — Foreign key → quiz.quiz_id — NOT NULL

survey_question

  • question_id — BIGINT — Primary key — NOT NULL
  • question_text — TEXT

survey_response

  • response_id — BIGINT — Primary key — NOT NULL
  • answer — TEXT
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • question_id — BIGINT — Foreign key → survey_question.question_id — NOT NULL

user_auth_provider

  • provider_id — BIGINT — Primary key — NOT NULL
  • provider — ENUM('google','naver','kakao')
  • provider_uid — VARCHAR(255)
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL

user_certification

  • cert_id — BIGINT — Primary key — NOT NULL
  • cert_name — VARCHAR(255)
  • issued_by — VARCHAR(255)
  • issue_date — DATE
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL

user_edu_history

  • edu_id — BIGINT — Primary key — NOT NULL
  • institution — VARCHAR(255)
  • degree — VARCHAR(100)
  • graduation_year — INT
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL

users

  • user_id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(255)
  • password_hash — VARCHAR(255)
  • name — VARCHAR(100)
  • created_at — TIMESTAMP

wrong_note

  • note_id — BIGINT — Primary key — NOT NULL
  • created_at — TIMESTAMP
  • user_id — BIGINT — Foreign key → users.user_id — NOT NULL
  • quiz_id — BIGINT — Foreign key → quiz.quiz_id — NOT NULL