django

Tables (3)

Accounts (accounts)

  • 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(20)
  • Account Type (account_type) — VARCHAR(20)
  • Balance (balance) — DECIMAL(18, 2)
  • Create At (created_at) — TIMESTAMP
  • Update At (updated_at) — TIMESTAMP

Transaction_history (transaction_history)

  • Transaction id (transaction_id) — UUID — Primary key — NOT NULL
  • Account id (account_id) — UUID — Foreign key → Accounts.Account id — NOT NULL
  • Amount (amount) — DECIMAL(15, 2)
  • Balance After (balance_after) — DECIMAL(15, 2)
  • Description (description) — VARCHAR(255)
  • Transaction Direction (transaction_direction) — VARCHAR(20)
  • Transaction Type (transaction_type) — VARCHAR(30)
  • Transaction At (transaction_at) — TIMESTAMP

User (user)

  • User Id (user_id) — UUID — Primary key — NOT NULL
  • Email (email) — VARCHAR(255)
  • Password (password) — VARCHAR(255)
  • Nickname (nickname) — VARCHAR(50)
  • Name (name) — VARCHAR(50)
  • Phone Number (phone_number) — VARCHAR(20)
  • Last Login (last_login) — TIMESTAMP
  • Is Superuser (is_superuser) — BOOLEAN
  • Is Staff (is_staff) — BOOLEAN
  • Is Admin (is_admin) — BOOLEAN
  • Is Active (is_active) — BOOLEAN
  • Create At (created_at) — TIMESTAMP
  • Update At (updated_at) — TIMESTAMP