Djngo

Tables (3)

Accounts (Untitled2)

  • ID (id) — UUID — Primary key — NOT NULL
  • User_id (user_id) — ForeignKey(UUID) — Foreign key → Users.User_id — NOT NULL
  • Account_number (account_number) — VARCHAR(20)
  • Bank_code (bank_code) — VARCHAR(10)
  • Account_type (account_type) — VARCHAR(50)
  • Balance (balance) — Decimal

Transaction_History (Untitled3)

  • ID (id) — UUID — Primary key — NOT NULL
  • Account_id (account_id) — ForeignKey(UUID) — Foreign key → Accounts.ID — NOT NULL
  • Transaction_amount (transaction_amount) — Decimal
  • Transaction_Timestamp (transaction_tiemstamp) — DateTimeField
  • Transaction_type (transaction_type) — VARCHAR(50)
  • Balance_after (balance_after) — Decimal
  • Transaction_detail (transaction_detail) — VARCHAR(50)
  • Transaction_method (transaction_method) — VARCHAR(50)

Users (Untitled)

  • User_id (user_id) — UUID — Primary key — NOT NULL
  • Email (email) — VARCHAR(50)
  • Password (passowrd) — VARCHAR(50)
  • Nickname (nickname) — VARCHAR(50)
  • Name (name) — VARCHAR(50)
  • Phone_number (phone_number) — VARCHAR(50)
  • Is_staff (is_staff) — BOOLEAN
  • Is_admin (is_admin) — BOOLEAN
  • Is_active (is_active) — BOOLEAN