Just to say - while we love to help people here, this is not a place to turn to for professional consulting. Your schema looks complex enough (and based on the content, safety-critical enough) that you would benefit from paying someone to help design a schema for you.
3 Likes