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