From e0bb6a1350ec55e5b0975ba5da72745b9f6cbd5f Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc" Date: Mon, 4 Sep 2023 13:03:49 -0500 Subject: [PATCH] Explain the use of PEOPLE.Active --- doc/src/code_tables.m4 | 6 ++++++ 1 file changed, 6 insertions(+) diff --git a/doc/src/code_tables.m4 b/doc/src/code_tables.m4 index 99dca75..bf11d0b 100644 --- a/doc/src/code_tables.m4 +++ b/doc/src/code_tables.m4 @@ -259,6 +259,12 @@ inserted into the database. Further, when rows are updated an existing value cannot be set to the inactive :ref:`PEOPLE.Name`. |notnull| +Unlike most other data validation checks, :ref:`PEOPLE.Active` can be +changed from |true| to |false| even though the :ref:`PEOPLE.Person` +value is used elsewhere in the database. This allows time for +existing data to be cleaned while preventing undesirable values from +appearing in new data. + .. rubric:: Footnotes .. [#f14] The database could accept the full-set of Unicode characters, -- 2.34.1