20250430_2

Tables (5)

Account

  • acc_id — INT — Primary key
  • acc_type — VARCHAR(20)
  • balance — DECIMAL(15,2)
  • opened_date — DATE
  • cust_id — INT — Foreign key → Customer.cust_id

Branch

  • branch_id — INT — Primary key
  • branch_name — VARCHAR(100)
  • location — VARCHAR(100)

Customer

  • cust_id — INT — Primary key
  • cust_name — VARCHAR(100)
  • phone — VARCHAR(20)
  • address — VARCHAR(200)
  • branch_id — INT — Foreign key → Branch.branch_id

Employee

  • emp_id — INT — Primary key
  • emp_name — VARCHAR(100)
  • position — VARCHAR(50)
  • branch_id — INT — Foreign key → Branch.branch_id

Transaction

  • trans_id — INT — Primary key
  • trans_type — VARCHAR(10)
  • amount — DECIMAL(15,2)
  • trans_date — DATE
  • acc_id — INT — Foreign key → Account.acc_id
  • emp_id — INT — Foreign key → Employee.emp_id