bank model documentation

bank

Tables 9	Columns 42		Triggers 0	Sequences 0
Tables 9	Relationships 9	Views 0	Procedures 0	Domains 0

Diagram

All Items

Tables

#	Caption	Name
1	Customers	CUSTOMERS
2	Customer_Types	CUSTOMER_TYPES
3	Accounts	ACCOUNTS
4	Account_Types	ACCOUNT_TYPES
5	Customer_Purchase	CUSTOMER_PURCHASE
6	Transactions	TRANSACTIONS
7	Transaction_Types	TRANSACTION_TYPES
8	Products_and_services	PRODUCTS_AND_SERVICES
9	Merchants	MERCHANTS

Tables : CUSTOMERS

Columns 9	Keys 1	Triggers 0	Comment: Description:
Indexes 0	Contraints 0

Columns :

Name	Caption	Primary Key	type
CUSTOMERS_ID	Customers_ID	true	INT(10)
CUSTOMERS_NAME	Customers_name		VARCHAR(40)
CUSTOMERS_PHONE	Customers_phone		INT(10)
CUSTOMERS_EMAIL	Customers_email		VARCHAR(40)
DATE_BECAME_CUSTOMER	date_became_customer		DATE
LOGIN	login		VARCHAR(40)
PASSWORD	password		VARCHAR(40)
OTHER_DETAILS	other_details		VARCHAR(40)
CUSTOMER_TYPES_CODE	Customer_Types_code		INT(10)

Keys :

Name	Primary Key	Description
KEY_1	true

Columns Detail :

Name	CUSTOMERS_ID
Table	CUSTOMERS
Type	INT(10)
Domain
Primary Key	true
Not null	true

Name	CUSTOMERS_NAME
Table	CUSTOMERS
Type	VARCHAR(40)
Domain

Name	CUSTOMERS_PHONE
Table	CUSTOMERS
Type	INT(10)
Domain

Name	CUSTOMERS_EMAIL
Table	CUSTOMERS
Type	VARCHAR(40)
Domain

Name	DATE_BECAME_CUSTOMER
Table	CUSTOMERS
Type	DATE
Domain

Name	LOGIN
Table	CUSTOMERS
Type	VARCHAR(40)
Domain

Name	PASSWORD
Table	CUSTOMERS
Type	VARCHAR(40)
Domain

Name	OTHER_DETAILS
Table	CUSTOMERS
Type	VARCHAR(40)
Domain

Name	CUSTOMER_TYPES_CODE
Table	CUSTOMERS
Type	INT(10)
Domain
Foreign key	true

Tables : CUSTOMER_TYPES

Columns 2	Keys 1	Triggers 0	Comment: Description:
Indexes 0	Contraints 0

Columns :

Name	Caption	Primary Key	type
CUSTOMER_TYPES_CODE	Customer_Types_code	true	VARCHAR(15)
CUSTOMER_TYPES_DESCRIPTION	Customer_Types_description		VARCHAR(40)

Keys :

Name	Primary Key	Description
KEY_2	true

Columns Detail :

Name	CUSTOMER_TYPES_CODE
Table	CUSTOMER_TYPES
Type	VARCHAR(15)
Domain
Primary Key	true
Not null	true

Name	CUSTOMER_TYPES_DESCRIPTION
Table	CUSTOMER_TYPES
Type	VARCHAR(40)
Domain

Tables : ACCOUNTS

Columns 6	Keys 1	Triggers 0	Comment: Description:
Indexes 0	Contraints 0

Columns :

Name	Caption	Primary Key	type
ACCOUNT_ID	Account_ID	true	INT(10)
ACCOUNTS_NAME	Accounts_name		VARCHAR(40)
DATE_OPENED	date_opened		DATE
OTHER_ACCOUNT_DETAILS	other_account_details		VARCHAR(40)
ACCOUNT_TYPES_CODE	Account_Types_code		INT(10)
CUSTOMERS_ID	Customers_ID		INT(10)

Keys :

Name	Primary Key	Description
KEY_3	true

Columns Detail :

Name	ACCOUNT_ID
Table	ACCOUNTS
Type	INT(10)
Domain
Primary Key	true
Not null	true

Name	ACCOUNTS_NAME
Table	ACCOUNTS
Type	VARCHAR(40)
Domain

Name	DATE_OPENED
Table	ACCOUNTS
Type	DATE
Domain

Name	OTHER_ACCOUNT_DETAILS
Table	ACCOUNTS
Type	VARCHAR(40)
Domain

Name	ACCOUNT_TYPES_CODE
Table	ACCOUNTS
Type	INT(10)
Domain
Foreign key	true

Name	CUSTOMERS_ID
Table	ACCOUNTS
Type	INT(10)
Domain
Foreign key	true

Tables : ACCOUNT_TYPES

Columns 2	Keys 1	Triggers 0	Comment: Description:
Indexes 0	Contraints 0

Columns :

Name	Caption	Primary Key	type
ACCOUNT_TYPES_CODE	Account_Types_code	true	VARCHAR(15)
ACCOUNT_TYPES_DESCRIPTION	Account_Types_description		VARCHAR(40)

Keys :

Name	Primary Key	Description
KEY_4	true

Columns Detail :

Name	ACCOUNT_TYPES_CODE
Table	ACCOUNT_TYPES
Type	VARCHAR(15)
Domain
Primary Key	true
Not null	true

Name	ACCOUNT_TYPES_DESCRIPTION
Table	ACCOUNT_TYPES
Type	VARCHAR(40)
Domain

Tables : CUSTOMER_PURCHASE

Columns 6	Keys 1	Triggers 0	Comment: Description:
Indexes 0	Contraints 0

Columns :

Name	Caption	Primary Key	type
PURCHASE_ID	Purchase_ID	true	INT(10)
DATE	Date		DATE
QUANTITY	Quantity		FLOAT(8,1)
OTHER_DETAILS	Other_details		VARCHAR(40)
CUSTOMERS_ID	Customers_ID		INT(10)
PRODUCT_AND_SERVICES_CODE	Product_and_services_code		VARCHAR(15)

Keys :

Name	Primary Key	Description
KEY_6	true

Columns Detail :

Name	PURCHASE_ID
Table	CUSTOMER_PURCHASE
Type	INT(10)
Domain
Primary Key	true
Not null	true

Name	DATE
Table	CUSTOMER_PURCHASE
Type	DATE
Domain

Name	QUANTITY
Table	CUSTOMER_PURCHASE
Type	FLOAT(8,1)
Domain

Name	OTHER_DETAILS
Table	CUSTOMER_PURCHASE
Type	VARCHAR(40)
Domain

Name	CUSTOMERS_ID
Table	CUSTOMER_PURCHASE
Type	INT(10)
Domain
Foreign key	true

Name	PRODUCT_AND_SERVICES_CODE
Table	CUSTOMER_PURCHASE
Type	VARCHAR(15)
Domain
Foreign key	true

Tables : TRANSACTIONS

Columns 7	Keys 1	Triggers 0	Comment: Description:
Indexes 0	Contraints 0

Columns :

Name	Caption	Primary Key	type
TRANSACTION_ID	Transaction_ID	true	INT(10)
DATE	date		DATE
AMOUNT_OF_TRANSACTION	amount_of_transaction		FLOAT(8,1)
OTHER_DETAILS	other_details		VARCHAR(40)
PURCHASE_ID	Purchase_ID		INT(10)
ACCOUNT_ID	Account_ID		INT(10)
TRANSACTION_TYPES_CODE	Transaction_Types_code		VARCHAR(15)

Keys :

Name	Primary Key	Description
KEY_7	true

Columns Detail :

Name	TRANSACTION_ID
Table	TRANSACTIONS
Type	INT(10)
Domain
Primary Key	true
Not null	true

Name	DATE
Table	TRANSACTIONS
Type	DATE
Domain

Name	AMOUNT_OF_TRANSACTION
Table	TRANSACTIONS
Type	FLOAT(8,1)
Domain

Name	OTHER_DETAILS
Table	TRANSACTIONS
Type	VARCHAR(40)
Domain

Name	PURCHASE_ID
Table	TRANSACTIONS
Type	INT(10)
Domain
Foreign key	true

Tables : TRANSACTION_TYPES

Columns 2	Keys 1	Triggers 0	Comment: Description:
Indexes 0	Contraints 0

Columns :

Name	Caption	Primary Key	type
TRANSACTION_TYPES_CODE	Transaction_Types_code	true	VARCHAR(15)
TRANSACTION_TYPES_DESCRIPTION	Transaction_Types_description		VARCHAR(40)

Keys :

Columns Detail :

Tables : PRODUCTS_AND_SERVICES

Columns 3	Keys 1	Triggers 0	Comment: Description:
Indexes 0	Contraints 0

Columns :

Name	Caption	Primary Key	type
PRODUCT_AND_SERVICES_CODE	Product_and_services_code	true	VARCHAR(15)
PRODUCTS_AND_SERVICES_DESCRIPTION	Products_and_services_description		VARCHAR(40)
MERCHANT_ID	Merchant_ID		INT(10)

Keys :

Columns Detail :

Tables : MERCHANTS

Columns 5	Keys 1	Triggers 0	Comment: Description:
Indexes 0	Contraints 0

Columns :

Name	Caption	Primary Key	type
MERCHANT_ID	Merchant_ID	true	INT(10)
MERCHANT_NAME	Merchant_name		VARCHAR(40)
MERCHANTS_PHONE	Merchants_phone		INT(10)
MERCHANTS_EMAIL	Merchants_email		VARCHAR(40)
OTHER_DETAILS	other_details		VARCHAR(40)

Keys :

Columns Detail :

Columns

Name	Caption	Primary Key	Type
CUSTOMERS_ID	Customers_ID	true	INT(10)
CUSTOMERS_NAME	Customers_name		VARCHAR(40)
CUSTOMERS_PHONE	Customers_phone		INT(10)
CUSTOMERS_EMAIL	Customers_email		VARCHAR(40)
DATE_BECAME_CUSTOMER	date_became_customer		DATE
LOGIN	login		VARCHAR(40)
PASSWORD	password		VARCHAR(40)
OTHER_DETAILS	other_details		VARCHAR(40)
CUSTOMER_TYPES_CODE	Customer_Types_code		INT(10)
CUSTOMER_TYPES_CODE	Customer_Types_code	true	VARCHAR(15)
CUSTOMER_TYPES_DESCRIPTION	Customer_Types_description		VARCHAR(40)
ACCOUNT_ID	Account_ID	true	INT(10)
ACCOUNTS_NAME	Accounts_name		VARCHAR(40)
DATE_OPENED	date_opened		DATE
OTHER_ACCOUNT_DETAILS	other_account_details		VARCHAR(40)
ACCOUNT_TYPES_CODE	Account_Types_code		INT(10)
CUSTOMERS_ID	Customers_ID		INT(10)
ACCOUNT_TYPES_CODE	Account_Types_code	true	VARCHAR(15)
ACCOUNT_TYPES_DESCRIPTION	Account_Types_description		VARCHAR(40)
PURCHASE_ID	Purchase_ID	true	INT(10)
DATE	Date		DATE
QUANTITY	Quantity		FLOAT(8,1)
OTHER_DETAILS	Other_details		VARCHAR(40)
CUSTOMERS_ID	Customers_ID		INT(10)
PRODUCT_AND_SERVICES_CODE	Product_and_services_code		VARCHAR(15)
TRANSACTION_ID	Transaction_ID	true	INT(10)
DATE	date		DATE
AMOUNT_OF_TRANSACTION	amount_of_transaction		FLOAT(8,1)
OTHER_DETAILS	other_details		VARCHAR(40)
PURCHASE_ID	Purchase_ID		INT(10)
ACCOUNT_ID	Account_ID		INT(10)
TRANSACTION_TYPES_CODE	Transaction_Types_code		VARCHAR(15)
TRANSACTION_TYPES_CODE	Transaction_Types_code	true	VARCHAR(15)
TRANSACTION_TYPES_DESCRIPTION	Transaction_Types_description		VARCHAR(40)
PRODUCT_AND_SERVICES_CODE	Product_and_services_code	true	VARCHAR(15)
PRODUCTS_AND_SERVICES_DESCRIPTION	Products_and_services_description		VARCHAR(40)
MERCHANT_ID	Merchant_ID		INT(10)
MERCHANT_ID	Merchant_ID	true	INT(10)
MERCHANT_NAME	Merchant_name		VARCHAR(40)
MERCHANTS_PHONE	Merchants_phone		INT(10)
MERCHANTS_EMAIL	Merchants_email		VARCHAR(40)
OTHER_DETAILS	other_details		VARCHAR(40)

Relationships

Name	Parent table	Child table	Parent table column	Child table column
REFERENCE_4	CUSTOMERS	CUSTOMER_PURCHASE	CUSTOMERS_ID	CUSTOMERS_ID
REFERENCE_5	CUSTOMER_PURCHASE	TRANSACTIONS	PURCHASE_ID	PURCHASE_ID
REFERENCE_6	ACCOUNTS	TRANSACTIONS	ACCOUNT_ID	ACCOUNT_ID
REFERENCE_7	TRANSACTION_TYPES	TRANSACTIONS	TRANSACTION_TYPES_CODE	TRANSACTION_TYPES_CODE
REFERENCE_8	PRODUCTS_AND_SERVICES	CUSTOMER_PURCHASE	PRODUCT_AND_SERVICES_CODE	PRODUCT_AND_SERVICES_CODE
REFERENCE_9	MERCHANTS	PRODUCTS_AND_SERVICES	MERCHANT_ID	MERCHANT_ID
REFERENCE_1	CUSTOMER_TYPES	CUSTOMERS	CUSTOMER_TYPES_CODE	CUSTOMER_TYPES_CODE
REFERENCE_2	ACCOUNT_TYPES	ACCOUNTS	ACCOUNT_TYPES_CODE	ACCOUNT_TYPES_CODE
REFERENCE_3	CUSTOMERS	ACCOUNTS	CUSTOMERS_ID	CUSTOMERS_ID

General

bank

Tables

9

Columns

42

Triggers

0

Sequences

0

Relationships

9

Views

0

Procedures

0

Domains

0

Diagram

All Items

Tables

Tables : CUSTOMERS

Columns

9

Keys

1

Triggers

0

Comment:

Description:

Indexes

0

Contraints

0

Columns :

Keys :

Columns Detail :

Tables : CUSTOMER_TYPES

Columns

2

Keys

1

Triggers

0

Comment:

Description:

Indexes

0

Contraints

0

Columns :

Keys :

Columns Detail :

Tables : ACCOUNTS

Columns

6

Keys

1

Triggers

0

Comment:

Description:

Indexes

0

Contraints

0

Columns :

Keys :

Columns Detail :

Tables : ACCOUNT_TYPES

Columns

2

Keys

1

Triggers

0

Comment:

Description:

Indexes

0