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