new hanacare

Tables (18)

Account

  • id — BIGINT — NOT NULL
  • asset_id — BIGINT — Foreign key → Asset.id — NOT NULL
  • company — VARCHAR(100)
  • account_name — VARCHAR(100)
  • account_number — VARCHAR(50)
  • balance — DECIMAL(18, 2)

Asset

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • category — ENUM('REAL_ESTATE', 'CAR', 'GOLD', 'ACCOUNT', 'STOCK', 'INSURANCE', 'CARD') — NOT NULL
  • total_value — DECIMAL(18, 2)
  • data_source — ENUM('MYDATA', 'MANUAL')
  • address — VARCHAR(255)
  • details — JSON — 부동산 면적, 차번호 등 상세정보
  • created_at — DATETIME
  • updated_at — DATETIME

Card

  • id — BIGINT — NOT NULL
  • asset_id — BIGINT — Foreign key → Asset.id — NOT NULL
  • company — VARCHAR(100)
  • card_name — VARCHAR(100)
  • used_amount — DECIMAL(18, 2)
  • limit_amount — DECIMAL(18, 2)
  • payment_date — INT

CarePermission

  • id — BIGINT — NOT NULL
  • grantor_id — BIGINT — NOT NULL — 권한 부여 부모
  • grantee_id — BIGINT — NOT NULL — 권한 수령 자녀
  • view_insurance — BOOLEAN
  • status — ENUM('PENDING', 'ACTIVE', 'REVOKED')
  • relation — ENUM('SPOUSE', 'CHILD', 'PARENT', 'SIBLING')
  • created_at — DATETIME
  • updated_at — DATETIME

InheritanceBeneficiary

  • id — BIGINT — NOT NULL
  • plan_id — BIGINT — Foreign key → InheritancePlan.id — NOT NULL
  • relation — VARCHAR(20)
  • name — VARCHAR(50)
  • ratio — DECIMAL(5, 2) — 상속 비율(%)
  • amount — DECIMAL(18, 2)

InheritanceLetter

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL — 작성자(부모)
  • beneficiary_id — BIGINT — Foreign key → User.id — NOT NULL — 수신자(자녀)
  • content — TEXT
  • is_locked — BOOLEAN
  • created_at — DATETIME

InheritancePlan

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • gifted — DECIMAL(18, 2) — 기증여 재산
  • estimated_tax — DECIMAL(18, 2) — 추정 상속세
  • family_type — VARCHAR(50)
  • created_at — DATETIME
  • updated_at — DATETIME

Insurance

  • id — BIGINT — NOT NULL
  • asset_id — BIGINT — Foreign key → Asset.id — NOT NULL
  • insurance_name — VARCHAR(100)
  • premium — DECIMAL(18, 2) — NOT NULL
  • coverage — TEXT

MedicalReceipt

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • receipt_type — VARCHAR(50)
  • place_name — VARCHAR(100)
  • amount — DECIMAL(18, 2)
  • receipt_date — DATE
  • image_url — VARCHAR(512)

Product

  • id — BIGINT — NOT NULL
  • category — ENUM('PENSION', 'TRUST', 'LOAN') — NOT NULL
  • sub_category — ENUM('MORTGAGE', 'CREDIT')
  • name — VARCHAR(100) — NOT NULL
  • description — TEXT
  • base_rate — DECIMAL(5, 2) — 이율(%)
  • is_available — BOOLEAN
  • mortgage_type — ENUM('REAL_ESTATE', 'ACCOUNT', 'INSURANCE')

SimulationSetting

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • expected_age — INT
  • care_type — VARCHAR(50)
  • created_at — DATETIME
  • updated_at — DATETIME

Stock

  • id — BIGINT — NOT NULL
  • asset_id — BIGINT — Foreign key → Asset.id — NOT NULL
  • stock_name — VARCHAR(100)
  • quantity — DECIMAL(18, 4)
  • avg_price — DECIMAL(18, 2)
  • current_price — DECIMAL(18, 2)

Terms

  • id — BIGINT — NOT NULL
  • type — ENUM('SERVICE', 'MYDATA')
  • title — VARCHAR(100)
  • content — TEXT
  • version — VARCHAR(10)
  • is_required — BOOLEAN
  • created_at — DATETIME

TermsAgreement

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • terms_id — BIGINT — Foreign key → Terms.id — NOT NULL
  • is_agreed — BOOLEAN — NOT NULL
  • agreed_at — DATETIME

Transaction

  • id — BIGINT — NOT NULL
  • userproduct_id — BIGINT — NOT NULL
  • type — ENUM('PAYOUT', 'INTEREST', 'REPAYMENT')
  • amount — DECIMAL(18, 2)
  • status — ENUM('COMPLETED', 'PENDING', 'FAILED')
  • transaction_at — DATETIME

User

  • id — BIGINT — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • phone — VARCHAR(50) — NOT NULL
  • login_type — ENUM('HANA_CERT', 'GENERAL') — NOT NULL
  • auth_method — ENUM('PASSWORD', 'FACE_ID', 'PATTERN') — NOT NULL
  • is_active — BOOLEAN
  • password — VARCHAR(255)
  • created_at — DATETIME
  • updated_at — DATETIME

UserAuth

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • auth_type — ENUM('HANA_CERT', 'PATTERN', 'BIO')
  • result — ENUM('SUCCESS', 'FAIL')
  • ip_address — VARCHAR(50)
  • device_info — VARCHAR(255) — NOT NULL
  • created_at — DATETIME

User_Product

  • id — BIGINT — NOT NULL
  • user_id — BIGINT — Foreign key → User.id — NOT NULL
  • product_id — BIGINT — Foreign key → Product.id — NOT NULL
  • target_asset_id — BIGINT — Foreign key → Asset.id — NOT NULL — 담보 자산
  • repayment_child_id — BIGINT — NOT NULL — 채무 승계 자녀
  • prod_type — ENUM('PENSION', 'TRUST', 'LOAN')
  • monthly_payout — DECIMAL(18, 2)
  • loan_amount — DECIMAL(18, 2)
  • inheritance_type — ENUM('GIFT', 'INHERIT') — 부담부증여/채무상속
  • status — ENUM('ACTIVE', 'PAID_OFF', 'TERMINATED')