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