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')