Technology

idBanking_TechnologyCapabilities
1ATMContactless Transaction
2ATMCard Swipe Only
3Point of Sale TerminalContactless Transaction
4Point of Sale TerminalCard Swipe Only
5Mobile AppPayment Processing
6Online BankingTransfer Funds

Customers

idFirstNameLastNameBirthDatePhoneNumberEmailAddress
1JohnDoe1980-01-01+1234567890john.doe@example.com
2JaneSmith1990-02-02+9876543210jane.smith@example.com
3AliceBrown1995-03-03+1111111111alice.brown@example.com
4CharlieBlack1985-04-04+2222222222charlie.black@example.com

Accounts

idCustomerIDBalanceOpenDate
(→ Customers.id)
111000.02020-01-01
22500.02021-02-02
333000.02019-03-03
442000.02022-04-04

ATMs

idTechnologyIdLocationCreatedAt
(→ Technology.id)
11Main Street2020-01-01T10:00:00
22Market Square2021-02-02T11:00:00
33Park Avenue2019-03-03T12:00:00
44River Side2022-04-04T13:00:00

POS_Terminals

idTechnologyIdStoreLocationCreatedAt
(→ Technology.id)
11Grocery Shop2020-01-01T14:00:00
22Electronics Store2021-02-02T15:00:00
33Clothing Boutique2019-03-03T16:00:00
44Bookstore2022-04-04T17:00:00