I did something like this, though I started in Tinderbox and moved to a database (Postgres) when things became a bit unwieldy on the map.
I had person, tv show and film as prototypes. A person could be an actor in, a writer of, a producer of, a director of, a tv show or a film. A person’s relationship to a tv show or film was expressed using named links.
It was fun, but I don’t think Tinderbox wants to hold you to the kind of stringent rules that are described by, e.g. foreign keys. I think it could, though I couldn’t tell you where to start, manage some elements but, taking an update rule on a foreign key relationship as an example, I don’t believe Tinderbox can be coded to cascade an update of text in one note to another. Others may respond with the facts on that.
May I suggest you look at the PHP content management framework Processwire(.com)? This is a tool that you could use to emulate a database but, having said that, you’d be building a database on top of a database. The advantage you’d have with Processwire is that a lot of the work wrt to rich or other text fields is done for you. I won’t go into that any further, you can look it up. It’s an excellent piece of software.
I think you might be better off converting your model into a physical db on, e.g. Postgres, which runs very well on macOS (installers from EDB) and, well, thats all I’ve got for you!!
Since you’ve created a model, I suspect you may know all that so forgive me if I’ve seemed to be “teaching”. Not my intention. I’d be happy to talk to you about it though because I love this sort of problem.
Nic