Perhaps the type of a base table column should be BOOLEAN (based on enumerated types)

Copy SQL

WITH bool_enum AS (SELECT nspname AS type_schema, typname
FROM pg_catalog.pg_type t INNER JOIN pg_catalog.pg_enum e ON t.oid=e.enumtypid
INNER JOIN pg_catalog.pg_namespace n ON n.oid=t.typnamespace
WHERE enumlabel~*'^(true|false|yes|no|on|off|jah|ei|unkn)$' AND nspname NOT IN (SELECT schema_name
FROM INFORMATION_SCHEMA.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL))
SELECT nspname AS type_schema, typname, array_agg(enumlabel ORDER BY enumsortorder) AS values,
(SELECT array_agg(table_schema || '.' || table_name || '.' || column_name ORDER BY table_schema, table_name) AS cols
FROM information_schema.columns AS c WHERE c.udt_schema=n.nspname AND c.udt_name=t.typname) AS cols
FROM pg_catalog.pg_type t INNER JOIN pg_catalog.pg_enum e ON t.oid=e.enumtypid
INNER JOIN pg_catalog.pg_namespace n ON n.oid=t.typnamespace
WHERE nspname NOT IN (SELECT schema_name
FROM INFORMATION_SCHEMA.schemata
WHERE schema_name<>'public' AND
schema_owner='postgres' AND schema_name IS NOT NULL) 
AND (nspname, typname) IN (SELECT type_schema, typname
FROM bool_enum)
GROUP BY nspname, typname
HAVING Count(*) IN (2, 3);