public.device_app_versions
Description
Labels
svc-portal
Columns
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | varchar(36) | false | Device app version identifier (UUID). | |||
| device_id | uuid | false | public.devices | Device ID. | ||
| app_id | varchar(36) | false | public.managed_apps | Managed app ID. | ||
| installed_version_code | integer | false | Installed version code. | |||
| installed_version_name | varchar(50) | false | Installed version name. | |||
| first_installed_at | timestamp with time zone | true | First installation timestamp. | |||
| last_updated_at | timestamp with time zone | false | Last update timestamp. | |||
| last_reported_at | timestamp with time zone | false | Last device report timestamp. |
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