How to transform this spreadsheet into a database model - see example code
Hi everyone!
I have to transform this spreadsheet Spreadsheet into database model. This spreadsheet is part of a apprenticeship curriculum in germany, in case you want to be a mechatronics engineer.
Step 12 is easy. We have a Current Number, a Title, a Description and a Amount of Weeks to teach in Year of training
Milestone
current_number: int
title: string
description: text
duration_in_weeks: int
year_of_training: int
end
So. I'am struggling with step 13 We have a topic with different steps to teach in different years of training. So my plan is to split the Milestone Model and add a MilestoneStep Model with a One-To-Many Relationship because a Milestone can have many different steps.
MilestoneStep
description: text
duration_in_weeks: int
year_of_training: int
end
Milestone
current_number: int
title: string
end
Is this the way to go, or am i missing something and doing things completely wrong? I really appreciate your help!
Kind regards,
Sebastian