|
Проектирование БД для банка
#38983565
Ссылка:
Ссылка на сообщение:
Ссылка с названием темы:
|
|
|
|
Arm79у ФЛ и ЮЛ общая таблица-предок
Спс.
Как Вам такое
1.
2.
3.
4.
5.
6.
7.
8.
9.
10.
11.
12.
13.
14.
15.
16.
17.
18.
19.
20.
21.
22.
23.
# The internal structure of the bank
# List of All possible Accounts (current, credit, etc...)
CREATE TABLE AccountTypes(Id bigint AUTO_INCREMENT, AccountTypeName varchar(50) NOT NULL, basePercentage decimal NOT NULL, currency int NOT NULL, PRIMARY KEY(Id));
# AccountManagement
# List of Accounts. There will bee added field
CREATE TABLE Account(Id bigint AUTO_INCREMENT, AccountNumber bigint NOT NULL, AccountTypesId bigint NOT NULL,
PRIMARY KEY(Id), FOREIGN KEY(AccountTypesId) REFERENCES AccountTypes(Id));
# Clients
# Clients basic information
CREATE TABLE AccountOwner(Id bigint AUTO_INCREMENT, ClientId bigint NOT NULL, PRIMARY KEY(Id));
CREATE TABLE ClientPersons(Id bigint AUTO_INCREMENT, AccountOwnerId BigInt, firstName varchar(20) NOT NULL, lastName varchar(20) NOT NULL, phone varchar(20), address varchar(50),
PRIMARY KEY(Id), FOREIGN KEY(AccountOwnerId) REFERENCES AccountOwner(Id));
# Company basic information
CREATE TABLE ClientCompany(Id bigint AUTO_INCREMENT, AccountOwnerId BigInt, CompanyName varchar(50) NOT NULL, phone varchar(20) NOT NULL, address varchar(50),
PRIMARY KEY(Id), FOREIGN KEY(AccountOwnerId) REFERENCES AccountOwner(id));
# Each Account Owner could have several accounts
CREATE TABLE AccountRelatedToOwner(Id bigint AUTO_INCREMENT, AccountId bigint NOT NULL, AccountOwnerId bigint,
PRIMARY KEY(Id), FOREIGN KEY(AccountId) REFERENCES Account(Id), FOREIGN KEY(AccountOwnerId) REFERENCES AccountOwner(Id));
|
|
|
