mini_bank_ERD

Tables (3)

user

  • uuid — varchar(36) — Primary key — NOT NULL
  • id — varchar(100) — NOT NULL
  • name — varchar(100) — NOT NULL
  • password — varchar(100) — NOT NULL
  • created_at — timestamp
  • state — varchar(10)

user_account

  • account — varchar(50) — Primary key — NOT NULL
  • uuid — varchar(36) — Foreign key → user.uuid
  • amount — int — NOT NULL
  • created_at — timestamp

user_transaction_details

  • account — varchar(50) — Primary key — NOT NULL
  • uuid — varchar(36) — Foreign key → user_account.uuid
  • sender — varchar(100) — NOT NULL
  • recipient — varchar(100) — NOT NULL
  • transaction_amount — int — NOT NULL
  • remaining_amount — int — NOT NULL
  • memo — varchar(200)
  • date_transaction — timestamp