위시커넥트
테이블 (23)
ai_interview
- id — BIGINT — 기본 키 — NOT NULL
- essay_question_id — BIGINT — 외래 키 → essay_question.id — NOT NULL
- question_text — TEXT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
essay
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.id — NOT NULL
- scholarship_id — BIGINT — 외래 키 → scholarship.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
essay_answer
- id — BIGINT — 기본 키 — NOT NULL
- essay_question_id — BIGINT — NOT NULL
- ai_draft — LONGTEXT — NOT NULL
- is_temporary — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
essay_question
- id — BIGINT — 기본 키 — NOT NULL
- essay_id — BIGINT — 외래 키 → essay.id — NOT NULL
- question_order — INT — NOT NULL
- question_title — VARCHAR(500) — NOT NULL
- question_description — TEXT
- char_limit — INT — NOT NULL
- updated_at — DATETIME — NOT NULL
insight
- id — BIGINT — 기본 키 — NOT NULL
- title — VARCHAR(500) — NOT NULL
- content — TEXT
- original_url — VARCHAR(1000)
- thumbnail_url — VARCHAR(1000)
- category_id — BIGINT — 외래 키 → insight_category.id — NOT NULL
- view_count — BIGINT — NOT NULL
- published_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
insight_category
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- display_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
insight_tag
- id — BIGINT — 기본 키 — NOT NULL
- insight_id — BIGINT — 외래 키 → insight.id — NOT NULL
- tag_id — BIGINT — 외래 키 → tag.id — NOT NULL
major
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- category — VARCHAR(50) — 소득분위 1~10
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
notification
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.id — NOT NULL
- type — VARCHAR(20) — NOT NULL
- content — TEXT
- related_type — VARCHAR(20) — NOT NULL
- created_at — DATETIME — NOT NULL
notification_dispatch_log
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.id — NOT NULL
- scholarship_id — BIGINT — NOT NULL
- type — VARCHAR(20) — NOT NULL
- sent_date — DATE — NOT NULL
- created_at — DATETIME — NOT NULL
notification_setting
- user_id — BIGINT — 외래 키 — NOT NULL
- is_schedule_enabled — BOOLEAN — NOT NULL
- is_essay_enabled — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
raw_scholarship
- id — BIGINT — 기본 키 — NOT NULL
- source — VARCHAR(50) — NOT NULL — 예: 자기소개서, 성적증명서
- source_url — VARCHAR(1000) — NOT NULL
- source_id — VARCHAR(200) — NOT NULL — 자소서 항목 여부
- raw_json — JSON — SCHOOL/MAJOR/REGION/INCOME/FAMILY/GRADE/GPA/...
- raw_html — LONGTEXT
- crawled_at — DATETIME — NOT NULL
- parse_status — VARCHAR(20) — NOT NULL — IN/EQ/LTE/GTE/BETWEEN
- parse_error — TEXT
- scholarship_id — BIGINT — School/Major/Region FK 대용(애플리케이션 관리)
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
region
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(100) — NOT NULL
- parent_id — BIGINT — 외래 키 → region.id — 시/도 → 시/군/구 계층
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
scholarship
- id — BIGINT — 기본 키 — NOT NULL
- title — VARCHAR(500) — NOT NULL
- provider — VARCHAR(200) — NOT NULL — 운영자 검수 완료 여부
- summary — TEXT
- description — TEXT
- scholarship_type — VARCHAR(20) — NOT NULL — 주 출처
- application_start_at — DATETIME
- application_end_at — DATETIME
- recruitment_status — VARCHAR(20) — NOT NULL — KOSAF/SCHOOL_WEB/NEWS/MANUAL
- selection_count — INT
- amount — BIGINT — 출처의 고유 ID(공고번호 등)
- is_active — BOOLEAN — NOT NULL — 가공 전 원본
- is_verified — BOOLEAN — NOT NULL — PENDING/PARSED/FAILED/SKIPPED
- primary_source — VARCHAR(50) — 정제 후 연결된 Scholarship
- last_synced_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
scholarship_condition
- id — BIGINT — 기본 키 — NOT NULL
- scholarship_id — BIGINT — NOT NULL
- condition_type — VARCHAR(30) — NOT NULL — 조건 충족 여부
- operator — VARCHAR(20) — NOT NULL — NOT_STARTED/IN_PROGRESS/COMPLETED
- ref_id — BIGINT — 글자 수 제한
- value_int — INT — AI 생성 세부 질문
- value_int_max — INT — 사용자 답변
- value_string — VARCHAR(100) — STEP 2 AI 초안
- is_auto_extracted — BOOLEAN — NOT NULL — 사용자 최종/수정본
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
scholarship_document
- id — BIGINT — 기본 키 — NOT NULL
- scholarship_id — BIGINT — 외래 키 → scholarship.id — NOT NULL
- name — VARCHAR(200) — NOT NULL — LLM 자동 추출 여부
- is_essay — BOOLEAN — NOT NULL — 정렬용 점수
- display_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
scholarship_recommendation
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.id — NOT NULL
- scholarship_id — BIGINT — NOT NULL
- match_score — INT — NOT NULL — PK 겸 FK
- match_reason — TEXT — MATCH/SCHEDULE/ESSAY
- is_eligible — BOOLEAN — NOT NULL — SCHOLARSHIP/ESSAY
- calculated_at — DATETIME — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
scholarship_timeline
- id — BIGINT — 기본 키 — NOT NULL
- scholarship_id — BIGINT — 외래 키 → scholarship.id — NOT NULL
- title — VARCHAR(100) — NOT NULL — BETWEEN용 상한
- start_date — DATE
- end_date — DATE
- display_order — INT — NOT NULL
- created_at — DATETIME — NOT NULL
school
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(200) — NOT NULL
- region_id — BIGINT — 외래 키 → region.id
- school_type — VARCHAR(50) — 인문/공학/예체능 등 계열
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
scrap
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.id — NOT NULL
- scholarship_id — BIGINT — 외래 키 → scholarship.id — NOT NULL
- created_at — DATETIME — NOT NULL
tag
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(50) — NOT NULL
- created_at — DATETIME — NOT NULL
user
- id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- role — VARCHAR(50) — NOT NULL — STEP_1~STEP_4
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- deleted_at — DATETIME
user_profile
- id — BIGINT — 기본 키 — NOT NULL
- user_id — BIGINT — 외래 키 → user.id — NOT NULL
- school_id — BIGINT — 외래 키 → school.id
- major_id — BIGINT — 외래 키 → major.id
- region_id — BIGINT
- income_level — INT — INTERNAL/EXTERNAL
- family_type — VARCHAR(50) — UPCOMING/OPEN/CLOSED
- onboarding_step — VARCHAR(20) — NOT NULL — 장학금 금액(원)
- is_onboarding_completed — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
- =유저 — 프로필(조건 정보