public.app_update_logs

Description

Labels

svc-portal

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	varchar(36)		false
device_id	uuid		true		public.devices
release_id	varchar(36)		false		public.app_releases
status	varchar(20)		false
error_code	integer		true
error_message	text		true
timestamp	timestamp with time zone		false
download_duration_seconds	integer		true
install_duration_seconds	integer		true

Viewpoints

Name	Definition
App Management	OTA app updates for SmartPOS terminals

Constraints

Name	Type	Definition
ck_app_update_logs_status	CHECK	CHECK (((status)::text = ANY ((ARRAY['success'::character varying, 'failed'::character varying, 'downloading'::character varying, 'installing'::character varying])::text[])))
app_update_logs_device_id_fkey	FOREIGN KEY	FOREIGN KEY (device_id) REFERENCES devices(device_id) ON DELETE SET NULL
app_update_logs_release_id_fkey	FOREIGN KEY	FOREIGN KEY (release_id) REFERENCES app_releases(id) ON DELETE CASCADE
app_update_logs_pkey	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
app_update_logs_pkey	CREATE UNIQUE INDEX app_update_logs_pkey ON public.app_update_logs USING btree (id)
idx_app_update_logs_device	CREATE INDEX idx_app_update_logs_device ON public.app_update_logs USING btree (device_id)
idx_app_update_logs_release	CREATE INDEX idx_app_update_logs_release ON public.app_update_logs USING btree (release_id)
idx_app_update_logs_timestamp	CREATE INDEX idx_app_update_logs_timestamp ON public.app_update_logs USING btree ("timestamp")

Relations

---

Generated by tbls