SQL Scripts and DB-setup - Githubissues

HugTheMainframe / OenskeSkyen

1 stars 2 forks source link

SQL Scripts and DB-setup #15

Open OSBJE opened 3 weeks ago

OSBJE commented 3 weeks ago

Technical Description: Our SQL Database needs to be set-up and configurated

What: The following is need for an functionel SQL database:

[ ] SQL Scripts
[ ] ER diagram //Database tables / design - OenskeSkyDB
[ ] User (Name, mail, password, PrimaryKey User_ID)
[ ] WishList (Name, PrimaryKey WishList_ID)
[ ] Wish (Name, Price, Link, PrimaryKey Wish_ID)
[ ] WishList_wishes(WishList_ID, Wish_ID)
[ ] User_WishList (User_ID, WishList_ID)
[ ]

Why: Because we need data.

How: Run SQL Scripts and connect Java code to DB via methods in repository

Acceptance criteria: will be tested via method test in H2. Which ensures control