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