Entity-Relationship Model v01

Diagram

Data Requirements

Users

Represents all system users who may act as project owners or workers.

Candidate keys:

• user_id (primary key)

Attributes:

• user_id – numeric, required
• email – text, required, unique
• password – text, required
• role – text, required
• createdAt – date/time, required

Projects

Represents projects owned by users.

Candidate keys:

• project_id (primary key)

Attributes:

• project_id – numeric
• client_id – numeric
• name – text
• status – text
• startDate – date
• endDate – date

Relationships

• User owns Project (1:N)
• Project includes Task (1:N)
• Task has File (1:N)
• Task has Comment (1:N)
• TimesheetProject contains TimesheetEntry (1:N)

Entity-Relationship Model History

• v01 – Initial ER model created based on project requirements.