I'm thinking about the right database design for this requirement.
It's a manual maintenance check. A company can have a maintenance contract comprising HW checks, Sys checks, both or none. The part with the
CommandParameters worries me especially. The amount/name of the commands can be changed after a while, furthermore they are depending on each company. I was thinking to outsource the
CommandParameters to it's own table, linking it with the
MaintenanceContract. The commands would be all in one column, seperated with a delimter. The checkbox and comment line (free-text) are not directly linked with them (see below). Problem here is, I have to be sure that the amount of delimiters of free-text, checkbox, commands are always the same. I guess it's not possible in the structure, which I have designed below. Would be nice, when you have some other/better ideas.
Here the database draft: