CREATE TABLE Borrower (
Email VARCHAR,
Name VARCHAR,
PRIMARY KEY (Email) );

CREATE TABLE EquipmentType (
Category VARCHAR, PRIMARY KEY(Category) );

CREATE TABLE Equipment (
EquipmentID VARCHAR,
Description VARCHAR,
Category VARCHAR REFERENCES EquipmentType(Category),
Loanstatus VARCHAR,
PRIMARY KEY (EquipmentID) );

CREATE TABLE Loan (
LoanID INTEGER,
EquipmentID INTEGER REFERENCES Equipment (EquipmentID),
Email VARCHAR REFERENCES Borrower (Email),
BorrowDate DATE,
PlannedReturnDate DATE,
Purpose VARCHAR,
ActualReturnDate DATE,
PRIMARY KEY (LoanID) );


INSERT INTO Borrower(Email, Name)
VALUES ("luil@itu.dk", "Luis Landa");

INSERT INTO Borrower(Email, Name)
VALUES ("kakh@itu.dk", "Kasper Nielsen");

INSERT INTO Borrower(Email, Name)
VALUES ("jamy@itu.dk", "Janina Schnitzel");

INSERT INTO Borrower(Email, Name)
VALUES ("frba@itu.dk", "Frederik von Dyke");


INSERT INTO EquipmentType(Category)
VALUES ("DVD");

INSERT INTO EquipmentType(Category)
VALUES ("PC");

INSERT INTO EquipmentType(Category)
VALUES ("Camera");

INSERT INTO EquipmentType(Category)
VALUES ("Projector");

INSERT INTO Equipment(EquipmentID, Description, Category, Loanstatus)
VALUES (101, "Dvd Player", "DVD", "Available");

INSERT INTO Equipment(EquipmentID, Description, Category, Loanstatus)
VALUES (102, "PC", "PC", "On Loan");

INSERT INTO Equipment(EquipmentID, Description, Category, Loanstatus)
VALUES (103, "Camera", "Camera", "Under Repair");

INSERT INTO Equipment(EquipmentID, Description, Category, Loanstatus)
VALUES (104, "Projector", "Projector", "Discarded");

INSERT INTO Loan(LoanID, EquipmentID, Email, BorrowDate, PlannedReturnDate, Purpose)
VALUES(0001, 101, "luil@itu.dk", "08/11/2018", "11/11/2018", "Exam");

INSERT INTO Loan(LoanID, EquipmentID, Email, BorrowDate, PlannedReturnDate, Purpose)
VALUES(0002, 102, "kakh@itu.dk", "09/11/2018", "12/11/2018", "Exam");

INSERT INTO Loan(LoanID, EquipmentID, Email, BorrowDate, PlannedReturnDate, Purpose)
VALUES(0003, 103, "jamy@itu.dk", "10/11/2018", "15/11/2018", "Exam");

INSERT INTO Loan(LoanID, EquipmentID, Email, BorrowDate, PlannedReturnDate, Purpose)
VALUES(0004, 104, "frba@itu.dk", "11/11/2018", "19/11/2018", "Exam");