WishConnect

Tables (24)

ai_interview

  • id — BIGSERIAL — Primary key — NOT NULL
  • essay_question_id — BIGINT — Foreign key → essay_question.id — NOT NULL
  • question_text — TEXT — NOT NULL
  • answer_text — TEXT — 사용자 답변
  • step_order — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

essay

  • id — BIGSERIAL — Primary key — NOT NULL
  • scholarship_id — BIGINT — Foreign key → scholarship.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • last_edited_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

essay_answer

  • id — BIGSERIAL — Primary key — NOT NULL
  • essay_question_id — BIGINT — Foreign key → essay_question.id — NOT NULL
  • ai_draft — TEXT
  • user_content — TEXT — 사용자 최종/수정본
  • char_count — INT — NOT NULL
  • is_temporary — BOOLEAN — NOT NULL — 임시저장 여부
  • is_completed — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

essay_question

  • id — BIGSERIAL — Primary key — NOT NULL
  • essay_id — BIGINT — Foreign key → essay.id — NOT NULL
  • question_order — INT — NOT NULL
  • question_title — VARCHAR(500) — NOT NULL
  • question_description — TEXT
  • char_limit — INT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

insight

  • id — BIGSERIAL — Primary key — NOT NULL
  • category_id — BIGINT — Foreign key → insight_category.id — NOT NULL
  • title — VARCHAR(500) — NOT NULL
  • content — TEXT
  • original_url — VARCHAR(1000)
  • thumbnail_url — VARCHAR(1000)
  • view_count — BIGINT — NOT NULL
  • published_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

insight_category

  • id — BIGSERIAL — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • display_order — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

insight_tag

  • id — BIGSERIAL — Primary key — NOT NULL
  • insight_id — BIGINT — Foreign key → insight.id — NOT NULL
  • tag_id — BIGINT — Foreign key → tag.id — NOT NULL

major

  • id — BIGSERIAL — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • category — VARCHAR(50)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

notification

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • content — TEXT
  • related_type — VARCHAR(20)
  • related_id — BIGINT
  • is_read — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

notification_dispatch_log

  • id — BIGSERIAL — Primary key — NOT NULL
  • scholarship_id — BIGINT — Foreign key → scholarship.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • type — VARCHAR(20) — NOT NULL
  • sent_date — DATE — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

notification_setting

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • is_matching_enabled — BOOLEAN — NOT NULL
  • is_schedule_enabled — BOOLEAN — NOT NULL
  • is_essay_enabled — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

raw_scholarship

  • id — BIGSERIAL — Primary key — NOT NULL
  • scholarship_id — BIGINT — Foreign key → scholarship.id — NOT NULL
  • source — VARCHAR(50) — NOT NULL
  • source_url — VARCHAR(1000) — NOT NULL
  • source_id — VARCHAR(200) — NOT NULL — 출처의 고유 ID(공고번호 등)
  • raw_json — JSONB
  • raw_html — TEXT
  • crawled_at — TIMESTAMP — NOT NULL
  • parse_status — VARCHAR(20) — NOT NULL — PENDING/PARSED/FAILED/SKIPPED
  • parse_error — TEXT
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

region

  • id — BIGSERIAL — Primary key — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • parent_id — BIGINT — Foreign key → region.id
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

scholarship

  • id — BIGSERIAL — Primary key — 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 — TIMESTAMP
  • application_end_at — TIMESTAMP
  • recruitment_status — VARCHAR(20) — NOT NULL
  • selection_count — INT
  • amount — BIGINT
  • is_active — BOOLEAN — NOT NULL
  • is_verified — BOOLEAN — NOT NULL
  • primary_source — VARCHAR(50)
  • last_synced_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

scholarship_condition

  • id — BIGSERIAL — Primary key — NOT NULL
  • scholarship_id — BIGINT — Foreign key → scholarship.id — NOT NULL
  • condition_type — VARCHAR(30) — NOT NULL
  • operator — VARCHAR(20) — NOT NULL — IN/EQ/LTE/GTE/BETWEEN
  • ref_id — BIGINT — School/Major/Region FK 대용(애플리케이션 관리)
  • value_int — INT — 숫자 값(분위/학년 등)
  • value_int_max — INT — BETWEEN용 상한
  • value_string — VARCHAR(100) — Enum 값
  • is_auto_extracted — BOOLEAN — NOT NULL — LLM 자동 추출 여부
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

scholarship_document

  • id — BIGSERIAL — Primary key — NOT NULL
  • scholarship_id — BIGINT — Foreign key → scholarship.id — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • is_essay — BOOLEAN — NOT NULL — 자소서 항목 여부
  • display_order — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

scholarship_recommendation

  • id — BIGSERIAL — Primary key — NOT NULL
  • scholarship_id — BIGINT — Foreign key → scholarship.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • match_score — INT — NOT NULL
  • match_reason — TEXT — 추천 이유
  • is_eligible — BOOLEAN — NOT NULL — 조건 충족 여부
  • calculated_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

scholarship_timeline

  • id — BIGSERIAL — Primary key — NOT NULL
  • scholarship_id — BIGINT — Foreign key → scholarship.id — NOT NULL
  • title — VARCHAR(100) — NOT NULL
  • start_date — DATE
  • end_date — DATE
  • display_order — INT — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

school

  • id — BIGSERIAL — Primary key — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • region_id — BIGINT — Foreign key → region.id
  • school_type — VARCHAR(50)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

scrap

  • id — BIGSERIAL — Primary key — NOT NULL
  • scholarship_id — BIGINT — Foreign key → scholarship.id — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

tag

  • id — BIGSERIAL — Primary key — NOT NULL
  • name — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

user_profile

  • id — BIGSERIAL — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • school_id — BIGINT — Foreign key → school.id
  • major_id — BIGINT — Foreign key → major.id
  • region_id — BIGINT — Foreign key → region.id
  • income_level — INT
  • family_type — VARCHAR(50) — GENERAL/SINGLE_PARENT/MULTI_CHILD 등
  • onboarding_step — VARCHAR(20) — NOT NULL — STEP_1~STEP_4
  • is_onboarding_completed — BOOLEAN — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

users

  • id — BIGSERIAL — Primary key — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — VARCHAR(255) — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • role — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • deleted_at — TIMESTAMP

이미지 (image)

  • id — BIGSERIAL — Primary key — NOT NULL
  • Field