So far the database should have tables that contains the following:
User_T (_T denotes that it is a table which is a common notation)
PK: UserID (Auto increment start at 1)
Email address (should be unique)
Username (should be unique)
Password
Projects Following
Project_T
PK: ProjectID (auto increment start at 1)
Project Description
Project Steps
FK (foreign key): UserID
We will also need tables with file paths to images/videos uploaded by the users which I imagine will have MediaID as a primary key which can be referenced in Project_T.
I may create a database diagram and attach it to this, so more to come here. May have multiple phases to this so I will make it an Epic.
So far the database should have tables that contains the following:
User_T (_T denotes that it is a table which is a common notation) PK: UserID (Auto increment start at 1) Email address (should be unique) Username (should be unique) Password Projects Following
Project_T PK: ProjectID (auto increment start at 1) Project Description Project Steps FK (foreign key): UserID
We will also need tables with file paths to images/videos uploaded by the users which I imagine will have MediaID as a primary key which can be referenced in Project_T.
I may create a database diagram and attach it to this, so more to come here. May have multiple phases to this so I will make it an Epic.