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