Internet Banking Data Model

On this page…

An interactive fragment of the Internet Banking System data model

  • Move cursor on the element or relationship to see its description

  • Click on the table element to navigate to its documentation page

The table contains an automatically generated list of displayed database tables including fields

  • The table columns to be displayed can be configured

  • The amount of information about each attribute can be specified

 

Name

Description

Attributes

Name

Description

Attributes

Customers

Stores entities of Customer

Customer Id:integer
Notes: Unique customer number

First Name:varchar
Notes: First name

Last Name:varchar
Notes: Last name

Accounts

Stores entities of Account

Account Number:varchar
Notes: Account number (local format)

Currency:char
Notes: 3-digit currency code

Transactions

Stores entities of Transaction

Amount:money
Notes: Amount in the account currency

Other Account:varchar
Notes: Account the money goes to or comes from. IBAN format.