From fdfdf46713c3382c958e090ec4076475531c172c Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Tue, 9 Jun 2026 22:00:20 +0000 Subject: [PATCH] Create PG_SOURCES code table --- db/schemas/codes/tables/Makefile | 1 + db/schemas/codes/tables/create/pg_sources.m4 | 28 +++++++++++++ doc/src/code_tables.m4 | 42 ++++++++++++++++++++ doc/src/epilog.inc.m4 | 4 ++ 4 files changed, 75 insertions(+) create mode 100644 db/schemas/codes/tables/create/pg_sources.m4 diff --git a/db/schemas/codes/tables/Makefile b/db/schemas/codes/tables/Makefile index eb06cbf..d269636 100644 --- a/db/schemas/codes/tables/Makefile +++ b/db/schemas/codes/tables/Makefile @@ -37,6 +37,7 @@ ORDER := agg_severities \ parities \ people \ obs_periods \ + pg_sources \ repro_state_change_sources \ role_codes \ sighting_records \ diff --git a/db/schemas/codes/tables/create/pg_sources.m4 b/db/schemas/codes/tables/create/pg_sources.m4 new file mode 100644 index 0000000..89b3a1c --- /dev/null +++ b/db/schemas/codes/tables/create/pg_sources.m4 @@ -0,0 +1,28 @@ +dnl Copyright (C) 2026 The Meme Factory, Inc., http://www.karlpinc.com/ +dnl +dnl This program is free software: you can redistribute it and/or modify +dnl it under the terms of the GNU Affero General Public License as published +dnl by the Free Software Foundation, either version 3 of the License, or +dnl (at your option) any later version. +dnl +dnl This program is distributed in the hope that it will be useful, +dnl but WITHOUT ANY WARRANTY; without even the implied warranty of +dnl MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the +dnl GNU Affero General Public License for more details. +dnl +dnl You should have received a copy of the GNU Affero General Public License +dnl along with this program. If not, see . +dnl +dnl Karl O. Pinc +dnl +dnl +dnl m4 includes +include(`copyright.m4')dnl +include(`constants.m4')dnl +include(`tablemacros.m4')dnl +include(`grants.m4')dnl + +support_table(`PG_SOURCES', `Source', `TEXT', ` + emptytext_check(`Source') + uppercase_check(`Source')' +) diff --git a/doc/src/code_tables.m4 b/doc/src/code_tables.m4 index 841332b..f962c67 100644 --- a/doc/src/code_tables.m4 +++ b/doc/src/code_tables.m4 @@ -941,6 +941,48 @@ existing data to be cleaned while preventing undesirable values from appearing in new data. +.. _PG_SOURCES: + +PG_SOURCES (PantGrunt SOURCES) +------------------------------ + +.. |PG_SOURCES_summary| replace:: + Contains one row for each source of pantgrunt information. + +|PG_SOURCES_summary| + + +Special Values +`````````````` + +None. + + +Column Descriptions +``````````````````` + +.. _PG_SOURCES.Source: + +Source +'''''' + +.. |PG_SOURCES.Source_summary| replace:: + A code identifying a source of data for pantgrunt information. + +|PG_SOURCES.Source_summary| |caseuniquekeycol| |uppercase| + + +.. _PG_SOURCES.Description: + +Description +''''''''''' + +.. |PG_SOURCES.Description_summary| replace:: + A description of the source of pantgrunt data. + +|PG_SOURCES.Description_summary| |emptytext| |notnull| + + .. _REPRO_STATE_CHANGE_SOURCES: REPRO_STATE_CHANGE_SOURCES diff --git a/doc/src/epilog.inc.m4 b/doc/src/epilog.inc.m4 index c5f8c5e..df2a121 100644 --- a/doc/src/epilog.inc.m4 +++ b/doc/src/epilog.inc.m4 @@ -493,6 +493,10 @@ sdb_generated_rst()dnl .. |PEOPLE.Description| replace:: :ref:`Description ` .. |PEOPLE.Active| replace:: :ref:`Active ` +.. |PG_SOURCES| replace:: :ref:`PG_SOURCES ` +.. |PG_SOURCES.Source| replace:: + :ref:`Code ` + .. |REPRO_STATES| replace:: :ref:`REPRO_STATES ` .. |REPRO_STATES.ReID| replace:: :ref:`ReID ` -- 2.34.1