public.managed_apps

Description

Labels

svc-portal

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	varchar(36)		false	public.app_releases public.device_app_versions		Managed app identifier (UUID).
package_name	varchar(255)		false			Android package name (e.g., com.smartpos.app).
app_name	varchar(255)		false			App display name.
description	text		true			App description.
is_active	boolean		false			App active status.
created_at	timestamp with time zone		false			Record creation timestamp.
updated_at	timestamp with time zone		false			Record last update timestamp.

Viewpoints

Name	Definition
App Management	OTA app updates for SmartPOS terminals

Constraints

Name	Type	Definition
managed_apps_pkey	PRIMARY KEY	PRIMARY KEY (id)

Indexes

Name	Definition
managed_apps_pkey	CREATE UNIQUE INDEX managed_apps_pkey ON public.managed_apps USING btree (id)
ix_managed_apps_package_name	CREATE UNIQUE INDEX ix_managed_apps_package_name ON public.managed_apps USING btree (package_name)

Relations

---

Generated by tbls