Build Scheduler app models

[Yacobolo]

we need these models to store the output of the scheduling algorithm, which has the following output:

They should all be add to the scheduler app.

Models Overview

1. SchedulerRuns

   • id (AutoField): Primary key, automatically incremented.
   • run_time (DateTimeField): Records when the scheduling process was executed.
   • details (TextField): Stores a summary or details about the scheduling run, such as outcomes, performance metrics, etc.

2. ResourceIntervals

   • id (AutoField): Primary key, automatically incremented.
   • resource_id (ForeignKey): Links to the Resource model.
   • task_id (ForeignKey): Links to the Task model, indicating the task to which the interval belongs.
   • interval_start (DateTimeField): The start time of the scheduled interval.
   • interval_end (DateTimeField): The end time of the scheduled interval.

3. ResourceAllocations

   • id (AutoField): Primary key, automatically incremented.
   • task_id (ForeignKey): Links to the Task model.
   • resource_id (ForeignKey): Links to the Resource model, indicating the resource assigned to the task.

4. Task (existing model)

   • planned_start (DateTimeField): Planned start time for the task.
   • planned_end (DateTimeField): Planned end time for the task.

[Yacobolo]

In the resource manager app we need the models: Resource and ResourceGroup
In the resource assigner app we need the Resource assignments which should reflect the Assignment model in factryengine. You can keep the Assignment Rule and Assignment Rule Constraint.
See: https://github.com/factryflow/factryengine/blob/main/docs/usage.md
.