7ITAX ERD
Tables (23)
accounts
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- account_type — VARCHAR(20) — PERSONAL, BUSINESS
- bank_code — VARCHAR(255)
- account_no — VARCHAR(255)
- account_type_unique_no — VARCHAR(255)
- alias — VARCHAR(255)
- status — VARCHAR(20) — ACTIVE, INACTIVE, CLOSED
- deleted — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_account_user_id
book_entries
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- payment_id — BIGINT — Foreign key → payments.id
- entry_date — DATE
- description — VARCHAR(255)
- merchant_name — VARCHAR(255)
- entry_type — VARCHAR(20) — INCOME, EXPENSE, ASSET
- income_amount — BIGINT
- expense_amount — BIGINT
- fixed_asset_amount — BIGINT
- vat_amount — BIGINT
- supply_price — BIGINT
- category_code — VARCHAR(255)
- category_name — VARCHAR(255)
- is_business_expense — BOOLEAN
- is_vat_deductible — BOOLEAN
- confidence_score — DOUBLE
- confirmed — BOOLEAN
- confirmed_at — DATETIME
- note — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_be_user_date
- INDEX — idx_be_user_confirmed
business_profiles
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- business_reg_number — VARCHAR(255)
- business_name — VARCHAR(255)
- industry_code — VARCHAR(255)
- nts_verified — BOOLEAN
- nts_verified_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
card_transactions
- id — BIGINT
- card_id — BIGINT — Foreign key → cards.id — NOT NULL
- transaction_type — VARCHAR(20) — CHARGE, PAYMENT, REFUND
- amount — BIGINT
- balance_after — BIGINT
- description — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
cards
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- card_name — VARCHAR(255)
- card_type — VARCHAR(20) — PERSONAL, BUSINESS
- last4_digits — VARCHAR(4)
- is_default — BOOLEAN
- card_no — VARCHAR(255)
- cvc — VARCHAR(255)
- card_unique_no — VARCHAR(255)
- ssafy_account_no — VARCHAR(255)
- withdrawal_account_no — VARCHAR(255)
- withdrawal_date — VARCHAR(255)
- card_expiry_date — VARCHAR(255)
- status — VARCHAR(20) — INACTIVE, ACTIVE
- default_purpose — VARCHAR(20) — PERSONAL, BUSINESS
- deleted — BOOLEAN
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_card_user_id
chat_messages
- id — BIGINT
- session_id — VARCHAR(255) — Foreign key → chat_sessions.session_id — NOT NULL
- role — VARCHAR(255)
- content — TEXT
- created_at — DATETIME
chat_sessions
- id — BIGINT
- session_id — VARCHAR(255) — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- message_count — INT
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_cs_user_id
- INDEX — idx_cs_session_id
expense_details
- id — BIGINT
- tax_return_id — BIGINT — Foreign key → tax_returns.id — NOT NULL
- expense_code — VARCHAR(255)
- expense_name — VARCHAR(255)
- amount — BIGINT
- created_at — DATETIME
- updated_at — DATETIME
fcm_tokens
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- token — VARCHAR(255)
- device_info — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_fcm_token_user_id
mcc_tax_rule
- id — BIGINT
- mcc — VARCHAR(255)
- tier — VARCHAR(10) — A or B
- condition_expr — VARCHAR(255)
- tax_category — VARCHAR(255)
- vat_deductible — BOOLEAN
- amount_threshold — BIGINT
- remark — VARCHAR(255)
- legal_basis — VARCHAR(255)
- annual_limit — BIGINT
- confidence — DOUBLE
- requires_user_confirm — BOOLEAN
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- INDEX — idx_mcc_tax_rule_mcc
- INDEX — idx_mcc_tax_rule_tier
merchant
- id — BIGINT
- merchant_name — VARCHAR(255)
- mcc — VARCHAR(255)
- category — VARCHAR(255)
- example_names — VARCHAR(255)
- is_domestic — BOOLEAN
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- INDEX — idx_merchant_mcc
- INDEX — idx_merchant_name
merchant_keyword_mapping
- id — BIGINT
- keyword — VARCHAR(255)
- mcc — VARCHAR(255)
- tax_category — VARCHAR(255)
- is_domestic — BOOLEAN
- confidence — DOUBLE
- created_at — DATETIME(6)
- updated_at — DATETIME(6)
- INDEX — idx_mkm_keyword
- INDEX — idx_mkm_tax_category
payments
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- card_id — BIGINT — Foreign key → cards.id — NOT NULL
- amount — BIGINT
- currency — VARCHAR(10)
- merchant_id — VARCHAR(255)
- merchant_name — VARCHAR(255)
- merchant_category_code — VARCHAR(255)
- payment_method — VARCHAR(20) — ONLINE, OFFLINE
- purpose — VARCHAR(20) — PERSONAL, BUSINESS
- status — VARCHAR(20) — AUTHORIZED, CAPTURED, CANCELLED, DECLINED
- authorization_code — VARCHAR(255)
- cancelled_amount — BIGINT
- cancel_reason — VARCHAR(255)
- ssafy_transaction_unique_no — VARCHAR(255)
- authorized_at — DATETIME
- captured_at — DATETIME
- cancelled_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_payment_user_id
- INDEX — idx_payment_card_id
- INDEX — idx_payment_status
- INDEX — idx_payment_user_status
tax_brackets
- id — BIGINT
- year — INT
- bracket_min — BIGINT
- bracket_max — BIGINT
- rate — DOUBLE
- progressive_deduction — BIGINT
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_tb_year
tax_deadlines
- id — BIGINT
- year — INT
- name — VARCHAR(255)
- description — VARCHAR(255)
- deadline_month — INT
- deadline_day — INT
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_tax_deadline_year
tax_limit
- id — BIGINT
- tax_category — VARCHAR(255)
- limit_type — VARCHAR(255)
- limit_amount — BIGINT
- unit — VARCHAR(255)
- legal_basis — VARCHAR(255)
- alert_message — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_tax_limit_category
- INDEX — idx_tax_limit_type
tax_parameters
- id — BIGINT
- year — INT
- category — VARCHAR(255)
- param_key — VARCHAR(255)
- param_value — VARCHAR(255)
- description — VARCHAR(255)
- legal_basis — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_tax_param_year_cat
tax_payments
- id — BIGINT
- tax_return_id — BIGINT — Foreign key → tax_returns.id — NOT NULL
- payment_type — VARCHAR(20) — NATIONAL, LOCAL
- amount — BIGINT
- virtual_account — VARCHAR(255)
- virtual_bank — VARCHAR(255)
- from_account — VARCHAR(255)
- transfer_id — VARCHAR(255)
- status — VARCHAR(20) — PENDING, PROCESSING, COMPLETED, FAILED
- error_message — VARCHAR(255)
- paid_at — DATETIME
- version — BIGINT
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_tax_payment_tax_return
tax_returns
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- tax_year — INT
- status — VARCHAR(20) — DRAFT, SUBMITTED, ACCEPTED, PAID, COMPLETED
- receipt_number — VARCHAR(255)
- submitted_at — DATETIME
- accepted_at — DATETIME
- taxpayer_name — VARCHAR(255)
- resident_number — VARCHAR(255)
- total_revenue — BIGINT
- total_expense — BIGINT
- income_amount — BIGINT
- total_deductions — BIGINT
- taxable_income — BIGINT
- tax_rate — DOUBLE
- calculated_tax — BIGINT
- determined_tax — BIGINT
- prepaid_tax — BIGINT
- final_tax — BIGINT
- local_tax — BIGINT
- deductions_json — TEXT
- version — BIGINT
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_tax_return_user_year
transfers
- id — BIGINT
- sender_user_id — BIGINT — Foreign key → users.id — NOT NULL
- receiver_user_id — BIGINT — Foreign key → users.id
- sender_card_id — BIGINT — Foreign key → cards.id — NOT NULL
- receiver_card_id — BIGINT — Foreign key → cards.id
- transfer_type — VARCHAR(20) — P2P, WITHDRAW
- amount — BIGINT
- status — VARCHAR(20) — COMPLETED, FAILED
- description — VARCHAR(255)
- target_account_no — VARCHAR(255)
- ssafy_transaction_unique_no — VARCHAR(255)
- failure_reason — VARCHAR(255)
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_transfer_sender_user
- INDEX — idx_transfer_receiver_user
user_consents
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- consent_type — VARCHAR(20) — NOT NULL — SERVICE, PRIVACY, FINANCIAL
- consented — BOOLEAN
- consented_at — DATETIME
- revoked_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_consent_user_id
users
- id — BIGINT
- ci — VARCHAR(255)
- di — VARCHAR(255)
- name — VARCHAR(255)
- birth_date — VARCHAR(255)
- gender — VARCHAR(255)
- phone_number — VARCHAR(255)
- phone_last4 — VARCHAR(4)
- pin_hash — VARCHAR(255)
- biometric_enabled — BOOLEAN
- device_id — VARCHAR(255)
- kyc_verified — BOOLEAN
- is_business — BOOLEAN
- status — VARCHAR(20) — ACTIVE, SUSPENDED, WITHDRAWN
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_user_phone_last4
vat_returns
- id — BIGINT
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- tax_year — INT
- tax_period — INT
- status — VARCHAR(20) — DRAFT, SUBMITTED, ACCEPTED, PAID, COMPLETED
- receipt_number — VARCHAR(255)
- sales_amount — BIGINT
- sales_tax — BIGINT
- purchase_amount — BIGINT
- purchase_tax — BIGINT
- preliminary_paid — BIGINT
- final_tax — BIGINT
- submitted_at — DATETIME
- version — BIGINT
- created_at — DATETIME
- updated_at — DATETIME
- INDEX — idx_vat_return_user_year