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)