Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vOOvh-0066yg-0l for pgsql-general@arkaria.postgresql.org; Wed, 26 Nov 2025 23:28:09 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vOOue-002BB0-1m for pgsql-general@arkaria.postgresql.org; Wed, 26 Nov 2025 23:27:04 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vOOue-002BAs-0U for pgsql-general@lists.postgresql.org; Wed, 26 Nov 2025 23:27:04 +0000 Received: from mail-pf1-x434.google.com ([2607:f8b0:4864:20::434]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1vOOuc-001gZg-10 for pgsql-general@lists.postgresql.org; Wed, 26 Nov 2025 23:27:04 +0000 Received: by mail-pf1-x434.google.com with SMTP id d2e1a72fcca58-7b8e49d8b35so274775b3a.3 for ; Wed, 26 Nov 2025 15:27:01 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1764199620; x=1764804420; darn=lists.postgresql.org; h=to:references:message-id:date:cc:in-reply-to:from:subject :mime-version:content-transfer-encoding:from:to:cc:subject:date :message-id:reply-to; bh=PC+piIDJf9Q9hvwH2kqKjTEuEcliEm0kzsPfMgZW7Sg=; b=EXYYQVdg2pvM85smaTPzRrkxM09GyfzufFDjqYrYEICwuJ56Dk+vTWDJA6mHDaVGLE qxWYP2JKb20jwx8egH2xLQZIoDiixnXKUtpRemHDe/cqrdbrYJUZs4LRaF0NKxtUci7t sU7Ffzz0t23eFlDmwa/Bi6IqiGNylUXkKu6o5O0nqsHtiQk0AN+KbIecYrzaf1gpKynr 6TQFqTNsAOJLf/ks7KAxkyKDnOWbqMAtXkRxggBFyJs4Y8v9vqGLNg3SBXgLNtFX3CfK MvkNJxBI/4lc0tfh92CEB/0inyxjwwc0YS1Hm5m0I8LCMs+C6xbg4tY3cCKdB6RXQ09f 8O8g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1764199620; x=1764804420; h=to:references:message-id:date:cc:in-reply-to:from:subject :mime-version:content-transfer-encoding:x-gm-gg:x-gm-message-state :from:to:cc:subject:date:message-id:reply-to; bh=PC+piIDJf9Q9hvwH2kqKjTEuEcliEm0kzsPfMgZW7Sg=; b=NFPBsI4bX3MX/OfAWPl5WW5vuDrJdGU2DWzqLqGNVSqfoyz1LhJz6uOBWTM5lWZR53 O0ByNn/UFozUjauO15hF/6I7KsbMh3TwWVEmwsfYRJXw0U9WAP0t75T2hFOY3VXS9Id3 xKPqI/ceklQwlzwM4DgFmGKNjrtFEhOTaWVvyaUMVS4tDM8LCi4SpAOWvYGT6siAP+ks zFgsBhxC6pqHnrJu5661zPrwiyZmUXZEugDtEAmCgQU6neA1Tw18UHLHqo2s8rXC5oG0 S6Tc6u+qk5gJdUniiIlcYIQPfMdJZszXpFFxFWoCuTQ9wtELuvudd1xtsDpH5xjEx1ut Mnjg== X-Gm-Message-State: AOJu0YxZC0wCOqMMfzOYHqbnRCNJ1erozcDG8YHjru4YReWPPxQlItDW K6p8z5Jt6vvDRUTBvbDSY6KLDCzDdUsNkt3X2ffx33Yh8j/4VT6UFoh9vJsneQ== X-Gm-Gg: ASbGncsNctdXdCXn1UiDdx6BvyvW7PA7WeVv9hKcug6F5b8XVAfPez/k2aNQMmBw23U E0gL5e+o4/IiDzl0sagOcjmHQGoC48Rx0uWTB7IV0hr2jFjsvyRwY/IBx+u8UNyQn3wXZDcYkjX xe0HHJNr1lpclNzXSowegavK7odn2uWeQRVdJbO+mAHC/Wmvah+NYLKPQoCxhU2ymNyDyLwQk0U 6sNafnAuDv/vFIIOv9moyiSPQR5w+1C6ymKSIIDzmoPIoFJrDW8MLk/tGK/cZ8LirNHidmeluee TC/g4rk9Zm62VuMEtbxwTLyiE26HOiPSPSxDPdsl1/c6VLEdWr1HhvqopAco2lGPOG74jIahbTu SydVVIzhhOvcPH//fDcZDc1slbD6xSK1mayoi+z/96E25+yIIECchChcDYBQFKLGgX2zDdJ6MRZ oywHELTE7wkQ6LwMAHnP3JVj+MxaMygg1XhOu6kYyglPWR5ybQ6OEMx6IU4S+SW0yMvPEzTuCbq 2Jm7cjnbprzyh0+ X-Google-Smtp-Source: AGHT+IGz0dZM9byD4CyrbVpmWn4SRit5K6w4560uuH/L8uDDw71T0iTsr8GfCgVHSULtDxaEBTt7Uw== X-Received: by 2002:a05:6a20:3ca3:b0:35d:2172:6010 with SMTP id adf61e73a8af0-36150f34587mr24165669637.51.1764199619618; Wed, 26 Nov 2025 15:26:59 -0800 (PST) Received: from smtpclient.apple (ec2-15-220-16-55.us-west-2.compute.amazonaws.com. [15.220.16.55]) by smtp.gmail.com with ESMTPSA id d2e1a72fcca58-7c3f023f432sm22348214b3a.44.2025.11.26.15.26.59 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 26 Nov 2025 15:26:59 -0800 (PST) Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Mime-Version: 1.0 (1.0) Subject: Re: Schema design: user account deletion vs. keeping family tree data From: Rob Sargent In-Reply-To: Cc: pgsql-general@lists.postgresql.org Date: Wed, 26 Nov 2025 16:26:48 -0700 Message-Id: References: To: Christoph Pieper X-Mailer: iPhone Mail (22G100) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk > On Nov 26, 2025, at 3:25=E2=80=AFPM, Christoph Pieper = wrote: > =EF=BB=BF > Thanks everybody! >=20 > 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 s= tatement certainly implies the former. That you will have many many users te= nds towards the latter.=20 With respect to genetics I repeat myself (and another responder): keep the t= riplet 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 i= n fact identifying information.=20 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 y= our users wish to tell you=