Please enable JavaScript.
Coggle requires JavaScript to display documents.
Banking Customer 360 - Coggle Diagram
Banking Customer 360
Customer
Customer ID (PK)
Personal ID
Date of Birth
Name
Gender
Address
City
Nationality
Marital
Income
Occupation
Company Name
Company Address
Email
Phone Number
Transaction
Timestamp
Transaction ID (FK)
Product ID (FK)
Transaction Type
Location
Currency
Amount
Status
CIF ID
Transaction Method
Bank
Bank ID (PK)
Bank Name
Bank Address
Bank Region
Latitude
Longtitude
Status
CIF
Customer ID (FK)
Bank ID (FK)
CIF ID (PK)
Banker ID
Customer Type
Date of Opening
Status
Loan
Loan ID (PK)
Product ID (FK)
Loan Amount
Bank ID (FK)
Banker ID
Type of Loan
Expired Date
Status
Default
Started Date
CIF ID
Card
Card ID (PK)
Product ID (FK)
Card Type
Expired Date
Limit
Open Date
Status
CIF ID
Bank ID
Banker ID
Casa
Casa ID (PK,FK)
Product ID (FK)
Type
Date of Opening
Status
Limit
CIF ID (FK)
Interest Rate
Amount
Bank ID
Banker ID
Expired Date
Deposit
Deposit ID (PK,FK)
Timestamp
Product ID (FK)
Amount
Type
Start Date
CIF ID
Status
Interest Rate
Expired Date
Deposit Method
Bank ID
Banker ID
Banker
Banker ID
Bank ID
Banker Name
Banker Role
Department
Manager ID
Manager Name
Status
Product
Product ID
Product Name
Product Type
Product Open Date
Status