NOTIFY - Notification Entries

Apr 19, 2024

CREATE TABLE K3S_5WEB.NOTIFY ( 
	USER_ID CHAR(10) CCSID 37 DEFAULT NULL , 
	SENT_FROM_USER_ID FOR COLUMN SENT_00001 CHAR(10) CCSID 37 DEFAULT NULL , 
	SUBJECT VARCHAR(40) CCSID 37 DEFAULT NULL , 
	MESSAGE VARCHAR(255) CCSID 37 DEFAULT NULL , 
	"READ" SMALLINT NOT NULL DEFAULT 0 , 
	COMPLETED SMALLINT NOT NULL DEFAULT 0 , 
	"ID" NUMERIC(11, 0) GENERATED ALWAYS AS IDENTITY ( 
	START WITH 1 INCREMENT BY 1 
	NO MINVALUE NO MAXVALUE 
	CYCLE NO ORDER 
	CACHE 20 ) 
	, 
	LINK VARCHAR(255) ALLOCATE(1) CCSID 37 NOT NULL DEFAULT '#' , 
	"TYPE" VARCHAR(20) ALLOCATE(7) CCSID 37 NOT NULL DEFAULT 'warning' , 
	BIRTH TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , 
	LASTUPDATE TIMESTAMP GENERATED ALWAYS 	FOR EACH ROW ON UPDATE AS ROW CHANGE TIMESTAMP NOT NULL , 
	NOTE VARCHAR(50) CCSID 37 DEFAULT NULL )   
	  
	RCDFMT NOTIFY     ; 
  
LABEL ON TABLE WEB_5WEB.NOTIFY 
	IS 'Web - Completion on Submitted Jobs from R6' ; 

---