ai 해커톤
테이블 (19)
applicant_profiles
- user_id — VARCHAR(100) — 외래 키 → users.id — NOT NULL
- nationality_code — CHAR(2) — NOT NULL
- visa_type — VARCHAR(20) — NOT NULL
- legal_name — VARCHAR(255)
- birth_date — DATE
- alien_registration_number — VARCHAR(255)
- stay_qualification — VARCHAR(30)
- stay_start_date — DATE
- stay_end_date — DATE
- korean_address — VARCHAR(500)
- home_country_address — VARCHAR(500)
- passport_number — VARCHAR(255)
- passport_expires_on — DATE
- phone_number — VARCHAR(30)
- phone_is_self_owned — BOOLEAN
- school_name — VARCHAR(255)
- has_enrollment_certificate — BOOLEAN
- confirmed_at — DATETIME
- updated_at — DATETIME — NOT NULL
application_purposes
- application_id — VARCHAR(36) — 외래 키 → applications.id — NOT NULL
- purpose_code — VARCHAR(30) — 외래 키 → purpose_codes.code — NOT NULL
applications
- id — VARCHAR(36) — 기본 키 — NOT NULL
- user_id — VARCHAR(100) — 외래 키 → users.id — NOT NULL
- bank_code — VARCHAR(20) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- current_step — VARCHAR(30) — NOT NULL
- started_at — DATETIME — NOT NULL
- reviewed_at — DATETIME
- completed_at — DATETIME
- updated_at — DATETIME — NOT NULL
assessment_issues
- id — VARCHAR(36) — 기본 키 — NOT NULL
- product_assessment_id — VARCHAR(36) — 외래 키 → product_assessments.id — NOT NULL
- related_document_type_code — VARCHAR(40) — 외래 키 → document_types.code
- issue_code — VARCHAR(50) — NOT NULL
- severity — VARCHAR(20) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- guidance — TEXT
- due_at — DATETIME
- resolved_at — DATETIME
bank_products
- id — VARCHAR(36) — 기본 키 — NOT NULL
- bank_code — VARCHAR(20) — NOT NULL
- product_code — VARCHAR(50) — NOT NULL
- name — VARCHAR(200) — NOT NULL
- account_type — VARCHAR(30) — NOT NULL
- daily_transfer_limit_krw — INT
- active — BOOLEAN — NOT NULL
document_types
- code — VARCHAR(40) — 기본 키 — NOT NULL
- label_ko — VARCHAR(100) — NOT NULL
- image_required — BOOLEAN — NOT NULL
- paper_original_required — BOOLEAN — NOT NULL
- valid_for_days — INT
documents
- id — VARCHAR(255) — 기본 키 — NOT NULL
- session_id — VARCHAR(255) — 외래 키 → tasks.session_id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- action_id — VARCHAR(100) — 외래 키 → tasks.id — NOT NULL
- preview_url — VARCHAR(2048) — NOT NULL
- pdf_url — VARCHAR(2048) — NOT NULL
- created_at — DATETIME — NOT NULL
evidence_documents
- id — VARCHAR(36) — 기본 키 — NOT NULL
- application_id — VARCHAR(36) — 외래 키 → applications.id — NOT NULL
- document_type_code — VARCHAR(40) — 외래 키 → document_types.code — NOT NULL
- source — VARCHAR(20) — NOT NULL
- storage_key — VARCHAR(500)
- mime_type — VARCHAR(100)
- size_bytes — INT
- processing_status — VARCHAR(30) — NOT NULL
- issued_at — DATETIME
- expires_at — DATETIME
- created_at — DATETIME — NOT NULL
extracted_fields
- id — VARCHAR(36) — 기본 키 — NOT NULL
- evidence_document_id — VARCHAR(36) — 외래 키 → evidence_documents.id — NOT NULL
- field_key — VARCHAR(100) — NOT NULL
- raw_value — TEXT
- normalized_value — TEXT
- confidence — DECIMAL(5,4)
- verification_status — VARCHAR(30) — NOT NULL
- corrected_value — TEXT
- verified_at — DATETIME
generated_documents
- id — VARCHAR(36) — 기본 키 — NOT NULL
- application_id — VARCHAR(36) — 외래 키 → applications.id — NOT NULL
- document_kind — VARCHAR(40) — NOT NULL
- template_code — VARCHAR(50) — NOT NULL
- template_version — VARCHAR(30) — NOT NULL
- language_code — VARCHAR(10) — NOT NULL
- file_name — VARCHAR(255) — NOT NULL
- storage_key — VARCHAR(500) — NOT NULL
- page_count — INT
- size_bytes — INT
- content_snapshot_json — TEXT — NOT NULL
- generated_at — DATETIME — NOT NULL
- expires_at — DATETIME
pending_approvals
- session_id — VARCHAR(255) — 외래 키 → tasks.session_id — NOT NULL
- action_id — VARCHAR(100) — 외래 키 → tasks.id — NOT NULL
- title — VARCHAR(255) — NOT NULL
- summary — JSON — NOT NULL
- document_id — VARCHAR(255) — 외래 키 → documents.id — NOT NULL
- evidence — JSON — NOT NULL
- risk_level — VARCHAR(10) — NOT NULL
- approved — BOOLEAN
preparation_tasks
- id — VARCHAR(36) — 기본 키 — NOT NULL
- application_id — VARCHAR(36) — 외래 키 → applications.id — NOT NULL
- task_type — VARCHAR(40) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- title — VARCHAR(255) — NOT NULL
- description — TEXT
- location_hint — VARCHAR(255)
- estimated_minutes — INT
- sort_order — INT — NOT NULL
- due_at — DATETIME
product_assessments
- id — VARCHAR(36) — 기본 키 — NOT NULL
- application_id — VARCHAR(36) — 외래 키 → applications.id — NOT NULL
- bank_product_id — VARCHAR(36) — 외래 키 → bank_products.id — NOT NULL
- result — VARCHAR(30) — NOT NULL
- policy_version — VARCHAR(50) — NOT NULL
- summary — TEXT
- assessed_at — DATETIME — NOT NULL
purpose_codes
- code — VARCHAR(30) — 기본 키 — NOT NULL
- label_ko — VARCHAR(100) — NOT NULL
- label_en — VARCHAR(100) — NOT NULL
- active — BOOLEAN — NOT NULL
tasks
- id — VARCHAR(100) — 기본 키 — NOT NULL
- session_id — VARCHAR(255) — 외래 키 → 사용자 서비스 흐름.session_id — NOT NULL
- label — VARCHAR(255) — NOT NULL
- status — ENUM('locked', 'available', 'in_progress', 'done') — NOT NULL
- prereq — JSON — NOT NULL
- blocked_by — JSON — NOT NULL
- deadline — DATE
- d_day — INT
- evidence — JSON — NOT NULL
user (Untitled)
- 회원번호 (user_id) — NOT NULL — 기본 키 — NOT NULL
- 닉네임 (nickname) — NOT NULL
- 비밀번호 (password) — NOT NULL
- 이름 (name)
- 언어 (language)
- 비자종류 (visa_type)
- Field6
users
- id — VARCHAR(100) — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- preferred_language — VARCHAR(10) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
사용자 서비스 흐름 (sessions)
- session_id — VARCHAR(255) — 기본 키 — NOT NULL
- locale — VARCHAR(10) — NOT NULL
사용자 프로필(최종값) (profiles)
- session_id — VARCHAR(255) — 외래 키 → 사용자 서비스 흐름.session_id — NOT NULL
- arc_no — VARCHAR(255)
- nationality — CHAR(3)
- name_en — VARCHAR(255)
- birth_date — DATE
- visa_type — VARCHAR(50)
- stay_expiry — DATE
- addr_kr — VARCHAR(500)