CREATE TABLE DepositTypes
(
DepositTypeID INT IDENTITY PRIMARY KEY,
Name VARCHAR(20)
)

CREATE TABLE Deposits
(
DepositID INT IDENTITY PRIMARY KEY,
Amount DECIMAL(10,2),
StartDate DATE,
EndDate DATE,
DepositTypeID INT,
CustomerID INT,
CONSTRAINT FK_Deposits_DepositTypes FOREIGN KEY (DepositTypeID) REFERENCES DepositTypes (DepositTypeID),
CONSTRAINT FK_Deposits_Customers FOREIGN KEY (CustomerID) REFERENCES Customers (CustomerID)
)



CREATE TABLE EmployeesDeposits
(
EmployeeID INT,
DepositID INT,
CONSTRAINT PK_EmployeesDeposits PRIMARY KEY (EmployeeID, DepositID),
CONSTRAINT FK_EmployeesDeposits_Employees FOREIGN KEY (EmployeeID) REFERENCES Employees (EmployeeID),
CONSTRAINT FK_EmployeesDeposits_Deposits FOREIGN KEY (DepositID) REFERENCES Deposits (DepositID)
)

CREATE TABLE CreditHistory
(
CreditHistoryID INT IDENTITY PRIMARY KEY,
Mark VARCHAR,
StartDate DATE,
EndDate DATE,
CustomerID INT,
CONSTRAINT FK_CreditHistory_Customers FOREIGN KEY (CustomerID) REFERENCES Customers (CustomerID)
)

CREATE TABLE Payments
(
PayementID INT IDENTITY PRIMARY KEY,
Date DATE,
Amount DECIMAL(10,2),
LoanID INT,
CONSTRAINT FK_Payments_Loans FOREIGN KEY (LoanID) REFERENCES Loans (LoanID)
)

CREATE TABLE Users
(
UserID INT IDENTITY PRIMARY KEY,
UserName VARCHAR(20),
Password VARCHAR(20),
CustomerID INT UNIQUE,
CONSTRAINT FK_Users_Customers FOREIGN KEY (CustomerID) REFERENCES Customers (CustomerID)
)

ALTER TABLE Employees
ADD ManagerID INT,
CONSTRAINT FK_Employees_Employees FOREIGN KEY (ManagerID) REFERENCES Employees (EmployeeID)