public.app_releases
Description
Labels
svc-portal
Columns
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | varchar(36) | false | public.app_update_logs | |||
| app_id | varchar(36) | false | public.managed_apps | |||
| version_code | integer | false | ||||
| version_name | varchar(50) | false | ||||
| release_notes | text | true | ||||
| min_sdk_version | integer | true | ||||
| target_sdk_version | integer | true | ||||
| s3_key | varchar(512) | false | ||||
| file_size_bytes | bigint | false | ||||
| checksum_sha256 | varchar(64) | false | ||||
| is_active | boolean | false | ||||
| uploaded_at | timestamp with time zone | false | ||||
| uploaded_by_user_id | varchar(36) | true | public.users | |||
| activated_at | timestamp with time zone | true | ||||
| activated_by_user_id | varchar(36) | true | public.users | |||
| update_window_start | varchar(5) | '00:00'::character varying | false | |||
| update_window_end | varchar(5) | '23:59'::character varying | false |
Viewpoints
| Name | Definition |
|---|---|
| App Management | OTA app updates for SmartPOS terminals |
Constraints
| Name | Type | Definition |
|---|---|---|
| app_releases_activated_by_user_id_fkey | FOREIGN KEY | FOREIGN KEY (activated_by_user_id) REFERENCES users(user_id) ON DELETE SET NULL |
| app_releases_uploaded_by_user_id_fkey | FOREIGN KEY | FOREIGN KEY (uploaded_by_user_id) REFERENCES users(user_id) ON DELETE SET NULL |
| app_releases_app_id_fkey | FOREIGN KEY | FOREIGN KEY (app_id) REFERENCES managed_apps(id) ON DELETE CASCADE |
| app_releases_pkey | PRIMARY KEY | PRIMARY KEY (id) |
| uq_app_releases_app_version | UNIQUE | UNIQUE (app_id, version_code) |
Indexes
| Name | Definition |
|---|---|
| app_releases_pkey | CREATE UNIQUE INDEX app_releases_pkey ON public.app_releases USING btree (id) |
| uq_app_releases_app_version | CREATE UNIQUE INDEX uq_app_releases_app_version ON public.app_releases USING btree (app_id, version_code) |
| idx_app_releases_app_active | CREATE INDEX idx_app_releases_app_active ON public.app_releases USING btree (app_id, is_active) |
| idx_app_releases_uploaded | CREATE INDEX idx_app_releases_uploaded ON public.app_releases USING btree (uploaded_at) |
| ix_app_releases_app_id | CREATE INDEX ix_app_releases_app_id ON public.app_releases USING btree (app_id) |
| ix_app_releases_is_active | CREATE INDEX ix_app_releases_is_active ON public.app_releases USING btree (is_active) |
Relations
Generated by tbls