Top

Database Design


The TimeSync web application uses Entity Framework Core (Code-First) to define and manage the database schema. The database is structured to support modular, scalable relationships between users, timesheets, leave requests, and system settings.

Key Features:

  1. Built using EF Core Code-First approach.
  2. All entities (models) are defined in code and EF automatically creates and manages the database schema via migrations.
  3. Foreign keys and indexes handled through EF navigation properties.
  4. Relationships such as one-to-many and many-to-many are handled through navigation properties and data annotations or fluent API configurations.
ERD