위시커넥트

테이블 (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
  • =유저 — 프로필(조건 정보