B4 I get to much farther please critque what I am doing

programming
1

Hey yall I am new to mysql and database management so forgive me. So far I have built a cms from scratch and am curious if I am going about it the right way before I get to much farther. In reference to “going about it the right way” I am talking about table structure, data, and capabilities for final presentation data usability.

Here is the overall goal:
Admin can create projects (this involves id, title and original file)
Admin can create users
Admin can view users, add/remove users from a single project, delete users or edit them (add them to a project)

Users:
Users can login and view project files that they have been assigned to by ADMIN
Users can download project files and then reupload (reupload would just add to project files not overwrite original)

Here are my tables that I thought would be involved:


users
---------------------------------------
userID   userType   userName  userPass

userInfo
---------------------------------------
userInfoID   userID    projectID   filePath

projects
---------------------------------------
projectID    subjectID    title   filePath

Now I was thinking that the userInfo table would store not only projects that each user is involved in but also store the filePath to the files they have uploaded. Am I going about this the right way? I do not want to proceed to much farther if my table structure is FLAWED. Please advise. Thanks in advance.

MT