# Party Model and subtypes of a subtype **URL:** \ **Category:** Questions\ **Tags:** data-model, party-model\ **Created:** [April 29, 2023, 6:56pm UTC](https://the.fmsoup.org/t/party-model-and-subtypes-of-a-subtype/3534 "2023-04-29T18:56:49Z")\ **Posts on this page:** 3\ **Page:** 2
**Author:** ![Matteo](https://avatars.discourse-cdn.com/v4/letter/m/f9ae1b/32.png) [@Matteo](https://the.fmsoup.org/u/Matteo)\ **Post date:** [May 5, 2023, 3:23pm UTC](https://the.fmsoup.org/t/party-model-and-subtypes-of-a-subtype/3534/21 "2023-05-05T15:23:00Z")
> [@Torsten](#): > > I’ve been reading all posts here and must admit that I did no get what your solution shall achieve. Yes, I know. I did not really specify the purpose, but that is partly because I want to experiment and see, how the Party Model works and what it can do. Regarding my solution: It is a solution for an organisation that deals with day care for children („Tagesmütter“ as you are from Switzerland). At the moment it can/should manage two aspects: - Training courses (in the framework of coninuing education) - Internships But as I said: I expect it to grow an manage almost everything the organisation does. I could imagine the following: - Relations between people (child, mother, father, siblings, carer) to represent the day care situation - Which child is cared for by which carer? - Who are the child's parents? - Who are its siblings? - ... - Management of the carers/caring places - contact information - schedules - available places for new children - ... - Material for the carers (baby cribs, toys,...) - inventory - a kind of lending system (which item is with which person?) - ... - Management of administration staff - working hours - diplomae - evaluation - ... As this might get really big and complex I wanted to use a flexible data model and had a look into the Party Model. Of course I could also just use a standard approach and create "normal" tables. I am not sure if I am creating a complex model with a lot of flexibility and options or if I am only making it too complex. > [@Malcolm](#): > > If you enforced a rule that said you may have only one record in PartyRole then the historical data would have to be moved into PartyRelation. > > The reason for confusion is that you have choices. That is exactly my problem. I could do it this way or that way or even another way and I can not make up my mind or try to understand what the differences are. Maybe I should continue to experiment with different scenarios and see if I want to put those records (using "from" and "thru") into PartyRole or PartyRelation. But I guess there comes a point where I should stop pondering... 😉 > [@Malcolm](#): > > I suggest you opt for the pattern you think is simplest. Don't create cognitive effort for yourself. Very true, but surely not my strength. I am anxious of picking a pattern that turns out to be too simple further down the road. ---
**Author:** ![Torsten](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/torsten/32/1574_2.png) [@Torsten](https://the.fmsoup.org/u/Torsten)\ **Post date:** [May 5, 2023, 3:34pm UTC](https://the.fmsoup.org/t/party-model-and-subtypes-of-a-subtype/3534/22 "2023-05-05T15:34:30Z")
Excellent, this makes things much clearer! I happen to have rolled out a solution for a language school earlier this year and may be able to provide a suggestion for the 'training courses part' over the weekend. ---
**Author:** ![Matteo](https://avatars.discourse-cdn.com/v4/letter/m/f9ae1b/32.png) [@Matteo](https://the.fmsoup.org/u/Matteo)\ **Post date:** [May 5, 2023, 4:06pm UTC](https://the.fmsoup.org/t/party-model-and-subtypes-of-a-subtype/3534/23 "2023-05-05T16:06:36Z")
That is very kind of you, but this is the part that I have already completed with a standard approach. 🙂 [Previous page](https://the.fmsoup.org/t/party-model-and-subtypes-of-a-subtype/3534.md?page=1)