public.device_app_versions

Description

Labels

svc-portal

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	varchar(36)		false
device_id	uuid		false		public.devices
app_id	varchar(36)		false		public.managed_apps
installed_version_code	integer		false
installed_version_name	varchar(50)		false
first_installed_at	timestamp with time zone		true
last_updated_at	timestamp with time zone		false
last_reported_at	timestamp with time zone		false

Viewpoints

Name	Definition
App Management	OTA app updates for SmartPOS terminals

Constraints

Name	Type	Definition
device_app_versions_device_id_fkey	FOREIGN KEY	FOREIGN KEY (device_id) REFERENCES devices(device_id) ON DELETE CASCADE
device_app_versions_app_id_fkey	FOREIGN KEY	FOREIGN KEY (app_id) REFERENCES managed_apps(id) ON DELETE CASCADE
device_app_versions_pkey	PRIMARY KEY	PRIMARY KEY (id)
uq_device_app_versions_device_app	UNIQUE	UNIQUE (device_id, app_id)

Indexes

Name	Definition
device_app_versions_pkey	CREATE UNIQUE INDEX device_app_versions_pkey ON public.device_app_versions USING btree (id)
uq_device_app_versions_device_app	CREATE UNIQUE INDEX uq_device_app_versions_device_app ON public.device_app_versions USING btree (device_id, app_id)
idx_device_app_versions_device	CREATE INDEX idx_device_app_versions_device ON public.device_app_versions USING btree (device_id)
idx_device_app_versions_app	CREATE INDEX idx_device_app_versions_app ON public.device_app_versions USING btree (app_id)
idx_device_app_versions_version	CREATE INDEX idx_device_app_versions_version ON public.device_app_versions USING btree (app_id, installed_version_code)

Relations

---

Generated by tbls