CREATE OR REPLACE FUNCTION wellness_measure(id INTEGER) RETURNS TRIGGER AS $$
DECLARE NYHA_calc NUMERIC; DASI_calc NUMERIC; HFSAS_calc NUMERIC; STATS_calc NUMERIC;
BEGIN
SELECT (NYHA * 0.1) AS NYHA_calc
FROM User_Input
WHERE EID = id;
SELECT (DASI * 0.1) AS DASI_calc
FROM User_Input
WHERE EID = id;
SELECT (HFSAS * 0.1) AS HFSAS_calc
FROM User_Input
WHERE EID = id;
SELECT (STATS * 0.7) AS STATS_calc
FROM User_Monitor
WHERE EID = id;
UPDATE EHR SET Wellness = (NYHA_calc + DASI_calc + HFSAS_calc + STATS_calc), DATE = CURRENT_DATE WHERE EID = id; RETURN NULL;
END;
$$ LANGUAGE plpgsql
;