Database Design for task monitoring system
Posted by: Prashant Sontale
Date: May 12, 2023 05:46AM

I am designing the database table structure for the task monitoring system. I have a situation where each user can assign tasks to each other. For example, user A assigns a task to user B. User B can assign tasks to user C and so on.
I have designed the following tables and their columns

1. users table - stores all users of the system
UserId - int - Primary key- auto increment
Full Name - varchar
Email - varchar
username - varchar
password - varchar

2. tasks table - stores the tasks for each user
TaskId - int - primary key -auto increment
CreatedBy - int - foreign key - (UserId of users table)
AssignedTo - int - foreign key (UserId of users table)
TaskName - varchar
TaskDescrition - varchar
StartDate - date
EndDate - date
Status - varchar

Is this table design correct for storing the task details created by one user to another?

Options: ReplyQuote


Subject
Written By
Posted
Database Design for task monitoring system
May 12, 2023 05:46AM


Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.