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