-- Data for Name: role_action_link; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.role_action_link (id, role_id, action_id) FROM stdin;
\.


--
-- Data for Name: role_actions; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.role_actions (id, role_id, action) FROM stdin;
\.


--
-- Data for Name: role_rules; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.role_rules (id, role_id, action, route, "V", "C", "E", "D") FROM stdin;
17947	1		/user/healthController	t	t	f	t
17948	1		/user/cacheReset	f	t	f	t
17949	1		/user/access	t	t	f	t
17950	1		/user/verify-contact	t	t	f	t
17951	1		/user/check-contact	t	t	f	t
17952	1		/user/auth/sign-up	t	t	f	t
17953	1		/user/auth/sign-in	t	t	f	t
17954	1		/user/auth/forgot-password	t	t	f	t
17955	1		/user/auth/reset-password	t	t	f	t
17956	1		/user/auth/confirm-account	t	t	f	t
17957	1		/user/auth/check-code	t	t	f	t
17958	1		/user/me	t	t	f	t
17959	1		/user/user-additional	t	t	f	t
17960	1		/user/refresh-token	t	t	f	t
17961	1		/user/auth/auto-login	f	t	f	t
17962	1		/user/role/:id	t	t	f	f
17963	1		/user/role/:id/unset	t	t	f	f
17964	1		/user/group/:id	t	t	f	f
17965	1		/user/action/:id	t	t	f	f
17966	1		/user/handbook/groups/:id	t	t	f	f
17967	1		/user/handbook/:id	t	t	f	f
17968	1		/user/handbook/code/:code	t	t	f	t
17969	1		/user/users	t	t	f	f
17970	1		/user/shoppers	t	t	f	t
17971	1		/user/users/:id/base	t	t	f	t
17972	1		/user/users/:id/fields	t	t	f	t
17973	1		/user/users/:id	t	t	t	t
17974	1		/user/users/ids	t	t	f	f
17975	1		/user/users/restore	t	t	f	t
17976	1		/user/access/client/set	t	t	f	t
17977	1		/user/access/client/unset	t	t	f	t
17978	1		/user/access/client/flush	t	t	f	f
17979	1		/user/users/:id/activity-status	t	t	f	t
17980	1		/user/settings	t	t	f	t
17981	1		/user/comments/:id	t	t	f	t
17982	1		/user/competitors/:id	t	t	f	f
17983	1		/user/competitors/bind	t	t	f	t
17984	1		/user/competitors/unbind	t	t	f	t
17985	1		/user/clients	t	t	f	t
17986	1		/user/client/:id/settings	t	t	f	t
17987	1		/user/client/settings	t	t	f	t
17988	1		/user/client/:id/workers	t	t	f	t
17989	1		/user/client/:id/worker/:workerId	t	t	f	f
17990	1		/file/healthController	f	t	f	t
17991	1		/file/providers	f	t	f	t
17992	1		/file/provider/:id	f	t	f	f
17993	1		/file/upload	t	t	f	t
17994	1		/file/uploads	t	t	f	t
17995	1		/file/read/:provider/*	t	t	f	t
17996	1		/notifications/healthController	t	t	f	t
17997	1		/notifications/actions	t	t	f	t
17998	1		/notifications/action/code/:code	t	t	f	t
17999	1		/notifications/action/:id	t	t	f	f
18000	1		/notifications/communication/:id	t	t	f	f
18001	1		/notifications/communications	t	t	f	t
18002	1		/notifications/communication/:id/delete	t	t	f	f
18003	1		/notifications/communication/:id/users	t	t	f	t
18004	1		/notifications/communication/:id/update	t	t	f	t
18005	1		/notifications/templates	t	t	f	t
18006	1		/notifications/template/:id	t	t	f	f
18007	1		/notifications/template/communication/:communicationId	t	t	f	t
18008	1		/notifications/template/action/:actionId	t	t	f	t
18009	1		/notifications/template/render/:id	t	t	f	t
18010	1		/notifications/send	t	t	f	t
18011	1		/locations/healthController	t	t	f	t
18012	1		/locations/group/change-locations	t	t	f	t
18013	1		/locations/group-client-set	t	t	f	t
18014	1		/locations/group/:id	t	t	f	t
18015	1		/locations/group	t	t	f	t
18016	1		/locations/location/:id	t	t	f	t
18017	1		/locations/locations/ids	t	t	f	t
18018	1		/locations/location/test	t	t	f	t
18019	1		/locations/location/status	t	t	f	t
18020	1		/locations/location-status/:id	t	t	f	t
18021	1		/locations/countries	t	t	f	t
18022	1		/locations/countries/:countryCode/city	t	t	f	t
18023	1		/locations/countries/:countryCode/regions	t	t	f	t
18024	1		/locations/regions/:regionId/cities	t	t	f	t
18025	1		/locations/countries/:countryCode	t	t	f	t
18026	1		/locations/regions/:regionId	t	t	f	t
18027	1		/locations/cities/:cityId	t	t	f	t
18028	1		/locations/locationInfo	t	t	f	t
18029	1		/locations/shopping/visit-list	t	t	f	t
18030	1		/locations/shopping/execution-list	t	t	f	t
18031	1		/locations/shopping/executions/status	t	t	f	t
18032	1		/locations/shopping/executions/:id	t	t	f	f
18033	1		/locations/shopping/executions/delete-all	t	t	f	f
18034	1		/locations/program-type/status	t	t	f	t
18035	1		/locations/program-type/delete-all	t	t	f	f
18036	1		/locations/program-type/:id	t	t	f	f
18037	1		/locations/bonus/delete-all	t	t	f	f
18038	1		/locations/bonus/status	t	t	f	t
18039	1		/locations/bonus/:id	t	t	f	f
18040	1		/locations/client/:id/level	t	t	f	t
18041	1		/locations/access/execution/:user_id	t	t	f	t
18042	1		/locations/access/program/:user_id	t	t	f	t
18043	1		/locations/access/execution/set	t	t	f	t
18044	1		/locations/access/execution/unset	t	t	f	t
18045	1		/locations/access/program/set	t	t	f	t
18046	1		/locations/access/program/unset	t	t	f	t
18047	1		/locations/access/program/flush	t	t	f	t
18048	1		/locations/access/execution/flush	t	t	f	t
18049	1		/import-export/healthController	f	t	f	t
18050	1		/import-export/export/answer-list	f	t	f	t
18051	1		/import-export/export/workers	f	t	f	t
18052	1		/import-export/export/clients	f	t	f	t
18053	1		/import-export/export/shoppers	f	t	f	t
18054	1		/import-export/export/users	f	t	f	t
18055	1		/import-export/export/msp	f	t	f	t
18056	1		/import-export/export/locations	f	t	f	t
18057	1		/import-export/export/location-groups	f	t	f	t
18058	1		/import-export/export/executions	f	t	f	t
18059	1		/import-export/export/program-types	f	t	f	t
18060	1		/import-export/export/pdf/locations	f	t	f	t
18061	1		/import-export/export/pdf/location-groups	f	t	f	t
18062	1		/import-export/export/pdf/workers	f	t	f	t
18063	1		/import-export/export/pdf/clients	f	t	f	t
18064	1		/import-export/export/pdf/shoppers	f	t	f	t
18065	1		/import-export/export/pdf/users	f	t	f	t
18066	1		/import-export/export/pdf/msp	f	t	f	t
18067	1		/import-export/export/pdf/executions	f	t	f	t
18068	1		/import-export/export/pdf/program-types	f	t	f	t
18069	1		/import-export/import/users	f	t	f	t
18070	1		/import-export/import/clients	f	t	f	t
18071	1		/import-export/import/workers	f	t	f	t
18072	1		/import-export/import/msp	f	t	f	t
18073	1		/import-export/import/myMo	f	t	f	t
18074	1		/import-export/import/parse	f	t	f	t
18075	1		/import-export/import/locations	f	t	f	t
18076	1		/import-export/import/programs	f	t	f	t
18077	1		/questionnaire/healthController	t	t	f	t
18078	1		/questionnaire/quest	t	t	f	t
18079	1		/questionnaire/quest/:id	t	t	f	t
18080	1		/questionnaire/test	t	t	f	t
18081	1		/questionnaire/answer/stats	t	t	f	t
18082	1		/questionnaire/answer/stats/sections	t	t	f	t
18083	1		/questionnaire/answers	t	t	f	t
18084	1		/questionnaire/answer/:id	t	t	f	t
18085	1		/questionnaire/answer/:id/:status	t	t	f	t
18086	1		/questionnaire/appeal/:id	t	t	f	f
18087	1		/questionnaire/integration/v1/sign-in	t	t	f	t
18088	1		/questionnaire/integration/v1/all	t	t	f	t
18089	1		/questionnaire/integration/v1/answer/:id	t	t	f	t
18090	1		/questionnaire/integration/v2/sign-in	t	t	f	t
18091	1		/questionnaire/integration/v2/all	t	t	f	t
18092	1		/questionnaire/integration/v2/answer/:id	t	t	f	t
18093	1		/social-service/healthController	f	t	f	t
18094	1		/social-service/statistics	f	t	f	t
18095	1		/backup/healthController	f	t	f	f
18096	1		/backup/list	f	t	f	f
18097	1		/backup/	t	t	f	f
18098	1		/backup/restore	t	t	f	f
18099	1		/backup/:fileName	t	t	f	f
18100	1		/questionnaire/answer/create-execution-link	t	f	f	t
18101	1		/questionnaire/appeal	t	f	f	t
18102	1		/questionnaire/appeal/reply/:appealId	t	f	f	t
18103	1		/questionnaire/appeal/manager-reply/:appealId	t	f	f	t
18104	1		/notifications/action	t	f	f	t
18105	1		/notifications/communication	t	f	f	t
18106	1		/notifications/communication/:id/set	t	f	f	t
18107	1		/notifications/template	t	f	f	t
18108	1		/locations/groups	t	f	f	t
18109	1		/locations/locations	t	f	f	t
18110	1		/locations/shopping/executions	t	f	f	t
18111	1		/locations/shopping/executions-confirm	t	f	f	t
18112	1		/locations/shopping/executions-submit	t	f	f	t
18113	1		/locations/shopping/executions-duplicate	t	f	f	t
18114	1		/locations/shopping/received-visit/:id	t	f	f	t
18115	1		/locations/program-types	t	f	f	t
18116	1		/locations/bonus	t	f	f	t
18117	1		/file/provider	t	f	f	t
18118	1		/file/provider/set-user-provider	t	f	f	t
18119	1		/file/make-workspace	t	f	f	t
18120	1		/user/role	t	f	f	t
18121	1		/user/role/:id/set	t	f	f	t
18122	1		/user/group	t	f	f	t
18123	1		/user/group/:id/set	t	f	f	t
18124	1		/user/group/:id/unset	t	f	f	t
18125	1		/user/action	t	f	f	t
18126	1		/user/handbook/groups	t	f	f	t
18127	1		/user/handbook	t	f	f	t
18128	1		/user/handbook/set	t	f	f	t
18129	1		/user/handbook/unset	t	f	f	t
18130	1		/user/comments	t	f	f	t
18131	1		/user/competitors	t	f	f	t
18132	1		/user/client	t	f	f	t
18133	1		/user/client/:id/worker	t	f	f	t
18134	1		/user/client/:id/level	t	f	f	t
18135	1		/user/msp/sub	t	f	f	t
18136	1		/user/msp	t	f	f	t
18137	1		/user/account-settings/payment	t	t	t	t
18138	1		/user/payments	t	t	t	t
18139	1		/locations/shops/:id/apply-for-current-user	f	f	t	f
5830	3		/notifications/communication/:id	t	t	t	t
5831	3		/notifications/communications	t	t	t	t
5832	3		/notifications/communication	t	t	t	t
5833	3		/notifications/communication/:id/set	t	t	t	t
5834	3		/notifications/communication/:id/delete	t	t	t	t
5835	3		/notifications/communication/:id/users	t	t	t	t
5836	3		/notifications/communication/:id/update	t	t	t	t
5837	3		/notifications/templates	t	t	t	t
5838	3		/notifications/template/:id	t	t	t	t
5839	3		/notifications/template/communication/:communicationId	t	t	t	t
5840	3		/notifications/template/action/:actionId	t	t	t	t
5841	3		/notifications/template	t	t	t	t
5842	3		/notifications/template/render/:id	t	t	t	t
5843	3		/notifications/send	t	t	t	t
5844	3		/locations/healthController	t	t	t	t
5845	3		/locations/group/change-locations	t	t	t	t
5846	3		/locations/group-client-set	t	t	t	t
5847	3		/locations/groups	t	t	t	t
5848	3		/locations/group/:id	t	t	t	t
5849	3		/locations/group	t	t	t	t
5850	3		/locations/locations	t	t	t	t
5851	3		/locations/location/:id	t	t	t	t
5852	3		/locations/locations/ids	t	t	t	t
5853	3		/locations/location/test	t	t	t	t
5854	3		/locations/location/status	t	t	f	t
5855	3		/locations/location-status/:id	t	t	t	t
5856	3		/locations/countries	t	t	t	t
5857	3		/locations/countries/:countryCode/city	t	t	t	t
5858	3		/locations/countries/:countryCode/regions	t	t	t	t
18140	1		/locations/shops/approve-application	f	f	t	f
18141	1		/locations/shops/applications/pending	t	f	f	f
18142	1		/questionnaire/answer-by-shop-ids	t	f	f	f
18143	1		/questionnaire/quest-by-shop/:id	t	f	f	f
5859	3		/locations/regions/:regionId/cities	t	t	t	t
5860	3		/locations/countries/:countryCode	t	t	t	t
5861	3		/locations/regions/:regionId	t	t	t	t
5862	3		/locations/cities/:cityId	t	t	t	t
5863	3		/locations/locationInfo	t	t	t	t
5864	3		/locations/shopping/executions	t	t	t	t
5865	3		/locations/shopping/executions-confirm	t	t	t	t
5866	3		/locations/shopping/executions-submit	t	t	t	t
5867	3		/locations/shopping/executions-duplicate	t	t	t	t
5868	3		/locations/shopping/received-visit/:id	t	t	t	t
5869	3		/user/healthController	t	t	f	t
5870	3		/user/cacheReset	t	t	f	t
5871	3		/user/access	t	t	f	t
5872	3		/user/verify-contact	t	t	f	t
5873	3		/user/check-contact	t	t	f	t
5874	3		/user/auth/sign-up	t	t	f	t
5875	3		/user/auth/sign-in	t	t	f	t
5876	3		/user/auth/forgot-password	t	t	f	t
5877	3		/user/auth/reset-password	t	t	f	t
5878	3		/user/auth/confirm-account	t	t	f	t
5879	3		/user/auth/check-code	t	t	f	t
5880	3		/user/me	t	t	f	t
5881	3		/user/user-additional	t	t	f	t
5882	3		/user/refresh-token	t	t	f	t
5883	3		/user/auth/auto-login	t	t	f	t
5884	3		/user/role	t	t	f	t
5885	3		/user/role/:id	t	t	t	t
5886	3		/user/role/:id/set	t	t	f	t
5887	3		/user/role/:id/unset	t	t	f	t
5888	3		/user/group	t	t	f	t
5889	3		/user/group/:id	t	t	t	t
5890	3		/user/group/:id/set	t	t	f	t
5891	3		/user/group/:id/unset	t	t	f	t
5892	3		/user/action	t	t	f	t
5893	3		/user/action/:id	t	t	t	t
5894	3		/user/handbook/groups	t	t	f	t
5895	3		/user/handbook/groups/:id	t	t	t	t
5896	3		/user/handbook	t	t	f	t
5897	3		/user/handbook/:id	t	t	t	t
5898	3		/user/handbook/code/:code	t	t	f	t
5899	3		/user/handbook/set	t	t	f	t
5900	3		/user/handbook/unset	t	t	f	t
5901	3		/user/users	t	t	t	t
5902	3		/user/shoppers	t	t	f	t
5903	3		/user/users/:id/base	t	t	f	t
5904	3		/user/users/:id/fields	t	t	f	t
5905	3		/user/users/:id	t	t	t	t
5906	3		/user/users/ids	t	t	f	t
5907	3		/user/users/restore	t	t	t	t
5908	3		/user/access/client/set	t	t	t	t
5909	3		/user/access/client/unset	t	t	t	t
5910	3		/user/access/client/flush	t	t	f	t
5911	3		/user/users/:id/activity-status	t	t	f	t
5912	3		/user/settings	t	t	t	t
5913	3		/user/comments	t	t	f	t
5914	3		/user/comments/:id	t	t	t	t
5915	3		/user/competitors	t	t	f	t
5916	3		/user/competitors/:id	t	t	t	t
5917	3		/user/competitors/bind	t	t	t	t
5918	3		/user/competitors/unbind	t	t	t	t
5919	3		/user/clients	t	t	f	t
5920	3		/user/client/:id/settings	t	t	f	t
5921	3		/user/client/settings	t	t	t	t
5922	3		/user/client/:id/workers	t	t	f	t
5923	3		/user/client/:id/worker/:workerId	t	t	f	t
5924	3		/user/client	t	t	f	t
5925	3		/user/client/:id/worker	t	t	f	t
5926	3		/user/client/:id/level	t	t	f	t
5927	3		/user/msp/sub	t	t	f	t
5928	3		/user/msp	t	t	f	t
5929	3		/file/healthController	t	t	t	t
5930	3		/file/providers	t	t	t	t
5931	3		/file/provider/:id	t	t	t	t
5932	3		/file/provider	t	t	t	t
5933	3		/file/provider/set-user-provider	t	t	t	t
5934	3		/file/make-workspace	t	t	t	t
5935	3		/file/upload	t	t	t	t
5936	3		/file/uploads	t	t	t	t
5937	3		/file/read/:provider/*	t	t	t	t
5938	3		/notifications/healthController	t	t	t	t
5939	3		/notifications/actions	t	t	t	t
5940	3		/notifications/action/code/:code	t	t	t	t
5941	3		/notifications/action/:id	t	t	t	t
5942	3		/notifications/action	t	t	t	t
5943	3		/locations/shopping/visit-list	t	t	t	t
5944	3		/locations/shopping/execution-list	t	t	t	t
5945	3		/locations/shopping/executions/status	t	t	t	t
5946	3		/locations/shopping/executions/:id	t	t	t	t
5947	3		/locations/shopping/executions/delete-all	t	t	t	t
5948	3		/locations/program-types	t	t	t	t
5949	3		/locations/program-type/status	t	t	t	t
5950	3		/locations/program-type/delete-all	t	t	t	t
5951	3		/locations/program-type/:id	t	t	t	t
5952	3		/locations/bonus	t	t	t	t
5953	3		/locations/bonus/delete-all	t	t	t	t
5954	3		/locations/bonus/status	t	t	t	t
5955	3		/locations/bonus/:id	t	t	t	t
5956	3		/locations/client/:id/level	t	t	t	t
5957	3		/locations/access/execution/:user_id	t	t	t	t
5958	3		/locations/access/program/:user_id	t	t	t	t
5959	3		/locations/access/execution/set	t	t	t	t
5960	3		/locations/access/execution/unset	t	t	t	t
5961	3		/locations/access/program/set	t	t	t	t
5962	3		/locations/access/program/unset	t	t	t	t
5963	3		/locations/access/program/flush	t	t	t	t
5964	3		/locations/access/execution/flush	t	t	t	t
5965	3		/import-export/healthController	t	t	t	t
5966	3		/import-export/export/answer-list	t	t	t	t
5967	3		/import-export/export/workers	t	t	t	t
5968	3		/import-export/export/clients	t	t	t	t
5969	3		/import-export/export/shoppers	t	t	t	t
5970	3		/import-export/export/users	t	t	t	t
5971	3		/import-export/export/msp	t	t	t	t
5972	3		/import-export/export/locations	t	t	t	t
5973	3		/import-export/export/location-groups	t	t	t	t
5974	3		/import-export/export/executions	t	t	t	t
5975	3		/import-export/export/program-types	t	t	t	t
5976	3		/import-export/export/pdf/locations	t	t	t	t
18144	1		/questionnaire/answer/send-verify	f	t	f	f
18145	1		/questionnaire/answer/send	f	t	f	f
18146	1		/locations/shops/available	t	f	f	f
18147	1		/locations/shops/job/:id	t	f	f	f
18148	1		/user/favorites-shops	t	t	f	f
18149	1		/user/favorites-shops/:shop_id	f	f	f	t
18150	1		/locations/shops/favorites-shops-list	t	f	f	f
18151	1		/locations/shopping/suggested-visits	t	f	f	f
18152	1		/locations/shops/:id/apply-assigned-for-current-user	f	f	t	f
18153	1		/user/jobs	t	f	f	f
18154	1		/user/jobs/:id	t	f	f	f
18354	4		/questionnaire/client/answers/:id/files	t	t	t	f
18355	4		/questionnaire/client/answers/:id	t	t	t	f
18356	4		/import-export/healthController	t	f	f	f
18357	4		/import-export/export/answer-client-data	t	f	f	f
18358	4		/import-export/export/client-answers	t	f	f	f
18359	4		/import-export/export/survey-validator	t	f	f	f
18360	4		/import-export/export/shops	t	f	f	f
18361	4		/import-export/export/answer-list	t	f	f	f
18362	4		/import-export/export/workers	t	f	f	f
18363	4		/import-export/export/clients	t	f	f	f
18364	4		/import-export/export/shoppers	t	f	f	f
18365	4		/import-export/export/users	t	f	f	f
18366	4		/import-export/export/msp	t	f	f	f
18367	4		/import-export/export/pdf/msp	t	f	f	f
18368	4		/import-export/export/pdf/sub-msp	t	f	f	f
18369	4		/import-export/export/pdf/executions	t	f	f	f
18370	4		/import-export/export/pdf/program-types	t	f	f	f
18371	4		/import-export/import/users	t	f	f	f
18372	4		/import-export/import/clients	t	f	f	f
18373	4		/import-export/import/workers	t	f	f	f
18374	4		/import-export/import/msp	t	f	f	f
18375	4		/import-export/import/sub-msp	t	f	f	f
18376	4		/import-export/import/myMo	t	f	f	f
18377	4		/import-export/import/parse	t	f	f	f
18378	4		/import-export/import/locations	t	f	f	f
18379	4		/import-export/import/location-visits	t	f	f	f
18380	4		/import-export/import/programs	t	f	f	f
18381	4		/locations/shops/available	t	t	t	f
18382	4		/locations/shops/job/:id	t	t	t	f
18383	4		/locations/shops/:id/apply-for-current-user	t	t	t	f
18384	4		/locations/status	t	t	f	f
18385	4		/locations/categories	t	t	t	f
18386	4		/locations/category/:id	t	t	t	f
18387	4		/locations/category	t	f	t	f
18388	4		/locations/category/values/:id	t	t	t	f
18389	4		/locations/category/client-rules/:client_id	t	t	t	f
18390	4		/locations/regions/ids	t	t	t	f
18391	4		/locations/cities/ids	t	t	t	f
18392	4		/locations/group/:id	t	t	t	f
18393	4		/locations/group	t	t	t	f
18394	4		/locations/locations	t	f	t	f
18395	4		/locations/location/:id	t	t	t	f
18396	4		/locations/locations/ids	t	t	t	f
18397	4		/locations/location/test	t	t	t	f
18398	4		/locations/location/status	t	f	f	f
18399	4		/locations/location-status/:id	t	t	t	f
18400	4		/locations/countries	t	t	t	f
18401	4		/locations/countries/:countryCode/city	t	t	t	f
18402	4		/locations/countries/:countryCode/regions	t	t	t	f
18403	4		/locations/regions/:regionId/cities	t	t	t	f
18404	4		/locations/countries/:countryCode	t	t	t	f
18405	4		/locations/regions/:regionId	t	t	t	f
18406	4		/locations/cities/:cityId	t	t	t	f
18407	4		/locations/locationInfo	t	t	t	f
18408	4		/locations/shopping/executions	t	t	t	f
18409	4		/locations/shopping/executions-confirm	t	f	f	f
18410	4		/questionnaire/healthController	t	t	t	f
18411	4		/questionnaire/answer/validator/send	t	t	t	f
18412	4		/questionnaire/answer/validation/:id/status	t	t	t	f
18413	4		/questionnaire/answer/validation/:id/publish	t	t	t	f
18414	4		/questionnaire/answer/validation/:id/unpublish	t	t	t	f
18415	4		/questionnaire/answer/validation/:id	t	t	t	f
18416	4		/questionnaire/answer/validation/:id/accept	t	t	t	f
18417	4		/questionnaire/answer/validation/:id/reject	t	t	t	f
18418	4		/questionnaire/answer/send	t	t	t	f
18419	4		/questionnaire/answer/send-verify	t	t	t	f
18420	4		/questionnaire/quest	t	f	t	f
18421	4		/questionnaire/quest/:id	t	t	t	f
18422	4		/questionnaire/quest-by-shop/:id	t	t	t	f
18423	4		/questionnaire/quest/:id/customization	t	t	t	f
18424	4		/questionnaire/quest/all	t	t	t	f
18425	4		/questionnaire/quest/:id/section	t	t	t	f
18426	4		/questionnaire/quest/:id/nps	t	t	t	f
18427	4		/questionnaire/answer/stats	t	t	t	f
18428	4		/questionnaire/answer/stats/sections	t	t	t	f
18429	4		/questionnaire/answers	t	t	t	f
18430	4		/questionnaire/answer/:id	t	t	t	f
18431	4		/questionnaire/answer/create-execution-link	t	t	t	f
18432	4		/questionnaire/answer/:id/:status	t	t	t	f
18433	4		/questionnaire/answer-by-shop-ids	t	t	t	f
18434	4		/questionnaire/answers/public	t	t	t	f
18435	4		/questionnaire/appeal/group	t	t	t	f
18436	4		/questionnaire/appeal	t	t	t	f
18437	4		/questionnaire/appeal/:id	t	t	t	f
18438	4		/questionnaire/appeal/reply/:appealId	t	t	t	f
18439	4		/questionnaire/appeal-setting/:id	t	t	t	f
18440	4		/questionnaire/appeal-setting	t	t	t	f
18441	4		/questionnaire/appeal/connect-to-questionnaire	t	t	t	f
18442	4		/questionnaire/appeal/manager-reply/:appealId	t	t	t	f
18443	4		/questionnaire/integration/v1/sign-in	t	t	t	f
18444	4		/questionnaire/integration/v1/all	t	t	t	f
18445	4		/questionnaire/integration/v1/answer/:id	t	t	t	f
18446	4		/questionnaire/integration/v2/repair-survey	t	t	t	f
18447	4		/questionnaire/integration/v2/sign-in	t	t	t	f
18448	4		/questionnaire/integration/v2/all	t	t	t	f
18449	4		/questionnaire/integration/v2/answer/:id	t	t	t	f
18450	4		/questionnaire/integration/v2/links/:id	t	t	t	f
18451	4		/questionnaire/integration/v2/create-link/:id	t	t	t	f
18452	4		/questionnaire/integration/v2/store-questionnaire	t	t	t	f
18453	4		/questionnaire/integration/v2/sync/:id	t	t	t	f
18454	4		/user/competitors/bind	t	f	f	f
18455	4		/user/competitors/unbind	t	f	f	f
18456	4		/file/provider	t	f	f	f
18457	4		/file/provider/set-user-provider	t	f	f	f
18458	4		/file/make-workspace	t	t	f	f
18459	4		/file/upload	t	t	f	f
18460	4		/file/uploads	t	t	f	f
18461	4		/file/read/:provider/*	t	f	f	f
18462	4		/locations/healthController	f	t	t	f
18463	4		/locations/group/change-locations	t	t	t	f
18464	4		/locations/group-client-set	t	t	t	f
18465	4		/locations/groups	t	f	t	f
18466	4		/locations/shopping/executions-submit	t	f	t	f
18467	4		/locations/shopping/executions-duplicate	t	f	t	f
18468	4		/locations/shopping/received-visit/:id	t	t	t	f
18469	4		/locations/shopping/visit-list	t	t	t	f
18470	4		/locations/shopping/execution-list	t	t	t	f
18471	4		/locations/shopping/executions/status	t	t	t	f
18472	4		/locations/shopping/executions/:id	t	t	t	f
18473	4		/locations/shopping/executions/delete-all	t	t	t	f
18474	4		/locations/program-types	t	t	t	f
18475	4		/locations/program-type/status	t	t	t	f
18476	4		/locations/program-type/delete-all	t	t	t	f
18477	4		/locations/program-type/:id	t	t	t	f
18478	4		/locations/bonus	f	f	t	f
18479	4		/locations/bonus/delete-all	t	t	t	f
18480	4		/locations/bonus/status	t	t	f	f
18481	4		/locations/bonus/:id	f	t	f	f
18482	4		/locations/client/:id/level	t	t	t	f
18483	4		/locations/access/execution/:user_id	t	t	t	f
18484	4		/locations/access/program/:user_id	t	t	t	f
18485	4		/user/feedback-clients/:id	t	f	t	t
18486	4		/locations/access/execution/set	t	t	f	f
18487	4		/locations/access/execution/unset	t	t	f	f
18488	4		/locations/access/program/set	t	t	f	f
18489	4		/locations/access/program/unset	t	t	f	f
18490	4		/locations/access/program/flush	t	t	t	f
18491	4		/locations/access/execution/flush	t	t	t	f
18492	4		/questionnaire/test	t	f	f	f
18493	4		/social-service/healthController	t	f	f	f
18494	4		/social-service/statistics	t	f	f	f
18495	4		/backup/healthController	t	f	f	f
18496	4		/backup/	t	f	f	f
18497	4		/backup/restore	t	f	f	f
18498	4		/backup/:fileName	t	f	f	f
18499	4		/questionnaire/mistakes	t	t	t	f
18500	4		/questionnaire/mistakes/:id	t	t	t	f
18501	4		/questionnaire/validator-comments	t	t	t	f
18502	4		/questionnaire/validator-comment/:id	t	t	t	f
18503	4		/questionnaire/validator-comment	t	t	t	f
18504	4		/questionnaire/answer-histories	t	t	t	f
18505	4		/questionnaire/answer-history/:id	t	t	t	f
18506	4		/questionnaire/answer-history	t	t	t	f
18507	4		/questionnaire/client/answers	t	t	t	f
18508	4		/import-export/export/sub-msp	t	f	f	f
18509	4		/import-export/export/locations	t	f	f	f
18510	4		/import-export/export/location-visit	t	f	f	f
18511	4		/import-export/export/location-groups	t	f	f	f
18512	4		/import-export/export/executions	t	f	f	f
18513	4		/import-export/export/program-types	t	f	f	f
18514	4		/import-export/export/pdf/locations	t	f	f	f
18515	4		/import-export/export/pdf/location-groups	t	f	f	f
18516	4		/import-export/export/pdf/workers	t	f	f	f
18517	4		/import-export/export/pdf/clients	t	f	f	f
18518	4		/import-export/export/pdf/shoppers	t	f	f	f
5977	3		/import-export/export/pdf/location-groups	t	t	t	t
5978	3		/import-export/export/pdf/workers	t	t	t	t
5979	3		/import-export/export/pdf/clients	t	t	t	t
5980	3		/import-export/export/pdf/shoppers	t	t	t	t
5981	3		/import-export/export/pdf/users	t	t	t	t
5982	3		/import-export/export/pdf/msp	t	t	t	t
18519	4		/import-export/export/pdf/users	t	f	f	f
18520	4		/locations/shopping/executions/connect-questionnaire	t	f	t	f
18521	4		/locations/shopping/executions/disconnect-questionnaire	t	f	t	f
18522	4		/locations/shopping/executions/:id/start-project	t	f	t	f
18523	4		/locations/program-type/connect-questionnaire	t	f	t	f
18524	4		/locations/program-type/disconnect-questionnaire	t	f	t	f
18525	4		/locations/client/:id/rules	t	t	t	f
18526	4		/locations/shops/approve-application	t	t	t	f
18527	4		/locations/shops/project/view	t	t	t	f
18528	4		/locations/shops/update-status	t	t	t	f
18529	4		/locations/shops	t	t	t	f
18530	4		/locations/shops/:id	t	t	t	f
18531	4		/locations/shops/set-respondent	t	t	t	f
5983	3		/import-export/export/pdf/executions	t	t	t	t
5984	3		/import-export/export/pdf/program-types	t	t	t	t
5985	3		/import-export/import/users	t	t	t	t
5986	3		/import-export/import/clients	t	t	t	t
5987	3		/import-export/import/workers	t	t	t	t
5988	3		/import-export/import/msp	t	t	t	t
5989	3		/import-export/import/myMo	t	t	t	t
5990	3		/import-export/import/parse	t	t	t	t
5991	3		/import-export/import/locations	t	t	t	t
5992	3		/import-export/import/programs	t	t	t	t
5993	3		/questionnaire/healthController	t	t	t	t
5994	3		/questionnaire/quest	t	t	t	t
5995	3		/questionnaire/quest/:id	t	t	t	t
5996	3		/questionnaire/test	t	t	t	t
18532	4		/locations/shops/:id/pay-and-rating	t	t	t	f
18533	4		/locations/shops/by-respondent/:respondent_id	t	t	t	f
18534	4		/locations/shops/check-location	t	t	t	f
18535	4		/locations/shops/by-hash/:hash	t	t	t	f
18536	4		/locations/shops/:id/status	t	t	t	f
18537	4		/locations/shops/:id/progress	t	t	t	f
18538	4		/locations/shops/:id/set-answer	t	t	t	f
18539	4		/locations/shops/applications/pending	t	t	t	f
18540	4		/locations/quality-control/executions-stats	t	t	t	f
18541	4		/locations/execution-type	t	f	t	f
18542	4		/locations/execution-type/:id	t	t	t	f
18543	4		/locations/execution/:id/types	t	t	t	f
18544	4		/locations/wave	t	f	t	f
18545	4		/locations/wave/:waveId	t	t	t	f
18546	4		/locations/wave/:waveId/shops	t	f	t	f
18547	4		/locations/shops/:shopId/wave	t	t	t	f
18548	4		/notifications/communication/:id/users	t	f	f	f
18549	4		/notifications/read/:id	f	f	t	f
18550	4		/notifications/send	t	f	f	f
18551	4		/notifications/user/notification	t	f	f	f
18552	4		/user/healthController	t	f	f	f
18553	4		/user/access	t	f	f	f
18554	4		/user/verify-contact	t	f	f	f
18555	4		/user/check-contact	t	f	f	f
18556	4		/user/auth/sign-up	t	f	f	f
18557	4		/user/auth/sign-in	t	f	f	f
18558	4		/user/auth/forgot-password	t	f	f	f
18559	4		/user/auth/reset-password	t	f	f	f
18560	4		/user/auth/confirm-account	t	f	f	f
18561	4		/user/auth/check-code	t	f	f	f
18562	4		/user/me	t	f	f	f
18563	4		/user/user-additional	t	f	f	f
18564	4		/user/refresh-token	t	f	f	f
18565	4		/user/auth/auto-login	t	f	f	f
18566	4		/user/role	t	f	f	f
18567	4		/user/role/:id	t	f	f	f
18568	4		/user/role/:id/set	t	f	f	f
18569	4		/user/role/:id/unset	t	f	f	f
18570	4		/user/group	t	f	f	f
18571	4		/user/group/:id	t	f	f	f
18572	4		/user/group/:id/set	t	f	f	f
18573	4		/user/group/:id/unset	t	f	f	f
18574	4		/user/action	t	f	f	f
18575	4		/user/action/:id	t	f	f	f
18576	4		/user/handbook/groups	t	f	f	f
18577	4		/user/handbook/groups/:id	t	f	f	f
18578	4		/user/handbook	t	f	f	f
18579	4		/user/handbook/:id	t	f	f	f
18580	4		/user/handbook/code/:code	t	f	f	f
18581	4		/user/handbook/set	t	f	f	f
18582	4		/user/handbook/unset	t	f	f	f
18583	4		/user/handbook/:handbook_code	t	f	f	f
18584	4		/user/handbook/:handbook_code/:value_code	t	f	f	f
18585	4		/user/users	t	f	f	f
18586	4		/user/shoppers	t	f	f	f
18587	4		/user/users/names	t	f	f	f
18588	4		/user/users/:id/mini	t	f	f	f
18589	4		/user/users/:id/base	t	f	f	f
18590	4		/user/users/:id/fields	t	f	f	f
18591	4		/user/users/:id	t	f	f	f
18592	4		/user/shopper/:id/rating	t	f	f	f
18593	4		/user/users/ids	t	f	f	f
18594	4		/user/users/restore	t	f	f	f
18595	4		/user/access/client/set	t	f	f	f
18596	4		/user/access/client/unset	t	f	f	f
18597	4		/user/access/client/flush	t	f	f	f
18598	4		/user/users/:id/activity-status	t	f	f	f
18599	4		/user/settings	t	f	f	f
18600	4		/user/customizations	t	f	f	f
18601	4		/user/comments	t	f	f	f
18602	4		/user/comments/:id	t	f	f	f
18603	4		/user/competitors	t	f	f	f
18604	4		/user/competitors/:id	t	f	f	f
18605	4		/user/my-access	t	f	f	f
18606	4		/user/clients	t	f	f	f
18607	4		/user/client/:id/settings	t	f	f	f
18608	4		/user/client/settings	t	f	f	f
18609	4		/user/client/:id/workers	t	f	f	f
18610	4		/user/client/:id/worker/:workerId	t	f	f	f
18611	4		/user/client	t	f	f	f
18612	4		/user/client/:id/worker	t	f	f	f
18613	4		/user/client/:id/level	t	f	f	f
18614	4		/user/msp/sub	t	f	f	f
18615	4		/user/msp	t	f	f	f
18616	4		/user/user-worker-groups	t	f	f	f
18617	4		/user/user-worker-groups/:id	t	f	f	f
18618	4		/user/tasks	t	t	f	f
18619	4		/user/tasks/:id	t	f	t	t
18620	4		/user/tasks/:id/employee-comment	t	t	f	f
18621	4		/user/task/education	t	t	f	f
18622	4		/user/tasks/close/:id	t	f	t	f
18623	4		/user/feedback-clients	t	t	f	f
18624	4		/user/feedback-clients/employ	t	t	f	f
18625	4		/user/feedback-clients/closed	t	t	f	f
18626	4		/user/account-settings/payment	t	f	f	f
18627	4		/user/payments	t	f	f	f
18628	4		/locations/client/request	f	t	f	f
18629	4		/questionnaire/appeal/client-accepted/:id	f	f	t	f
18630	4		/user/client/message-office	f	t	f	f
18631	4		/user/tasks/redirect/:id	f	f	t	f
18632	4		/questionnaire/client/reporting/main-report	t	f	f	f
18633	4		/import-export/import/my-mo	t	t	f	f
18634	4		/questionnaire/client/reporting/chart	f	t	f	f
18635	4		/questionnaire/widgets/add-to-client	f	t	f	f
18636	4		/questionnaire/widgets/my-widgets	t	f	f	f
18637	4		/questionnaire/widgets	t	f	f	f
18638	4		/user/worker/xm-setting	t	f	t	f
18639	4		/questionnaire/widgets/delete-to-client/:id	f	f	f	t
18640	4		/questionnaire/widgets/sorts	f	f	t	f
18641	4		/questionnaire/answer/:id/status	t	f	f	f
18642	4		/user/worker/xm-statistics	t	f	f	f
18643	4		/questionnaire/widgets/update-to-client/:id	f	f	t	f
18644	4		/questionnaire/widgets/cjm	f	t	f	f
18645	4		/questionnaire/client/quest/project/:id	t	f	f	f
18646	4		/questionnaire/widgets/cjm/page	f	t	f	f
18647	4		/user/worker/cjm-setting	t	f	f	f
18648	4		/questionnaire/client/reporting/drill-analysis	f	t	f	f
18649	4		/questionnaire/widgets/default	f	t	f	f
5997	3		/questionnaire/answer/stats	t	t	t	t
5998	3		/questionnaire/answer/stats/sections	t	t	t	t
5999	3		/questionnaire/answers	t	t	t	t
6000	3		/questionnaire/answer/:id	t	t	t	t
6001	3		/questionnaire/answer/:id/:status	t	t	t	t
6002	3		/questionnaire/answer/create-execution-link	t	t	t	t
6003	3		/questionnaire/appeal	t	t	t	t
6004	3		/questionnaire/appeal/:id	t	t	t	t
6005	3		/questionnaire/appeal/reply/:appealId	t	t	t	t
6006	3		/questionnaire/appeal/manager-reply/:appealId	t	t	t	t
6007	3		/questionnaire/integration/v1/sign-in	t	t	t	t
6008	3		/questionnaire/integration/v1/all	t	t	t	t
6009	3		/questionnaire/integration/v1/answer/:id	t	t	t	t
6010	3		/questionnaire/integration/v2/sign-in	t	t	t	t
6011	3		/questionnaire/integration/v2/all	t	t	t	t
6012	3		/questionnaire/integration/v2/answer/:id	t	t	t	t
6013	3		/social-service/healthController	t	t	t	t
6014	3		/social-service/statistics	t	t	t	t
6015	3		/backup/healthController	t	t	f	t
6016	3		/backup/list	t	t	f	t
6017	3		/backup/	t	t	f	t
6018	3		/backup/restore	t	t	f	t
6019	3		/backup/:fileName	t	t	f	t
6020	3		/locations/shops/set-respondent	t	t	t	t
6021	3		/locations/shops/:id	t	t	t	t
6022	3		/locations/status	t	t	t	t
6023	3		/notifications/communication/:user_id/users	t	t	t	t
6024	3		/notifications/communication/:user_id/clear	t	t	t	t
6025	3		/locations/shops	t	t	t	t
6026	3		/import-export/import/sub-msp	t	t	t	t
6027	3		/import-export/export/pdf/sub-msp	t	t	t	t
6028	3		/import-export/export/sub-msp	t	t	t	t
6029	3		/locations/shopping/executions/connect-questionnaire	t	t	t	t
6030	3		/locations/program-type/connect-questionnaire	t	t	t	t
6031	3		/locations/shops/by-respondent/:respondent_id	t	t	t	t
6032	3		/locations/shops/check-location	t	t	t	t
6033	3		/questionnaire/integration/v2/links/:id	t	t	t	t
6034	3		/questionnaire/integration/v2/store-questionnaire	t	t	t	t
6035	3		/questionnaire/integration/v2/create-link/:id	t	t	t	t
6036	3		/questionnaire/quest/all	t	t	t	t
6037	3		/user/customizations	t	f	f	f
\.


--
-- Data for Name: role_user_link; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.role_user_link (id, role_id, user_id) FROM stdin;
3	1	3
2	7	2
4	7	4
5	1	5
6	2	6
7	6	7
8	6	8
9	4	9
10	4	10
11	1	11
12	2	12
13	1	13
14	1	14
15	1	15
16	1	16
17	2	17
18	1	18
19	2	19
20	4	20
1	1	1
21	6	21
\.


--
-- Data for Name: roles; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.roles (id, name, default_role, access_pages, deleted_at, delete_at, access_page_manager) FROM stdin;
3	Manager	f	[{"name": "User", "path": "/crm/users", "view": true, "routes": [{"name": "User List", "path": "/crm/users", "view": true}, {"name": "Clients", "path": "/crm/users/clients", "view": true}, {"name": "Shoppers", "path": "/crm/users/shoppers", "view": true}, {"name": "Group", "path": "/crm/users/groups", "view": true}, {"name": "Role", "path": "/crm/users/role", "view": true}, {"name": "Settings", "path": "/crm/users/settings/edit", "view": true}]}, {"name": "Handbook", "path": "/crm/handbook", "view": true, "routes": [{"name": "Group", "path": "/crm/handbook/group", "view": true}, {"name": "Handbook", "path": "/crm/handbook", "view": true}]}, {"name": "Notifications", "path": "/notifications", "view": true, "routes": [{"name": "Providers", "path": "/crm/notifications/providers", "view": true}, {"name": "Templates", "path": "/crm/notifications/templates", "view": true}, {"name": "Action", "path": "/crm/notifications/actions", "view": true}]}, {"name": "Locations", "path": "/crm/locations", "view": true, "routes": [{"name": "Locations Group", "path": "/crm/locations/groups?page=1&parent_id=0", "view": true}, {"name": "Locations", "path": "/crm/locations", "view": true}]}]	\N	\N	{}
5	Competitor	f	[]	\N	\N	{}
7	Admin	f	[{"name": "User", "path": "/crm/users", "view": true, "routes": [{"name": "User List", "path": "/crm/users", "view": true}, {"name": "Clients", "path": "/crm/users/clients", "view": true}, {"name": "Shoppers", "path": "/crm/users/shoppers", "view": true}, {"name": "Group", "path": "/crm/users/groups", "view": true}, {"name": "Role", "path": "/crm/users/role", "view": true}, {"name": "Settings", "path": "/crm/users/settings/edit", "view": true}]}, {"name": "Handbook", "path": "/crm/handbook", "view": true, "routes": [{"name": "Group", "path": "/crm/handbook/group", "view": true}, {"name": "Handbook", "path": "/crm/handbook", "view": true}]}, {"name": "Notifications", "path": "/notifications", "view": true, "routes": [{"name": "Providers", "path": "/crm/notifications/providers", "view": true}, {"name": "Templates", "path": "/crm/notifications/templates", "view": true}, {"name": "Action", "path": "/crm/notifications/actions", "view": true}]}, {"name": "Locations", "path": "/crm/locations", "view": true, "routes": [{"name": "Locations Group", "path": "/crm/locations/groups", "view": true}, {"name": "Locations", "path": "/crm/locations", "view": true}, {"name": "Geodata", "path": "/crm/locations/geodata", "view": true}]}, {"name": "Backup", "path": "/crm/backup-service", "view": false, "routes": [{"name": "Backup List", "path": "/crm/backup-service", "view": true}]}, {"name": "Appeals", "path": "/crm/appeals", "view": true, "routes": [{"name": "Statuses", "path": "/crm/appeals/statuses", "view": true}]}]	\N	\N	[{"icon": {"src": "/_next/static/media/assistant_on_hub.9a71e975.svg", "width": 24, "height": 24, "blurWidth": 0, "blurHeight": 0}, "path": "/manager", "view": false, "title": "dashboard"}, {"icon": {"src": "/_next/static/media/project_health.14b2ef7d.svg", "width": 24, "height": 24, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/project-health", "view": true, "title": "projectHealth", "options": [{"path": "/manager/project-health", "view": true, "title": "pmt"}, {"path": "/manager/project-health/project-management-health", "view": true, "title": "pmh"}, {"path": "/manager/project-health/timeline", "view": true, "title": "timeline"}, {"path": "/manager/project-health/calendar", "view": true, "title": "calendar"}]}, {"icon": {"src": "/_next/static/media/search_hands_free.09b2c6db.svg", "width": 20, "height": 20, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/scheduling", "view": true, "title": "scheduling", "options": [{"path": "/manager/scheduling", "view": true, "title": "shops"}, {"path": "/manager/scheduling/applicants", "view": true, "title": "applicants"}, {"path": "/manager/scheduling/route-applicants", "view": true, "title": "routeApplicants"}]}, {"icon": {"src": "/_next/static/media/user_3.c7d03726.svg", "width": 20, "height": 16, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/quality-control", "view": true, "title": "qualityControl", "options": [{"path": "/manager/quality-control/project-surveys", "view": true, "title": "project-surveys"}, {"path": "/manager/quality-control/appeals", "view": true, "title": "appeals"}, {"path": "/manager/quality-control/ai-trust-score", "view": true, "title": "ai-trust-score"}, {"path": "/manager/quality-control/survey-queue", "view": true, "title": "survey-queue"}]}, {"icon": {"src": "/_next/static/media/search_hands_free.09b2c6db.svg", "width": 20, "height": 20, "blurWidth": 0, "blurHeight": 0}, "path": "manager/survey-management/project-surveys", "view": true, "title": "surveysManagement", "options": [{"path": "/manager/survey-management/project-surveys", "view": true, "title": "projectSurveys"}]}, {"icon": {"src": "/_next/static/media/vue_sax.8645ea47.svg", "width": 19, "height": 19, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/shopper-database", "view": true, "title": "shopperDatabase", "options": [{"path": "/manager/shopper-database/shoppers", "view": true, "title": "shoppers"}, {"path": "/manager/shopper-database/shopper-routes", "view": true, "title": "shopperRoutes"}]}, {"icon": {"src": "/_next/static/media/apps.c83c30be.svg", "width": 19, "height": 20, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/projects", "view": true, "title": "projects", "options": [{"path": "/manager/projects", "view": true, "title": "project"}, {"path": "/manager/projects/surveys", "view": true, "title": "surveys"}, {"path": "/manager/projects/swap-shops", "view": true, "title": "swapShops"}]}, {"icon": {"src": "/_next/static/media/clock_loader.c75fc8c7.svg", "width": 23, "height": 23, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/programs", "view": true, "title": "programs"}, {"icon": {"src": "/_next/static/media/person_apron.8810452f.svg", "width": 19, "height": 20, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/clients", "view": true, "title": "clients", "options": [{"path": "/manager/clients", "view": true, "title": "clients"}, {"path": "/manager/clients/locations/groups", "view": true, "title": "location_groups"}, {"path": "/manager/clients/locations", "view": true, "title": "locations"}, {"path": "/manager/clients/client-level", "view": true, "title": "clientLevel"}, {"path": "/manager/clients/client-users", "view": true, "title": "clientUsers"}, {"path": "/manager/clients/client-groups", "view": true, "title": "clientGroups"}]}, {"icon": {"src": "/_next/static/media/badge.19ddda87.svg", "width": 20, "height": 21, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/staff", "view": true, "title": "staff", "options": [{"path": "/manager/staff/msp-users", "view": true, "title": "mspUsers"}, {"path": "/manager/staff/sub-msp", "view": true, "title": "subMSPs"}, {"path": "/manager/settings", "view": true, "title": "settings"}]}, {"icon": {"src": "/_next/static/media/monetization.4185c074.svg", "width": 20, "height": 21, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/payment", "view": true, "title": "payment", "options": [{"path": "/manager/payments/package", "view": true, "title": "paymentPackage"}, {"path": "/manager/payments/setting", "view": true, "title": "paymentSetting"}]}, {"icon": {"src": "/_next/static/media/settings_manager.63be6fff.svg", "width": 24, "height": 25, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/settings", "view": true, "title": "settings", "options": [{"path": "/manager/settings/personal-data", "view": true, "title": "personalData"}, {"path": "/manager/settings/notification-settings", "view": true, "title": "notificationSettings"}, {"path": "/manager/settings/msp-customization", "view": true, "title": "mspCustomization"}, {"path": "/manager/settings/msp-dictionary", "view": true, "title": "mspDictionary"}, {"path": "/manager/settings/msp-operations-settings", "view": true, "title": "mspOperationsSettings"}]}]
6	MSP	f	[{"name": "User", "path": "/crm/users", "view": false, "routes": [{"name": "User List", "path": "/crm/users", "view": false}, {"name": "Clients", "path": "/crm/users/clients", "view": false}, {"name": "Shoppers", "path": "/crm/users/shoppers", "view": false}, {"name": "Group", "path": "/crm/users/groups", "view": false}, {"name": "Role", "path": "/crm/users/role", "view": false}, {"name": "Settings", "path": "/crm/users/settings/edit", "view": false}]}, {"name": "Handbook", "path": "/crm/handbook", "view": false, "routes": [{"name": "Group", "path": "/crm/handbook/group", "view": false}, {"name": "Handbook", "path": "/crm/handbook", "view": false}]}, {"name": "Notifications", "path": "/notifications", "view": false, "routes": [{"name": "Providers", "path": "/crm/notifications/providers", "view": false}, {"name": "Templates", "path": "/crm/notifications/templates", "view": false}, {"name": "Action", "path": "/crm/notifications/actions", "view": false}]}, {"name": "Locations", "path": "/crm/locations", "view": false, "routes": [{"name": "Locations Group", "path": "/crm/locations/groups", "view": false}, {"name": "Locations", "path": "/crm/locations", "view": false}, {"name": "Geodata", "path": "/crm/locations/geodata", "view": false}]}, {"name": "Backup", "path": "/crm/backup-service", "view": false, "routes": [{"name": "Backup List", "path": "/crm/backup-service", "view": false}]}, {"name": "Appeals", "path": "/crm/appeals", "view": false, "routes": [{"name": "Statuses", "path": "/crm/appeals/statuses", "view": false}]}]	\N	\N	[{"icon": {"src": "/_next/static/media/assistant_on_hub.9a71e975.svg", "width": 24, "height": 24, "blurWidth": 0, "blurHeight": 0}, "path": "/manager", "view": false, "title": "dashboard"}, {"icon": {"src": "/_next/static/media/project_health.14b2ef7d.svg", "width": 24, "height": 24, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/project-health", "view": true, "title": "projectHealth", "options": [{"path": "/manager/project-health", "view": true, "title": "pmt"}, {"path": "/manager/project-health/project-management-health", "view": true, "title": "pmh"}, {"path": "/manager/project-health/timeline", "view": true, "title": "timeline"}, {"path": "/manager/project-health/calendar", "view": true, "title": "calendar"}]}, {"icon": {"src": "/_next/static/media/search_hands_free.09b2c6db.svg", "width": 20, "height": 20, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/scheduling", "view": true, "title": "scheduling", "options": [{"path": "/manager/scheduling", "view": true, "title": "shops"}, {"path": "/manager/scheduling/applicants", "view": true, "title": "applicants"}, {"path": "/manager/scheduling/route-applicants", "view": true, "title": "routeApplicants"}]}, {"icon": {"src": "/_next/static/media/user_3.c7d03726.svg", "width": 20, "height": 16, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/quality-control", "view": true, "title": "qualityControl", "options": [{"path": "/manager/quality-control/project-surveys", "view": true, "title": "project-surveys"}, {"path": "/manager/quality-control/appeals", "view": true, "title": "appeals"}, {"path": "/manager/quality-control/ai-trust-score", "view": true, "title": "ai-trust-score"}, {"path": "/manager/quality-control/survey-queue", "view": true, "title": "survey-queue"}]}, {"icon": {"src": "/_next/static/media/search_hands_free.09b2c6db.svg", "width": 20, "height": 20, "blurWidth": 0, "blurHeight": 0}, "path": "manager/survey-management/project-surveys", "view": true, "title": "surveysManagement", "options": [{"path": "/manager/survey-management/project-surveys", "view": true, "title": "projectSurveys"}]}, {"icon": {"src": "/_next/static/media/vue_sax.8645ea47.svg", "width": 19, "height": 19, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/shopper-database", "view": true, "title": "shopperDatabase", "options": [{"path": "/manager/shopper-database/shoppers", "view": true, "title": "shoppers"}, {"path": "/manager/shopper-database/shopper-routes", "view": true, "title": "shopperRoutes"}]}, {"icon": {"src": "/_next/static/media/apps.c83c30be.svg", "width": 19, "height": 20, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/projects", "view": true, "title": "projects", "options": [{"path": "/manager/projects", "view": true, "title": "project"}, {"path": "/manager/projects/surveys", "view": true, "title": "surveys"}, {"path": "/manager/projects/swap-shops", "view": true, "title": "swapShops"}]}, {"icon": {"src": "/_next/static/media/clock_loader.c75fc8c7.svg", "width": 23, "height": 23, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/programs", "view": true, "title": "programs"}, {"icon": {"src": "/_next/static/media/person_apron.8810452f.svg", "width": 19, "height": 20, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/clients", "view": true, "title": "clients", "options": [{"path": "/manager/clients", "view": true, "title": "clients"}, {"path": "/manager/clients/locations/groups", "view": true, "title": "location_groups"}, {"path": "/manager/clients/locations", "view": true, "title": "locations"}, {"path": "/manager/clients/client-level", "view": true, "title": "clientLevel"}, {"path": "/manager/clients/client-users", "view": true, "title": "clientUsers"}, {"path": "/manager/clients/client-groups", "view": true, "title": "clientGroups"}]}, {"icon": {"src": "/_next/static/media/badge.19ddda87.svg", "width": 20, "height": 21, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/staff", "view": true, "title": "staff", "options": [{"path": "/manager/staff/msp-users", "view": true, "title": "mspUsers"}, {"path": "/manager/staff/sub-msp", "view": true, "title": "subMSPs"}, {"path": "/manager/settings", "view": true, "title": "settings"}]}, {"icon": {"src": "/_next/static/media/monetization.4185c074.svg", "width": 20, "height": 21, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/payment", "view": true, "title": "payment", "options": [{"path": "/manager/payments/package", "view": true, "title": "paymentPackage"}, {"path": "/manager/payments/setting", "view": true, "title": "paymentSetting"}]}, {"icon": {"src": "/_next/static/media/settings_manager.63be6fff.svg", "width": 24, "height": 25, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/settings", "view": true, "title": "settings", "options": [{"path": "/manager/settings/personal-data", "view": true, "title": "personalData"}, {"path": "/manager/settings/notification-settings", "view": true, "title": "notificationSettings"}, {"path": "/manager/settings/msp-customization", "view": true, "title": "mspCustomization"}, {"path": "/manager/settings/msp-dictionary", "view": true, "title": "mspDictionary"}]}]
1	Shopper	t	[{"name": "User", "path": "/crm/users", "view": true, "routes": [{"name": "User List", "path": "/crm/users", "view": true}, {"name": "Clients", "path": "/crm/users/clients", "view": true}, {"name": "Shoppers", "path": "/crm/users/shoppers", "view": true}, {"name": "Group", "path": "/crm/users/groups", "view": true}, {"name": "Role", "path": "/crm/users/role", "view": true}, {"name": "Settings", "path": "/crm/users/settings/edit", "view": true}]}, {"name": "Handbook", "path": "/crm/handbook", "view": true, "routes": [{"name": "Group", "path": "/crm/handbook/group", "view": true}, {"name": "Handbook", "path": "/crm/handbook", "view": true}]}, {"name": "Notifications", "path": "/notifications", "view": true, "routes": [{"name": "Providers", "path": "/crm/notifications/providers", "view": true}, {"name": "Templates", "path": "/crm/notifications/templates", "view": true}, {"name": "Action", "path": "/crm/notifications/actions", "view": true}]}, {"name": "Locations", "path": "/crm/locations", "view": true, "routes": [{"name": "Locations Group", "path": "/crm/locations/groups", "view": true}, {"name": "Locations", "path": "/crm/locations", "view": true}, {"name": "Geodata", "path": "/crm/locations/geodata", "view": false}]}, {"name": "Backup", "path": "/crm/backup-service", "view": false, "routes": [{"name": "Backup List", "path": "/crm/backup-service", "view": false}]}, {"name": "Appeals", "path": "/crm/appeals", "view": false, "routes": [{"name": "Statuses", "path": "/crm/appeals/statuses", "view": false}]}]	\N	\N	[{"icon": {"src": "/_next/static/media/assistant_on_hub.9a71e975.svg", "width": 24, "height": 24, "blurWidth": 0, "blurHeight": 0}, "path": "/manager", "view": true, "title": "dashboard"}, {"icon": {"src": "/_next/static/media/project_health.14b2ef7d.svg", "width": 24, "height": 24, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/project-health", "view": true, "title": "projectHealth", "options": [{"path": "/manager/project-health", "view": true, "title": "pmt"}, {"path": "/manager/project-health/project-management-health", "view": true, "title": "pmh"}, {"path": "/manager/project-health/timeline", "view": true, "title": "timeline"}, {"path": "/manager/project-health/calendar", "view": true, "title": "calendar"}]}, {"icon": {"src": "/_next/static/media/search_hands_free.09b2c6db.svg", "width": 20, "height": 20, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/scheduling", "view": true, "title": "scheduling", "options": [{"path": "/manager/scheduling", "view": true, "title": "shops"}, {"path": "/manager/scheduling/applicants", "view": true, "title": "applicants"}, {"path": "/manager/scheduling/route-applicants", "view": true, "title": "routeApplicants"}]}, {"icon": {"src": "/_next/static/media/user_3.c7d03726.svg", "width": 20, "height": 16, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/quality-control", "view": true, "title": "qualityControl", "options": [{"path": "/manager/quality-control/project-surveys", "view": true, "title": "project-surveys"}, {"path": "/manager/quality-control/appeals", "view": true, "title": "appeals"}, {"path": "/manager/quality-control/ai-trust-score", "view": true, "title": "ai-trust-score"}, {"path": "/manager/quality-control/survey-queue", "view": true, "title": "survey-queue"}]}, {"icon": {"src": "/_next/static/media/search_hands_free.09b2c6db.svg", "width": 20, "height": 20, "blurWidth": 0, "blurHeight": 0}, "path": "manager/survey-management/project-surveys", "view": true, "title": "surveysManagement", "options": [{"path": "/manager/survey-management/project-surveys", "view": true, "title": "projectSurveys"}]}, {"icon": {"src": "/_next/static/media/vue_sax.8645ea47.svg", "width": 19, "height": 19, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/shopper-database", "view": true, "title": "shopperDatabase", "options": [{"path": "/manager/shopper-database/shoppers", "view": true, "title": "shoppers"}, {"path": "/manager/shopper-database/shopper-routes", "view": true, "title": "shopperRoutes"}]}, {"icon": {"src": "/_next/static/media/apps.c83c30be.svg", "width": 19, "height": 20, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/projects", "view": true, "title": "projects", "options": [{"path": "/manager/projects", "view": true, "title": "project"}, {"path": "/manager/projects/surveys", "view": true, "title": "surveys"}, {"path": "/manager/projects/swap-shops", "view": true, "title": "swapShops"}]}, {"icon": {"src": "/_next/static/media/clock_loader.c75fc8c7.svg", "width": 23, "height": 23, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/programs", "view": true, "title": "programs"}, {"icon": {"src": "/_next/static/media/person_apron.8810452f.svg", "width": 19, "height": 20, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/clients", "view": true, "title": "clients", "options": [{"path": "/manager/clients", "view": true, "title": "clients"}, {"path": "/manager/clients/locations/groups", "view": true, "title": "location_groups"}, {"path": "/manager/clients/locations", "view": true, "title": "locations"}, {"path": "/manager/clients/client-level", "view": true, "title": "clientLevel"}, {"path": "/manager/clients/client-users", "view": true, "title": "clientUsers"}, {"path": "/manager/clients/client-groups", "view": true, "title": "clientGroups"}]}, {"icon": {"src": "/_next/static/media/badge.19ddda87.svg", "width": 20, "height": 21, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/staff", "view": true, "title": "staff", "options": [{"path": "/manager/staff/msp-users", "view": true, "title": "mspUsers"}, {"path": "/manager/staff/sub-msp", "view": true, "title": "subMSPs"}, {"path": "/manager/settings", "view": true, "title": "settings"}]}, {"icon": {"src": "/_next/static/media/monetization.4185c074.svg", "width": 20, "height": 21, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/payment", "view": true, "title": "payment", "options": [{"path": "/manager/payments/package", "view": true, "title": "paymentPackage"}, {"path": "/manager/payments/setting", "view": true, "title": "paymentSetting"}]}, {"icon": {"src": "/_next/static/media/settings_manager.63be6fff.svg", "width": 24, "height": 25, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/settings", "view": true, "title": "settings", "options": [{"path": "/manager/settings/personal-data", "view": true, "title": "personalData"}, {"path": "/manager/settings/notification-settings", "view": true, "title": "notificationSettings"}, {"path": "/manager/settings/msp-customization", "view": true, "title": "mspCustomization"}, {"path": "/manager/settings/msp-dictionary", "view": true, "title": "mspDictionary"}, {"path": "/manager/settings/msp-operations-settings", "view": false, "title": "mspOperationsSettings"}]}]
2	Client	f	[{"name": "User", "path": "/crm/users", "view": true, "routes": [{"name": "User List", "path": "/crm/users", "view": true}, {"name": "Clients", "path": "/crm/users/clients", "view": true}, {"name": "Shoppers", "path": "/crm/users/shoppers", "view": true}, {"name": "Group", "path": "/crm/users/groups", "view": true}, {"name": "Role", "path": "/crm/users/role", "view": true}, {"name": "Settings", "path": "/crm/users/settings/edit", "view": true}]}, {"name": "Handbook", "path": "/crm/handbook", "view": true, "routes": [{"name": "Group", "path": "/crm/handbook/group", "view": true}, {"name": "Handbook", "path": "/crm/handbook", "view": true}]}, {"name": "Notifications", "path": "/notifications", "view": true, "routes": [{"name": "Providers", "path": "/crm/notifications/providers", "view": true}, {"name": "Templates", "path": "/crm/notifications/templates", "view": true}, {"name": "Action", "path": "/crm/notifications/actions", "view": true}]}, {"name": "Locations", "path": "/crm/locations", "view": true, "routes": [{"name": "Locations Group", "path": "/crm/locations/groups", "view": true}, {"name": "Locations", "path": "/crm/locations", "view": true}, {"name": "Geodata", "path": "/crm/locations/geodata", "view": false}]}, {"name": "Backup", "path": "/crm/backup-service", "view": false, "routes": [{"name": "Backup List", "path": "/crm/backup-service", "view": false}]}, {"name": "Appeals", "path": "/crm/appeals", "view": false, "routes": [{"name": "Statuses", "path": "/crm/appeals/statuses", "view": false}]}]	\N	\N	[{"icon": {"src": "/_next/static/media/assistant_on_hub.9a71e975.svg", "width": 24, "height": 24, "blurWidth": 0, "blurHeight": 0}, "path": "/manager", "view": true, "title": "dashboard"}, {"icon": {"src": "/_next/static/media/project_health.14b2ef7d.svg", "width": 24, "height": 24, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/project-health", "view": true, "title": "projectHealth", "options": [{"path": "/manager/project-health", "view": true, "title": "pmt"}, {"path": "/manager/project-health/project-management-health", "view": true, "title": "pmh"}, {"path": "/manager/project-health/timeline", "view": true, "title": "timeline"}, {"path": "/manager/project-health/calendar", "view": true, "title": "calendar"}]}, {"icon": {"src": "/_next/static/media/search_hands_free.09b2c6db.svg", "width": 20, "height": 20, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/scheduling", "view": true, "title": "scheduling", "options": [{"path": "/manager/scheduling", "view": true, "title": "shops"}, {"path": "/manager/scheduling/applicants", "view": true, "title": "applicants"}, {"path": "/manager/scheduling/route-applicants", "view": true, "title": "routeApplicants"}]}, {"icon": {"src": "/_next/static/media/user_3.c7d03726.svg", "width": 20, "height": 16, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/quality-control", "view": true, "title": "qualityControl", "options": [{"path": "/manager/quality-control/project-surveys", "view": true, "title": "project-surveys"}, {"path": "/manager/quality-control/appeals", "view": true, "title": "appeals"}, {"path": "/manager/quality-control/ai-trust-score", "view": true, "title": "ai-trust-score"}, {"path": "/manager/quality-control/survey-queue", "view": true, "title": "survey-queue"}]}, {"icon": {"src": "/_next/static/media/search_hands_free.09b2c6db.svg", "width": 20, "height": 20, "blurWidth": 0, "blurHeight": 0}, "path": "manager/survey-management/project-surveys", "view": true, "title": "surveysManagement", "options": [{"path": "/manager/survey-management/project-surveys", "view": true, "title": "projectSurveys"}]}, {"icon": {"src": "/_next/static/media/vue_sax.8645ea47.svg", "width": 19, "height": 19, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/shopper-database", "view": true, "title": "shopperDatabase", "options": [{"path": "/manager/shopper-database/shoppers", "view": true, "title": "shoppers"}, {"path": "/manager/shopper-database/shopper-routes", "view": true, "title": "shopperRoutes"}]}, {"icon": {"src": "/_next/static/media/apps.c83c30be.svg", "width": 19, "height": 20, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/projects", "view": true, "title": "projects", "options": [{"path": "/manager/projects", "view": true, "title": "project"}, {"path": "/manager/projects/surveys", "view": true, "title": "surveys"}, {"path": "/manager/projects/swap-shops", "view": true, "title": "swapShops"}]}, {"icon": {"src": "/_next/static/media/clock_loader.c75fc8c7.svg", "width": 23, "height": 23, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/programs", "view": true, "title": "programs"}, {"icon": {"src": "/_next/static/media/person_apron.8810452f.svg", "width": 19, "height": 20, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/clients", "view": true, "title": "clients", "options": [{"path": "/manager/clients", "view": true, "title": "clients"}, {"path": "/manager/clients/locations/groups", "view": true, "title": "location_groups"}, {"path": "/manager/clients/locations", "view": true, "title": "locations"}, {"path": "/manager/clients/client-level", "view": true, "title": "clientLevel"}, {"path": "/manager/clients/client-users", "view": true, "title": "clientUsers"}, {"path": "/manager/clients/client-groups", "view": true, "title": "clientGroups"}]}, {"icon": {"src": "/_next/static/media/badge.19ddda87.svg", "width": 20, "height": 21, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/staff", "view": true, "title": "staff", "options": [{"path": "/manager/staff/msp-users", "view": true, "title": "mspUsers"}, {"path": "/manager/staff/sub-msp", "view": true, "title": "subMSPs"}, {"path": "/manager/settings", "view": true, "title": "settings"}]}, {"icon": {"src": "/_next/static/media/monetization.4185c074.svg", "width": 20, "height": 21, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/payment", "view": true, "title": "payment", "options": [{"path": "/manager/payments/package", "view": true, "title": "paymentPackage"}, {"path": "/manager/payments/setting", "view": true, "title": "paymentSetting"}]}, {"icon": {"src": "/_next/static/media/settings_manager.63be6fff.svg", "width": 24, "height": 25, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/settings", "view": true, "title": "settings", "options": [{"path": "/manager/settings/personal-data", "view": true, "title": "personalData"}, {"path": "/manager/settings/notification-settings", "view": true, "title": "notificationSettings"}, {"path": "/manager/settings/msp-customization", "view": true, "title": "mspCustomization"}, {"path": "/manager/settings/msp-dictionary", "view": true, "title": "mspDictionary"}, {"path": "/manager/settings/msp-operations-settings", "view": false, "title": "mspOperationsSettings"}]}]
4	Worker	f	[{"name": "User", "path": "/crm/users", "view": false, "routes": [{"name": "User List", "path": "/crm/users", "view": false}, {"name": "Clients", "path": "/crm/users/clients", "view": false}, {"name": "Shoppers", "path": "/crm/users/shoppers", "view": false}, {"name": "Group", "path": "/crm/users/groups", "view": false}, {"name": "Role", "path": "/crm/users/role", "view": false}, {"name": "Settings", "path": "/crm/users/settings/edit", "view": false}]}, {"name": "Handbook", "path": "/crm/handbook", "view": false, "routes": [{"name": "Group", "path": "/crm/handbook/group", "view": false}, {"name": "Handbook", "path": "/crm/handbook", "view": false}]}, {"name": "Notifications", "path": "/notifications", "view": false, "routes": [{"name": "Providers", "path": "/crm/notifications/providers", "view": false}, {"name": "Templates", "path": "/crm/notifications/templates", "view": false}, {"name": "Action", "path": "/crm/notifications/actions", "view": false}]}, {"name": "Locations", "path": "/crm/locations", "view": false, "routes": [{"name": "Locations Group", "path": "/crm/locations/groups", "view": false}, {"name": "Locations", "path": "/crm/locations", "view": false}, {"name": "Geodata", "path": "/crm/locations/geodata", "view": false}]}, {"name": "Backup", "path": "/crm/backup-service", "view": false, "routes": [{"name": "Backup List", "path": "/crm/backup-service", "view": false}]}, {"name": "Appeals", "path": "/crm/appeals", "view": false, "routes": [{"name": "Statuses", "path": "/crm/appeals/statuses", "view": false}]}]	\N	\N	[{"icon": {"src": "/_next/static/media/assistant_on_hub.9a71e975.svg", "width": 24, "height": 24, "blurWidth": 0, "blurHeight": 0}, "path": "/manager", "view": true, "title": "dashboard"}, {"icon": {"src": "/_next/static/media/project_health.14b2ef7d.svg", "width": 24, "height": 24, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/project-health", "view": true, "title": "projectHealth", "options": [{"path": "/manager/project-health", "view": true, "title": "pmt"}, {"path": "/manager/project-health/project-management-health", "view": true, "title": "pmh"}, {"path": "/manager/project-health/timeline", "view": true, "title": "timeline"}, {"path": "/manager/project-health/calendar", "view": true, "title": "calendar"}]}, {"icon": {"src": "/_next/static/media/search_hands_free.09b2c6db.svg", "width": 20, "height": 20, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/scheduling", "view": true, "title": "scheduling", "options": [{"path": "/manager/scheduling", "view": true, "title": "shops"}, {"path": "/manager/scheduling/applicants", "view": true, "title": "applicants"}, {"path": "/manager/scheduling/route-applicants", "view": true, "title": "routeApplicants"}]}, {"icon": {"src": "/_next/static/media/user_3.c7d03726.svg", "width": 20, "height": 16, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/quality-control", "view": true, "title": "qualityControl", "options": [{"path": "/manager/quality-control/project-surveys", "view": true, "title": "project-surveys"}, {"path": "/manager/quality-control/appeals", "view": true, "title": "appeals"}, {"path": "/manager/quality-control/ai-trust-score", "view": true, "title": "ai-trust-score"}, {"path": "/manager/quality-control/survey-queue", "view": true, "title": "survey-queue"}]}, {"icon": {"src": "/_next/static/media/search_hands_free.09b2c6db.svg", "width": 20, "height": 20, "blurWidth": 0, "blurHeight": 0}, "path": "manager/survey-management/project-surveys", "view": true, "title": "surveysManagement", "options": [{"path": "/manager/survey-management/project-surveys", "view": true, "title": "projectSurveys"}]}, {"icon": {"src": "/_next/static/media/vue_sax.8645ea47.svg", "width": 19, "height": 19, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/shopper-database", "view": true, "title": "shopperDatabase", "options": [{"path": "/manager/shopper-database/shoppers", "view": true, "title": "shoppers"}, {"path": "/manager/shopper-database/shopper-routes", "view": true, "title": "shopperRoutes"}]}, {"icon": {"src": "/_next/static/media/apps.c83c30be.svg", "width": 19, "height": 20, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/projects", "view": true, "title": "projects", "options": [{"path": "/manager/projects", "view": true, "title": "project"}, {"path": "/manager/projects/surveys", "view": true, "title": "surveys"}, {"path": "/manager/projects/swap-shops", "view": true, "title": "swapShops"}]}, {"icon": {"src": "/_next/static/media/clock_loader.c75fc8c7.svg", "width": 23, "height": 23, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/programs", "view": true, "title": "programs"}, {"icon": {"src": "/_next/static/media/person_apron.8810452f.svg", "width": 19, "height": 20, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/clients", "view": true, "title": "clients", "options": [{"path": "/manager/clients", "view": true, "title": "clients"}, {"path": "/manager/clients/locations/groups", "view": true, "title": "location_groups"}, {"path": "/manager/clients/locations", "view": true, "title": "locations"}, {"path": "/manager/clients/client-level", "view": true, "title": "clientLevel"}, {"path": "/manager/clients/client-users", "view": true, "title": "clientUsers"}, {"path": "/manager/clients/client-groups", "view": true, "title": "clientGroups"}]}, {"icon": {"src": "/_next/static/media/badge.19ddda87.svg", "width": 20, "height": 21, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/staff", "view": true, "title": "staff", "options": [{"path": "/manager/staff/msp-users", "view": true, "title": "mspUsers"}, {"path": "/manager/staff/sub-msp", "view": true, "title": "subMSPs"}, {"path": "/manager/settings", "view": true, "title": "settings"}]}, {"icon": {"src": "/_next/static/media/monetization.4185c074.svg", "width": 20, "height": 21, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/payment", "view": true, "title": "payment", "options": [{"path": "/manager/payments/package", "view": true, "title": "paymentPackage"}, {"path": "/manager/payments/setting", "view": true, "title": "paymentSetting"}]}, {"icon": {"src": "/_next/static/media/settings_manager.63be6fff.svg", "width": 24, "height": 25, "blurWidth": 0, "blurHeight": 0}, "path": "/manager/settings", "view": true, "title": "settings", "options": [{"path": "/manager/settings/personal-data", "view": true, "title": "personalData"}, {"path": "/manager/settings/notification-settings", "view": true, "title": "notificationSettings"}, {"path": "/manager/settings/msp-customization", "view": true, "title": "mspCustomization"}, {"path": "/manager/settings/msp-dictionary", "view": true, "title": "mspDictionary"}, {"path": "/manager/settings/msp-operations-settings", "view": false, "title": "mspOperationsSettings"}]}]
\.


--
-- Data for Name: shop_applications; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.shop_applications (id, shop_id, shopper_id, status, is_manager_initiated, created_at, decision_at, respondent_visit_date, manager_id, respondent_decline_date, respondent_decline_comment) FROM stdin;
1	6	1	APPROVED_BY_BOTH_SIDES	f	2025-03-19 09:27:35.736211	2025-03-19 09:29:14.883	\N	\N	\N	\N
2	2	1	APPROVED_BY_BOTH_SIDES	f	2025-03-19 09:28:12.127309	2025-03-19 09:29:20.999	\N	\N	\N	\N
3	6	11	PENDING_SCHEDULER_APPROVAL	f	2025-03-20 17:17:18.426291	\N	\N	\N	\N	\N
4	1	9	PENDING_SCHEDULER_APPROVAL	f	2025-03-25 20:38:42.842461	\N	2025-03-26	\N	\N	\N
5	25	3	PENDING_SHOPPER_APPROVAL	t	2025-03-29 12:47:58.172	\N	\N	4	\N	\N
6	24	1	PENDING_SHOPPER_APPROVAL	t	2025-03-29 12:48:25.157	\N	\N	4	\N	\N
7	20	1	PENDING_SHOPPER_APPROVAL	t	2025-03-29 12:48:25.167	\N	\N	4	\N	\N
8	8	1	PENDING_SHOPPER_APPROVAL	t	2025-03-29 12:48:25.178	\N	\N	4	\N	\N
9	23	5	PENDING_SHOPPER_APPROVAL	t	2025-03-29 12:48:45.319	\N	\N	4	\N	\N
10	19	5	PENDING_SHOPPER_APPROVAL	t	2025-03-29 12:48:45.341	\N	\N	4	\N	\N
11	7	5	PENDING_SHOPPER_APPROVAL	t	2025-03-29 12:48:45.358	\N	\N	4	\N	\N
12	22	3	PENDING_SHOPPER_APPROVAL	t	2025-03-29 12:49:15.481	\N	\N	4	\N	\N
13	17	3	PENDING_SHOPPER_APPROVAL	t	2025-03-29 12:49:15.494	\N	\N	4	\N	\N
14	20	14	PENDING_SCHEDULER_APPROVAL	f	2025-04-09 20:14:03.850188	\N	2025-04-18	\N	\N	\N
15	23	14	PENDING_SCHEDULER_APPROVAL	f	2025-04-09 20:28:20.999851	\N	2025-04-15	\N	\N	\N
16	26	14	PENDING_SHOPPER_APPROVAL	t	2025-04-09 20:29:26.155	\N	\N	4	\N	\N
17	21	14	PENDING_SHOPPER_APPROVAL	t	2025-04-09 20:29:26.169	\N	\N	4	\N	\N
18	18	14	PENDING_SHOPPER_APPROVAL	t	2025-04-09 20:29:26.179	\N	\N	4	\N	\N
19	16	14	PENDING_SHOPPER_APPROVAL	t	2025-04-09 20:29:26.186	\N	\N	4	\N	\N
20	15	14	PENDING_SHOPPER_APPROVAL	t	2025-04-09 20:29:26.198	\N	\N	4	\N	\N
21	14	14	PENDING_SHOPPER_APPROVAL	t	2025-04-09 20:29:26.203	\N	\N	4	\N	\N
22	13	14	PENDING_SHOPPER_APPROVAL	t	2025-04-09 20:29:26.212	\N	\N	4	\N	\N
23	12	14	PENDING_SHOPPER_APPROVAL	t	2025-04-09 20:29:26.221	\N	\N	4	\N	\N
24	11	14	PENDING_SHOPPER_APPROVAL	t	2025-04-09 20:29:26.228	\N	\N	4	\N	\N
25	10	14	PENDING_SHOPPER_APPROVAL	t	2025-04-09 20:29:26.232	\N	\N	4	\N	\N
26	9	14	PENDING_SHOPPER_APPROVAL	t	2025-04-09 20:29:35.061	\N	\N	4	\N	\N
27	9	5	PENDING_SHOPPER_APPROVAL	t	2025-04-09 20:29:51.817	\N	\N	4	\N	\N
71	49	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 14:35:53.199	\N	\N	4	\N	\N
72	50	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 14:35:53.203	\N	\N	4	\N	\N
30	35	5	APPROVED_BY_BOTH_SIDES	f	2025-05-02 09:30:47.205731	2025-05-02 09:32:35.792	2025-05-02	2	\N	\N
31	27	14	PENDING_SCHEDULER_APPROVAL	f	2025-05-15 03:57:22.819275	\N	2025-05-14	\N	\N	\N
32	33	14	PENDING_SCHEDULER_APPROVAL	f	2025-05-15 03:58:21.206652	\N	2025-05-14	\N	\N	\N
33	30	14	PENDING_SCHEDULER_APPROVAL	f	2025-05-15 03:58:40.030927	\N	2025-05-15	\N	\N	\N
34	31	14	PENDING_SCHEDULER_APPROVAL	f	2025-05-15 03:58:48.687699	\N	2025-05-19	\N	\N	\N
35	32	14	PENDING_SCHEDULER_APPROVAL	f	2025-05-15 04:03:46.389896	\N	2025-05-14	\N	\N	\N
36	29	14	PENDING_SCHEDULER_APPROVAL	f	2025-05-15 04:03:55.372154	\N	2025-05-14	\N	\N	\N
37	26	18	PENDING_SHOPPER_APPROVAL	t	2025-05-15 04:22:07.824	\N	\N	4	\N	\N
38	21	18	PENDING_SHOPPER_APPROVAL	t	2025-05-15 04:22:07.831	\N	\N	4	\N	\N
39	18	18	PENDING_SHOPPER_APPROVAL	t	2025-05-15 04:22:07.835	\N	\N	4	\N	\N
40	16	18	PENDING_SHOPPER_APPROVAL	t	2025-05-15 04:22:07.842	\N	\N	4	\N	\N
41	15	18	PENDING_SHOPPER_APPROVAL	t	2025-05-15 04:22:07.85	\N	\N	4	\N	\N
42	14	18	PENDING_SHOPPER_APPROVAL	t	2025-05-15 04:22:07.855	\N	\N	4	\N	\N
43	13	18	PENDING_SHOPPER_APPROVAL	t	2025-05-15 04:22:07.859	\N	\N	4	\N	\N
44	12	18	PENDING_SHOPPER_APPROVAL	t	2025-05-15 04:22:07.862	\N	\N	4	\N	\N
45	11	18	PENDING_SHOPPER_APPROVAL	t	2025-05-15 04:22:07.866	\N	\N	4	\N	\N
46	10	18	PENDING_SHOPPER_APPROVAL	t	2025-05-15 04:22:07.871	\N	\N	4	\N	\N
47	9	18	PENDING_SHOPPER_APPROVAL	t	2025-05-15 04:22:07.874	\N	\N	4	\N	\N
48	8	18	PENDING_SHOPPER_APPROVAL	t	2025-05-15 04:22:07.877	\N	\N	4	\N	\N
49	7	18	PENDING_SHOPPER_APPROVAL	t	2025-05-15 04:22:07.883	\N	\N	4	\N	\N
50	5	18	PENDING_SHOPPER_APPROVAL	t	2025-05-15 04:22:07.889	\N	\N	4	\N	\N
52	35	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 01:05:13.689309	\N	2025-05-15	4	\N	\N
28	34	1	PENDING_SHOPPER_APPROVAL	t	2025-04-30 13:03:35.498009	2025-04-30 13:06:56.355	2025-04-30	4	\N	\N
51	33	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 01:01:41.374002	\N	2025-05-15	4	\N	\N
54	32	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 01:13:28.28	\N	\N	4	\N	\N
53	31	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 01:11:29.163981	\N	2025-05-15	4	\N	\N
55	30	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 01:13:28.289	\N	\N	4	\N	\N
56	29	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 01:13:28.293	\N	\N	4	\N	\N
29	28	1	PENDING_SHOPPER_APPROVAL	t	2025-04-30 13:04:08.81919	2025-04-30 13:06:58.597	2025-05-08	4	\N	\N
57	27	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 01:13:28.3	\N	\N	4	\N	\N
58	45	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 13:57:55.098	\N	\N	4	\N	\N
59	44	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 13:57:55.108	\N	\N	4	\N	\N
60	43	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 13:57:55.112	\N	\N	4	\N	\N
61	42	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 13:57:55.117	\N	\N	4	\N	\N
62	41	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 13:57:55.121	\N	\N	4	\N	\N
63	40	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 13:57:55.124	\N	\N	4	\N	\N
64	39	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 13:57:55.13	\N	\N	4	\N	\N
65	38	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 13:57:55.137	\N	\N	4	\N	\N
66	37	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 13:57:55.141	\N	\N	4	\N	\N
67	36	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 13:57:55.146	\N	\N	4	\N	\N
68	46	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 14:35:53.181	\N	\N	4	\N	\N
69	47	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 14:35:53.189	\N	\N	4	\N	\N
70	48	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 14:35:53.195	\N	\N	4	\N	\N
73	51	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 14:35:53.206	\N	\N	4	\N	\N
74	52	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 14:35:53.21	\N	\N	4	\N	\N
75	53	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 14:35:53.215	\N	\N	4	\N	\N
76	54	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 14:35:53.22	\N	\N	4	\N	\N
77	55	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 14:35:53.225	\N	\N	4	\N	\N
78	56	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 15:13:57.317	\N	\N	4	\N	\N
79	57	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 15:13:57.37	\N	\N	4	\N	\N
80	58	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 15:13:57.374	\N	\N	4	\N	\N
81	59	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 15:13:57.376	\N	\N	4	\N	\N
82	60	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 15:13:57.381	\N	\N	4	\N	\N
83	61	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 15:13:57.384	\N	\N	4	\N	\N
84	62	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 15:13:57.388	\N	\N	4	\N	\N
85	63	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 15:13:57.392	\N	\N	4	\N	\N
86	64	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 15:13:57.395	\N	\N	4	\N	\N
87	65	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 15:13:57.399	\N	\N	4	\N	\N
88	66	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 15:32:09.965	\N	\N	4	\N	\N
89	67	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 15:32:09.97	\N	\N	4	\N	\N
90	68	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 15:32:09.973	\N	\N	4	\N	\N
91	69	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 15:32:09.975	\N	\N	4	\N	\N
92	70	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 15:32:09.978	\N	\N	4	\N	\N
93	71	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 15:32:09.981	\N	\N	4	\N	\N
94	72	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 15:32:09.983	\N	\N	4	\N	\N
95	73	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 15:32:09.985	\N	\N	4	\N	\N
96	74	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 15:32:09.987	\N	\N	4	\N	\N
97	75	1	PENDING_SHOPPER_APPROVAL	t	2025-05-16 15:32:09.989	\N	\N	4	\N	\N
98	86	1	PENDING_SHOPPER_APPROVAL	t	2025-05-19 17:22:25.941	\N	\N	4	\N	\N
99	85	1	PENDING_SHOPPER_APPROVAL	t	2025-05-19 17:22:25.995	\N	\N	4	\N	\N
100	84	1	PENDING_SHOPPER_APPROVAL	t	2025-05-19 17:22:25.998	\N	\N	4	\N	\N
101	83	1	PENDING_SHOPPER_APPROVAL	t	2025-05-19 17:22:26.001	\N	\N	4	\N	\N
102	82	1	PENDING_SHOPPER_APPROVAL	t	2025-05-19 17:22:26.007	\N	\N	4	\N	\N
103	81	1	PENDING_SHOPPER_APPROVAL	t	2025-05-19 17:22:26.011	\N	\N	4	\N	\N
104	80	1	PENDING_SHOPPER_APPROVAL	t	2025-05-19 17:22:26.014	\N	\N	4	\N	\N
105	79	5	PENDING_SCHEDULER_APPROVAL	f	2025-05-20 10:30:52.159892	\N	2025-05-21	\N	\N	\N
106	87	1	PENDING_SHOPPER_APPROVAL	t	2025-05-20 11:33:30.416	\N	\N	4	\N	\N
107	88	1	PENDING_SHOPPER_APPROVAL	t	2025-05-20 11:33:30.424	\N	\N	4	\N	\N
108	90	5	PENDING_SHOPPER_APPROVAL	t	2025-05-20 11:34:06.959	\N	\N	4	\N	\N
109	89	5	PENDING_SHOPPER_APPROVAL	t	2025-05-20 11:34:06.966	\N	\N	4	\N	\N
116	103	1	PENDING_SHOPPER_APPROVAL	t	2025-05-20 17:22:53.559	\N	\N	4	\N	\N
120	102	5	PENDING_SHOPPER_APPROVAL	t	2025-05-21 13:20:26.445	\N	\N	4	\N	\N
121	117	5	PENDING_SHOPPER_APPROVAL	t	2025-05-21 14:53:02.873	\N	\N	4	\N	\N
122	100	1	PENDING_SCHEDULER_APPROVAL	f	2025-05-22 04:44:44.02653	\N	2025-05-21	\N	\N	\N
111	97	1	PENDING_SHOPPER_APPROVAL	t	2025-05-20 16:44:48.652	\N	\N	4	\N	\N
112	96	1	PENDING_SHOPPER_APPROVAL	t	2025-05-20 16:44:48.657	\N	\N	4	\N	\N
113	95	1	PENDING_SHOPPER_APPROVAL	t	2025-05-20 16:44:48.662	\N	\N	4	\N	\N
114	94	1	PENDING_SHOPPER_APPROVAL	t	2025-05-20 16:44:48.665	\N	\N	4	\N	\N
123	136	5	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:05:28.908	\N	\N	2	\N	\N
124	135	5	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:05:28.916	\N	\N	2	\N	\N
125	134	5	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:05:28.92	\N	\N	2	\N	\N
137	122	5	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:05:28.962	\N	\N	2	\N	\N
138	121	5	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:05:28.97	\N	\N	2	\N	\N
139	120	5	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:05:28.974	\N	\N	2	\N	\N
140	119	5	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:05:28.982	\N	\N	2	\N	\N
141	136	11	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:07:15.26	\N	\N	2	\N	\N
142	135	11	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:07:15.268	\N	\N	2	\N	\N
143	134	11	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:07:15.275	\N	\N	2	\N	\N
144	133	11	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:07:15.28	\N	\N	2	\N	\N
145	132	11	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:07:15.284	\N	\N	2	\N	\N
146	131	11	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:07:15.287	\N	\N	2	\N	\N
147	130	11	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:07:15.29	\N	\N	2	\N	\N
148	129	11	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:07:15.293	\N	\N	2	\N	\N
149	128	11	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:07:15.298	\N	\N	2	\N	\N
150	127	11	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:07:15.302	\N	\N	2	\N	\N
151	126	11	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:07:15.305	\N	\N	2	\N	\N
152	125	11	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:07:15.31	\N	\N	2	\N	\N
153	124	11	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:07:15.315	\N	\N	2	\N	\N
154	123	11	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:07:15.319	\N	\N	2	\N	\N
155	122	11	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:07:15.323	\N	\N	2	\N	\N
156	121	11	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:07:15.328	\N	\N	2	\N	\N
157	120	11	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:07:15.332	\N	\N	2	\N	\N
158	119	11	PENDING_SHOPPER_APPROVAL	t	2025-06-20 13:07:15.34	\N	\N	2	\N	\N
136	136	5	APPROVED_BY_BOTH_SIDES	t	2025-06-20 13:05:28.96	\N	2025-06-20	2	\N	\N
135	135	5	APPROVED_BY_BOTH_SIDES	t	2025-06-20 13:05:28.957	\N	2025-06-20	2	\N	\N
134	134	5	APPROVED_BY_BOTH_SIDES	t	2025-06-20 13:05:28.953	\N	2025-06-27	2	\N	\N
133	133	5	APPROVED_BY_BOTH_SIDES	t	2025-06-20 13:05:28.951	\N	2025-06-27	2	\N	\N
132	132	5	APPROVED_BY_BOTH_SIDES	t	2025-06-20 13:05:28.947	\N	2025-06-20	2	\N	\N
131	131	5	APPROVED_BY_BOTH_SIDES	t	2025-06-20 13:05:28.943	\N	2025-06-20	2	\N	\N
130	130	5	APPROVED_BY_BOTH_SIDES	t	2025-06-20 13:05:28.94	\N	2025-06-26	2	\N	\N
129	129	5	APPROVED_BY_BOTH_SIDES	t	2025-06-20 13:05:28.936	\N	2025-06-26	2	\N	\N
128	128	5	APPROVED_BY_BOTH_SIDES	t	2025-06-20 13:05:28.932	\N	2025-06-27	2	\N	\N
127	127	5	APPROVED_BY_BOTH_SIDES	t	2025-06-20 13:05:28.929	\N	2025-06-28	2	\N	\N
126	126	5	APPROVED_BY_BOTH_SIDES	t	2025-06-20 13:05:28.925	\N	2025-06-28	2	\N	\N
159	115	5	PENDING_SCHEDULER_APPROVAL	f	2025-06-20 16:47:44.668906	\N	2025-06-23	\N	\N	\N
160	114	5	PENDING_SCHEDULER_APPROVAL	f	2025-06-20 17:34:47.271277	\N	2025-06-23	\N	\N	\N
\.


--
-- Data for Name: status_changes; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.status_changes (id, entity_id, entity_type, user_id, old_status, new_status, changed_at) FROM stdin;
1	14	user	4	0	0	2025-05-15 04:02:38.743732
2	18	user	4	0	0	2025-05-15 04:20:18.928025
3	1	user	4	0	1	2025-05-16 01:05:49.659269
4	1	user	4	1	0	2025-05-16 01:13:40.296716
\.


--
-- Data for Name: user_city_access; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_city_access (id, worker_group_id, city_id, user_id, group_id) FROM stdin;
10	\N	27160	20	\N
14	\N	25672	10	\N
\.


--
-- Data for Name: user_client_access; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_client_access (id, client_id, user_id, group_id) FROM stdin;
1	19	21	\N
\.


--
-- Data for Name: user_client_xm_statistics; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_client_xm_statistics (id, client_id, type, score_percent, final, created_at, updated_at, date, industry, subdivision) FROM stdin;
9	6	xm	36.25	f	2025-04-18 12:22:53.337825	2025-06-20 17:55:37.627686	2025-03-01	\N	\N
21	6	xm	40.460606060606054	f	2025-06-20 17:55:03.577873	2025-06-20 17:55:37.682635	2025-06-01	\N	\N
6	6	cx	0	f	2025-04-18 12:22:53.314443	2025-06-20 17:55:37.689804	2025-03-01	\N	\N
18	6	cx	50.57575757575757	f	2025-06-20 17:55:03.561396	2025-06-20 17:55:37.705928	2025-06-01	\N	\N
7	6	ex	72.5	f	2025-04-18 12:22:53.327	2025-06-20 17:55:37.713542	2025-03-01	\N	\N
19	6	ex	50.57575757575757	f	2025-06-20 17:55:03.569983	2025-06-20 17:55:37.741301	2025-06-01	\N	\N
8	6	ux	72.5	f	2025-04-18 12:22:53.333078	2025-06-20 17:55:37.748119	2025-03-01	\N	\N
20	6	ux	50.57575757575757	f	2025-06-20 17:55:03.574403	2025-06-20 17:55:37.774168	2025-06-01	\N	\N
17	6	xm	40.377177649228706	f	2025-04-30 13:14:50.421893	2025-06-20 17:55:37.605619	2025-05-01	\N	\N
13	6	xm	46.40394736842106	f	2025-04-18 12:22:53.360813	2025-06-20 17:55:37.654586	2025-04-01	\N	\N
10	6	cx	57.75	f	2025-04-18 12:22:53.342613	2025-06-20 17:55:37.69611	2025-04-01	\N	\N
14	6	cx	49.46875	f	2025-04-30 13:14:50.391315	2025-06-20 17:55:37.701312	2025-05-01	\N	\N
11	6	ex	58.15789473684211	f	2025-04-18 12:22:53.347257	2025-06-20 17:55:37.723911	2025-04-01	\N	\N
15	6	ex	51.07310529845741	f	2025-04-30 13:14:50.405012	2025-06-20 17:55:37.735112	2025-05-01	\N	\N
12	6	ux	58.15789473684211	f	2025-04-18 12:22:53.353443	2025-06-20 17:55:37.76461	2025-04-01	\N	\N
16	6	ux	51.07310529845741	f	2025-04-30 13:14:50.414284	2025-06-20 17:55:37.768755	2025-05-01	\N	\N
1	6	cx	53.30973451327433	t	2025-04-17 12:53:06.147553	2025-06-20 17:55:37.563445	\N	\N	\N
2	6	ex	53.149196810354795	t	2025-04-17 12:53:06.156416	2025-06-20 17:55:37.569106	\N	\N	\N
3	6	ux	53.149196810354795	t	2025-04-17 12:53:06.162298	2025-06-20 17:55:37.573128	\N	\N	\N
4	6	xm	42.5675187591597	t	2025-04-17 12:53:06.169612	2025-06-20 17:55:37.577856	\N	\N	\N
5	6	nps	2	t	2025-04-18 10:34:32.200751	2025-06-20 17:55:37.582888	\N	\N	\N
\.


--
-- Data for Name: user_clients; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_clients (id, user_id, logo, created_at, updated_at, dashboard_positions, levels, customization, xm_settings, cjm_setting, email, phone) FROM stdin;
4	12		2025-03-21 07:29:41.867	2025-03-24 11:13:18.879	""	[]	{"background": "", "cell_color": "#000000", "text_color": "#FFA800", "chart_color": "#000000", "button_color": "#FFA800", "overlay_color": "#000000", "submenu_color": "#000000", "surveyTextColor": "#000000", "top_panel_color": "#000000", "background_color": "#FFA800", "title_on_widgets": "#000000", "bottom_cell_color": "#000000", "surveyHeaderColor": "#000000", "button_hover_color": "#FFA800", "surveySectionColor": "#000000", "surveyBackgroundColor": "#000000", "surveyHeaderBackground": "#000000", "surveySectionBackground": "#000000", "text_color_in_sub_buttons": "#000000"}	\N	\N	sdfd@mail.com	15654764554
3	2		2025-03-20 12:50:07.93	2025-03-20 12:50:17.543	{"componentsOrder":["AreaChartComponent","Box","BasicTables"],"lineChartData":[{"id":"lineValue3","title":"86.8","subTitle":"Lorem","data":[820,932,901,934,1290,1330,1320],"color":"#0D8F6F"},{"id":"lineValue4","title":"74.8","subTitle":"Lorem","data":[820,932,901,934,1290,1330,1320],"color":"#D82700"},{"id":"lineValue1","title":"32.5","subTitle":"Lorem","data":[820,932,901,934,1290,1330,1320,820,932,901,934,1290,1330,1320],"color":"#FFA500"},{"id":"lineValue2","title":"65.0","subTitle":"Lorem","data":[820,932,901,934,1290,1330,1320],"color":"#3F56CB"}],"sliderValues":[5,5,5,5]}	[]	{"background": "", "cell_color": "", "text_color": "", "chart_color": "", "button_color": "", "overlay_color": "", "submenu_color": "", "surveyTextColor": "", "top_panel_color": "", "background_color": "", "title_on_widgets": "", "bottom_cell_color": "", "surveyHeaderColor": "", "button_hover_color": "", "surveySectionColor": "", "surveyBackgroundColor": "", "surveyHeaderBackground": "", "surveySectionBackground": "", "text_color_in_sub_buttons": ""}	\N	\N	\N	\N
2	4		2025-03-19 09:24:18.674	2025-04-08 14:51:58.64	{"componentsOrder":["AreaChartComponent","Box","BasicTables"],"lineChartData":[{"id":"lineValue1","title":"32.5","subTitle":"Lorem","data":[820,932,901,934,1290,1330,1320,820,932,901,934,1290,1330,1320],"color":"#FFA500"},{"id":"lineValue2","title":"65.0","subTitle":"Lorem","data":[820,932,901,934,1290,1330,1320],"color":"#3F56CB"},{"id":"lineValue3","title":"86.8","subTitle":"Lorem","data":[820,932,901,934,1290,1330,1320],"color":"#0D8F6F"},{"id":"lineValue4","title":"74.8","subTitle":"Lorem","data":[820,932,901,934,1290,1330,1320],"color":"#D82700"}],"sliderValues":[4,5,5,5]}	[]	{"background": "", "cell_color": "", "text_color": "", "chart_color": "", "button_color": "", "overlay_color": "", "submenu_color": "", "surveyTextColor": "", "top_panel_color": "", "background_color": "", "title_on_widgets": "", "bottom_cell_color": "", "surveyHeaderColor": "", "button_hover_color": "", "surveySectionColor": "", "surveyBackgroundColor": "", "surveyHeaderBackground": "", "surveySectionBackground": "", "text_color_in_sub_buttons": ""}	\N	\N	\N	\N
1	6	https://proxy.happeas.space/file/read/local/4/945b67e0f3fc4fbc761f79944c06d133.png	2025-03-19 08:34:06.814	2025-06-24 10:35:24.160656	""	[]	{"background": "https://proxy.happeas.space/file/read/local/4/0f790db80054fdcbcb496b369afcd538.png", "cell_color": "#000000", "text_color": "#FFA800", "chart_color": "#000000", "button_color": "#FFA800", "overlay_color": "#000000", "submenu_color": "#000000", "surveyTextColor": "#000000", "top_panel_color": "#000000", "background_color": "#FFA800", "title_on_widgets": "#000000", "bottom_cell_color": "#000000", "surveyHeaderColor": "#000000", "button_hover_color": "#FFA800", "surveySectionColor": "#ffffff", "surveyBackgroundColor": "#e0ffec", "surveyHeaderBackground": "#9effa9", "surveySectionBackground": "#058a2d", "text_color_in_sub_buttons": "#000000"}	{"cx": {"types": ["MSh"], "percent": 30, "multipliers": [{"code": "MSh", "percent": 100, "projects": [{"sections": [49, 53, 54, 55, 51, 56, 52, 57, 50], "project_id": 14}, {"sections": [34, 35, 36, 39, 37, 38, 41, 42, 40], "project_id": 12}]}]}, "ex": {"types": ["ME"], "percent": 20, "multipliers": [{"code": "ME", "percent": 100, "projects": [{"sections": [25], "project_id": 10}, {"sections": [15, 16], "project_id": 4}, {"sections": [9, 11, 10], "project_id": 5}, {"sections": [17, 19, 18], "project_id": 6}, {"sections": [21], "project_id": 7}, {"sections": [26, 30, 31, 29, 32, 27, 33, 28, 43], "project_id": 11}, {"sections": [22, 23], "project_id": 8}, {"sections": [49, 53, 54, 55, 51, 56, 52, 57, 50], "project_id": 14}, {"sections": [34, 35, 36, 39, 37, 38, 41, 42, 40], "project_id": 12}, {"sections": [24], "project_id": 9}]}]}, "ux": {"types": ["UXTesting"], "percent": 30, "multipliers": [{"code": "UXTesting", "percent": 100, "projects": [{"sections": [17, 19, 18], "project_id": 6}, {"sections": [9, 11, 10], "project_id": 5}, {"sections": [15, 16], "project_id": 4}, {"sections": [25], "project_id": 10}, {"sections": [21], "project_id": 7}, {"sections": [26, 30, 31, 29, 32, 27, 33, 28, 43], "project_id": 11}, {"sections": [22, 23], "project_id": 8}, {"sections": [49, 53, 54, 55, 51, 56, 52, 57, 50], "project_id": 14}, {"sections": [34, 35, 36, 39, 37, 38, 41, 42, 40], "project_id": 12}, {"sections": [24], "project_id": 9}]}]}}	{"color": "#da5107", "date_end": "2025-05-22T00:00:00.000Z", "location": "HU", "projects": [{"id": "proj1", "color": "#da5107", "values": [0, 43, 61, 58.5, 72, 75], "sections": [{"icon": 4, "name": "Needs Identification Stage", "delta": 0, "quote": "Customers overall were happy but complained about some delays and confusion.", "percent": 0, "indicator": [{"name": "CSI", "type": "CSI", "delta": 0, "percent": null, "projects": [{"questions": [67], "project_id": 8}]}, {"name": "MSh", "type": "MSh", "delta": 0, "percent": 88, "projects": [{"questions": [44, 46, 45], "project_id": 6}]}, {"name": "NPS", "type": "NPS", "delta": 0, "percent": 0, "projects": []}, {"name": "CES", "type": "CES", "delta": 0, "percent": 50, "projects": [{"questions": [71, 72, 73], "project_id": 10}]}]}, {"icon": 2, "name": "Greeting", "delta": 0, "quote": "Customers overall were happy but complained about some delays, confusion, and the need for multiple clarifications.", "percent": 0, "indicator": [{"name": "NPS", "type": "NPS", "delta": 0, "percent": 8, "projects": [{"questions": [60], "project_id": 7}, {"questions": [117], "project_id": 12}, {"questions": [147], "project_id": 11}]}, {"name": "MSh", "type": "MSh", "delta": 0, "percent": 71, "projects": [{"questions": [46, 51, 53, 56], "project_id": 6}, {"questions": [89, 76, 98, 103, 106], "project_id": 11}]}, {"name": "CES", "type": "CES", "delta": 0, "percent": 50, "projects": [{"questions": [73, 72], "project_id": 10}]}]}, {"icon": 2, "name": "Consultation", "delta": 0, "quote": "Customers overall were somewhat satisfied but noted issues with initial greetings, mentioning that staff were cold, unengaged, or mechanical, and suggesting improvements like more warmth, proactive interaction, and using customer names.", "percent": 0, "indicator": [{"name": "CES", "type": "CES", "delta": 0, "percent": 50, "projects": [{"questions": [71, 72, 73], "project_id": 10}]}, {"name": "MSh", "type": "MSh", "delta": 0, "percent": 72, "projects": [{"questions": [61, 62], "project_id": 7}, {"questions": [133, 120, 128, 137, 143, 111], "project_id": 12}, {"questions": [90, 100, 104, 107, 108, 81], "project_id": 11}]}]}, {"icon": 2, "name": "Product Presentation", "delta": 0, "quote": "Customers overall were happy but experienced some delays and confusion.", "percent": 0, "indicator": [{"name": "MSh", "type": "MSh", "delta": 0, "percent": 67, "projects": [{"questions": [45, 50, 55, 52], "project_id": 6}]}, {"name": "CES", "type": "CES", "delta": 0, "percent": 50, "projects": [{"questions": [71, 72], "project_id": 10}]}]}, {"icon": 3, "name": "New ", "delta": 0, "quote": "Customers overall were satisfied but mentioned areas for improvement, such as clarity and personalization.", "percent": 0, "indicator": [{"name": "MSh", "type": "MSh", "delta": 0, "percent": 72, "projects": [{"questions": [84, 79, 92, 99, 89, 76, 98, 103, 106, 87, 77, 93, 82, 110, 91, 97, 90, 100, 104, 107, 108, 81, 78, 101, 105, 86, 94, 88, 83, 95, 80, 85, 96, 102, 109, 147], "project_id": 11}]}]}, {"icon": 3, "name": "Return", "delta": 0, "quote": "Customers overall were satisfied with the return process but expressed some dissatisfaction and concerns about staff knowledge and involvement.", "percent": 0, "indicator": [{"name": "MSh", "type": "MSh", "delta": 0, "percent": 75, "projects": [{"questions": [78, 101, 105, 86, 94], "project_id": 11}]}]}]}], "client_id": 6, "date_start": "2024-10-01T00:00:00.000Z", "location_type": 1}	gog@mail.com	14343434434
5	17	https://proxy.happeas.space/file/read/local/4/43ee82e633a310c7684df867adef722e.png	2025-05-14 16:31:30.427	2025-05-14 16:42:23.805457	""	[4,5,7]	{"cell_color": "#000000", "text_color": "#FFA800", "chart_color": "#000000", "button_color": "#FFA800", "overlay_color": "#000000", "submenu_color": "#000000", "top_panel_color": "#000000", "background_color": "#FFA800", "title_on_widgets": "#000000", "bottom_cell_color": "#000000", "button_hover_color": "#FFA800", "text_color_in_sub_buttons": "#000000"}	\N	\N	vic@phantomshopping.hu	36
6	19	https://proxy.happeas.space/file/read/local/4/865d1497646bdbe64bf9d67e2d1c692f.png	2025-06-03 13:20:39.348	2025-06-03 13:20:39.348	""	[]	{"cell_color": "#000000", "text_color": "#FFA800", "chart_color": "#000000", "button_color": "#FFA800", "overlay_color": "#000000", "submenu_color": "#000000", "top_panel_color": "#000000", "background_color": "#FFA800", "title_on_widgets": "#000000", "bottom_cell_color": "#000000", "button_hover_color": "#FFA800", "text_color_in_sub_buttons": "#000000"}	\N	\N	aakarsh.choudhary@floorwalk.in	919589941298
\.


--
-- Data for Name: user_comments; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_comments (id, who_created, user_id, comment, created_at, updated_at, deleted_at) FROM stdin;
\.


--
-- Data for Name: user_country_access; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_country_access (id, worker_group_id, country_id, user_id, group_id) FROM stdin;
15	\N	IN	20	\N
19	\N	HU	9	\N
21	\N	HU	10	\N
\.


--
-- Data for Name: user_favorites; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_favorites (id, user_id, shop_id, created_at) FROM stdin;
1	1	25	2025-04-09 10:53:48.344778
4	14	17	2025-04-09 20:15:06.720665
5	14	23	2025-04-09 20:15:09.522915
\.


--
-- Data for Name: user_handbook; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_handbook (id, name, type, handbook_group_id, sort, status, code) FROM stdin;
1	If you have a car?	radio	1	1	t	have_car
2	Where are you willing to visit?	radio	1	1	t	willing_visit
3	Zip code	input	1	1	t	zip_code
4	Language	select	1	2	t	language
6	Office address	input	2	4	t	office_address
7	Contract end date	input	2	5	t	contract_end_date
8	Contract person name	input	2	6	t	contract_person_name
9	Competitor client	input	2	7	t	competitor_client
10	Subdivisions client	multiselect	2	8	t	subdivisions_client
11	Date of birth	date	3	1	t	date_of_birth
12	Reliable transportation	select	4	2	t	reliable_transportation
13	Highest completed educational(optional)	select	4	3	t	completed_educational
14	Current job(optional)	input	4	4	t	current_job
15	Income level	input	4	5	t	income_level
16	Employment type	select	4	6	t	employment_type
17	Partner employment type	input	4	7	t	partner_employment_type
18	Number of children(optional)	select	4	8	t	number_of_children
19	Where did you hear from us?	select	4	9	t	here_from_us
20	Postal code	input	4	10	t	postal_code
21	PayPal address	input	4	11	t	paypal_address
22	Do you like to travel?	select	4	12	t	like_travel
23	Pets(optional)	input	4	13	t	pets
24	Do you have a valid driver’s licence?	select	4	14	t	driver_licence
38	Colour	input	5	2	t	colour_competitor
39	Competitor location	input	5	1	t	location_competitor
26	Bank	select	3	2	t	bank
27	Currency	select	3	3	t	currencies
28	MSP Logo	input	6	1	t	logo
29	MSP App Logo	input	6	2	t	app_logo
30	MSP Main Color	input	6	3	t	main_color
31	MSP Text Color	input	6	4	t	text_color
32	MSP Sub Menu Color	input	6	5	t	sub_menu_color
33	MSP Sub Menu Text Color	input	6	6	t	sub_menu_text_color
34	Address	input	1	9	t	address
35	Sub MSP Name	input	1	10	t	sub_msp_name
36	Manager Link	input	1	11	t	manager_link
37	Shopper Link	input	1	12	t	shopper_link
25	Driving Experience	select	3	1	t	driving_experience
5	Industry	select	2	3	t	industry
\.


--
-- Data for Name: user_handbook_filling; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_handbook_filling (id, user_id, handbook_id, value, json_value, color) FROM stdin;
2	6	4	en	\N	\N
3	6	5	enertainment	\N	\N
4	6	3	3243	\N	\N
5	6	6	Heroluepe 23	\N	\N
7	6	8	Valera Patron	\N	\N
8	6	7	2034-03-07	\N	\N
9	7	3	31233	\N	\N
10	7	4	en	\N	\N
11	8	4	en	\N	\N
12	8	34	123 weewrw	\N	\N
13	8	3	4323	\N	\N
14	12	3	3233	\N	\N
15	12	4	en	\N	\N
16	12	5	car_wash	\N	\N
17	12	5	car_wash	\N	\N
18	12	8	Dsad Mane	\N	\N
19	12	10		[]	\N
20	12	10		[]	\N
21	12	6	wqqw 32	\N	\N
22	12	7	2025-05-15	\N	\N
1	6	5	6	\N	\N
6	6	10		[]	\N
23	17	10		[]	\N
24	17	5	1	\N	\N
25	17	7	2025-12-31	\N	\N
26	17	8	Vivien	\N	\N
27	17	6	Ürömi utca 43.	\N	\N
28	17	10		[]	\N
29	17	5	1	\N	\N
30	17	4	en	\N	\N
31	19	3	122002	\N	\N
32	19	5	1	\N	\N
33	19	4	en	\N	\N
34	19	5	1	\N	\N
35	19	10		[]	\N
36	19	8	Demo Person	\N	\N
37	19	10		[]	\N
38	19	6	Empire Square, MR-I, Unit 1, 3rd Floor  MG Road Gurugram, Haryana	\N	\N
39	19	7	2025-07-31	\N	\N
40	1	3	122002	\N	\N
41	1	4	en	\N	\N
42	1	34	445 metro tower gurugram	\N	\N
43	21	4	en	\N	\N
44	21	3	122002	\N	\N
45	21	34	445 gurgaon 	\N	\N
\.


--
-- Data for Name: user_handbook_group; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_handbook_group (id, name, sort, status) FROM stdin;
1	Additional data	1	t
2	Client	1	t
3	Profile(Shopper general)	1	t
4	Profile(Shopper additional)	1	t
5	Competitor	1	t
6	Customizations	1	t
\.


--
-- Data for Name: user_handbook_link; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_handbook_link (id, handbook_id, handbook_group_id, role_id, group_id) FROM stdin;
4	0	1	3	0
5	0	1	3	0
1	0	2	2	0
3	0	1	2	0
6	0	3	1	0
7	0	4	1	0
2	0	1	1	0
8	0	5	5	0
9	5	0	5	0
10	10	0	5	0
11	0	1	6	0
12	0	6	6	0
13	0	1	3	0
14	0	1	3	0
15	0	2	2	0
16	0	1	2	0
17	0	3	1	0
18	0	4	1	0
19	0	1	1	0
20	0	5	5	0
21	5	0	5	0
22	10	0	5	0
23	0	1	6	0
24	0	6	6	0
25	43	0	6	0
26	3	0	6	0
27	42	0	6	0
29	34	0	6	0
30	0	6	6	0
31	29	0	6	0
32	30	0	6	0
33	28	0	6	0
34	32	0	6	0
35	33	0	6	0
36	31	0	6	0
\.


--
-- Data for Name: user_handbook_value; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_handbook_value (id, handbook_id, label, value, sort, color, image) FROM stdin;
1	1	Yes, the car is on gas	if_car_1	1	\N	\N
2	1	Yes, petrol car	if_car_2	1	\N	\N
3	1	Yes, electric	if_car_3	1	\N	\N
4	1	No	if_car_4	2	\N	\N
5	2	in your area	willing_visit_1	2	\N	\N
6	2	city	willing_visit_2	2	\N	\N
7	2	region	willing_visit_3	2	\N	\N
8	12	Yes	reliable_transportation_1	1	\N	\N
9	12	No	reliable_transportation_2	2	\N	\N
10	13	High school	completed_educational_1	1	\N	\N
11	13	College	completed_educational_2	2	\N	\N
12	13	University	completed_educational_3	3	\N	\N
13	13	Master	completed_educational_4	4	\N	\N
14	13	PhD	completed_educational_5	5	\N	\N
15	16	Full-time	employment_type_1	1	\N	\N
16	16	Part-time	employment_type_2	2	\N	\N
17	16	Freelance	employment_type_3	3	\N	\N
18	16	Contract	employment_type_4	4	\N	\N
19	18	0	number_of_children_1	1	\N	\N
20	18	1	number_of_children_2	2	\N	\N
21	18	2	number_of_children_3	3	\N	\N
22	18	3	number_of_children_4	4	\N	\N
23	18	4	number_of_children_5	5	\N	\N
24	18	5	number_of_children_6	6	\N	\N
25	18	6	number_of_children_7	7	\N	\N
26	18	7	number_of_children_8	8	\N	\N
27	18	8	number_of_children_9	9	\N	\N
28	18	9	number_of_children_10	10	\N	\N
29	19	Google	here_from_us_1	1	\N	\N
30	19	Facebook	here_from_us_2	2	\N	\N
31	19	Instagram	here_from_us_3	3	\N	\N
32	19	Friends	here_from_us_4	4	\N	\N
33	19	Other	here_from_us_5	5	\N	\N
34	22	Yes	like_travel_1	1	\N	\N
35	22	No	like_travel_2	2	\N	\N
36	24	Yes	driver_licence_1	1	\N	\N
37	243	No	driver_licence_2	2	\N	\N
38	4	English	en	1	\N	\N
39	4	German	de	2	\N	\N
40	4	French	fr	3	\N	\N
41	10	Wood	wood	1	\N	\N
42	10	Sanitary	sanitary	2	\N	\N
43	10	Tiles	tiles	3	\N	\N
44	10	Life insurance	life_insurance	4	\N	\N
177	5	Automotive	1	1	#000000	https://proxy.happeas.space/file/read/local/2/4770305be22dcaa11569d5cc102ef1f8.png
183	5	Grocery	13	5	#000000	https://proxy.happeas.space/file/read/local/2/e878652319b0c5aee99078dfc6875823.png
186	5	Real estate	18	5	#000000	https://proxy.happeas.space/file/read/local/2/1e8b5fb774b73971ffe69fb9f29d1001.png
193	5	Other	25	5	#000000	\N
195	5	Telecommunication	22	5	#000000	https://proxy.happeas.space/file/read/local/2/a98cadd1e71aae634cf88c56adeb2d1e.png
50	10	Vehicle insurance	vehicle_insurance	5	\N	\N
51	10	Property insurance	property_insurance	5	\N	\N
52	10	Garden	garden	5	\N	\N
53	10	Building material	building_material	5	\N	\N
54	10	Electric	electric	5	\N	\N
55	10	Customer service	customer_service	5	\N	\N
56	10	TV-Hifi	tv_hifi	5	\N	\N
57	10	Photo/Telecommunication	photo_telecommunication	5	\N	\N
58	10	Computer Software	computer_software	5	\N	\N
84	26	PrivatBank	bank_1	1	\N	\N
85	26	Monobank	bank_2	2	\N	\N
86	26	Oschadbank	bank_3	3	\N	\N
87	26	Raiffeisen Bank Aval	bank_4	4	\N	\N
88	27	USD	usd	1	\N	\N
89	27	EUR	eur	2	\N	\N
90	27	UAH	uah	3	\N	\N
91	27	HUF	huf	4	\N	\N
92	27	RUB	rub	5	\N	\N
119	25	0-1 year	driving_experience_1	1	#000000	\N
120	25	5-10 years	driving_experience_4	4	#000000	\N
121	25	3-5 years	driving_experience_3	3	#000000	\N
122	25	1-3 years	driving_experience_2	2	#000000	\N
123	25	10+ years	driving_experience_5	5	#000000	\N
178	5	Car wash	3	3	#000000	https://proxy.happeas.space/file/read/local/2/4770305be22dcaa11569d5cc102ef1f8.png
184	5	Health Care	14	5	#000000	https://proxy.happeas.space/file/read/local/2/5dd58c12d32fb5b5c2cdbafc08cea642.png
189	5	Retail	19	5	#000000	https://proxy.happeas.space/file/read/local/2/1e8b5fb774b73971ffe69fb9f29d1001.png
192	5	Training	23	5	#000000	\N
200	5	Wholesale	24	5	#000000	\N
202	5	Financial consultancy	8	5	#000000	\N
179	5	Business-to-Business	2	2	#000000	https://proxy.happeas.space/file/read/local/2/f20cbdbe10894a5006370288d7c49c9d.png
185	5	Lodging, accommodation	15	5	#000000	https://proxy.happeas.space/file/read/local/2/1e8b5fb774b73971ffe69fb9f29d1001.png
190	5	Pharmacies	17	5	#000000	https://proxy.happeas.space/file/read/local/2/5dd58c12d32fb5b5c2cdbafc08cea642.png
196	5	Enertainment	6	5	#000000	https://proxy.happeas.space/file/read/local/2/ffd3ee2e1c93b47703952cfa714d06ff.png
197	5	Construction	5	5	#000000	\N
180	5	Convenience Stores	4	4	#000000	https://proxy.happeas.space/file/read/local/2/e878652319b0c5aee99078dfc6875823.png
187	5	Government	12	5	#000000	https://proxy.happeas.space/file/read/local/2/9598c917690c64c8804548131f144157.png
191	5	Storage	21	5	#000000	https://proxy.happeas.space/file/read/local/2/9598c917690c64c8804548131f144157.png
198	5	Gas Stations	11	5	#000000	\N
199	5	FMCG	9	5	#000000	\N
181	5	Financial	7	5	#000000	https://proxy.happeas.space/file/read/local/2/e47bda8cf968cedf038d25d22f513aee.png
194	5	Food service	10	5	#000000	https://proxy.happeas.space/file/read/local/2/e878652319b0c5aee99078dfc6875823.png
203	5	Enertainment	enertainment	5	\N	\N
182	5	Lottery store	16	5	#000000	https://proxy.happeas.space/file/read/local/2/4b225259acd0fff3ffa487736aefb5a7.png
188	5	Shipping, transportation	20	5	#000000	https://proxy.happeas.space/file/read/local/2/4770305be22dcaa11569d5cc102ef1f8.png
201	5	Car_wash	car_wash	5	#000000	\N
\.


--
-- Data for Name: user_integrations; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_integrations (id, user_id, service, token, data, created_at, updated_at) FROM stdin;
\.


--
-- Data for Name: user_location_access; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_location_access (id, worker_group_id, location_id, user_id, group_id) FROM stdin;
\.


--
-- Data for Name: user_notes; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_notes (id, user_id, theme, comment, created_at, who_created) FROM stdin;
\.


--
-- Data for Name: user_notifications; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_notifications (id, user_id, action_id, notification, status, created_at, updated_at) FROM stdin;
2	10	0	<p><a href="https://happeas.space/client/management/questionnaire/6">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	new	2025-03-20 09:42:46.606619	2025-03-20 09:42:46.606619
4	10	0	<p><a href="https://happeas.space/client/management/questionnaire/5">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	new	2025-03-20 10:12:10.918469	2025-03-20 10:12:10.918469
6	10	0	<p><a href="https://happeas.space/client/management/questionnaire/5">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	new	2025-03-20 10:12:31.909055	2025-03-20 10:12:31.909055
8	10	0	<p><a href="https://happeas.space/client/management/questionnaire/6">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	new	2025-03-20 16:36:09.965933	2025-03-20 16:36:09.965933
10	10	0	<p><a href="https://happeas.space/client/management/questionnaire/6">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	new	2025-03-26 21:49:54.023728	2025-03-26 21:49:54.023728
3	9	0	<p><a href="https://happeas.space/client/management/questionnaire/5">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	read	2025-03-20 10:12:10.90054	2025-03-20 10:12:10.90054
1	9	0	<p><a href="https://happeas.space/client/management/questionnaire/6">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	read	2025-03-20 09:42:46.577157	2025-03-20 09:42:46.577157
9	9	0	<p><a href="https://happeas.space/client/management/questionnaire/6">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	read	2025-03-26 21:49:53.995345	2025-03-26 21:49:53.995345
7	9	0	<p><a href="https://happeas.space/client/management/questionnaire/6">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	read	2025-03-20 16:36:09.939398	2025-03-20 16:36:09.939398
5	9	0	<p><a href="https://happeas.space/client/management/questionnaire/5">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	read	2025-03-20 10:12:31.902788	2025-03-20 10:12:31.902788
11	10	0	<p><a href="https://happeas.space/client/management/questionnaire/4">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	new	2025-03-28 13:50:20.218458	2025-03-28 13:50:20.218458
12	9	0	<p><a href="https://happeas.space/client/management/questionnaire/4">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	new	2025-03-28 13:50:20.234987	2025-03-28 13:50:20.234987
13	10	0	<p><a href="https://happeas.space/client/management/questionnaire/5">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	new	2025-03-28 13:50:27.324222	2025-03-28 13:50:27.324222
14	9	0	<p><a href="https://happeas.space/client/management/questionnaire/5">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	new	2025-03-28 13:50:27.36921	2025-03-28 13:50:27.36921
15	10	0	<p><a href="https://happeas.space/client/management/questionnaire/6">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	new	2025-03-28 13:50:33.270893	2025-03-28 13:50:33.270893
16	9	0	<p><a href="https://happeas.space/client/management/questionnaire/6">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	new	2025-03-28 13:50:33.276987	2025-03-28 13:50:33.276987
17	10	0	<p><a href="https://happeas.space/client/management/questionnaire/3">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	new	2025-03-28 13:50:39.447999	2025-03-28 13:50:39.447999
20	10	0	<p><a href="https://happeas.space/client/management/questionnaire/127">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	new	2025-03-29 13:00:38.973639	2025-03-29 13:00:38.973639
22	10	0	<p><a href="https://happeas.space/client/management/questionnaire/128">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	new	2025-03-29 13:00:55.73229	2025-03-29 13:00:55.73229
24	10	0	<p><a href="https://happeas.space/client/management/questionnaire/129">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	new	2025-03-29 13:01:15.918434	2025-03-29 13:01:15.918434
26	10	0	<p><a href="https://happeas.space/client/management/questionnaire/130">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	new	2025-03-29 13:01:33.725808	2025-03-29 13:01:33.725808
28	10	0	<p><a href="https://happeas.space/client/management/questionnaire/131">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	new	2025-03-29 13:01:47.437979	2025-03-29 13:01:47.437979
30	10	0	<p><a href="https://happeas.space/client/management/questionnaire/133">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	new	2025-03-29 13:02:00.116978	2025-03-29 13:02:00.116978
32	10	0	<p><a href="https://happeas.space/client/management/questionnaire/132">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	new	2025-03-29 13:02:10.381673	2025-03-29 13:02:10.381673
34	10	0	<p><a href="https://happeas.space/client/management/questionnaire/129">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	new	2025-04-03 00:24:30.820935	2025-04-03 00:24:30.820935
36	10	0	<p><a href="https://happeas.space/client/management/questionnaire/129">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	new	2025-04-03 00:24:50.837431	2025-04-03 00:24:50.837431
21	9	0	<p><a href="https://happeas.space/client/management/questionnaire/128">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	read	2025-03-29 13:00:55.71996	2025-03-29 13:00:55.71996
29	9	0	<p><a href="https://happeas.space/client/management/questionnaire/133">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	read	2025-03-29 13:02:00.0945	2025-03-29 13:02:00.0945
19	9	0	<p><a href="https://happeas.space/client/management/questionnaire/127">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	read	2025-03-29 13:00:38.959512	2025-03-29 13:00:38.959512
18	9	0	<p><a href="https://happeas.space/client/management/questionnaire/3">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	read	2025-03-28 13:50:39.560087	2025-03-28 13:50:39.560087
33	9	0	<p><a href="https://happeas.space/client/management/questionnaire/129">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	read	2025-04-03 00:24:30.808908	2025-04-03 00:24:30.808908
25	9	0	<p><a href="https://happeas.space/client/management/questionnaire/130">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	read	2025-03-29 13:01:33.699181	2025-03-29 13:01:33.699181
35	9	0	<p><a href="https://happeas.space/client/management/questionnaire/129">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	read	2025-04-03 00:24:50.82312	2025-04-03 00:24:50.82312
23	9	0	<p><a href="https://happeas.space/client/management/questionnaire/129">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	read	2025-03-29 13:01:15.886432	2025-03-29 13:01:15.886432
31	9	0	<p><a href="https://happeas.space/client/management/questionnaire/132">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	read	2025-03-29 13:02:10.365997	2025-03-29 13:02:10.365997
27	9	0	<p><a href="https://happeas.space/client/management/questionnaire/131">New questionnaire</a> for review, check the <strong>management</strong> tab.</p>	read	2025-03-29 13:01:47.416143	2025-03-29 13:01:47.416143
\.


--
-- Data for Name: user_payment_methods; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_payment_methods (id, payment_method, icon, details) FROM stdin;
\.


--
-- Data for Name: user_payments_data; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_payments_data (id, user_id, payment_method_id, code, type, value) FROM stdin;
\.


--
-- Data for Name: user_region_access; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_region_access (id, worker_group_id, region_id, user_id, group_id) FROM stdin;
2	\N	IN-10	20	\N
\.


--
-- Data for Name: user_settings; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_settings (id, code, value, value_json) FROM stdin;
2	currencies	eur	[]
13	appeals_status		["Unintelligible request", "Justified request, incorrect", "Justified request, inaccurate role", "Questionable or subjective marking", "Unjustified request"]
1	language	en	[]
11	currency	USD	[]
3	clients_roles		[2]
20	content_contact_us		{"cz": {"title": null, "content": ""}, "en": {"title": null, "content": "<p>Book your free consultation about increasing your sales or any customer-focused goals you may have.<br><br>43. Ürömi utca 1023 Budapest, Hungary<br><br>Call us at: (+36) 20 776 0749<br><br>General information: info@phantomshopping.com<br><br>For company enquiries: inquire@phantomshopping.com<br><br>Send your CV and work with us: hr@phantomshopping.hu<br>&nbsp;</p><p><br>&nbsp;</p><p><a href=\\"mailto:Lorem.ipsum@happeas.com\\">Lorem.ipsum@happeas.com</a></p><p><a href=\\"tel:+1 (000) 000-0000\\">+1 (000) 000-0000</a></p>"}, "hu": {"title": null, "content": "Hungary test"}, "ro": {"title": null, "content": ""}, "ru": {"title": null, "content": ""}, "ua": {"title": null, "content": ""}}
4	shoppers_roles		[1]
7	manager_roles		[3]
8	worker_roles		[4]
9	competitor_roles		[5]
10	msp_roles		[6]
21	content_legal_information		{"cz": {"title": null, "content": "nvbnvbnv"}, "en": {"title": null, "content": ""}, "hu": {"title": null, "content": ""}, "ro": {"title": null, "content": ""}, "ru": {"title": null, "content": ""}, "ua": {"title": null, "content": "nvbnvv"}}
5	default_role	1	[]
22	content_faq		{"en": [{"answer": "You can return any item within 30 days of purchase for a full refund.", "question": "What is you return policy?"}, {"answer": "We accept Visa, MasterCard, American Express, PayPal, and Apple Pay.", "question": "What payment methods do you accept?"}], "hu": [{"answer": "123", "question": "213"}], "ro": [{"answer": "Test answer", "question": "Test question"}, {"answer": "Answer", "question": "Question"}]}
12	customizations		{"logo": "https://proxy.happeas.space/file/read/local/2/4a47f46ab67dbf8d53c4c6bf2e68f1e3.png", "app_logo": "/logo.png", "background": "https://proxy.happeas.space/file/read/local/2/1e02ef2846546a1330b7228890e5cb5d.png", "cell_color": "#000000", "text_color": "#333333", "chart_color": "#000000", "button_color": "#FF5733", "overlay_color": "#000000", "submenu_color": "#000000", "surveyTextColor": "#212121", "top_panel_color": "#000000", "background_color": "#FFFFFF", "title_on_widgets": "#000000", "bottom_cell_color": "#000000", "surveyHeaderColor": "#737373", "button_hover_color": "#C70039", "surveySectionColor": "#b0b0b0", "surveyBackgroundColor": "#c5fb74", "surveyHeaderBackground": "#b0fe7c", "surveySectionBackground": "#c2c2c2", "text_color_in_sub_buttons": "#000000"}
6	time_zone	europe/kiev	[]
16	live_chat	0	[]
15	msp		{"count": 1, "visits": 2, "delivery": 2, "rotation": 511, "validation": 8}
17	ai_cjm		{"enabled": true, "train_id": null, "provider_id": 1, "scenario_id": 1}
18	ai_trust_score		{"enabled": true, "train_id": null, "provider_id": 1, "scenario_id": 3}
19	content_about_us		{"cz": {"title": null, "content": ""}, "en": {"title": null, "content": "<p><strong>About us</strong><br><br>Having a hard time deciding on the data collection method that is right for your goals? It no longer has to be either-or. 360 CX Focus combines Voice of Customer, Mystery Shopping, and Employee surveys to give you richer insights. You will finally understand what your customers expect, how much you are delivering on those expectations, and how it affects your employee motivation.<br><br>In simple terms, we took everything we have learned from running thousands of different surveys and started cross-referencing their results. The outcome was breathtaking, so we are proud to share this methodology.<br><br><strong>360 CX Focus Benefits:</strong><br>&nbsp;</p><ul><li>Find the point to which customer wants can be delivered without hurting employee motivation.</li><li>Know the extent to which employee-fitted customer expectations are delivered.</li><li>Up your game with 3-sided aggregated insights</li></ul>"}, "hu": {"title": null, "content": ""}, "ro": {"title": null, "content": ""}, "ru": {"title": null, "content": ""}, "ua": {"title": null, "content": ""}}
\.


--
-- Data for Name: user_worker_feedback; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_worker_feedback (id, who_created, answer_id, comment, extra_points, status, client_id, created_at, updated_at, answer, employ_id, employ_comment, final_comment) FROM stdin;
1	9	5	Feedback	0	2	6	2025-03-21 09:07:58.203871	2025-03-21 09:09:19.71682	t	10	WORKERE	fsdfsdf
2	9	6	Test feedback	1	2	6	2025-04-01 08:21:26.815277	2025-04-01 08:48:40.475916	t	10	Comment by employee	Yes
3	9	131	dsaddas	2	0	6	2025-04-14 12:21:05.672503	2025-04-14 12:21:05.672503	f	\N	\N	\N
\.


--
-- Data for Name: user_worker_groups; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_worker_groups (id, client_id, name, created_at, updated_at, deleted_at, feedback_write, feedback_answer, task_create, ask_question, write_claim) FROM stdin;
1	6	Regeonal manager	2025-06-05 10:50:42.26008	2025-06-05 10:50:42.26008	\N	f	f	f	f	f
\.


--
-- Data for Name: user_worker_task; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_worker_task (id, answer_id, worker_id, status, type_task, client_id, date_start, date_end, attachment, created_at, updated_at, task, who_created, employee_id, employee_comment, employee_files, employee_created_at, final_comment, final_created_at, task_files) FROM stdin;
13	129	10	5	0	6	2025-04-30 00:00:00	2025-04-30 00:00:00	0	2025-04-30 15:38:18.556886	2025-05-01 00:00:00.930813	testt	9	\N	\N	\N	\N	\N	\N	[]
10	157	9	5	0	6	2025-03-27 00:00:00	2025-03-28 00:00:00	0	2025-03-27 14:48:39.946732	2025-03-28 00:00:00.167768	Okkk	9	\N	\N	\N	\N	\N	\N	[]
11	160	9	5	0	6	2025-04-03 00:00:00	2025-04-03 00:00:00	0	2025-04-03 09:50:11.129578	2025-04-04 00:00:00.038666	test	9	\N	\N	\N	\N	\N	\N	[]
12	150	9	5	0	6	2025-04-03 00:00:00	2025-04-03 00:00:00	0	2025-04-03 09:52:52.003668	2025-04-04 00:00:00.038666	test 2	9	\N	\N	\N	\N	\N	\N	[]
1	179	9	5	0	6	2025-03-19 00:00:00	2025-03-25 00:00:00	0	2025-03-19 09:48:04.475451	2025-03-19 10:35:44.178639	Task for employee	9	\N	\N	\N	\N	\N	\N	[]
2	178	10	2	0	6	2025-03-26 00:00:00	2025-03-31 00:00:00	0	2025-03-19 09:52:25.049971	2025-03-24 14:53:38.86588	Task for worker	9	10	Answer by worker	[]	2025-03-19	\N	\N	[]
3	179	10	5	0	6	2025-03-20 00:00:00	2025-03-29 00:00:00	1	2025-03-20 16:27:08.816607	2025-03-21 16:16:55.527947	Test work! need clean bar e	9	\N	\N	\N	\N	\N	\N	[]
4	179	9	5	0	6	2025-03-10 00:00:00	2025-03-29 00:00:00	0	2025-03-21 08:49:47.821956	2025-03-21 10:25:57.326674	цйкцууц	9	\N	\N	\N	\N	\N	\N	["https://proxy.happeas.space/file/read/local/9/cff2b6e10ec8bef896bafa4e0e0728ed.xls", "https://proxy.happeas.space/file/read/local/9/a68949c2b808d61c4591becd26302532.png"]
5	129	10	2	0	6	2025-03-27 00:00:00	2025-03-31 00:00:00	1	2025-03-21 09:02:14.636587	2025-03-27 13:49:30.390191	Test task	9	10	eerter22222222	["https://proxy.happeas.space/file/read/local/10/a54ec3dd989e9aaa3ff301be4f62a296.png"]	2025-03-21	\N	\N	["https://proxy.happeas.space/file/read/local/9/e965c616eb12859af016fe6f047e9f6a.jpg"]
6	129	9	5	0	6	2025-03-27 00:00:00	2025-03-28 00:00:00	0	2025-03-27 12:48:37.757606	2025-03-28 00:00:00.167768	text	9	\N	\N	\N	\N	\N	\N	[]
7	160	9	5	0	6	2025-03-27 00:00:00	2025-03-28 00:00:00	0	2025-03-27 13:04:16.049913	2025-03-28 00:00:00.167768	Lorem ipsum	9	\N	\N	\N	\N	\N	\N	[]
8	160	9	5	0	6	2025-03-27 00:00:00	2025-03-28 00:00:00	0	2025-03-27 13:41:07.12123	2025-03-28 00:00:00.167768	lorem 2	9	\N	\N	\N	\N	\N	\N	[]
9	157	10	5	0	6	2025-03-27 00:00:00	2025-03-27 00:00:00	0	2025-03-27 14:16:23.388982	2025-03-28 00:00:00.167768	ok	9	\N	\N	\N	\N	\N	\N	[]
\.


--
-- Data for Name: user_workers; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.user_workers (id, client_id, user_id, status, created_at, updated_at, "position", department, email_work, phone_work, language, permission_group, feedback_write, feedback_answer, task_create, ask_question, write_claim, xm_settings, cjm_setting) FROM stdin;
3	19	20	0	2025-06-03 13:24:33.373072	2025-06-04 09:02:36.849365	\N	\N	aakarsh.choudhary@floorwalk.in	919589941298	en	\N	t	t	t	t	f	\N	\N
1	6	9	0	2025-03-19 09:38:25.838417	2025-06-20 17:36:52.04489	\N	\N	client@gmail.com	+12342342343	en	\N	t	t	t	t	t	\N	\N
2	6	10	0	2025-03-19 09:39:06.304158	2025-06-20 17:53:08.180129	\N	\N	worker@gmail.com	+13242423233	en	\N	f	t	f	f	t	\N	\N
\.


--
-- Data for Name: waves; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.waves (id, name, created_at, updated_at, client_id, project_id) FROM stdin;
1	05.2025	2025-05-19 17:13:39.081611	2025-05-19 17:13:39.081611	\N	\N
\.


--
-- Data for Name: widget_to_client; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.widget_to_client (id, name, filters, widget_id, creation_date, who_created, sort, "position", type) FROM stdin;
16	TXM Index	{"client_id": 6}	7	2025-07-02 09:28:39.787459	9	0	{"h": 20, "w": 4, "x": 0, "y": 0}	dashboard
17	CX Index	{"type": "cx", "client_id": 6}	6	2025-07-02 09:28:39.792041	9	0	{"h": 5, "w": 4, "x": 4, "y": 0}	dashboard
18	EX Index	{"type": "ex", "client_id": 6}	6	2025-07-02 09:28:39.794351	9	5	{"h": 5, "w": 4, "x": 4, "y": 5}	dashboard
19	UX Index	{"type": "ux", "client_id": 6}	6	2025-07-02 09:28:39.796737	9	10	{"h": 5, "w": 4, "x": 4, "y": 10}	dashboard
20	ROX Index	{"type": "rox", "client_id": 6}	6	2025-07-02 09:28:39.798995	9	15	{"h": 5, "w": 4, "x": 4, "y": 15}	dashboard
21	Action plan	{"client_id": 6}	1	2025-07-02 09:28:39.801256	9	0	{"h": 7, "w": 4, "x": 8, "y": 0}	dashboard
22	Task calendar	{"client_id": 6}	2	2025-07-02 09:28:39.803765	9	7	{"h": 13, "w": 4, "x": 8, "y": 7}	dashboard
\.


--
-- Data for Name: widgets; Type: TABLE DATA; Schema: public; Owner: pma
--

COPY public.widgets (id, name, component, type) FROM stdin;
1	Action Plan	ActionPlanWidget	0
2	Task calendar	TaskCalendarWidget	0
3	Education result	EducationResultWidget	0
4	Trend report	TrendReportWidget	0
5	Circular	CircularReport	0
6	Line report	LineReportWidget	0
7	TXM	TXMWidget	0
8	Section trend	SectionTrendWidget	0
9	Question trend	QuestionTrendWidget	0
10	BarReportWidget	BarReportWidget	0
12	Trend report XM	XMWidget	1
13	Customer Journey Map	CJMWidget	1
14	Rank linear (question)	RankLinearQuestion	0
15	Rank linear (section)	RankLinearSection	0
16	Questionnaires Statistic	QuestionnairesStatisticsWidget	0
17	Index of questionnaire	IndexQuestionnaireWidget	0
18	Index of questionnaire by location	QuestionnaireByLocationWidget	0
19	Comparison by questionnaire	ComparisonQuestionnaireWidget	0
21	Rank columnar (section)	RankColumnarWidget	0
22	Location ranking	LocationRankingWidget	0
23	Non scored question	NonScoredQuestionWidget	0
\.



--
-- Name: user_settings PK_00f004f5922a0744d174530d639; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_settings
    ADD CONSTRAINT "PK_00f004f5922a0744d174530d639" PRIMARY KEY (id);


--
-- Name: location_category_values PK_01ea9b5ecddaf9453f92897437a; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_category_values
    ADD CONSTRAINT "PK_01ea9b5ecddaf9453f92897437a" PRIMARY KEY (id);


--
-- Name: location_execution_validator_link PK_02578a8d361603059b3650521a3; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_execution_validator_link
    ADD CONSTRAINT "PK_02578a8d361603059b3650521a3" PRIMARY KEY (id);


--
-- Name: location_execution_access PK_06421e9620d318a16cf764ff268; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_execution_access
    ADD CONSTRAINT "PK_06421e9620d318a16cf764ff268" PRIMARY KEY (id);


--
-- Name: location_category_relations PK_109a0d19770187f0c2b3f52ee3d; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_category_relations
    ADD CONSTRAINT "PK_109a0d19770187f0c2b3f52ee3d" PRIMARY KEY (id);


--
-- Name: location_execution_user_group_link PK_17a539acebc5e4e2e78ea51ab45; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_execution_user_group_link
    ADD CONSTRAINT "PK_17a539acebc5e4e2e78ea51ab45" PRIMARY KEY (id);


--
-- Name: user_handbook_group PK_1c6f944f7b1dfe0b6d290917f69; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_handbook_group
    ADD CONSTRAINT "PK_1c6f944f7b1dfe0b6d290917f69" PRIMARY KEY (id);


--
-- Name: questionnaire_answer_validator_comment PK_1d4e7f9e79de253af2c9cf590d9; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.questionnaire_answer_validator_comment
    ADD CONSTRAINT "PK_1d4e7f9e79de253af2c9cf590d9" PRIMARY KEY (id);


--
-- Name: file_manager_folders PK_229c742f236b237353ee3d9adc8; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.file_manager_folders
    ADD CONSTRAINT "PK_229c742f236b237353ee3d9adc8" PRIMARY KEY (id);


--
-- Name: location_groups PK_28b724510af407838c620b6b9fc; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_groups
    ADD CONSTRAINT "PK_28b724510af407838c620b6b9fc" PRIMARY KEY (id);


--
-- Name: shop_applications PK_2b1ee1c5f1089c0fe397731eb66; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.shop_applications
    ADD CONSTRAINT "PK_2b1ee1c5f1089c0fe397731eb66" PRIMARY KEY (id);


--
-- Name: ai_train_examples PK_2bb037df788a548839e2f847f22; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.ai_train_examples
    ADD CONSTRAINT "PK_2bb037df788a548839e2f847f22" PRIMARY KEY (id);


--
-- Name: user_comments PK_2d1437dfa86fd64a7a784cd95a8; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_comments
    ADD CONSTRAINT "PK_2d1437dfa86fd64a7a784cd95a8" PRIMARY KEY (id);


--
-- Name: appeals_setting PK_315358882c59623fa0812502655; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.appeals_setting
    ADD CONSTRAINT "PK_315358882c59623fa0812502655" PRIMARY KEY (id);


--
-- Name: user_client_xm_statistics PK_31638af52eb3f01cac31e7428fb; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_client_xm_statistics
    ADD CONSTRAINT "PK_31638af52eb3f01cac31e7428fb" PRIMARY KEY (id);


--
-- Name: questionnaire_answers PK_353fef8e031908634816fa91fd2; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.questionnaire_answers
    ADD CONSTRAINT "PK_353fef8e031908634816fa91fd2" PRIMARY KEY (id);


--
-- Name: client_subdivisions PK_3ba25e44debfad2162263195716; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.client_subdivisions
    ADD CONSTRAINT "PK_3ba25e44debfad2162263195716" PRIMARY KEY (id);


--
-- Name: user_payment_methods PK_3baaffbd29bfd03e2c9e9a1fd24; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_payment_methods
    ADD CONSTRAINT "PK_3baaffbd29bfd03e2c9e9a1fd24" PRIMARY KEY (id);


--
-- Name: questionnaire_sections PK_3be4de6403d5f62f5f011923cb7; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.questionnaire_sections
    ADD CONSTRAINT "PK_3be4de6403d5f62f5f011923cb7" PRIMARY KEY (id);


--
-- Name: file_manager_provider PK_3efc546e67f55a37fbf9adc4faa; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.file_manager_provider
    ADD CONSTRAINT "PK_3efc546e67f55a37fbf9adc4faa" PRIMARY KEY (id);


--
-- Name: program_type_access PK_41ffbe61abd198237d0957dfe3d; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.program_type_access
    ADD CONSTRAINT "PK_41ffbe61abd198237d0957dfe3d" PRIMARY KEY (id);


--
-- Name: location_execution_instructions PK_436ff69465af4fd9a55b3b4f5e4; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_execution_instructions
    ADD CONSTRAINT "PK_436ff69465af4fd9a55b3b4f5e4" PRIMARY KEY (id);


--
-- Name: location_execution PK_442b50b56f3d06ce658e5ffe22d; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_execution
    ADD CONSTRAINT "PK_442b50b56f3d06ce658e5ffe22d" PRIMARY KEY (id);


--
-- Name: program_type_questionnaire_links PK_467b4879b632e5cfbefb42c77ff; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.program_type_questionnaire_links
    ADD CONSTRAINT "PK_467b4879b632e5cfbefb42c77ff" PRIMARY KEY (id);


--
-- Name: user_handbook_link PK_46b05c7f3a46203a08e0f97abf0; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_handbook_link
    ADD CONSTRAINT "PK_46b05c7f3a46203a08e0f97abf0" PRIMARY KEY (id);


--
-- Name: program_type_intensive PK_4a106a053fe2b2b6d392daa3dcd; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.program_type_intensive
    ADD CONSTRAINT "PK_4a106a053fe2b2b6d392daa3dcd" PRIMARY KEY (id);


--
-- Name: role_rules PK_4a1d1980852b67db5b8dcbc8e6e; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.role_rules
    ADD CONSTRAINT "PK_4a1d1980852b67db5b8dcbc8e6e" PRIMARY KEY (id);


--
-- Name: location_categories PK_4e48dc4790629f70bbc060c46be; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_categories
    ADD CONSTRAINT "PK_4e48dc4790629f70bbc060c46be" PRIMARY KEY (id);


--
-- Name: competitor_link PK_4ebfc1e74c1d5a1c4348a51c800; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.competitor_link
    ADD CONSTRAINT "PK_4ebfc1e74c1d5a1c4348a51c800" PRIMARY KEY (id);


--
-- Name: questionnaire_questions PK_522868371a7e3e08cbd044d71b5; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.questionnaire_questions
    ADD CONSTRAINT "PK_522868371a7e3e08cbd044d71b5" PRIMARY KEY (id);


--
-- Name: client_competitors PK_5553c4d1d6e2085d6c1a779b019; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.client_competitors
    ADD CONSTRAINT "PK_5553c4d1d6e2085d6c1a779b019" PRIMARY KEY (id);


--
-- Name: user_notifications PK_569622b0fd6e6ab3661de985a2b; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_notifications
    ADD CONSTRAINT "PK_569622b0fd6e6ab3661de985a2b" PRIMARY KEY (id);


--
-- Name: user_handbook_filling PK_5744e44b1c265c5cbbc95b7b2a5; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_handbook_filling
    ADD CONSTRAINT "PK_5744e44b1c265c5cbbc95b7b2a5" PRIMARY KEY (id);


--
-- Name: questionnaire_answer_histories PK_5a2d2c52eaf9ab19af1a0705b96; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.questionnaire_answer_histories
    ADD CONSTRAINT "PK_5a2d2c52eaf9ab19af1a0705b96" PRIMARY KEY (id);


--
-- Name: role_user_link PK_5a40e2449b87daa0c25fe814672; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.role_user_link
    ADD CONSTRAINT "PK_5a40e2449b87daa0c25fe814672" PRIMARY KEY (id);


--
-- Name: role_actions PK_5ee58f1e3c6236c691f190e0781; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.role_actions
    ADD CONSTRAINT "PK_5ee58f1e3c6236c691f190e0781" PRIMARY KEY (id);


--
-- Name: questionnaire_answer_links PK_60e93cdb40c8336ed3b177aa56c; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.questionnaire_answer_links
    ADD CONSTRAINT "PK_60e93cdb40c8336ed3b177aa56c" PRIMARY KEY (id);


--
-- Name: user_location_access PK_6386b96e3a0c528f40149887d80; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_location_access
    ADD CONSTRAINT "PK_6386b96e3a0c528f40149887d80" PRIMARY KEY (id);


--
-- Name: groups PK_659d1483316afb28afd3a90646e; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.groups
    ADD CONSTRAINT "PK_659d1483316afb28afd3a90646e" PRIMARY KEY (id);


--
-- Name: communication_action_role PK_65c9dfb287d7dc82e83cc79756a; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.communication_action_role
    ADD CONSTRAINT "PK_65c9dfb287d7dc82e83cc79756a" PRIMARY KEY (id);


--
-- Name: questionnaire_mistakes_links PK_67f38d8e2f5e6980418f39325ec; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.questionnaire_mistakes_links
    ADD CONSTRAINT "PK_67f38d8e2f5e6980418f39325ec" PRIMARY KEY (id);


--
-- Name: ai_trains PK_685976824b62c35a99805a4359b; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.ai_trains
    ADD CONSTRAINT "PK_685976824b62c35a99805a4359b" PRIMARY KEY (id);


--
-- Name: communication_action_users PK_68781403ba22399bdb935fdc7f7; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.communication_action_users
    ADD CONSTRAINT "PK_68781403ba22399bdb935fdc7f7" PRIMARY KEY (id);


--
-- Name: user_client_access PK_6ad0a954ee6226c50c14f089945; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_client_access
    ADD CONSTRAINT "PK_6ad0a954ee6226c50c14f089945" PRIMARY KEY (id);


--
-- Name: user_favorites PK_6c472a19a7423cfbbf6b7c75939; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_favorites
    ADD CONSTRAINT "PK_6c472a19a7423cfbbf6b7c75939" PRIMARY KEY (id);


--
-- Name: file_manager_folder_links PK_6df630f7588a4a0bccc45470611; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.file_manager_folder_links
    ADD CONSTRAINT "PK_6df630f7588a4a0bccc45470611" PRIMARY KEY (id);


--
-- Name: communication_action_group PK_7000e05b7f6c80db35eaaa1dd24; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.communication_action_group
    ADD CONSTRAINT "PK_7000e05b7f6c80db35eaaa1dd24" PRIMARY KEY (id);


--
-- Name: location_execution_type PK_717e41929e4f68a8630e8ed8214; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_execution_type
    ADD CONSTRAINT "PK_717e41929e4f68a8630e8ed8214" PRIMARY KEY (id);


--
-- Name: competitors PK_76a451dd0c8a51a0e0fb6284389; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.competitors
    ADD CONSTRAINT "PK_76a451dd0c8a51a0e0fb6284389" PRIMARY KEY (id);


--
-- Name: location_category_filling PK_78c22dbe24fe94537dd1cb1d2c6; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_category_filling
    ADD CONSTRAINT "PK_78c22dbe24fe94537dd1cb1d2c6" PRIMARY KEY (id);


--
-- Name: location_group_links PK_798e18d70fb56bfd81ca890024d; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_group_links
    ADD CONSTRAINT "PK_798e18d70fb56bfd81ca890024d" PRIMARY KEY (id);


--
-- Name: questionnaire_sub_sections PK_79b42a899062c613fcacbbb5ccb; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.questionnaire_sub_sections
    ADD CONSTRAINT "PK_79b42a899062c613fcacbbb5ccb" PRIMARY KEY (id);


--
-- Name: group_user_link PK_7a64f6c4d4725362a2cc17dfa80; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.group_user_link
    ADD CONSTRAINT "PK_7a64f6c4d4725362a2cc17dfa80" PRIMARY KEY (id);


--
-- Name: questionnaire_answer_link_status PK_7ab2ecf339d60dc99647de40d4c; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.questionnaire_answer_link_status
    ADD CONSTRAINT "PK_7ab2ecf339d60dc99647de40d4c" PRIMARY KEY (id);


--
-- Name: actions PK_7bfb822f56be449c0b8adbf83cf; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.actions
    ADD CONSTRAINT "PK_7bfb822f56be449c0b8adbf83cf" PRIMARY KEY (id);


--
-- Name: locations PK_7cc1c9e3853b94816c094825e74; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.locations
    ADD CONSTRAINT "PK_7cc1c9e3853b94816c094825e74" PRIMARY KEY (id);


--
-- Name: user_worker_task PK_7effee13456fd42d843163f1e1d; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_worker_task
    ADD CONSTRAINT "PK_7effee13456fd42d843163f1e1d" PRIMARY KEY (id);


--
-- Name: location_execution_location_link PK_8280508dd420a4d343bb68cf8d1; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_execution_location_link
    ADD CONSTRAINT "PK_8280508dd420a4d343bb68cf8d1" PRIMARY KEY (id);


--
-- Name: user_workers PK_84da0f3ecea7da07b1700480d37; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_workers
    ADD CONSTRAINT "PK_84da0f3ecea7da07b1700480d37" PRIMARY KEY (id);


--
-- Name: program_type PK_87763b5dc03ea0905b390bc5f9f; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.program_type
    ADD CONSTRAINT "PK_87763b5dc03ea0905b390bc5f9f" PRIMARY KEY (id);


--
-- Name: location_status PK_8aaa0643a11576d67d6a29defc3; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_status
    ADD CONSTRAINT "PK_8aaa0643a11576d67d6a29defc3" PRIMARY KEY (id);


--
-- Name: migrations PK_8c82d7f526340ab734260ea46be; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.migrations
    ADD CONSTRAINT "PK_8c82d7f526340ab734260ea46be" PRIMARY KEY (id);


--
-- Name: location_group_parent_link PK_8d16e1360c527edecd5d2a39fc0; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_group_parent_link
    ADD CONSTRAINT "PK_8d16e1360c527edecd5d2a39fc0" PRIMARY KEY (id);


--
-- Name: user_region_access PK_8e03eb2e8b8aaf1e1a0541068dd; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_region_access
    ADD CONSTRAINT "PK_8e03eb2e8b8aaf1e1a0541068dd" PRIMARY KEY (id);


--
-- Name: user_clients PK_93fa1b9251af32ddc852b9eb787; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_clients
    ADD CONSTRAINT "PK_93fa1b9251af32ddc852b9eb787" PRIMARY KEY (id);


--
-- Name: location_execution_bonus_links PK_94a99afd7a2bce565924e6233dd; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_execution_bonus_links
    ADD CONSTRAINT "PK_94a99afd7a2bce565924e6233dd" PRIMARY KEY (id);


--
-- Name: location_execution_manager_link PK_94b70d3006457ae381b8bfe11c2; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_execution_manager_link
    ADD CONSTRAINT "PK_94b70d3006457ae381b8bfe11c2" PRIMARY KEY (id);


--
-- Name: file_manager_user_provider PK_9ac44109307f6c44149bcc73c19; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.file_manager_user_provider
    ADD CONSTRAINT "PK_9ac44109307f6c44149bcc73c19" PRIMARY KEY (id);


--
-- Name: widget_to_client PK_9c31d153786526512b9014ae4d1; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.widget_to_client
    ADD CONSTRAINT "PK_9c31d153786526512b9014ae4d1" PRIMARY KEY (id);


--
-- Name: location_group_user_link PK_9c7864b4d9eea42760f6222016e; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_group_user_link
    ADD CONSTRAINT "PK_9c7864b4d9eea42760f6222016e" PRIMARY KEY (id);


--
-- Name: role_action_link PK_9d3c0e7b7f8543fdd45cd661b26; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.role_action_link
    ADD CONSTRAINT "PK_9d3c0e7b7f8543fdd45cd661b26" PRIMARY KEY (id);


--
-- Name: user_worker_groups PK_9d4cd9416026d37a0b3b0581685; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_worker_groups
    ADD CONSTRAINT "PK_9d4cd9416026d37a0b3b0581685" PRIMARY KEY (id);


--
-- Name: mystery_shopper_visit PK_9dfc395172cbf3dd7032a547ac4; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.mystery_shopper_visit
    ADD CONSTRAINT "PK_9dfc395172cbf3dd7032a547ac4" PRIMARY KEY (id);


--
-- Name: user_handbook_value PK_9fa969bd09add83f46b158ed019; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_handbook_value
    ADD CONSTRAINT "PK_9fa969bd09add83f46b158ed019" PRIMARY KEY (id);


--
-- Name: questionnaires PK_a01d7cdea895ed9796b29233610; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.questionnaires
    ADD CONSTRAINT "PK_a01d7cdea895ed9796b29233610" PRIMARY KEY (id);


--
-- Name: location_execution_scheduler_link PK_a1d2385a66c529571e763a6a32e; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_execution_scheduler_link
    ADD CONSTRAINT "PK_a1d2385a66c529571e763a6a32e" PRIMARY KEY (id);


--
-- Name: file_manager_access PK_a2b1f887d9dacb5690b01b8cbba; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.file_manager_access
    ADD CONSTRAINT "PK_a2b1f887d9dacb5690b01b8cbba" PRIMARY KEY (id);


--
-- Name: location_execution_questionnaire_link PK_aec04266b9e952afd0970eb15be; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_execution_questionnaire_link
    ADD CONSTRAINT "PK_aec04266b9e952afd0970eb15be" PRIMARY KEY (id);


--
-- Name: questionnaire_answer_statistics PK_af9b8472710414ede3d92ada96e; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.questionnaire_answer_statistics
    ADD CONSTRAINT "PK_af9b8472710414ede3d92ada96e" PRIMARY KEY (id);


--
-- Name: status_changes PK_b09386c7bfe17fbe0b6d24e719e; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.status_changes
    ADD CONSTRAINT "PK_b09386c7bfe17fbe0b6d24e719e" PRIMARY KEY (id);


--
-- Name: bonus_system_location_link PK_b3ec40b7ffd8d5d127b34b63aaf; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.bonus_system_location_link
    ADD CONSTRAINT "PK_b3ec40b7ffd8d5d127b34b63aaf" PRIMARY KEY (id);


--
-- Name: user_worker_feedback PK_b441049fb11b43a70b4cd827498; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_worker_feedback
    ADD CONSTRAINT "PK_b441049fb11b43a70b4cd827498" PRIMARY KEY (id);


--
-- Name: user_handbook PK_b5f08c27bc4d6ee8743905433c4; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_handbook
    ADD CONSTRAINT "PK_b5f08c27bc4d6ee8743905433c4" PRIMARY KEY (id);


--
-- Name: ai_provider_scenarios PK_b84754d38856b552630f7bb230e; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.ai_provider_scenarios
    ADD CONSTRAINT "PK_b84754d38856b552630f7bb230e" PRIMARY KEY (id);


--
-- Name: location_execution_type_link PK_b853e136068c470fd65279ef4b4; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_execution_type_link
    ADD CONSTRAINT "PK_b853e136068c470fd65279ef4b4" PRIMARY KEY (id);


--
-- Name: waves PK_b9a2d49cb544011314ff8ce0fd6; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.waves
    ADD CONSTRAINT "PK_b9a2d49cb544011314ff8ce0fd6" PRIMARY KEY (id);


--
-- Name: location_user PK_ba3b695bc9d4bd35cc12839507f; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_user
    ADD CONSTRAINT "PK_ba3b695bc9d4bd35cc12839507f" PRIMARY KEY (id);


--
-- Name: communication_chanel_users PK_bea01a86781f912ba64569c43df; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.communication_chanel_users
    ADD CONSTRAINT "PK_bea01a86781f912ba64569c43df" PRIMARY KEY (id);


--
-- Name: roles PK_c1433d71a4838793a49dcad46ab; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.roles
    ADD CONSTRAINT "PK_c1433d71a4838793a49dcad46ab" PRIMARY KEY (id);


--
-- Name: user_integrations PK_c3de1a91ed82f698dbb15248eb0; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_integrations
    ADD CONSTRAINT "PK_c3de1a91ed82f698dbb15248eb0" PRIMARY KEY (id);


--
-- Name: country_payment_link PK_c73c376684ade79baca4b83e0d6; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.country_payment_link
    ADD CONSTRAINT "PK_c73c376684ade79baca4b83e0d6" PRIMARY KEY (id);


--
-- Name: communication_templates PK_ca5cd6c5ee3127e345e9d30a719; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.communication_templates
    ADD CONSTRAINT "PK_ca5cd6c5ee3127e345e9d30a719" PRIMARY KEY (id);


--
-- Name: jobs PK_cf0a6c42b72fcc7f7c237def345; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.jobs
    ADD CONSTRAINT "PK_cf0a6c42b72fcc7f7c237def345" PRIMARY KEY (id);


--
-- Name: user_country_access PK_cfbb6349eaabd8619fa1c307e4b; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_country_access
    ADD CONSTRAINT "PK_cfbb6349eaabd8619fa1c307e4b" PRIMARY KEY (id);


--
-- Name: location_category_options PK_d7009dcbadef4810efd8204ab57; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_category_options
    ADD CONSTRAINT "PK_d7009dcbadef4810efd8204ab57" PRIMARY KEY (id);


--
-- Name: widgets PK_da23136dbcfc91424451e24b725; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.widgets
    ADD CONSTRAINT "PK_da23136dbcfc91424451e24b725" PRIMARY KEY (id);


--
-- Name: location_questionnaire PK_dd79662de1c8daa137817723f98; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_questionnaire
    ADD CONSTRAINT "PK_dd79662de1c8daa137817723f98" PRIMARY KEY (location_id, questionnaire_id);


--
-- Name: user_payments_data PK_df81d31dfeb17d609c46960203d; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_payments_data
    ADD CONSTRAINT "PK_df81d31dfeb17d609c46960203d" PRIMARY KEY (id);


--
-- Name: file_manager_public_link PK_dff253d2ff322eabba153031787; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.file_manager_public_link
    ADD CONSTRAINT "PK_dff253d2ff322eabba153031787" PRIMARY KEY (id);


--
-- Name: user_notes PK_e6cd579b582af97475256da96fb; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_notes
    ADD CONSTRAINT "PK_e6cd579b582af97475256da96fb" PRIMARY KEY (id);


--
-- Name: imports PK_ea10c62f5eb1d75e83d8b5225db; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.imports
    ADD CONSTRAINT "PK_ea10c62f5eb1d75e83d8b5225db" PRIMARY KEY (id);


--
-- Name: appeals PK_ebd2050a02aa78081b5346152bc; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.appeals
    ADD CONSTRAINT "PK_ebd2050a02aa78081b5346152bc" PRIMARY KEY (id);


--
-- Name: user_city_access PK_f03287707f1ed4ae8918bc03b1f; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_city_access
    ADD CONSTRAINT "PK_f03287707f1ed4ae8918bc03b1f" PRIMARY KEY (id);


--
-- Name: questionnaire_question_options PK_f1267de7b2b23d2d659b48a5abf; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.questionnaire_question_options
    ADD CONSTRAINT "PK_f1267de7b2b23d2d659b48a5abf" PRIMARY KEY (id);


--
-- Name: ai_scenarios_correct PK_f46497a43214ac0b4886b721fb1; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.ai_scenarios_correct
    ADD CONSTRAINT "PK_f46497a43214ac0b4886b721fb1" PRIMARY KEY (id);


--
-- Name: questionnaire_mistakes PK_f4aee02975f2a35dcd6630995dc; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.questionnaire_mistakes
    ADD CONSTRAINT "PK_f4aee02975f2a35dcd6630995dc" PRIMARY KEY (id);


--
-- Name: bonus_system PK_ff0dfde69a957452abfdc62a745; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.bonus_system
    ADD CONSTRAINT "PK_ff0dfde69a957452abfdc62a745" PRIMARY KEY (id);


--
-- Name: location_execution_type_link UQ_execution_type_link; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_execution_type_link
    ADD CONSTRAINT "UQ_execution_type_link" UNIQUE (execution_type_id, execution_id);


--
-- Name: locations UQ_location_unique_id_client_id; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.locations
    ADD CONSTRAINT "UQ_location_unique_id_client_id" UNIQUE (unique_id, client_id);


--
-- Name: cities cities_pkey; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.cities
    ADD CONSTRAINT cities_pkey PRIMARY KEY (id);


--
-- Name: countries countries_pkey; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.countries
    ADD CONSTRAINT countries_pkey PRIMARY KEY (id);


--
-- Name: regions regions_pkey; Type: CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.regions
    ADD CONSTRAINT regions_pkey PRIMARY KEY (id);


--
-- Name: IDX_ANSWER_STATISTIC_LINK_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_ANSWER_STATISTIC_LINK_ID" ON public.questionnaire_answer_statistics USING btree (answer_link_id);


--
-- Name: IDX_APPEALS_SETTING_EXECUTION_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_APPEALS_SETTING_EXECUTION_ID" ON public.appeals_setting USING btree (execution_id);


--
-- Name: IDX_BONUS_SYSTEM_CLIENT_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_BONUS_SYSTEM_CLIENT_ID" ON public.bonus_system USING btree (client_id);


--
-- Name: IDX_BONUS_SYSTEM_LOCATION_GROUP_BONUS_SYSTEM_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_BONUS_SYSTEM_LOCATION_GROUP_BONUS_SYSTEM_ID" ON public.bonus_system_location_link USING btree (bonus_system_id);


--
-- Name: IDX_BONUS_SYSTEM_TYPE; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_BONUS_SYSTEM_TYPE" ON public.bonus_system USING btree (type);


--
-- Name: IDX_BONUS_SYSTEM_WHO_CREATE; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_BONUS_SYSTEM_WHO_CREATE" ON public.bonus_system USING btree (who_create);


--
-- Name: IDX_CLIENT_COMPETITORS_CLIENT_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_CLIENT_COMPETITORS_CLIENT_ID" ON public.client_competitors USING btree (client_id);


--
-- Name: IDX_CLIENT_COMPETITORS_COMPETITOR_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_CLIENT_COMPETITORS_COMPETITOR_ID" ON public.client_competitors USING btree (competitor_id);


--
-- Name: IDX_CLIENT_SUBDIVISIONS_CLIENT_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_CLIENT_SUBDIVISIONS_CLIENT_ID" ON public.client_subdivisions USING btree (client_id);


--
-- Name: IDX_COMMUNICATION_ACTION_GROUP_ACTION_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_COMMUNICATION_ACTION_GROUP_ACTION_ID" ON public.communication_action_group USING btree (action_id);


--
-- Name: IDX_COMMUNICATION_ACTION_ROLE_ACTION_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_COMMUNICATION_ACTION_ROLE_ACTION_ID" ON public.communication_action_role USING btree (action_id);


--
-- Name: IDX_COMPETITOR_LINK; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_COMPETITOR_LINK" ON public.competitor_link USING btree (competitor_id, client_id);


--
-- Name: IDX_HANDBOOK_GROUP_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_HANDBOOK_GROUP_ID" ON public.user_handbook USING btree (handbook_group_id);


--
-- Name: IDX_IS_REQUIRED; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_IS_REQUIRED" ON public.questionnaire_questions USING btree (is_required);


--
-- Name: IDX_JOBS_COUNTRY_CITY; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_JOBS_COUNTRY_CITY" ON public.jobs USING btree (country, city);


--
-- Name: IDX_LOCATION_CATEGORY_FILLING_CATEGORY_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_CATEGORY_FILLING_CATEGORY_ID" ON public.location_category_filling USING btree (category_id);


--
-- Name: IDX_LOCATION_CATEGORY_FILLING_LOCATION_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_CATEGORY_FILLING_LOCATION_ID" ON public.location_category_filling USING btree (location_id);


--
-- Name: IDX_LOCATION_CATEGORY_FILLING_VALUE_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_CATEGORY_FILLING_VALUE_ID" ON public.location_category_filling USING btree (value_id);


--
-- Name: IDX_LOCATION_CATEGORY_OPTIONS_CATEGORY_VALUE_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_CATEGORY_OPTIONS_CATEGORY_VALUE_ID" ON public.location_category_options USING btree (category_value_id);


--
-- Name: IDX_LOCATION_CITY_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_CITY_ID" ON public.locations USING btree (city_id);


--
-- Name: IDX_LOCATION_COUNTRY_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_COUNTRY_ID" ON public.locations USING btree (country_id);


--
-- Name: IDX_LOCATION_EXECUTION_ACCESS_CLIENT_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_EXECUTION_ACCESS_CLIENT_ID" ON public.location_execution_access USING btree (user_id);


--
-- Name: IDX_LOCATION_EXECUTION_ACCESS_EXECUTION_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_EXECUTION_ACCESS_EXECUTION_ID" ON public.location_execution_access USING btree (execution_id);


--
-- Name: IDX_LOCATION_EXECUTION_DATE_END; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_EXECUTION_DATE_END" ON public.location_execution USING btree (data_end);


--
-- Name: IDX_LOCATION_EXECUTION_DATE_START; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_EXECUTION_DATE_START" ON public.location_execution USING btree (data_start);


--
-- Name: IDX_LOCATION_EXECUTION_LOCATION_LOCATION_EXECUTION_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_EXECUTION_LOCATION_LOCATION_EXECUTION_ID" ON public.location_execution_location_link USING btree (location_execution_id);


--
-- Name: IDX_LOCATION_EXECUTION_LOCATION_LOCATION_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_EXECUTION_LOCATION_LOCATION_ID" ON public.location_execution_location_link USING btree (location_id);


--
-- Name: IDX_LOCATION_EXECUTION_PAYMENT_METHOD; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_EXECUTION_PAYMENT_METHOD" ON public.location_execution USING btree (payment_method);


--
-- Name: IDX_LOCATION_EXECUTION_QUESTIONNAIRE_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_EXECUTION_QUESTIONNAIRE_ID" ON public.location_execution USING btree (questionnaire_id);


--
-- Name: IDX_LOCATION_EXECUTION_STATUS; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_EXECUTION_STATUS" ON public.location_execution USING btree (status);


--
-- Name: IDX_LOCATION_EXECUTION_USER_GROUP_LINK_GROUP_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_EXECUTION_USER_GROUP_LINK_GROUP_ID" ON public.location_execution_user_group_link USING btree (group_id);


--
-- Name: IDX_LOCATION_EXECUTION_USER_GROUP_LINK_LOCATION_EXECUTION_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_EXECUTION_USER_GROUP_LINK_LOCATION_EXECUTION_ID" ON public.location_execution_user_group_link USING btree (location_execution_id);


--
-- Name: IDX_LOCATION_EXECUTION_USER_GROUP_USER_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_EXECUTION_USER_GROUP_USER_ID" ON public.location_execution_user_group_link USING btree (user_id);


--
-- Name: IDX_LOCATION_EXECUTION_WHO_CREATED; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_EXECUTION_WHO_CREATED" ON public.location_execution USING btree (who_created);


--
-- Name: IDX_LOCATION_GROUP_PARENT_LINK_GROUP_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_GROUP_PARENT_LINK_GROUP_ID" ON public.location_group_parent_link USING btree (group_id);


--
-- Name: IDX_LOCATION_GROUP_PARENT_LINK_PARENT_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_GROUP_PARENT_LINK_PARENT_ID" ON public.location_group_parent_link USING btree (parent_id);


--
-- Name: IDX_LOCATION_GROUP_USER_LINK; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_GROUP_USER_LINK" ON public.location_group_user_link USING btree (client_id, group_id);


--
-- Name: IDX_LOCATION_GROUP_UUID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_GROUP_UUID" ON public.location_groups USING btree (uuid);


--
-- Name: IDX_LOCATION_REGION_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_REGION_ID" ON public.locations USING btree (region_id);


--
-- Name: IDX_LOCATION_STATUS; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_STATUS" ON public.locations USING btree (status);


--
-- Name: IDX_LOCATION_UNIQUE_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_UNIQUE_ID" ON public.locations USING btree (unique_id);


--
-- Name: IDX_LOCATION_WHO_CREATE; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_LOCATION_WHO_CREATE" ON public.locations USING btree (who_create);


--
-- Name: IDX_MYSTERY_SHOPPER_VISIT_LOCATION_EXECUTION_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_MYSTERY_SHOPPER_VISIT_LOCATION_EXECUTION_ID" ON public.mystery_shopper_visit USING btree (location_execution_id);


--
-- Name: IDX_MYSTERY_SHOPPER_VISIT_LOCATION_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_MYSTERY_SHOPPER_VISIT_LOCATION_ID" ON public.mystery_shopper_visit USING btree (location_id);


--
-- Name: IDX_MYSTERY_SHOPPER_VISIT_STATUS; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_MYSTERY_SHOPPER_VISIT_STATUS" ON public.mystery_shopper_visit USING btree (status);


--
-- Name: IDX_MYSTERY_SHOPPER_VISIT_USER_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_MYSTERY_SHOPPER_VISIT_USER_ID" ON public.mystery_shopper_visit USING btree (user_id);


--
-- Name: IDX_PROGRAM_TYPE_ACCESS_PROGRAM_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_PROGRAM_TYPE_ACCESS_PROGRAM_ID" ON public.program_type_access USING btree (program_id);


--
-- Name: IDX_PROGRAM_TYPE_ACCESS_USER_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_PROGRAM_TYPE_ACCESS_USER_ID" ON public.program_type_access USING btree (user_id);


--
-- Name: IDX_PROGRAM_TYPE_CLIENT_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_PROGRAM_TYPE_CLIENT_ID" ON public.program_type USING btree (client_id);


--
-- Name: IDX_PROGRAM_TYPE_INTENSIVE; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_PROGRAM_TYPE_INTENSIVE" ON public.program_type_intensive USING btree (id);


--
-- Name: IDX_PROGRAM_TYPE_INTENSIVE_BONUS; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_PROGRAM_TYPE_INTENSIVE_BONUS" ON public.program_type_intensive USING btree (bonus_type);


--
-- Name: IDX_PROGRAM_TYPE_INTENSIVE_TYPE; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_PROGRAM_TYPE_INTENSIVE_TYPE" ON public.program_type_intensive USING btree (type);


--
-- Name: IDX_PROGRAM_TYPE_PROGRAM_TYPE; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_PROGRAM_TYPE_PROGRAM_TYPE" ON public.program_type USING btree (program_type);


--
-- Name: IDX_PROGRAM_TYPE_QUESTIONNAIRE_LINKS; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_PROGRAM_TYPE_QUESTIONNAIRE_LINKS" ON public.program_type_questionnaire_links USING btree (questionnaire_id, program_type_id);


--
-- Name: IDX_PROJECT_CODE; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_PROJECT_CODE" ON public.location_execution USING btree (project_code);


--
-- Name: IDX_PROJECT_TYPE; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_PROJECT_TYPE" ON public.location_execution USING btree (project_type);


--
-- Name: IDX_PUBLIC_LINK_HASH; Type: INDEX; Schema: public; Owner: pma
--

CREATE UNIQUE INDEX "IDX_PUBLIC_LINK_HASH" ON public.file_manager_public_link USING btree (hash);


--
-- Name: IDX_QUESTIONNAIRE_ANSWER_ANSWER_LINK; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_ANSWER_ANSWER_LINK" ON public.questionnaire_answers USING btree (questionnaire_answer_link);


--
-- Name: IDX_QUESTIONNAIRE_ANSWER_ID_HISTORIES; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_ANSWER_ID_HISTORIES" ON public.questionnaire_answer_histories USING btree (answer_id);


--
-- Name: IDX_QUESTIONNAIRE_ANSWER_LINKS_SHOP_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_ANSWER_LINKS_SHOP_ID" ON public.questionnaire_answer_links USING btree (shop_id);


--
-- Name: IDX_QUESTIONNAIRE_ANSWER_LINK_CITY_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_ANSWER_LINK_CITY_ID" ON public.questionnaire_answer_links USING btree (city_id);


--
-- Name: IDX_QUESTIONNAIRE_ANSWER_LINK_CUSTOM_NAME; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_ANSWER_LINK_CUSTOM_NAME" ON public.questionnaire_answer_links USING btree (custom_name);


--
-- Name: IDX_QUESTIONNAIRE_ANSWER_LINK_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_ANSWER_LINK_ID" ON public.questionnaire_answers USING btree (link_id);


--
-- Name: IDX_QUESTIONNAIRE_ANSWER_LINK_LOCATION_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_ANSWER_LINK_LOCATION_ID" ON public.questionnaire_answer_links USING btree (location_id);


--
-- Name: IDX_QUESTIONNAIRE_ANSWER_LINK_QUESTIONNAIRE_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_ANSWER_LINK_QUESTIONNAIRE_ID" ON public.questionnaire_answer_links USING btree (questionnaire_id);


--
-- Name: IDX_QUESTIONNAIRE_ANSWER_LINK_STATUS; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_ANSWER_LINK_STATUS" ON public.questionnaire_answer_links USING btree (status);


--
-- Name: IDX_QUESTIONNAIRE_ANSWER_LINK_WHO_CREATED; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_ANSWER_LINK_WHO_CREATED" ON public.questionnaire_answer_links USING btree (who_created);


--
-- Name: IDX_QUESTIONNAIRE_ANSWER_QUESTIONNAIRE_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_ANSWER_QUESTIONNAIRE_ID" ON public.questionnaire_answers USING btree (questionnaire_id);


--
-- Name: IDX_QUESTIONNAIRE_ANSWER_QUESTIONNAIRE_QUESTION_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_ANSWER_QUESTIONNAIRE_QUESTION_ID" ON public.questionnaire_answers USING btree (questionnaire_question_id);


--
-- Name: IDX_QUESTIONNAIRE_ANSWER_QUESTIONNAIRE_SECTION_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_ANSWER_QUESTIONNAIRE_SECTION_ID" ON public.questionnaire_questions USING btree (questionnaire_section_id);


--
-- Name: IDX_QUESTIONNAIRE_ANSWER_STATISTICS_IDENTIFICATION; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_ANSWER_STATISTICS_IDENTIFICATION" ON public.questionnaire_answer_statistics USING btree (identification);


--
-- Name: IDX_QUESTIONNAIRE_ANSWER_STATISTICS_QUESTIONNAIRE_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_ANSWER_STATISTICS_QUESTIONNAIRE_ID" ON public.questionnaire_answer_statistics USING btree (questionnaire_id);


--
-- Name: IDX_QUESTIONNAIRE_ANSWER_STATISTICS_TYPE; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_ANSWER_STATISTICS_TYPE" ON public.questionnaire_answer_statistics USING btree (type);


--
-- Name: IDX_QUESTIONNAIRE_ANSWER_VALIDATOR_COMMENT_ANSWER_LINK_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_ANSWER_VALIDATOR_COMMENT_ANSWER_LINK_ID" ON public.questionnaire_answer_validator_comment USING btree (answer_link_id);


--
-- Name: IDX_QUESTIONNAIRE_ANSWER_VALIDATOR_COMMENT_SHOPPER_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_ANSWER_VALIDATOR_COMMENT_SHOPPER_ID" ON public.questionnaire_answer_validator_comment USING btree (shopper_id);


--
-- Name: IDX_QUESTIONNAIRE_ANSWER_VALIDATOR_COMMENT_TYPE; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_ANSWER_VALIDATOR_COMMENT_TYPE" ON public.questionnaire_answer_validator_comment USING btree (type);


--
-- Name: IDX_QUESTIONNAIRE_ANSWER_VALIDATOR_COMMENT_VALIDATOR_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_ANSWER_VALIDATOR_COMMENT_VALIDATOR_ID" ON public.questionnaire_answer_validator_comment USING btree (validator_id);


--
-- Name: IDX_QUESTIONNAIRE_CLIENT_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_CLIENT_ID" ON public.questionnaires USING btree (client_id);


--
-- Name: IDX_QUESTIONNAIRE_IDENTIFICATION; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_IDENTIFICATION" ON public.questionnaires USING btree (identification);


--
-- Name: IDX_QUESTIONNAIRE_QUESTIONS_IDENTIFICATION; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_QUESTIONS_IDENTIFICATION" ON public.questionnaire_questions USING btree (identification);


--
-- Name: IDX_QUESTIONNAIRE_QUESTION_QUESTIONNAIRE_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_QUESTION_QUESTIONNAIRE_ID" ON public.questionnaire_questions USING btree (questionnaire_id);


--
-- Name: IDX_QUESTIONNAIRE_SECTIONS_IDENTIFICATION; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_SECTIONS_IDENTIFICATION" ON public.questionnaire_sections USING btree (identification);


--
-- Name: IDX_QUESTIONNAIRE_SECTION_QUESTIONNAIRE_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_SECTION_QUESTIONNAIRE_ID" ON public.questionnaire_sections USING btree (questionnaire_id);


--
-- Name: IDX_QUESTIONNAIRE_USER_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTIONNAIRE_USER_ID" ON public.questionnaires USING btree (user_id);


--
-- Name: IDX_QUESTION_TYPE; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_QUESTION_TYPE" ON public.questionnaire_questions USING btree (question_type);


--
-- Name: IDX_ROLES_NAME; Type: INDEX; Schema: public; Owner: pma
--

CREATE UNIQUE INDEX "IDX_ROLES_NAME" ON public.roles USING btree (name);


--
-- Name: IDX_ROLE_ACTIONS_ROLE_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_ROLE_ACTIONS_ROLE_ID" ON public.role_actions USING btree (role_id);


--
-- Name: IDX_ROLE_RULES_ROLE_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_ROLE_RULES_ROLE_ID" ON public.role_rules USING btree (role_id);


--
-- Name: IDX_SHOP_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_SHOP_ID" ON public.mystery_shopper_visit USING btree (shop_id);


--
-- Name: IDX_STATUS_CHANGES_CHANGED_AT; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_STATUS_CHANGES_CHANGED_AT" ON public.status_changes USING btree (changed_at);


--
-- Name: IDX_STATUS_CHANGES_ENTITY_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_STATUS_CHANGES_ENTITY_ID" ON public.status_changes USING btree (entity_id);


--
-- Name: IDX_STATUS_CHANGES_ENTITY_TYPE; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_STATUS_CHANGES_ENTITY_TYPE" ON public.status_changes USING btree (entity_type);


--
-- Name: IDX_STATUS_CHANGES_USER_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_STATUS_CHANGES_USER_ID" ON public.status_changes USING btree (user_id);


--
-- Name: IDX_USER_CLIENTS_CREATED_AT; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_CLIENTS_CREATED_AT" ON public.user_clients USING btree (created_at);


--
-- Name: IDX_USER_CLIENTS_UPDATED_AT; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_CLIENTS_UPDATED_AT" ON public.user_clients USING btree (updated_at);


--
-- Name: IDX_USER_CLIENTS_USER_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_CLIENTS_USER_ID" ON public.user_clients USING btree (user_id);


--
-- Name: IDX_USER_CLIENT_ACCESS_CLIENT_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_CLIENT_ACCESS_CLIENT_ID" ON public.user_client_access USING btree (client_id);


--
-- Name: IDX_USER_CLIENT_ACCESS_USER_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_CLIENT_ACCESS_USER_ID" ON public.user_client_access USING btree (user_id);


--
-- Name: IDX_USER_COMMENTS_USER_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_COMMENTS_USER_ID" ON public.user_comments USING btree (user_id);


--
-- Name: IDX_USER_COMMENTS_WHO_CREATED; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_COMMENTS_WHO_CREATED" ON public.user_comments USING btree (who_created);


--
-- Name: IDX_USER_FAVORITE_UNIQUE; Type: INDEX; Schema: public; Owner: pma
--

CREATE UNIQUE INDEX "IDX_USER_FAVORITE_UNIQUE" ON public.user_favorites USING btree (user_id, shop_id);


--
-- Name: IDX_USER_HANDBOOK_CODE; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_HANDBOOK_CODE" ON public.user_handbook USING btree (code);


--
-- Name: IDX_USER_HANDBOOK_LINK_HANDBOOK_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_HANDBOOK_LINK_HANDBOOK_ID" ON public.user_handbook_link USING btree (handbook_id);


--
-- Name: IDX_USER_HANDBOOK_LINK_ROLE_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_HANDBOOK_LINK_ROLE_ID" ON public.user_handbook_link USING btree (role_id);


--
-- Name: IDX_USER_HANDBOOK_NAME; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_HANDBOOK_NAME" ON public.user_handbook USING btree (name);


--
-- Name: IDX_USER_INTEGRATIONS_SERVICE; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_INTEGRATIONS_SERVICE" ON public.user_integrations USING btree (service);


--
-- Name: IDX_USER_INTEGRATIONS_USER_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_INTEGRATIONS_USER_ID" ON public.user_integrations USING btree (user_id);


--
-- Name: IDX_USER_NOTIFICATIONS_USER_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_NOTIFICATIONS_USER_ID" ON public.user_notifications USING btree (user_id);


--
-- Name: IDX_USER_SETTINGS_CODE; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_SETTINGS_CODE" ON public.user_settings USING btree (code);


--
-- Name: IDX_USER_WORKERS_CLIENT_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_WORKERS_CLIENT_ID" ON public.user_workers USING btree (client_id);


--
-- Name: IDX_USER_WORKERS_USER_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_WORKERS_USER_ID" ON public.user_workers USING btree (user_id);


--
-- Name: IDX_USER_WORKER_FEEDBACK_ANSWER_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_WORKER_FEEDBACK_ANSWER_ID" ON public.user_worker_feedback USING btree (answer_id);


--
-- Name: IDX_USER_WORKER_FEEDBACK_CLIENT_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_WORKER_FEEDBACK_CLIENT_ID" ON public.user_worker_feedback USING btree (client_id);


--
-- Name: IDX_USER_WORKER_FEEDBACK_STATUS; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_WORKER_FEEDBACK_STATUS" ON public.user_worker_feedback USING btree (status);


--
-- Name: IDX_USER_WORKER_TASK_ANSWER_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_WORKER_TASK_ANSWER_ID" ON public.user_worker_task USING btree (answer_id);


--
-- Name: IDX_USER_WORKER_TASK_STATUS; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_WORKER_TASK_STATUS" ON public.user_worker_task USING btree (status);


--
-- Name: IDX_USER_WORKER_TASK_WORKER_ID; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_USER_WORKER_TASK_WORKER_ID" ON public.user_worker_task USING btree (worker_id);


--
-- Name: IDX_U_NOTES_THEME; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX "IDX_U_NOTES_THEME" ON public.user_notes USING btree (theme);


--
-- Name: IDX_location_execution_access_group_id_execution_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE UNIQUE INDEX "IDX_location_execution_access_group_id_execution_id" ON public.location_execution_access USING btree (group_id, execution_id);


--
-- Name: IDX_program_type_access_group_id_program_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE UNIQUE INDEX "IDX_program_type_access_group_id_program_id" ON public.program_type_access USING btree (group_id, program_id);


--
-- Name: IDX_user_city_access_group_id_city_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE UNIQUE INDEX "IDX_user_city_access_group_id_city_id" ON public.user_city_access USING btree (group_id, city_id);


--
-- Name: IDX_user_city_access_worker_group_id_city_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE UNIQUE INDEX "IDX_user_city_access_worker_group_id_city_id" ON public.user_city_access USING btree (worker_group_id, city_id);


--
-- Name: IDX_user_client_access_group_id_client_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE UNIQUE INDEX "IDX_user_client_access_group_id_client_id" ON public.user_client_access USING btree (group_id, client_id);


--
-- Name: IDX_user_country_access_group_id_country_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE UNIQUE INDEX "IDX_user_country_access_group_id_country_id" ON public.user_country_access USING btree (group_id, country_id);


--
-- Name: IDX_user_country_access_worker_group_id_country_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE UNIQUE INDEX "IDX_user_country_access_worker_group_id_country_id" ON public.user_country_access USING btree (worker_group_id, country_id);


--
-- Name: IDX_user_location_access_group_id_location_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE UNIQUE INDEX "IDX_user_location_access_group_id_location_id" ON public.user_location_access USING btree (group_id, location_id);


--
-- Name: IDX_user_location_access_worker_group_id_location_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE UNIQUE INDEX "IDX_user_location_access_worker_group_id_location_id" ON public.user_location_access USING btree (worker_group_id, location_id);


--
-- Name: IDX_user_region_access_group_id_region_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE UNIQUE INDEX "IDX_user_region_access_group_id_region_id" ON public.user_region_access USING btree (group_id, region_id);


--
-- Name: IDX_user_region_access_worker_group_id_region_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE UNIQUE INDEX "IDX_user_region_access_worker_group_id_region_id" ON public.user_region_access USING btree (worker_group_id, region_id);


--
-- Name: actions_code_index; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX actions_code_index ON public.actions USING btree (code);


--
-- Name: communication_action_users_index; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX communication_action_users_index ON public.communication_action_users USING btree (action_id);


--
-- Name: communication_action_users_user_index; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX communication_action_users_user_index ON public.communication_action_users USING btree (user_id);


--
-- Name: communication_chanel_users_index; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX communication_chanel_users_index ON public.communication_chanel_users USING btree (communication_id);


--
-- Name: communication_chanel_users_user_index; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX communication_chanel_users_user_index ON public.communication_chanel_users USING btree (user_id);


--
-- Name: communication_templates_action_index; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX communication_templates_action_index ON public.communication_templates USING btree (action_id);


--
-- Name: communication_templates_index; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX communication_templates_index ON public.communication_templates USING btree (communication_id);


--
-- Name: group_user_link_group_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX group_user_link_group_id ON public.group_user_link USING btree (group_id);


--
-- Name: group_user_link_user_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX group_user_link_user_id ON public.group_user_link USING btree (user_id);


--
-- Name: idx_execution_type_link_execution_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX idx_execution_type_link_execution_id ON public.location_execution_type_link USING btree (execution_id);


--
-- Name: idx_execution_type_link_type_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX idx_execution_type_link_type_id ON public.location_execution_type_link USING btree (execution_type_id);


--
-- Name: idx_program_type_intensive_date_end; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX idx_program_type_intensive_date_end ON public.program_type_intensive USING btree (date_end);


--
-- Name: idx_program_type_intensive_date_start; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX idx_program_type_intensive_date_start ON public.program_type_intensive USING btree (date_start);


--
-- Name: idx_user_worker_group_cities_user_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX idx_user_worker_group_cities_user_id ON public.user_city_access USING btree (user_id);


--
-- Name: idx_user_worker_group_countries_user_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX idx_user_worker_group_countries_user_id ON public.user_country_access USING btree (user_id);


--
-- Name: idx_user_worker_group_locations_user_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX idx_user_worker_group_locations_user_id ON public.user_location_access USING btree (user_id);


--
-- Name: idx_user_worker_group_regions_user_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX idx_user_worker_group_regions_user_id ON public.user_region_access USING btree (user_id);


--
-- Name: role_action_link_index; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX role_action_link_index ON public.role_action_link USING btree (role_id, action_id);


--
-- Name: role_user_link_role_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX role_user_link_role_id ON public.role_user_link USING btree (role_id);


--
-- Name: role_user_link_role_user_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX role_user_link_role_user_id ON public.role_user_link USING btree (user_id);


--
-- Name: user_handbook_filling_handbook_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX user_handbook_filling_handbook_id ON public.user_handbook_filling USING btree (handbook_id);


--
-- Name: user_handbook_filling_user_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX user_handbook_filling_user_id ON public.user_handbook_filling USING btree (user_id);


--
-- Name: user_handbook_value_handbook_id; Type: INDEX; Schema: public; Owner: pma
--

CREATE INDEX user_handbook_value_handbook_id ON public.user_handbook_value USING btree (handbook_id);


--
-- Name: widget_to_client FK_094ca2830ddb75a61dfc4d220bb; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.widget_to_client
    ADD CONSTRAINT "FK_094ca2830ddb75a61dfc4d220bb" FOREIGN KEY (widget_id) REFERENCES public.widgets(id) ON DELETE CASCADE;


--
-- Name: ai_trains FK_1910b37f15ae51b3513a7b9dc76; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.ai_trains
    ADD CONSTRAINT "FK_1910b37f15ae51b3513a7b9dc76" FOREIGN KEY (scenario_id) REFERENCES public.ai_provider_scenarios(id) ON DELETE CASCADE;


--
-- Name: file_manager_public_link FK_1e44e2588e21361fc7b9fe9385a; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.file_manager_public_link
    ADD CONSTRAINT "FK_1e44e2588e21361fc7b9fe9385a" FOREIGN KEY (file_id) REFERENCES public.file_manager(id) ON DELETE CASCADE;


--
-- Name: file_manager_public_link FK_23b3e5b35974cbb18d46c8184a4; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.file_manager_public_link
    ADD CONSTRAINT "FK_23b3e5b35974cbb18d46c8184a4" FOREIGN KEY (provider_id) REFERENCES public.file_manager_provider(id) ON DELETE CASCADE;


--
-- Name: file_manager_folder_links FK_23c4cf479bf726a73866c1b15c5; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.file_manager_folder_links
    ADD CONSTRAINT "FK_23c4cf479bf726a73866c1b15c5" FOREIGN KEY ("fileId") REFERENCES public.file_manager(id);


--
-- Name: location_execution_type_link FK_25a0fa55ddcc0de10c3eed7888e; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_execution_type_link
    ADD CONSTRAINT "FK_25a0fa55ddcc0de10c3eed7888e" FOREIGN KEY (execution_id) REFERENCES public.location_execution(id);


--
-- Name: location_user FK_2a187ea153b876cca3b5d82190b; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_user
    ADD CONSTRAINT "FK_2a187ea153b876cca3b5d82190b" FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: role_actions FK_2ed4344d4ad234b70b11e3014ed; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.role_actions
    ADD CONSTRAINT "FK_2ed4344d4ad234b70b11e3014ed" FOREIGN KEY (role_id) REFERENCES public.roles(id) ON DELETE CASCADE;


--
-- Name: location_execution_type_link FK_3b1f2b93914dfe58e7bb518a537; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_execution_type_link
    ADD CONSTRAINT "FK_3b1f2b93914dfe58e7bb518a537" FOREIGN KEY (execution_type_id) REFERENCES public.location_execution_type(id);


--
-- Name: location_category_relations FK_414f8740b1a1145f616560d203a; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_category_relations
    ADD CONSTRAINT "FK_414f8740b1a1145f616560d203a" FOREIGN KEY (location_category_value_id) REFERENCES public.location_category_values(id) ON DELETE CASCADE;


--
-- Name: user_payments_data FK_4244d561ca164c4a91eb672a30d; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_payments_data
    ADD CONSTRAINT "FK_4244d561ca164c4a91eb672a30d" FOREIGN KEY (payment_method_id) REFERENCES public.user_payment_methods(id) ON DELETE SET NULL;


--
-- Name: location_category_relations FK_56f7202b0920aa8d86c48e4073b; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_category_relations
    ADD CONSTRAINT "FK_56f7202b0920aa8d86c48e4073b" FOREIGN KEY (location_category_id) REFERENCES public.location_categories(id) ON DELETE CASCADE;


--
-- Name: bonus_system_location_link FK_56fe776f8012e10da66ec66a5ea; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.bonus_system_location_link
    ADD CONSTRAINT "FK_56fe776f8012e10da66ec66a5ea" FOREIGN KEY (bonus_system_id) REFERENCES public.bonus_system(id) ON DELETE CASCADE;


--
-- Name: file_manager_folder_links FK_5c76f9a5dda6fb1e54bf705743c; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.file_manager_folder_links
    ADD CONSTRAINT "FK_5c76f9a5dda6fb1e54bf705743c" FOREIGN KEY ("folderId") REFERENCES public.file_manager_folders(id);


--
-- Name: file_manager_public_link FK_5cb50204074ba724d29efd3228c; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.file_manager_public_link
    ADD CONSTRAINT "FK_5cb50204074ba724d29efd3228c" FOREIGN KEY (who_created) REFERENCES public.users(id) ON DELETE SET NULL;


--
-- Name: country_payment_link FK_6eacc6086559082beb6ac2c3244; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.country_payment_link
    ADD CONSTRAINT "FK_6eacc6086559082beb6ac2c3244" FOREIGN KEY (payment_method_id) REFERENCES public.user_payment_methods(id) ON DELETE CASCADE;


--
-- Name: user_payments_data FK_6f71c8eca8b2c1e447e7ea107a9; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_payments_data
    ADD CONSTRAINT "FK_6f71c8eca8b2c1e447e7ea107a9" FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE SET NULL;


--
-- Name: appeals_setting FK_712d084ba7c4e719fef784e507d; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.appeals_setting
    ADD CONSTRAINT "FK_712d084ba7c4e719fef784e507d" FOREIGN KEY (execution_id) REFERENCES public.location_execution(id) ON DELETE CASCADE;


--
-- Name: file_manager_folders FK_7c82e3daaf80678ef0a7880bd15; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.file_manager_folders
    ADD CONSTRAINT "FK_7c82e3daaf80678ef0a7880bd15" FOREIGN KEY ("parentsId") REFERENCES public.file_manager_folders(id);


--
-- Name: shop_applications FK_87ed66ce28d6b49865f42815a28; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.shop_applications
    ADD CONSTRAINT "FK_87ed66ce28d6b49865f42815a28" FOREIGN KEY (shop_id) REFERENCES public.scheduling_shops(id) ON DELETE CASCADE;


--
-- Name: ai_train_examples FK_8e9a44d52649036605b44e5ce7b; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.ai_train_examples
    ADD CONSTRAINT "FK_8e9a44d52649036605b44e5ce7b" FOREIGN KEY (train_id) REFERENCES public.ai_trains(id) ON DELETE CASCADE;


--
-- Name: location_execution_manager_link FK_8feef2960bdb5ecf503eed4622c; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_execution_manager_link
    ADD CONSTRAINT "FK_8feef2960bdb5ecf503eed4622c" FOREIGN KEY (execution_id) REFERENCES public.location_execution(id) ON DELETE CASCADE;


--
-- Name: ai_scenarios_correct FK_94584a332bb9756587dc3e02ed0; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.ai_scenarios_correct
    ADD CONSTRAINT "FK_94584a332bb9756587dc3e02ed0" FOREIGN KEY (scenario_id) REFERENCES public.ai_provider_scenarios(id) ON DELETE CASCADE;


--
-- Name: user_favorites FK_USER_FAVORITES_SHOP; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_favorites
    ADD CONSTRAINT "FK_USER_FAVORITES_SHOP" FOREIGN KEY (shop_id) REFERENCES public.scheduling_shops(id) ON DELETE CASCADE;


--
-- Name: user_favorites FK_USER_FAVORITES_USER; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.user_favorites
    ADD CONSTRAINT "FK_USER_FAVORITES_USER" FOREIGN KEY (user_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: questionnaire_question_options FK_b03cbbfbdd6c16281fefce7e27b; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.questionnaire_question_options
    ADD CONSTRAINT "FK_b03cbbfbdd6c16281fefce7e27b" FOREIGN KEY (questionnaire_id) REFERENCES public.questionnaires(id) ON DELETE CASCADE;


--
-- Name: groups FK_b5ec4f59d8703473034ee7d89b2; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.groups
    ADD CONSTRAINT "FK_b5ec4f59d8703473034ee7d89b2" FOREIGN KEY (role_id) REFERENCES public.roles(id) ON DELETE CASCADE;


--
-- Name: location_category_values FK_b98e7c028e855f230ace1f7588e; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_category_values
    ADD CONSTRAINT "FK_b98e7c028e855f230ace1f7588e" FOREIGN KEY (location_category_id) REFERENCES public.location_categories(id) ON DELETE CASCADE;


--
-- Name: ai_provider_scenarios FK_bb5904c16c2d8b1b8838e37ac1e; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.ai_provider_scenarios
    ADD CONSTRAINT "FK_bb5904c16c2d8b1b8838e37ac1e" FOREIGN KEY (provider_id) REFERENCES public.ai_providers(id) ON DELETE CASCADE;


--
-- Name: shop_applications FK_d486d9ea399da1b80700e5e26c3; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.shop_applications
    ADD CONSTRAINT "FK_d486d9ea399da1b80700e5e26c3" FOREIGN KEY (manager_id) REFERENCES public.users(id) ON DELETE SET NULL;


--
-- Name: role_rules FK_e7d47723580483911e488ac65ba; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.role_rules
    ADD CONSTRAINT "FK_e7d47723580483911e488ac65ba" FOREIGN KEY (role_id) REFERENCES public.roles(id) ON DELETE CASCADE;


--
-- Name: questionnaire_answer_validator_comment FK_e961589e2100ef4a3dc232456b1; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.questionnaire_answer_validator_comment
    ADD CONSTRAINT "FK_e961589e2100ef4a3dc232456b1" FOREIGN KEY (answer_link_id) REFERENCES public.questionnaire_answer_links(id) ON DELETE SET NULL;


--
-- Name: questionnaire_question_options FK_eddae6045305349006dc10f4fbe; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.questionnaire_question_options
    ADD CONSTRAINT "FK_eddae6045305349006dc10f4fbe" FOREIGN KEY (question_id) REFERENCES public.questionnaire_questions(id) ON DELETE CASCADE;


--
-- Name: shop_applications FK_eeb65c8481493b6836633077cfe; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.shop_applications
    ADD CONSTRAINT "FK_eeb65c8481493b6836633077cfe" FOREIGN KEY (shopper_id) REFERENCES public.users(id) ON DELETE CASCADE;


--
-- Name: location_questionnaire FK_ef5722a445e5a9fdd1c01f0dc2f; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_questionnaire
    ADD CONSTRAINT "FK_ef5722a445e5a9fdd1c01f0dc2f" FOREIGN KEY (location_id) REFERENCES public.locations(id);


--
-- Name: location_user FK_fe9d703fffbdc0d46e648e59ba3; Type: FK CONSTRAINT; Schema: public; Owner: pma
--

ALTER TABLE ONLY public.location_user
    ADD CONSTRAINT "FK_fe9d703fffbdc0d46e648e59ba3" FOREIGN KEY (location_id) REFERENCES public.locations(id) ON DELETE CASCADE;


--
-- Name: answer_link_client_view; Type: MATERIALIZED VIEW DATA; Schema: public; Owner: pma
--

REFRESH MATERIALIZED VIEW public.answer_link_client_view;


--
--

