All data is stored in the MySQL database
ER-model of the database and how the entities are connected to it
The SQL calls to create the database tables needed:
CREATE TABLE Tasks (
id int NOT NULL PRIMARY KEY AUTO_INCREMENT,
name text NOT NULL,
description text NOT NULL,
priority Boolean NOT NULL,
startDate text NOT NULL,
endDate text NOT NULL,
Completedate text,
categoryId INT NOT NULL
);
CREATE TABLE Categorys (
id int NOT NULL PRIMARY KEY AUTO_INCREMENT,
name text NOT NULL,
description text NOT NULL
);
CREATE TABLE CompletedTasks (
id int NOT NULL PRIMARY KEY AUTO_INCREMENT,
name text NOT NULL,
description text NOT NULL,
priority Boolean NOT NULL,
startDate text NOT NULL,
endDate text NOT NULL,
Completedate text NOT NULL,
categoryId INT NOT NULL
);