public.app_releases
Description
Labels
svc-portal
Columns
| Name | Type | Default | Nullable | Children | Parents | Comment |
|---|---|---|---|---|---|---|
| id | varchar(36) | false | public.app_update_logs | App release identifier (UUID). | ||
| app_id | varchar(36) | false | public.managed_apps | Parent managed app ID. | ||
| version_code | integer | false | Version code (integer). | |||
| version_name | varchar(50) | false | Version name (e.g., 1.0.0). | |||
| release_notes | text | true | Release notes for this version. | |||
| min_sdk_version | integer | true | Minimum Android SDK version. | |||
| target_sdk_version | integer | true | Target Android SDK version. | |||
| s3_key | varchar(512) | false | S3 key path to APK file. | |||
| file_size_bytes | bigint | false | APK file size in bytes. | |||
| checksum_sha256 | varchar(64) | false | SHA256 checksum of APK file. | |||
| is_active | boolean | false | Active release flag. Only one per app. | |||
| uploaded_at | timestamp with time zone | false | APK upload timestamp. | |||
| uploaded_by_user_id | varchar(36) | true | public.users | User ID who uploaded this release. | ||
| activated_at | timestamp with time zone | true | Release activation timestamp. | |||
| activated_by_user_id | varchar(36) | true | public.users | User ID who activated this release. | ||
| update_window_start | varchar(5) | '00:00'::character varying | false | Update window start time (HH:MM UTC). | ||
| update_window_end | varchar(5) | '23:59'::character varying | false | Update window end time (HH:MM UTC). |
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