mini_bank_ERD
Tables (3)
user
- uuid — varchar(36) — Primary key — NOT NULL
- id — varchar(100) — NOT NULL
- name — varchar(100) — NOT NULL
- password — varchar(100) — NOT NULL
- created_at — timestamp
- state — varchar(10)
user_account
- account — varchar(50) — Primary key — NOT NULL
- uuid — varchar(36) — Foreign key → user.uuid
- amount — int — NOT NULL
- created_at — timestamp
user_transaction_details
- account — varchar(50) — Primary key — NOT NULL
- uuid — varchar(36) — Foreign key → user_account.uuid
- sender — varchar(100) — NOT NULL
- recipient — varchar(100) — NOT NULL
- transaction_amount — int — NOT NULL
- remaining_amount — int — NOT NULL
- memo — varchar(200)
- date_transaction — timestamp