Skip to content
GitLab
Explore
Sign in
Primary navigation
Search or go to…
Project
D
DCST1008-studass-eksempel
Manage
Activity
Members
Labels
Plan
Issues
0
Issue boards
Milestones
Wiki
Code
Repository
Branches
Commits
Tags
Repository graph
Compare revisions
Snippets
Deploy
Releases
Package Registry
Container Registry
Model registry
Operate
Terraform modules
Monitor
Incidents
Analyze
Value stream analytics
Contributor analytics
Repository analytics
Model experiments
Help
Help
Support
GitLab documentation
Compare GitLab plans
Community forum
Contribute to GitLab
Provide feedback
Keyboard shortcuts
?
Snippets
Groups
Projects
This is an archived project. Repository and other project resources are read-only.
Show more breadcrumbs
Alexander Moltu
DCST1008-studass-eksempel
Wiki
Persistence
Changes
Page history
New page
Templates
Clone repository
Create Persistence
authored
2 years ago
by
Alexander Moltu
Hide whitespace changes
Inline
Side-by-side
Showing
1 changed file
Persistence.md
+45
-0
45 additions, 0 deletions
Persistence.md
with
45 additions
and
0 deletions
Persistence.md
0 → 100644
View page @
6479da61
<h3>
All data is stored in the MySQL database
</h3>
<h4>
ER-model of the database and how the entities are connected to it
</h4>
<img
src=
"https://media.discordapp.net/attachments/749996590621524151/836570699346608178/image0.png?width=899&height=676"
>
**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
);
```
This diff is collapsed.
Click to expand it.