> On Nov 26, 2025, at 3:25 PM, Christoph Pieper <[email protected]> wrote:
>
> Thanks everybody!
>
> And what do you think about Option A?
> Especially the pedigree node approach beside the animal node?
I have to ask if you are thinking about genetics or genealogy. Your opening
statement certainly implies the former. That you will have many many users
tends towards the latter.
With respect to genetics I repeat myself (and another responder): keep the
triplet table simple as can be with ego-mother-father. All else is fluff. ;)
You will have to lose/break pedigrees in the event of a deletion/retraction.
Keep in mind that there is a school of thought that claims pedigrees are in
fact identifying information.
For genealogy you might work off a two table setup: person and relationship.
The former defines an id and the latter relates two persons with a specific
type of relationship including half sibs, step sibs, uncle/aunt - whatever your
users wish to tell you
