MobileAppVersions


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id uuid 2147483647 gen_random_uuid()
major int4 10 null
minor int4 10 null
patch int4 10 null
summary text 2147483647 null
description text 2147483647 null
countryCode varchar 255 null
Countries.code MobileAppVersions_countryCode_fkey R
platform enum_MobilePlatforms 2147483647 null
editorId uuid 2147483647 null
Users.id MobileAppVersions_editorid_fkey R
level enum_MobileVersionReleaseLevel 2147483647 null
createdAt timestamptz 35,6 now()
updatedAt timestamptz 35,6 now()
appUpdateUserRole enum_App_update_user_role 2147483647 √ null

Indexes

Constraint Name Type Sort Column(s)
MobileAppVersions_pkey Primary key Asc id
MobileAppVersions_countryCode_idx Performance Asc countryCode
MobileAppVersions_editorid_idx Performance Asc editorId
MobileAppVersions_major_minor_patch_countryCode_platform_appUpd Must be unique Asc/Asc/Asc/Asc/Asc/Asc major + minor + patch + countryCode + platform + appUpdateUserRole
MobileAppVersions_major_minor_patch_idx Performance Asc/Asc/Asc major + minor + patch
MobileAppVersions_platform_idx Performance Asc platform

Check Constraints

Constraint Name Constraint
MobileAppVersions_patch_check ((patch >= 0))
MobileAppVersions_minor_check ((minor >= 0))
MobileAppVersions_major_check ((major >= 0))

Relationships

Close relationships within degrees of separation