stagfe2/spec/measurment-spec-jan-13-2021.txt

@Vijay
----------------------------------------------------

	SELECT * FROM measurement LEFT JOIN client_bdt_measurement LEFT JOIN bdt_measurement

	SELECT * FROM measurement WHERE month = "MONTH_SELECTOR_VALUE":

		Vital Graph

										  Month Selector

		BP Graph: (shows the thresholds min/max and values outside this range will be highlighted)

			<....>

		Weight Graph:

			<....>

----------------------------------------------------

	Allow me to double click any of the numbers and popup modal to UPDATE this measurement entry::

		* Stamp it (STATUS = "ACK") --> [Stamp] JS powered refresh of the data.

		* Declare it to be wrong (STATUS = "INVALID_ACK")

----------------------------------------------------

	Measurements subpage in the client 

----------------------------------------------------

@Josh

	ALTER TABLE measurement ADD COLUMN IF NOT EXISTS effective_time TIMESTAMP WITH TIME ZONE;

	UPDATE measurement SET effective_time = (SELECT ts WHATEVER SINCE 1970)

	BLOOD PRESSURE has this as its alert arch.
	
		sbp_value_alert_threshold_max		140
		sbp_value_alert_threshold_max_memo	
		dbp_value_alert_threshold_max		110
		dbp_value_alert_threshold_max_memo	
		sbp_value_alert_threshold_min		90
		sbp_value_alert_threshold_min_memo	
		dbp_value_alert_threshold_min		70
		dbp_value_alert_threshold_min_memo

----------------------------------------------------