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