erd

Tables (3)

Accounts (account)

  • Account id (account_id) — UUID — Primary key — NOT NULL
  • User id (user_id) — UUID — Foreign key → USER.User id — NOT NULL
  • Account Number (account_number) — VARCHAR(20)
  • Bank Code (bank_code) — VARCHAR(10)
  • Account Type (account_type) — VARCHAR(20)
  • Balance (balance) — DECIMAL(18,2)

Transaction Histroy (transaction history)

  • Account id (account_id2) — UUID — Foreign key → Accounts.Account id — NOT NULL
  • Trasaction id (trasaction_id2) — UUID — Foreign key — NOT NULL
  • transaction method (transaction_method) — DECIMAL(18,2)
  • amount — VARCHAR(50)
  • Balance (balance) — DECIMAL(18,2)
  • Description (description) — VARCHAR(50)
  • Created at (created_at) — VARCHAR(20)
  • Updated (updated) — VARCHAR(50)

USER (user)

  • User id (user_id) — UUID — Primary key — NOT NULL
  • Name (name) — VARCHAR(50)
  • Nickname (nickname) — VARCHAR(50)
  • Email (email) — VARCHAR(200)
  • Phone (phone) — VARCHAR(20)
  • IS ACTIVE (is_active) — BOOLEAN
  • Is staff (is_staff) — BOOLEAN
  • Created at (created_at) — TIMESTAMP
  • Update at (update_at) — BOOLEAN