column | grant_sites.created_at | timestamp null=NO default=CURRENT_TIMESTAMP column | grant_sites.id | text null=NO default=- column | grant_sites.role | GrantRole null=NO default=- column | grant_sites.site_id | text null=NO default=- column | grant_sites.updated_at | timestamp null=NO default=- column | grant_sites.user_grant_id | text null=NO default=- column | notifications.body | text null=NO default=- column | notifications.created_at | timestamp null=NO default=CURRENT_TIMESTAMP column | notifications.description | text null=YES default=- column | notifications.id | text null=NO default=- column | notifications.readed_at | timestamp null=YES default=- column | notifications.site_id | text null=YES default=- column | notifications.title | text null=NO default=- column | notifications.type | NotificationType null=NO default='UNKNOWN'::"NotificationType" column | notifications.user_id | text null=NO default=- column | otp_codes.created_at | timestamp null=NO default=CURRENT_TIMESTAMP column | otp_codes.entityId | text null=NO default=- column | otp_codes.expires_at | timestamp null=NO default=- column | otp_codes.hash | text null=NO default=- column | otp_codes.id | text null=NO default=- column | otp_codes.type | OtpCodeType null=NO default=- column | sessions.created_at | timestamp null=NO default=CURRENT_TIMESTAMP column | sessions.deviceId | text null=YES default=- column | sessions.device_type | DeviceType null=YES default=- column | sessions.expires_at | timestamp null=NO default=- column | sessions.id | text null=NO default=- column | sessions.ip | text null=YES default=- column | sessions.os | text null=YES default=- column | sessions.type | SessionType null=NO default=- column | sessions.updated_at | timestamp null=NO default=- column | sessions.user_agent | text null=YES default=- column | sessions.user_id | text null=NO default=- column | site_api_keys.created_at | timestamp null=NO default=CURRENT_TIMESTAMP column | site_api_keys.hash | text null=NO default=- column | site_api_keys.id | text null=NO default=- column | site_api_keys.prefix | text null=NO default=- column | site_api_keys.siteId | text null=NO default=- column | site_api_keys.type | ApiKeyType null=NO default=- column | site_api_keys.updated_at | timestamp null=NO default=- column | sites.comment | text null=YES default=- column | sites.created_at | timestamp null=NO default=CURRENT_TIMESTAMP column | sites.domain | text null=NO default=- column | sites.id | text null=NO default=- column | sites.ipv4 | text null=YES default=- column | sites.is_confirmed | bool null=NO default=false column | sites.sitePlatform | SitePlatform null=NO default='UNKNOWN'::"SitePlatform" column | sites.title | text null=NO default=- column | sites.updated_at | timestamp null=NO default=- column | sites.user_id | text null=NO default=- column | user_grants.created_at | timestamp null=NO default=CURRENT_TIMESTAMP column | user_grants.grantor_id | text null=NO default=- column | user_grants.id | text null=NO default=- column | user_grants.receiver_id | text null=NO default=- column | users.created_at | timestamp null=NO default=CURRENT_TIMESTAMP column | users.email | text null=NO default=- column | users.fullname | text null=NO default=- column | users.id | text null=NO default=- column | users.is_confirmed | bool null=NO default=false column | users.password_hash | text null=NO default=- column | users.updated_at | timestamp null=NO default=- constraint | grant_sites.grant_sites_pkey | PRIMARY KEY (id) constraint | grant_sites.grant_sites_site_id_fkey | FOREIGN KEY (site_id) REFERENCES sites(id) ON UPDATE CASCADE ON DELETE CASCADE constraint | grant_sites.grant_sites_user_grant_id_fkey | FOREIGN KEY (user_grant_id) REFERENCES user_grants(id) ON UPDATE CASCADE ON DELETE CASCADE constraint | notifications.notifications_pkey | PRIMARY KEY (id) constraint | notifications.notifications_site_id_fkey | FOREIGN KEY (site_id) REFERENCES sites(id) ON UPDATE CASCADE ON DELETE CASCADE constraint | notifications.notifications_user_id_fkey | FOREIGN KEY (user_id) REFERENCES users(id) ON UPDATE CASCADE ON DELETE CASCADE constraint | otp_codes.otp_codes_pkey | PRIMARY KEY (id) constraint | sessions.sessions_pkey | PRIMARY KEY (id) constraint | sessions.sessions_user_id_fkey | FOREIGN KEY (user_id) REFERENCES users(id) ON UPDATE CASCADE ON DELETE CASCADE constraint | site_api_keys.site_api_keys_pkey | PRIMARY KEY (id) constraint | site_api_keys.site_api_keys_siteId_fkey | FOREIGN KEY ("siteId") REFERENCES sites(id) ON UPDATE CASCADE ON DELETE CASCADE constraint | sites.sites_pkey | PRIMARY KEY (id) constraint | sites.sites_user_id_fkey | FOREIGN KEY (user_id) REFERENCES users(id) ON UPDATE CASCADE ON DELETE CASCADE constraint | user_grants.user_grants_grantor_id_fkey | FOREIGN KEY (grantor_id) REFERENCES users(id) ON UPDATE CASCADE ON DELETE CASCADE constraint | user_grants.user_grants_pkey | PRIMARY KEY (id) constraint | user_grants.user_grants_receiver_id_fkey | FOREIGN KEY (receiver_id) REFERENCES users(id) ON UPDATE CASCADE ON DELETE CASCADE constraint | users.users_pkey | PRIMARY KEY (id) enum | ApiKeyType | SITE_NOTIFICATONS enum | DeviceType | DESKTOP,TABLET,MOBILE enum | GrantRole | ADMINISTRATOR,MANAGER enum | NotificationType | SYSTEM,SITE_NEW_ORDER,SITE_NEW_FORM,SITE_CUSTOM,UNKNOWN enum | OtpCodeType | EMAIL_VERIFICATION,SITE_SYNCHRONIZAION enum | SessionType | AUTHORIZED,UNAUTHORIZED enum | SitePlatform | KZLL_COMMON,KRZL_COMMON,KRZI_COMMON,KRZA_COMMON,KZLA_COMMON,KZLL_SEPARATED,KRZL_SEPARATED,KRZI_SEPARATED,KRZA_SEPARATED,KZLA_SEPARATED,UNKNOWN index | grant_sites.grant_sites_pkey | CREATE UNIQUE INDEX grant_sites_pkey ON public.grant_sites USING btree (id) index | notifications.notifications_pkey | CREATE UNIQUE INDEX notifications_pkey ON public.notifications USING btree (id) index | otp_codes.otp_codes_entityId_type_key | CREATE UNIQUE INDEX "otp_codes_entityId_type_key" ON public.otp_codes USING btree ("entityId", type) index | otp_codes.otp_codes_pkey | CREATE UNIQUE INDEX otp_codes_pkey ON public.otp_codes USING btree (id) index | sessions.sessions_pkey | CREATE UNIQUE INDEX sessions_pkey ON public.sessions USING btree (id) index | site_api_keys.site_api_keys_pkey | CREATE UNIQUE INDEX site_api_keys_pkey ON public.site_api_keys USING btree (id) index | site_api_keys.site_api_keys_siteId_type_key | CREATE UNIQUE INDEX "site_api_keys_siteId_type_key" ON public.site_api_keys USING btree ("siteId", type) index | sites.sites_domain_idx | CREATE INDEX sites_domain_idx ON public.sites USING btree (domain) index | sites.sites_domain_key | CREATE UNIQUE INDEX sites_domain_key ON public.sites USING btree (domain) index | sites.sites_pkey | CREATE UNIQUE INDEX sites_pkey ON public.sites USING btree (id) index | user_grants.user_grants_grantor_id_receiver_id_key | CREATE UNIQUE INDEX user_grants_grantor_id_receiver_id_key ON public.user_grants USING btree (grantor_id, receiver_id) index | user_grants.user_grants_pkey | CREATE UNIQUE INDEX user_grants_pkey ON public.user_grants USING btree (id) index | users.users_email_key | CREATE UNIQUE INDEX users_email_key ON public.users USING btree (email) index | users.users_pkey | CREATE UNIQUE INDEX users_pkey ON public.users USING btree (id) migrations | applied | 20260212155256_init, 20261021120000_add_user_grants rows | user_grants / grant_sites | 0 / 0