ID | Name |
---|---|
1 | Contactless Transaction |
2 | Withdrawal Only |
ID | Name | Address | POSID |
---|---|---|---|
(→ Point_of_Sale_Terminals.ID) | |||
1 | ATM1 | Main Street | 1 |
2 | ATM2 | Highway 10 | None |
ID | Name | Address | AtmID | CapabilityID |
---|---|---|---|---|
(→ ATMs.ID) | (→ Capabilities.ID) | |||
1 | POS1 | Shopping Mall | 3 | 1 |
2 | POS2 | Grocery Store | None | 2 |
ID | FirstName | LastName | DOB | AccountNumber |
---|---|---|---|---|
(→ Accounts.Number) | ||||
1 | John | Doe | 1980-01-01 | 1001 |
2 | Jane | Smith | 1975-06-15 | 1002 |
3 | Alice | Brown | 1990-07-22 | 1003 |
Number | Balance | Type | CustomerID |
---|---|---|---|
(→ Customers.ID) | |||
1001 | 1000 | Checking | 1 |
1002 | 500 | Savings | 2 |
1003 | 2000 | Checking | 3 |
ID | Amount | Date | Description | FromID | ToID |
---|---|---|---|---|---|
(→ Accounts.Number) | (→ Accounts.Number) | ||||
1 | 500 | 2021-01-01 | Payment | 1001 | 1002 |
2 | -200 | 2021-01-02 | Withdrawal | 1001 | 1001 |
3 | 250 | 2021-01-03 | Transfer | 1002 | 1003 |