From 29e6fbac3cb9e7994c1ad5b2d42caa6e74d0ac35 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Thu, 18 Jan 2024 21:37:06 +0000 Subject: [PATCH] Add BIOGRAPHY.DadID_Prelim column --- db/schemas/sokwedb/tables/create/biography.m4 | 2 ++ doc/src/tables/biography.m4 | 14 ++++++++++++++ 2 files changed, 16 insertions(+) diff --git a/db/schemas/sokwedb/tables/create/biography.m4 b/db/schemas/sokwedb/tables/create/biography.m4 index b019697..0a751d6 100644 --- a/db/schemas/sokwedb/tables/create/biography.m4 +++ b/db/schemas/sokwedb/tables/create/biography.m4 @@ -64,6 +64,8 @@ CREATE TABLE biography ( OR sex = 'sdb_unk_sex') ,animid_type_column(`momid', `MomID', `NULL') ,animid_type_column(`dadid', `DadID', `NULL') + ,dadprelim BOOLEAN + null_iff_null(`DadPrelim', `DadID') ,dadidpub TEXT NOT NULL emptytext_check(`DadIDPub') ,firstborn CHAR(1) NOT NULL diff --git a/doc/src/tables/biography.m4 b/doc/src/tables/biography.m4 index 38ff76c..dc9fe36 100644 --- a/doc/src/tables/biography.m4 +++ b/doc/src/tables/biography.m4 @@ -181,6 +181,20 @@ DadID (Father's AnimID) |allownull| +.. _BIOGRAPHY.DadPrelim: + +DadPrelim (Is Paternity Preliminary?) +`````````````````````````````````````` + +.. |BIOGRAPHY.DadPrelim_summary| replace:: + A boolean value. When |true|, the paternity assignment is preliminary. + +|BIOGRAPHY.DadPrelim_summary| +sdb_null_iff_null({|BIOGRAPHY.DadID|}) + +|allownull| + + .. _BIOGRAPHY.DadIDPub: DadIDPub (Publication of Paternity) -- 2.34.1