CREATE TABLE person.tbl_users
(
    user_id integer NOT NULL,
    user_email text COLLATE pg_catalog."default" NOT NULL,
    user_name text COLLATE pg_catalog."default" NOT NULL,
    date_last_upd timestamp(4) without time zone NOT NULL,
    date_ins timestamp(4) without time zone NOT NULL,
    isd integer NOT NULL DEFAULT 0,
    user_type integer NOT NULL,
    CONSTRAINT "TBL_USERS_pkey" PRIMARY KEY (user_id),
    CONSTRAINT "FK_USER_TYPE" FOREIGN KEY (user_type)
        REFERENCES person.tbl_user_type (user_type_id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
)
WITH (
    OIDS = FALSE
)

CREATE TABLE person.tbl_user_attr
(
    ua_id integer NOT NULL,
    ua_attr_id integer NOT NULL,
    ua_user_id integer NOT NULL,
    ua_attr_value text COLLATE pg_catalog."default",
    CONSTRAINT "TBL_USER_ATTR_pkey" PRIMARY KEY (ua_id),
    CONSTRAINT "FK_USER_ID" FOREIGN KEY (ua_user_id)
        REFERENCES person.tbl_users (user_id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION,
    CONSTRAINT "FK_USER_TYPE_ID" FOREIGN KEY (ua_attr_id)
        REFERENCES person.tbl_user_attr_type (ua_type_id) MATCH SIMPLE
        ON UPDATE NO ACTION
        ON DELETE NO ACTION
)
WITH (
    OIDS = FALSE
)

...
v_new_user_id = (SELECT nextval('person.seq_user_id'));
INSERT INTO person."tbl_users"(user_id, user_email, user_name, date_last_upd, date_ins, isd, user_type)
	VALUES (v_new_user_id, v_par_email, v_par_email, TIMESTAMP(0) 'now', TIMESTAMP(0) 'now', 0, 1);
insert into person."tbl_user_attr" ("ua_id","ua_attr_id","ua_user_id","ua_attr_value")
    VALUES(nextval('public.seq_attr_id'),16,v_new_user_id,'true');
...

...
UPDATE person.tbl_user_attr
SET ua_attr_value = par_attr_value
WHERE ua_user_id = par_user_id and ua_attr_id = 11;
...
--проапдейтили значения по конкретному par_user_id и теперь обновить поле даты последнего изменения в первой таблице
UPDATE person.tbl_users
SET date_last_upd= TIMESTAMP(0) 'now'
WHERE user_id = par_user_id and isd = 0;

clock_timestamp()