public.instance_monitoring_report

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
attempts	integer	0	false			Delivery attempts made so far, successful or not. Three ends the report.
createdAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false
dataPoints	json		false			The data point array exactly as sent to the receiver.
deliveredAt	timestamp(3) with time zone		true			When the receiver accepted the report; NULL while undelivered.
id	uuid		false			UUID; travels with the payload as its batchId.
lastAttemptAt	timestamp(3) with time zone		true			When the last attempt finished; NULL before the first. Paces retries across a restart.
lastError	text		true			Message of the most recent delivery failure.
reportDate	varchar(10)		true			UTC day the report was created on, as YYYY-MM-DD. Unique, so one report is created a day. Not the days the report covers. NULL only on a legacy row that shared its day with an earlier one.
status	varchar(64)	'pending'::character varying	false			Skipped means the instance stopped trying that day, not that the numbers were lost: only a delivered report crosses a day off, so a skipped day is covered by the next report.
updatedAt	timestamp(3) with time zone	CURRENT_TIMESTAMP(3)	false

Constraints

Name	Type	Definition
CHK_instance_monitoring_report_status	CHECK	CHECK (((status)::text = ANY ((ARRAY['pending'::character varying, 'delivered'::character varying, 'skipped_after_max_retries'::character varying, 'sending'::character varying])::text[])))
PK_4a5cb8aa51c67e4f5a7eb0f9509	PRIMARY KEY	PRIMARY KEY (id)
instance_monitoring_report_attempts_not_null	n	NOT NULL attempts
instance_monitoring_report_createdAt_not_null	n	NOT NULL "createdAt"
instance_monitoring_report_dataPoints_not_null	n	NOT NULL "dataPoints"
instance_monitoring_report_id_not_null	n	NOT NULL id
instance_monitoring_report_status_not_null	n	NOT NULL status
instance_monitoring_report_updatedAt_not_null	n	NOT NULL "updatedAt"

Indexes

Name	Definition
IDX_instance_monitoring_report_reportDate	CREATE UNIQUE INDEX "IDX_instance_monitoring_report_reportDate" ON public.instance_monitoring_report USING btree ("reportDate") WHERE ("reportDate" IS NOT NULL)
PK_4a5cb8aa51c67e4f5a7eb0f9509	CREATE UNIQUE INDEX "PK_4a5cb8aa51c67e4f5a7eb0f9509" ON public.instance_monitoring_report USING btree (id)

Relations

erDiagram


"public.instance_monitoring_report" {
  integer attempts
  timestamp_3__with_time_zone createdAt
  json dataPoints
  timestamp_3__with_time_zone deliveredAt
  uuid id
  timestamp_3__with_time_zone lastAttemptAt
  text lastError
  varchar_10_ reportDate
  varchar_64_ status
  timestamp_3__with_time_zone updatedAt
}

---

Generated by tbls