Initialize Database

[qy21gafy]

User story

1. As a user
2. I want / need a database that holds my user data, booked desks, company data etc.
3. So that I can efficiently book desks

Acceptance criteria

• Database initialization should follow the specified design
• Database should contain dummy data to allow easy testing of future features
• SQL Database should be used, industry partner suggested MS-SQL-Server Express or PostgreSQL
• Dev environment setup in docker
• Research production databases

Definition of done (DoD)

• Added only after week 5
• The same for all features
• Here goes the project specific part

DoD general criteria

• Feature has been fully implemented
• Feature has been merged into the mainline
• All acceptance criteria were met
• Product owner approved features
• All tests are passing
• Developers agreed to release

[Faoilthiama]

First two bullet points in Acceptance criteria should be an extra ticket because they are dependent on ticket #6 . We should review the design before thinking about dummy data.

[qy21gafy]

As the database design fits our idea, some suggestions for dummy data: Add an admin role, normal user and an intial admin role (user that registers company with service and has the most permissions) to the roles for testing; Add a dummy company with maybe one normal registered user, one admin and one initial admin; Maybe add one building, one room and one desk or so registered with that company to the database. These are just some suggestions, feel free to add more or less.

[xilef45]

Pull-Request: init DB + add Dummy Data #5