CashFlow
Tables (3)
account (account table)
- account_id (account id) — BIGINT — Primary key — NOT NULL
- account_number (account number) — VARCHAR
- balance (account balance) — INTEGER
- status (account status) — VARCHAR
- created_at (account created date) — DATETIME
- modified_at (account modified date) — DATETIME
- user_id (user id) — BIGINT — Foreign key → user.user_id — NOT NULL
remittance (remittance table)
- remittance_id (remittance id) — BIGINT — Primary key — NOT NULL
- receiving_account_number (receiving account number) — VARCHAR
- amount (remittance amount) — INTEGER
- account_balance_snapshot (account balance snapshot) — INTEGER
- created_at (remittance created date) — DATETIME
- account_id (account id) — BIGINT — Foreign key → account.account_id — NOT NULL
user (user table)
- user_id (user id) — BIGINT — Primary key — NOT NULL
- login_id (user id for login) — VARCHAR
- password (user password for login) — VARCHAR
- role (user role) — VARCHAR
- created_at (user created date) — DATETIME
- modified_at (user modified date) — DATETIME