ID | Name | Address | PhoneNumber | Services_Offered | ManagerName |
---|---|---|---|---|---|
1 | First Branch | 123 Main St | 555-1234 | Balance | John Doe |
2 | Second Branch | 456 Elm St | 555-5678 | Checking & Savings | Jane Smith |
ID | Name | Website | CustomerSupportPhoneNumber | Services_Offered | SecurityMeasures |
---|---|---|---|---|---|
1 | MyBank | https://www.mybank.com | 555-9999 | Balance | Two-factor authentication, Encrypted communication channels |
2 | AnotherBank | https://www.anotherbank.com | 555-8888 | Checking & Savings | Biometric access control, Secure API |
ID | FirstName | LastName | DateOfBirth | PhoneNumber | AccountID | |
---|---|---|---|---|---|---|
(→ Accounts.ID) | ||||||
1 | Alice | Wonderland | 1990-01-01 | alice@example.com | 555-1111 | 1 |
2 | Bob | Builder | 1985-02-02 | bob@example.com | 555-2222 | 2 |
3 | Charlie | Chaplin | 1992-03-03 | charlie@example.com | 555-3333 | 3 |
4 | David | Davis | 1988-04-04 | david@example.com | 555-4444 | 4 |
5 | Eve | Evans | 1991-05-05 | eve@example.com | 555-5555 | 5 |
TransactionID | Amount | Type | Timestamp | AccountID | CustomerID |
---|---|---|---|---|---|
(→ Accounts.ID) | (→ Customers.ID) | ||||
1 | 1000 | Deposit | 2021-01-01 10:00:00 | 1 | 1 |
2 | -500 | Withdrawal | 2021-01-01 11:00:00 | 2 | 2 |
3 | 200 | Transfer | 2021-01-02 12:00:00 | 3 | 3 |
4 | -150 | Payment | 2021-01-03 13:00:00 | 4 | 4 |
5 | 1200 | Deposit | 2021-01-04 14:00:00 | 5 | 5 |
ID | AccountNumber | Balance | InterestRate | OpenDate | CurrentBranchID | IsActive |
---|---|---|---|---|---|---|
(→ Branch.ID) | ||||||
1 | 12345678 | 10000 | 0.5 | 2021-01-01 10:00:00 | 1 | 1 |
2 | 98765432 | 5000 | 0.4 | 2021-01-02 11:00:00 | 2 | 1 |
3 | 54321098 | 8000 | 0.6 | 2021-01-03 12:00:00 | 1 | 0 |
4 | 65432109 | 2000 | 0.3 | 2021-01-04 13:00:00 | 2 | 1 |
5 | 12345678 | 3000 | 0.2 | 2021-01-05 14:00:00 | 1 | 1 |