20231022
Tables (3)
Account
- serial_no — int — Primary key — NOT NULL
- customer_id — int — Foreign key → Customer.customer_id — NOT NULL
- account_type (type) — char(1) — NOT NULL
- balance — decimal(15) — NOT NULL
Customer
- customer_id — int — Primary key — NOT NULL
- name — varchar(20) — NOT NULL
Transaction_history
- serial_no — int — Primary key — NOT NULL
- deposit_serial_no — int — Foreign key → Account.serial_no
- deposit_customer_id — int — Foreign key → Account.customer_id
- withdrawal _serial_no — int — Foreign key → Account.serial_no
- withdrawal _customer_id (withdrawal _ustomer_id) — int — Foreign key → Account.customer_id
- transaction_type — char(1) — NOT NULL
- transaction_datetime — datetime — NOT NULL
- transaction_amount (Field) — decimal(15) — NOT NULL