biz ai demo

Tables (17)

accounts

  • id — INTEGER — Primary key — NOT NULL
  • account_no — VARCHAR
  • account_name — VARCHAR
  • bank_code — VARCHAR
  • bank_name — VARCHAR
  • account_type — VARCHAR
  • currency — VARCHAR
  • opened_date — DATE
  • is_active — BOOLEAN
  • created_at — TIMESTAMP

anomaly_rule_category_codes

  • code — VARCHAR — Primary key — NOT NULL
  • code_text — VARCHAR — NOT NULL

anomaly_rules

  • rule_id — INTEGER — Primary key — NOT NULL
  • rule_name — VARCHAR — NOT NULL
  • rule_description — VARCHAR
  • condition_hint — VARCHAR
  • category — VARCHAR — Foreign key → anomaly_rule_category_codes.code

bank_response_codes

  • code — VARCHAR — Primary key — NOT NULL
  • code_text — VARCHAR — NOT NULL

banks

  • bank_code — VARCHAR — Primary key — NOT NULL
  • bank_name — VARCHAR
  • country_code — VARCHAR
  • swift_code — VARCHAR

companies

  • company_code — VARCHAR — Primary key — NOT NULL
  • company_name — VARCHAR
  • country_code — VARCHAR
  • currency_code — VARCHAR
  • created_at — TIMESTAMP

company_accounts

  • account_id — INTEGER — Primary key — NOT NULL
  • company_code — VARCHAR — Foreign key → companies.company_code
  • bank_code — VARCHAR — Foreign key → banks.bank_code
  • account_no — VARCHAR
  • account_name — VARCHAR
  • currency_code — VARCHAR — Foreign key → currencies.currency_code
  • is_active — BOOLEAN

currencies

  • currency_code — VARCHAR — Primary key — NOT NULL
  • currency_name — VARCHAR
  • decimal_places — INTEGER

payment_details

  • payment_id — BIGINT — Foreign key → payments.payment_id — NOT NULL
  • beneficiary_name — VARCHAR
  • beneficiary_bank_code — VARCHAR — Foreign key → banks.bank_code
  • beneficiary_account — VARCHAR
  • reason_code — VARCHAR — Foreign key → payment_reason_codes.code
  • memo — VARCHAR

payment_reason_codes

  • code — VARCHAR — Primary key — NOT NULL
  • code_text — VARCHAR — NOT NULL

payment_result_codes

  • code — VARCHAR — Primary key — NOT NULL
  • code_text — VARCHAR — NOT NULL

payment_status_codes

  • code — VARCHAR — Primary key — NOT NULL
  • code_text — VARCHAR — NOT NULL

payment_type_codes

  • code — VARCHAR — Primary key — NOT NULL
  • code_text — VARCHAR — NOT NULL

payments

  • payment_id — BIGINT — Primary key — NOT NULL
  • company_code — VARCHAR — Foreign key → companies.company_code
  • account_id — INTEGER — Foreign key → company_accounts.account_id
  • payment_date — DATE
  • due_date — DATE
  • payment_type — VARCHAR — Foreign key → payment_type_codes.code
  • status — VARCHAR — Foreign key → payment_status_codes.code
  • payment_result — VARCHAR — Foreign key → payment_result_codes.code
  • bank_response_code — VARCHAR — Foreign key → bank_response_codes.code
  • amount — NUMERIC(18,2)
  • currency_code — VARCHAR — Foreign key → currencies.currency_code
  • created_at — TIMESTAMP

transaction_category_codes

  • code — VARCHAR — Primary key — NOT NULL
  • code_text — VARCHAR — NOT NULL

transaction_type_codes

  • code — VARCHAR — Primary key — NOT NULL
  • code_text — VARCHAR — NOT NULL

transactions

  • id — BIGINT — Primary key — NOT NULL
  • account_id — INTEGER — Foreign key → accounts.id
  • transaction_date — DATE
  • transaction_time — TIME
  • transaction_type — VARCHAR — Foreign key → transaction_type_codes.code
  • category — VARCHAR — Foreign key → transaction_category_codes.code
  • amount — NUMERIC(18,2)
  • balance_after — NUMERIC(18,2)
  • counterparty_name — VARCHAR
  • counterparty_account — VARCHAR
  • description — VARCHAR
  • created_at — TIMESTAMP