RdsDiagram
Customer
customer_id: INTEGER
first_name: VARCHAR(45)
last_name: VARCHAR(45)
mobile_no: BIGINT
email_id: VARCHAR(45)
dob: DATE
status: BOOLEAN
Address
address_type: VARCHAR(45)
house_no: INTEGER
street_name: VARCHAR(45)
city: VARCHAR(45)
state: VARCHAR(45)
pin: INTEGER
customer_id: INTEGER
Identity_proof
identity_id: INTEGER
identity_type: VARCHAR(45)
identity_no: INTEGER
customer_id: INTEGER
SavingsAccountUser
account_id: INTEGER
date_of_opening: DATE
date_of_closing: DATE
account_status: BOOLEAN
account_balance: FLOAT(20)
type: VARCHAR(20)
reason: VARCHAR(45)
customer_id: INTEGER
joint_users
jointaccountid: INTEGER
account_id: INTEGER
transactions
transaction_id: INTEGER
type: INTEGER
transaction_amount: INTEGER
transaction_date: DATE
transaction_status: VARCHAR(45)
transaction_description: VARCHAR(45)
account_id: INTEGER