erd
Tables (3)
Accounts (account)
- 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(10)
- Account Type (account_type) — VARCHAR(20)
- Balance (balance) — DECIMAL(18,2)
Transaction Histroy (transaction history)
- Account id (account_id2) — UUID — Foreign key → Accounts.Account id — NOT NULL
- Trasaction id (trasaction_id2) — UUID — Foreign key — NOT NULL
- transaction method (transaction_method) — DECIMAL(18,2)
- amount — VARCHAR(50)
- Balance (balance) — DECIMAL(18,2)
- Description (description) — VARCHAR(50)
- Created at (created_at) — VARCHAR(20)
- Updated (updated) — VARCHAR(50)
USER (user)
- User id (user_id) — UUID — Primary key — NOT NULL
- Name (name) — VARCHAR(50)
- Nickname (nickname) — VARCHAR(50)
- Email (email) — VARCHAR(200)
- Phone (phone) — VARCHAR(20)
- IS ACTIVE (is_active) — BOOLEAN
- Is staff (is_staff) — BOOLEAN
- Created at (created_at) — TIMESTAMP
- Update at (update_at) — BOOLEAN