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