= Entity-Relationship Model v01 =

== Diagram ==
[[Image(EcoreDiagram-2.png, width=100%)]]

== 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.