mini_project_team_2

Tables (3)

Accounts (Untitled2)

  • account_id (PK) — INT — Primary key — NOT NULL
  • user_id (FK) — INT — Foreign key → Users.user_id — NOT NULL
  • account_number (Field3) — VARCHAR
  • bank_code (Field4) — VARCHAR
  • account_type (Field5) — VARCHAR
  • balance (Field6) — DECIMAL

Transaction_History (Untitled3)

  • transaction_id (PK) — INT — Primary key — NOT NULL
  • account_id (FK) — INT — Foreign key → Accounts.account_id — NOT NULL
  • transaction_amount (Field3) — DECIMAL
  • post_transaction_balance (Field4) — DECIMAL
  • transaction_description (Field5) — VARCHAR
  • transaction_type (Field6) — VARCHAR
  • payment_method (Field7) — VARCHAR
  • transaction_datetime (Field8) — DATETIME

Users (Untitled)

  • user_id (PK) — INT — Primary key — NOT NULL
  • email (Field2) — VARCHAR
  • password (Field3) — VARCHAR
  • nickname (Field4) — VARCHAR
  • phone_number (Field5) — VARCHAR
  • last_login (Field6) — DATETIME
  • is_staff (Field7) — BOOLEAN
  • is_admin (Field8) — BOOLEAN
  • is_active (Field9) — BOOLEAN