SCREENOPT - Screen Options

Jul 30, 2026

-- SCREENOPT — Per-user screen options (widget layout, table column order, etc.)
-- One row per user per screen. OPTIONS holds a JSON blob; shape is owned by the
-- web app (versioned inside the JSON itself, e.g. {"v":1,...}).
-- Runs in each install's XXX_5WEB library (K3S_5WEB shown, per docs convention).

SET SCHEMA XXX_5WEB;

CREATE TABLE SCREENOPT (
	USER_ID INTEGER NOT NULL ,
	IDENTIFIER FOR COLUMN IDENT VARCHAR(50) CCSID 37 NOT NULL ,
	OPTIONS CLOB(1M) CCSID 37 NOT NULL ,
	BIRTH TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ,
	LASTUPDATE FOR COLUMN LASTU00001 TIMESTAMP GENERATED ALWAYS
		FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP NOT NULL ,
	PRIMARY KEY ( USER_ID , IDENTIFIER ) )

	RCDFMT SCREENOPT ;

LABEL ON TABLE SCREENOPT
	IS 'Web - Per User Screen Options JSON' ;

---