Data Model - kurtispe/Scrumptious GitHub Wiki

Project Table

The project class will contain all of the properties described in the Object Model page but as columns. There will be no foreign keys associated to the table.

Sprint Table

The sprint table, like the project table, will contain its properties as columns. A foreign key of the project-ID will be in the sprint table for relational association.

Backlog

The backlog table will behave similarly to the above two, but with a foreign key of the sprint-ID. This relation will be one-to-one.

User

The user table will have a one-to-one relation to a task in the task table.

Task

A task will have both a user-ID (that is a unique pairing) as well as a backlog-ID it will be associated with.

Step

Lastly, steps can belong to the same task-ID.