-- Name: base_employeeshiftschedule_company_id_company_id_df72d486; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_employeeshiftschedule_company_id_company_id_df72d486 ON public.base_employeeshiftschedule_company_id USING btree (company_id);


--
-- Name: base_employeeshiftschedule_created_by_id_5dda4d62; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_employeeshiftschedule_created_by_id_5dda4d62 ON public.base_employeeshiftschedule USING btree (created_by_id);


--
-- Name: base_employeeshiftschedule_day_id_3adbec28; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_employeeshiftschedule_day_id_3adbec28 ON public.base_employeeshiftschedule USING btree (day_id);


--
-- Name: base_employeeshiftschedule_employeeshiftschedule_id_e3a7a8a4; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_employeeshiftschedule_employeeshiftschedule_id_e3a7a8a4 ON public.base_employeeshiftschedule_company_id USING btree (employeeshiftschedule_id);


--
-- Name: base_employeeshiftschedule_modified_by_id_4c4cf90a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_employeeshiftschedule_modified_by_id_4c4cf90a ON public.base_employeeshiftschedule USING btree (modified_by_id);


--
-- Name: base_employeeshiftschedule_shift_id_id_0b0b76ba; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_employeeshiftschedule_shift_id_id_0b0b76ba ON public.base_employeeshiftschedule USING btree (shift_id_id);


--
-- Name: base_employeetype_company_id_company_id_fb8006d6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_employeetype_company_id_company_id_fb8006d6 ON public.base_employeetype_company_id USING btree (company_id);


--
-- Name: base_employeetype_company_id_employeetype_id_0aa55002; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_employeetype_company_id_employeetype_id_0aa55002 ON public.base_employeetype_company_id USING btree (employeetype_id);


--
-- Name: base_employeetype_created_by_id_c6fe9642; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_employeetype_created_by_id_c6fe9642 ON public.base_employeetype USING btree (created_by_id);


--
-- Name: base_employeetype_modified_by_id_cb5ba349; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_employeetype_modified_by_id_cb5ba349 ON public.base_employeetype USING btree (modified_by_id);


--
-- Name: base_historicalrotatingshi_audittag_id_814369ae; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingshi_audittag_id_814369ae ON public.base_historicalrotatingshiftassign_history_tags USING btree (audittag_id);


--
-- Name: base_historicalrotatingshi_historicalrotatingshiftass_98c6b941; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingshi_historicalrotatingshiftass_98c6b941 ON public.base_historicalrotatingshiftassign_history_tags USING btree (historicalrotatingshiftassign_id);


--
-- Name: base_historicalrotatingshi_rotating_shift_id_id_3c076fe6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingshi_rotating_shift_id_id_3c076fe6 ON public.base_historicalrotatingshiftassign USING btree (rotating_shift_id_id);


--
-- Name: base_historicalrotatingshiftassign_created_by_id_09d2123e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingshiftassign_created_by_id_09d2123e ON public.base_historicalrotatingshiftassign USING btree (created_by_id);


--
-- Name: base_historicalrotatingshiftassign_current_shift_id_76c97d97; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingshiftassign_current_shift_id_76c97d97 ON public.base_historicalrotatingshiftassign USING btree (current_shift_id);


--
-- Name: base_historicalrotatingshiftassign_employee_id_id_991498a9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingshiftassign_employee_id_id_991498a9 ON public.base_historicalrotatingshiftassign USING btree (employee_id_id);


--
-- Name: base_historicalrotatingshiftassign_history_date_5e854fb5; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingshiftassign_history_date_5e854fb5 ON public.base_historicalrotatingshiftassign USING btree (history_date);


--
-- Name: base_historicalrotatingshiftassign_history_relation_id_f86808dd; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingshiftassign_history_relation_id_f86808dd ON public.base_historicalrotatingshiftassign USING btree (history_relation_id);


--
-- Name: base_historicalrotatingshiftassign_history_user_id_0e47cd81; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingshiftassign_history_user_id_0e47cd81 ON public.base_historicalrotatingshiftassign USING btree (history_user_id);


--
-- Name: base_historicalrotatingshiftassign_id_493b78d7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingshiftassign_id_493b78d7 ON public.base_historicalrotatingshiftassign USING btree (id);


--
-- Name: base_historicalrotatingshiftassign_modified_by_id_f292aff7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingshiftassign_modified_by_id_f292aff7 ON public.base_historicalrotatingshiftassign USING btree (modified_by_id);


--
-- Name: base_historicalrotatingshiftassign_next_shift_id_369414f0; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingshiftassign_next_shift_id_369414f0 ON public.base_historicalrotatingshiftassign USING btree (next_shift_id);


--
-- Name: base_historicalrotatingwor_audittag_id_fbfad6f7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingwor_audittag_id_fbfad6f7 ON public.base_historicalrotatingworktypeassign_history_tags USING btree (audittag_id);


--
-- Name: base_historicalrotatingwor_current_work_type_id_3209eedc; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingwor_current_work_type_id_3209eedc ON public.base_historicalrotatingworktypeassign USING btree (current_work_type_id);


--
-- Name: base_historicalrotatingwor_historicalrotatingworktype_bbc5caa7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingwor_historicalrotatingworktype_bbc5caa7 ON public.base_historicalrotatingworktypeassign_history_tags USING btree (historicalrotatingworktypeassign_id);


--
-- Name: base_historicalrotatingwor_history_relation_id_aa9df2e0; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingwor_history_relation_id_aa9df2e0 ON public.base_historicalrotatingworktypeassign USING btree (history_relation_id);


--
-- Name: base_historicalrotatingwor_next_work_type_id_0aafd1c2; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingwor_next_work_type_id_0aafd1c2 ON public.base_historicalrotatingworktypeassign USING btree (next_work_type_id);


--
-- Name: base_historicalrotatingwor_rotating_work_type_id_id_1070e4ee; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingwor_rotating_work_type_id_id_1070e4ee ON public.base_historicalrotatingworktypeassign USING btree (rotating_work_type_id_id);


--
-- Name: base_historicalrotatingworktypeassign_created_by_id_7361b0d4; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingworktypeassign_created_by_id_7361b0d4 ON public.base_historicalrotatingworktypeassign USING btree (created_by_id);


--
-- Name: base_historicalrotatingworktypeassign_employee_id_id_ac747bf1; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingworktypeassign_employee_id_id_ac747bf1 ON public.base_historicalrotatingworktypeassign USING btree (employee_id_id);


--
-- Name: base_historicalrotatingworktypeassign_history_date_59dde7ca; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingworktypeassign_history_date_59dde7ca ON public.base_historicalrotatingworktypeassign USING btree (history_date);


--
-- Name: base_historicalrotatingworktypeassign_history_user_id_28ca3275; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingworktypeassign_history_user_id_28ca3275 ON public.base_historicalrotatingworktypeassign USING btree (history_user_id);


--
-- Name: base_historicalrotatingworktypeassign_id_e461ed90; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingworktypeassign_id_e461ed90 ON public.base_historicalrotatingworktypeassign USING btree (id);


--
-- Name: base_historicalrotatingworktypeassign_modified_by_id_24058264; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalrotatingworktypeassign_modified_by_id_24058264 ON public.base_historicalrotatingworktypeassign USING btree (modified_by_id);


--
-- Name: base_historicalshiftreques_historicalshiftrequest_id_847ea50e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalshiftreques_historicalshiftrequest_id_847ea50e ON public.base_historicalshiftrequest_history_tags USING btree (historicalshiftrequest_id);


--
-- Name: base_historicalshiftrequest_created_by_id_a7603569; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalshiftrequest_created_by_id_a7603569 ON public.base_historicalshiftrequest USING btree (created_by_id);


--
-- Name: base_historicalshiftrequest_employee_id_id_aedfeaf3; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalshiftrequest_employee_id_id_aedfeaf3 ON public.base_historicalshiftrequest USING btree (employee_id_id);


--
-- Name: base_historicalshiftrequest_history_date_6a85763e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalshiftrequest_history_date_6a85763e ON public.base_historicalshiftrequest USING btree (history_date);


--
-- Name: base_historicalshiftrequest_history_relation_id_b55281a2; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalshiftrequest_history_relation_id_b55281a2 ON public.base_historicalshiftrequest USING btree (history_relation_id);


--
-- Name: base_historicalshiftrequest_history_tags_audittag_id_749e92d3; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalshiftrequest_history_tags_audittag_id_749e92d3 ON public.base_historicalshiftrequest_history_tags USING btree (audittag_id);


--
-- Name: base_historicalshiftrequest_history_user_id_979ea896; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalshiftrequest_history_user_id_979ea896 ON public.base_historicalshiftrequest USING btree (history_user_id);


--
-- Name: base_historicalshiftrequest_id_c79122c2; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalshiftrequest_id_c79122c2 ON public.base_historicalshiftrequest USING btree (id);


--
-- Name: base_historicalshiftrequest_modified_by_id_30a46bb9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalshiftrequest_modified_by_id_30a46bb9 ON public.base_historicalshiftrequest USING btree (modified_by_id);


--
-- Name: base_historicalshiftrequest_previous_shift_id_id_3beec7c0; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalshiftrequest_previous_shift_id_id_3beec7c0 ON public.base_historicalshiftrequest USING btree (previous_shift_id_id);


--
-- Name: base_historicalshiftrequest_reallocate_to_id_b34570a9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalshiftrequest_reallocate_to_id_b34570a9 ON public.base_historicalshiftrequest USING btree (reallocate_to_id);


--
-- Name: base_historicalshiftrequest_shift_id_id_b10c3051; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalshiftrequest_shift_id_id_b10c3051 ON public.base_historicalshiftrequest USING btree (shift_id_id);


--
-- Name: base_historicalworktypereq_audittag_id_e87dd597; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalworktypereq_audittag_id_e87dd597 ON public.base_historicalworktyperequest_history_tags USING btree (audittag_id);


--
-- Name: base_historicalworktypereq_historicalworktyperequest__0e0f338f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalworktypereq_historicalworktyperequest__0e0f338f ON public.base_historicalworktyperequest_history_tags USING btree (historicalworktyperequest_id);


--
-- Name: base_historicalworktypereq_previous_work_type_id_id_162e234d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalworktypereq_previous_work_type_id_id_162e234d ON public.base_historicalworktyperequest USING btree (previous_work_type_id_id);


--
-- Name: base_historicalworktyperequest_created_by_id_a814446c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalworktyperequest_created_by_id_a814446c ON public.base_historicalworktyperequest USING btree (created_by_id);


--
-- Name: base_historicalworktyperequest_employee_id_id_8dcebf94; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalworktyperequest_employee_id_id_8dcebf94 ON public.base_historicalworktyperequest USING btree (employee_id_id);


--
-- Name: base_historicalworktyperequest_history_date_dae1ccdb; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalworktyperequest_history_date_dae1ccdb ON public.base_historicalworktyperequest USING btree (history_date);


--
-- Name: base_historicalworktyperequest_history_relation_id_991a4d9d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalworktyperequest_history_relation_id_991a4d9d ON public.base_historicalworktyperequest USING btree (history_relation_id);


--
-- Name: base_historicalworktyperequest_history_user_id_93351399; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalworktyperequest_history_user_id_93351399 ON public.base_historicalworktyperequest USING btree (history_user_id);


--
-- Name: base_historicalworktyperequest_id_bb0da676; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalworktyperequest_id_bb0da676 ON public.base_historicalworktyperequest USING btree (id);


--
-- Name: base_historicalworktyperequest_modified_by_id_31a4fe5e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalworktyperequest_modified_by_id_31a4fe5e ON public.base_historicalworktyperequest USING btree (modified_by_id);


--
-- Name: base_historicalworktyperequest_work_type_id_id_532ab06d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_historicalworktyperequest_work_type_id_id_532ab06d ON public.base_historicalworktyperequest USING btree (work_type_id_id);


--
-- Name: base_holidays_company_id_id_dcd70297; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_holidays_company_id_id_dcd70297 ON public.base_holidays USING btree (company_id_id);


--
-- Name: base_holidays_created_by_id_0ddc62ec; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_holidays_created_by_id_0ddc62ec ON public.base_holidays USING btree (created_by_id);


--
-- Name: base_holidays_modified_by_id_a4e26e62; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_holidays_modified_by_id_a4e26e62 ON public.base_holidays USING btree (modified_by_id);


--
-- Name: base_horillamailtemplate_company_id_id_c6322691; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_horillamailtemplate_company_id_id_c6322691 ON public.base_horillamailtemplate USING btree (company_id_id);


--
-- Name: base_horillamailtemplate_created_by_id_878efa95; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_horillamailtemplate_created_by_id_878efa95 ON public.base_horillamailtemplate USING btree (created_by_id);


--
-- Name: base_horillamailtemplate_modified_by_id_71c40a87; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_horillamailtemplate_modified_by_id_71c40a87 ON public.base_horillamailtemplate USING btree (modified_by_id);


--
-- Name: base_horillamailtemplate_title_bcdd3970_like; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_horillamailtemplate_title_bcdd3970_like ON public.base_horillamailtemplate USING btree (title varchar_pattern_ops);


--
-- Name: base_jobposition_company_id_company_id_c1803a10; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_jobposition_company_id_company_id_c1803a10 ON public.base_jobposition_company_id USING btree (company_id);


--
-- Name: base_jobposition_company_id_jobposition_id_da6fae2f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_jobposition_company_id_jobposition_id_da6fae2f ON public.base_jobposition_company_id USING btree (jobposition_id);


--
-- Name: base_jobposition_created_by_id_924524b6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_jobposition_created_by_id_924524b6 ON public.base_jobposition USING btree (created_by_id);


--
-- Name: base_jobposition_department_id_id_3a4e0e2c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_jobposition_department_id_id_3a4e0e2c ON public.base_jobposition USING btree (department_id_id);


--
-- Name: base_jobposition_modified_by_id_e834fef8; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_jobposition_modified_by_id_e834fef8 ON public.base_jobposition USING btree (modified_by_id);


--
-- Name: base_jobrole_company_id_company_id_00594b32; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_jobrole_company_id_company_id_00594b32 ON public.base_jobrole_company_id USING btree (company_id);


--
-- Name: base_jobrole_company_id_jobrole_id_0a5b1a10; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_jobrole_company_id_jobrole_id_0a5b1a10 ON public.base_jobrole_company_id USING btree (jobrole_id);


--
-- Name: base_jobrole_created_by_id_295bd2e6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_jobrole_created_by_id_295bd2e6 ON public.base_jobrole USING btree (created_by_id);


--
-- Name: base_jobrole_job_position_id_id_e90dff92; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_jobrole_job_position_id_id_e90dff92 ON public.base_jobrole USING btree (job_position_id_id);


--
-- Name: base_jobrole_modified_by_id_0560dbfb; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_jobrole_modified_by_id_0560dbfb ON public.base_jobrole USING btree (modified_by_id);


--
-- Name: base_multipleapprovalcondition_company_id_id_d33471ce; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_multipleapprovalcondition_company_id_id_d33471ce ON public.base_multipleapprovalcondition USING btree (company_id_id);


--
-- Name: base_multipleapprovalcondition_created_by_id_a833e417; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_multipleapprovalcondition_created_by_id_a833e417 ON public.base_multipleapprovalcondition USING btree (created_by_id);


--
-- Name: base_multipleapprovalcondition_department_id_0123c893; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_multipleapprovalcondition_department_id_0123c893 ON public.base_multipleapprovalcondition USING btree (department_id);


--
-- Name: base_multipleapprovalcondition_modified_by_id_0248a986; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_multipleapprovalcondition_modified_by_id_0248a986 ON public.base_multipleapprovalcondition USING btree (modified_by_id);


--
-- Name: base_multipleapprovalmanagers_condition_id_id_3f6be088; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_multipleapprovalmanagers_condition_id_id_3f6be088 ON public.base_multipleapprovalmanagers USING btree (condition_id_id);


--
-- Name: base_penaltyaccounts_created_by_id_d2cde238; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_penaltyaccounts_created_by_id_d2cde238 ON public.base_penaltyaccounts USING btree (created_by_id);


--
-- Name: base_penaltyaccounts_employee_id_id_edbbe2bb; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_penaltyaccounts_employee_id_id_edbbe2bb ON public.base_penaltyaccounts USING btree (employee_id_id);


--
-- Name: base_penaltyaccounts_late_early_id_id_7a6389d6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_penaltyaccounts_late_early_id_id_7a6389d6 ON public.base_penaltyaccounts USING btree (late_early_id_id);


--
-- Name: base_penaltyaccounts_leave_request_id_id_015a796d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_penaltyaccounts_leave_request_id_id_015a796d ON public.base_penaltyaccounts USING btree (leave_request_id_id);


--
-- Name: base_penaltyaccounts_leave_type_id_id_9fbfde5e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_penaltyaccounts_leave_type_id_id_9fbfde5e ON public.base_penaltyaccounts USING btree (leave_type_id_id);


--
-- Name: base_penaltyaccounts_modified_by_id_ee3da796; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_penaltyaccounts_modified_by_id_ee3da796 ON public.base_penaltyaccounts USING btree (modified_by_id);


--
-- Name: base_rotatingshift_created_by_id_9924e341; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_rotatingshift_created_by_id_9924e341 ON public.base_rotatingshift USING btree (created_by_id);


--
-- Name: base_rotatingshift_modified_by_id_1bf62cb1; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_rotatingshift_modified_by_id_1bf62cb1 ON public.base_rotatingshift USING btree (modified_by_id);


--
-- Name: base_rotatingshift_shift1_id_a18464b7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_rotatingshift_shift1_id_a18464b7 ON public.base_rotatingshift USING btree (shift1_id);


--
-- Name: base_rotatingshift_shift2_id_14afc77b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_rotatingshift_shift2_id_14afc77b ON public.base_rotatingshift USING btree (shift2_id);


--
-- Name: base_rotatingshiftassign_created_by_id_bc0c9b87; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_rotatingshiftassign_created_by_id_bc0c9b87 ON public.base_rotatingshiftassign USING btree (created_by_id);


--
-- Name: base_rotatingshiftassign_current_shift_id_f546b96a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_rotatingshiftassign_current_shift_id_f546b96a ON public.base_rotatingshiftassign USING btree (current_shift_id);


--
-- Name: base_rotatingshiftassign_employee_id_id_2c62486a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_rotatingshiftassign_employee_id_id_2c62486a ON public.base_rotatingshiftassign USING btree (employee_id_id);


--
-- Name: base_rotatingshiftassign_modified_by_id_dbf1e1c7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_rotatingshiftassign_modified_by_id_dbf1e1c7 ON public.base_rotatingshiftassign USING btree (modified_by_id);


--
-- Name: base_rotatingshiftassign_next_shift_id_f32a9069; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_rotatingshiftassign_next_shift_id_f32a9069 ON public.base_rotatingshiftassign USING btree (next_shift_id);


--
-- Name: base_rotatingshiftassign_rotating_shift_id_id_04b24bbb; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_rotatingshiftassign_rotating_shift_id_id_04b24bbb ON public.base_rotatingshiftassign USING btree (rotating_shift_id_id);


--
-- Name: base_rotatingworktype_created_by_id_3e26c1b7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_rotatingworktype_created_by_id_3e26c1b7 ON public.base_rotatingworktype USING btree (created_by_id);


--
-- Name: base_rotatingworktype_modified_by_id_b561415c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_rotatingworktype_modified_by_id_b561415c ON public.base_rotatingworktype USING btree (modified_by_id);


--
-- Name: base_rotatingworktype_work_type1_id_3db498c9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_rotatingworktype_work_type1_id_3db498c9 ON public.base_rotatingworktype USING btree (work_type1_id);


--
-- Name: base_rotatingworktype_work_type2_id_c8539552; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_rotatingworktype_work_type2_id_c8539552 ON public.base_rotatingworktype USING btree (work_type2_id);


--
-- Name: base_rotatingworktypeassign_created_by_id_f70083f5; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_rotatingworktypeassign_created_by_id_f70083f5 ON public.base_rotatingworktypeassign USING btree (created_by_id);


--
-- Name: base_rotatingworktypeassign_current_work_type_id_011f4ef1; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_rotatingworktypeassign_current_work_type_id_011f4ef1 ON public.base_rotatingworktypeassign USING btree (current_work_type_id);


--
-- Name: base_rotatingworktypeassign_employee_id_id_7df12772; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_rotatingworktypeassign_employee_id_id_7df12772 ON public.base_rotatingworktypeassign USING btree (employee_id_id);


--
-- Name: base_rotatingworktypeassign_modified_by_id_617a9333; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_rotatingworktypeassign_modified_by_id_617a9333 ON public.base_rotatingworktypeassign USING btree (modified_by_id);


--
-- Name: base_rotatingworktypeassign_next_work_type_id_51672d14; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_rotatingworktypeassign_next_work_type_id_51672d14 ON public.base_rotatingworktypeassign USING btree (next_work_type_id);


--
-- Name: base_rotatingworktypeassign_rotating_work_type_id_id_25af494e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_rotatingworktypeassign_rotating_work_type_id_id_25af494e ON public.base_rotatingworktypeassign USING btree (rotating_work_type_id_id);


--
-- Name: base_shiftrequest_created_by_id_bea31919; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_shiftrequest_created_by_id_bea31919 ON public.base_shiftrequest USING btree (created_by_id);


--
-- Name: base_shiftrequest_employee_id_id_a5fa6bd9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_shiftrequest_employee_id_id_a5fa6bd9 ON public.base_shiftrequest USING btree (employee_id_id);


--
-- Name: base_shiftrequest_modified_by_id_3062fe89; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_shiftrequest_modified_by_id_3062fe89 ON public.base_shiftrequest USING btree (modified_by_id);


--
-- Name: base_shiftrequest_previous_shift_id_id_e5d96887; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_shiftrequest_previous_shift_id_id_e5d96887 ON public.base_shiftrequest USING btree (previous_shift_id_id);


--
-- Name: base_shiftrequest_reallocate_to_id_48ba7a4e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_shiftrequest_reallocate_to_id_48ba7a4e ON public.base_shiftrequest USING btree (reallocate_to_id);


--
-- Name: base_shiftrequest_shift_id_id_c5024f4a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_shiftrequest_shift_id_id_c5024f4a ON public.base_shiftrequest USING btree (shift_id_id);


--
-- Name: base_shiftrequestcomment_created_by_id_21ea5fad; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_shiftrequestcomment_created_by_id_21ea5fad ON public.base_shiftrequestcomment USING btree (created_by_id);


--
-- Name: base_shiftrequestcomment_employee_id_id_48e54a2f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_shiftrequestcomment_employee_id_id_48e54a2f ON public.base_shiftrequestcomment USING btree (employee_id_id);


--
-- Name: base_shiftrequestcomment_files_baserequestfile_id_7db65962; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_shiftrequestcomment_files_baserequestfile_id_7db65962 ON public.base_shiftrequestcomment_files USING btree (baserequestfile_id);


--
-- Name: base_shiftrequestcomment_files_shiftrequestcomment_id_ee9b60b3; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_shiftrequestcomment_files_shiftrequestcomment_id_ee9b60b3 ON public.base_shiftrequestcomment_files USING btree (shiftrequestcomment_id);


--
-- Name: base_shiftrequestcomment_modified_by_id_18deac02; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_shiftrequestcomment_modified_by_id_18deac02 ON public.base_shiftrequestcomment USING btree (modified_by_id);


--
-- Name: base_shiftrequestcomment_request_id_id_bd54b51e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_shiftrequestcomment_request_id_id_bd54b51e ON public.base_shiftrequestcomment USING btree (request_id_id);


--
-- Name: base_tags_company_id_id_ec9a08f4; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_tags_company_id_id_ec9a08f4 ON public.base_tags USING btree (company_id_id);


--
-- Name: base_tags_created_by_id_16be081b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_tags_created_by_id_16be081b ON public.base_tags USING btree (created_by_id);


--
-- Name: base_tags_modified_by_id_7e6e7fb2; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_tags_modified_by_id_7e6e7fb2 ON public.base_tags USING btree (modified_by_id);


--
-- Name: base_tracklatecomeearlyout_created_by_id_998011af; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_tracklatecomeearlyout_created_by_id_998011af ON public.base_tracklatecomeearlyout USING btree (created_by_id);


--
-- Name: base_tracklatecomeearlyout_modified_by_id_ddef4b5e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_tracklatecomeearlyout_modified_by_id_ddef4b5e ON public.base_tracklatecomeearlyout USING btree (modified_by_id);


--
-- Name: base_worktype_company_id_company_id_d2d58a62; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_worktype_company_id_company_id_d2d58a62 ON public.base_worktype_company_id USING btree (company_id);


--
-- Name: base_worktype_company_id_worktype_id_29a81247; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_worktype_company_id_worktype_id_29a81247 ON public.base_worktype_company_id USING btree (worktype_id);


--
-- Name: base_worktype_created_by_id_bebc20f6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_worktype_created_by_id_bebc20f6 ON public.base_worktype USING btree (created_by_id);


--
-- Name: base_worktype_modified_by_id_15d81354; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_worktype_modified_by_id_15d81354 ON public.base_worktype USING btree (modified_by_id);


--
-- Name: base_worktyperequest_created_by_id_da875da8; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_worktyperequest_created_by_id_da875da8 ON public.base_worktyperequest USING btree (created_by_id);


--
-- Name: base_worktyperequest_employee_id_id_d747036a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_worktyperequest_employee_id_id_d747036a ON public.base_worktyperequest USING btree (employee_id_id);


--
-- Name: base_worktyperequest_modified_by_id_cf5dcbb5; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_worktyperequest_modified_by_id_cf5dcbb5 ON public.base_worktyperequest USING btree (modified_by_id);


--
-- Name: base_worktyperequest_previous_work_type_id_id_0187b88f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_worktyperequest_previous_work_type_id_id_0187b88f ON public.base_worktyperequest USING btree (previous_work_type_id_id);


--
-- Name: base_worktyperequest_work_type_id_id_cff6cd3f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_worktyperequest_work_type_id_id_cff6cd3f ON public.base_worktyperequest USING btree (work_type_id_id);


--
-- Name: base_worktyperequestcommen_worktyperequestcomment_id_4f8ea110; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_worktyperequestcommen_worktyperequestcomment_id_4f8ea110 ON public.base_worktyperequestcomment_files USING btree (worktyperequestcomment_id);


--
-- Name: base_worktyperequestcomment_created_by_id_90ecf6c8; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_worktyperequestcomment_created_by_id_90ecf6c8 ON public.base_worktyperequestcomment USING btree (created_by_id);


--
-- Name: base_worktyperequestcomment_employee_id_id_5f0b0e04; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_worktyperequestcomment_employee_id_id_5f0b0e04 ON public.base_worktyperequestcomment USING btree (employee_id_id);


--
-- Name: base_worktyperequestcomment_files_baserequestfile_id_56f0cad3; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_worktyperequestcomment_files_baserequestfile_id_56f0cad3 ON public.base_worktyperequestcomment_files USING btree (baserequestfile_id);


--
-- Name: base_worktyperequestcomment_modified_by_id_ac63c417; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_worktyperequestcomment_modified_by_id_ac63c417 ON public.base_worktyperequestcomment USING btree (modified_by_id);


--
-- Name: base_worktyperequestcomment_request_id_id_802359b4; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX base_worktyperequestcomment_request_id_id_802359b4 ON public.base_worktyperequestcomment USING btree (request_id_id);


--
-- Name: biometric_biometricdevices_company_id_id_24f01059; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX biometric_biometricdevices_company_id_id_24f01059 ON public.biometric_biometricdevices USING btree (company_id_id);


--
-- Name: biometric_biometricdevices_created_by_id_e53d3c02; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX biometric_biometricdevices_created_by_id_e53d3c02 ON public.biometric_biometricdevices USING btree (created_by_id);


--
-- Name: biometric_biometricdevices_modified_by_id_4a3ba0a1; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX biometric_biometricdevices_modified_by_id_4a3ba0a1 ON public.biometric_biometricdevices USING btree (modified_by_id);


--
-- Name: biometric_biometricemployees_device_id_id_a109542b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX biometric_biometricemployees_device_id_id_a109542b ON public.biometric_biometricemployees USING btree (device_id_id);


--
-- Name: biometric_biometricemployees_employee_id_id_f8a27dce; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX biometric_biometricemployees_employee_id_id_f8a27dce ON public.biometric_biometricemployees USING btree (employee_id_id);


--
-- Name: biometric_cosecattendancearguments_device_id_id_d1307353; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX biometric_cosecattendancearguments_device_id_id_d1307353 ON public.biometric_cosecattendancearguments USING btree (device_id_id);


--
-- Name: django_admin_log_content_type_id_c4bce8eb; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX django_admin_log_content_type_id_c4bce8eb ON public.django_admin_log USING btree (content_type_id);


--
-- Name: django_admin_log_user_id_c564eba6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX django_admin_log_user_id_c564eba6 ON public.django_admin_log USING btree (user_id);


--
-- Name: django_apscheduler_djangojob_next_run_time_2f022619; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX django_apscheduler_djangojob_next_run_time_2f022619 ON public.django_apscheduler_djangojob USING btree (next_run_time);


--
-- Name: django_apscheduler_djangojobexecution_job_id_daf5090a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX django_apscheduler_djangojobexecution_job_id_daf5090a ON public.django_apscheduler_djangojobexecution USING btree (job_id);


--
-- Name: django_apscheduler_djangojobexecution_run_time_16edd96b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX django_apscheduler_djangojobexecution_run_time_16edd96b ON public.django_apscheduler_djangojobexecution USING btree (run_time);


--
-- Name: django_session_expire_date_a5c62663; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX django_session_expire_date_a5c62663 ON public.django_session USING btree (expire_date);


--
-- Name: django_session_session_key_c0390e0f_like; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX django_session_session_key_c0390e0f_like ON public.django_session USING btree (session_key varchar_pattern_ops);


--
-- Name: employee_actiontype_created_by_id_9cd886e5; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_actiontype_created_by_id_9cd886e5 ON public.employee_actiontype USING btree (created_by_id);


--
-- Name: employee_actiontype_modified_by_id_ca03f5db; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_actiontype_modified_by_id_ca03f5db ON public.employee_actiontype USING btree (modified_by_id);


--
-- Name: employee_bonuspoint_created_by_id_2ce413ab; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_bonuspoint_created_by_id_2ce413ab ON public.employee_bonuspoint USING btree (created_by_id);


--
-- Name: employee_bonuspoint_modified_by_id_3041354b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_bonuspoint_modified_by_id_3041354b ON public.employee_bonuspoint USING btree (modified_by_id);


--
-- Name: employee_disciplinaryactio_disciplinaryaction_id_e4d129d5; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_disciplinaryactio_disciplinaryaction_id_e4d129d5 ON public.employee_disciplinaryaction_employee_id USING btree (disciplinaryaction_id);


--
-- Name: employee_disciplinaryaction_action_id_a7d291be; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_disciplinaryaction_action_id_a7d291be ON public.employee_disciplinaryaction USING btree (action_id);


--
-- Name: employee_disciplinaryaction_created_by_id_7fc312af; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_disciplinaryaction_created_by_id_7fc312af ON public.employee_disciplinaryaction USING btree (created_by_id);


--
-- Name: employee_disciplinaryaction_employee_id_employee_id_c3b19929; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_disciplinaryaction_employee_id_employee_id_c3b19929 ON public.employee_disciplinaryaction_employee_id USING btree (employee_id);


--
-- Name: employee_disciplinaryaction_modified_by_id_7eaa64e1; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_disciplinaryaction_modified_by_id_7eaa64e1 ON public.employee_disciplinaryaction USING btree (modified_by_id);


--
-- Name: employee_employee_email_29cdd800_like; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employee_email_29cdd800_like ON public.employee_employee USING btree (email varchar_pattern_ops);


--
-- Name: employee_employeebankdetails_created_by_id_eb03d5bb; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeebankdetails_created_by_id_eb03d5bb ON public.employee_employeebankdetails USING btree (created_by_id);


--
-- Name: employee_employeebankdetails_modified_by_id_8726ef48; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeebankdetails_modified_by_id_8726ef48 ON public.employee_employeebankdetails USING btree (modified_by_id);


--
-- Name: employee_employeegeneralsetting_company_id_id_6cf00960; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeegeneralsetting_company_id_id_6cf00960 ON public.employee_employeegeneralsetting USING btree (company_id_id);


--
-- Name: employee_employeegeneralsetting_created_by_id_03d5751d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeegeneralsetting_created_by_id_03d5751d ON public.employee_employeegeneralsetting USING btree (created_by_id);


--
-- Name: employee_employeegeneralsetting_modified_by_id_47e9b29b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeegeneralsetting_modified_by_id_47e9b29b ON public.employee_employeegeneralsetting USING btree (modified_by_id);


--
-- Name: employee_employeenote_created_by_id_2ca9060d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeenote_created_by_id_2ca9060d ON public.employee_employeenote USING btree (created_by_id);


--
-- Name: employee_employeenote_employee_id_id_b9fd028b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeenote_employee_id_id_b9fd028b ON public.employee_employeenote USING btree (employee_id_id);


--
-- Name: employee_employeenote_modified_by_id_eaeca7b4; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeenote_modified_by_id_eaeca7b4 ON public.employee_employeenote USING btree (modified_by_id);


--
-- Name: employee_employeenote_note_files_employeenote_id_68e119b7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeenote_note_files_employeenote_id_68e119b7 ON public.employee_employeenote_note_files USING btree (employeenote_id);


--
-- Name: employee_employeenote_note_files_notefiles_id_4fff24b8; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeenote_note_files_notefiles_id_4fff24b8 ON public.employee_employeenote_note_files USING btree (notefiles_id);


--
-- Name: employee_employeenote_updated_by_id_03758b94; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeenote_updated_by_id_03758b94 ON public.employee_employeenote USING btree (updated_by_id);


--
-- Name: employee_employeetag_created_by_id_9bd7d192; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeetag_created_by_id_9bd7d192 ON public.employee_employeetag USING btree (created_by_id);


--
-- Name: employee_employeetag_modified_by_id_c671878b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeetag_modified_by_id_c671878b ON public.employee_employeetag USING btree (modified_by_id);


--
-- Name: employee_employeeworkinfor_employeeworkinformation_id_adc704f0; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeeworkinfor_employeeworkinformation_id_adc704f0 ON public.employee_employeeworkinformation_tags USING btree (employeeworkinformation_id);


--
-- Name: employee_employeeworkinfor_reporting_manager_id_id_3f4c7fc4; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeeworkinfor_reporting_manager_id_id_3f4c7fc4 ON public.employee_employeeworkinformation USING btree (reporting_manager_id_id);


--
-- Name: employee_employeeworkinformation_company_id_id_51e946d8; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeeworkinformation_company_id_id_51e946d8 ON public.employee_employeeworkinformation USING btree (company_id_id);


--
-- Name: employee_employeeworkinformation_department_id_id_31d2170f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeeworkinformation_department_id_id_31d2170f ON public.employee_employeeworkinformation USING btree (department_id_id);


--
-- Name: employee_employeeworkinformation_employee_type_id_id_f7707903; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeeworkinformation_employee_type_id_id_f7707903 ON public.employee_employeeworkinformation USING btree (employee_type_id_id);


--
-- Name: employee_employeeworkinformation_job_position_id_id_447a02c3; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeeworkinformation_job_position_id_id_447a02c3 ON public.employee_employeeworkinformation USING btree (job_position_id_id);


--
-- Name: employee_employeeworkinformation_job_role_id_id_b7032a1b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeeworkinformation_job_role_id_id_b7032a1b ON public.employee_employeeworkinformation USING btree (job_role_id_id);


--
-- Name: employee_employeeworkinformation_shift_id_id_868ad7f1; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeeworkinformation_shift_id_id_868ad7f1 ON public.employee_employeeworkinformation USING btree (shift_id_id);


--
-- Name: employee_employeeworkinformation_tags_employeetag_id_d877fd1d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeeworkinformation_tags_employeetag_id_d877fd1d ON public.employee_employeeworkinformation_tags USING btree (employeetag_id);


--
-- Name: employee_employeeworkinformation_work_type_id_id_e48fe5c7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_employeeworkinformation_work_type_id_id_e48fe5c7 ON public.employee_employeeworkinformation USING btree (work_type_id_id);


--
-- Name: employee_historicalbonuspo_historicalbonuspoint_id_40f9c15d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalbonuspo_historicalbonuspoint_id_40f9c15d ON public.employee_historicalbonuspoint_history_tags USING btree (historicalbonuspoint_id);


--
-- Name: employee_historicalbonuspoint_created_by_id_0b61cb56; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalbonuspoint_created_by_id_0b61cb56 ON public.employee_historicalbonuspoint USING btree (created_by_id);


--
-- Name: employee_historicalbonuspoint_employee_id_id_e83d42fc; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalbonuspoint_employee_id_id_e83d42fc ON public.employee_historicalbonuspoint USING btree (employee_id_id);


--
-- Name: employee_historicalbonuspoint_history_date_c3debb07; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalbonuspoint_history_date_c3debb07 ON public.employee_historicalbonuspoint USING btree (history_date);


--
-- Name: employee_historicalbonuspoint_history_relation_id_407cc345; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalbonuspoint_history_relation_id_407cc345 ON public.employee_historicalbonuspoint USING btree (history_relation_id);


--
-- Name: employee_historicalbonuspoint_history_tags_audittag_id_d2a36a4e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalbonuspoint_history_tags_audittag_id_d2a36a4e ON public.employee_historicalbonuspoint_history_tags USING btree (audittag_id);


--
-- Name: employee_historicalbonuspoint_history_user_id_a529213d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalbonuspoint_history_user_id_a529213d ON public.employee_historicalbonuspoint USING btree (history_user_id);


--
-- Name: employee_historicalbonuspoint_id_fe0a60ae; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalbonuspoint_id_fe0a60ae ON public.employee_historicalbonuspoint USING btree (id);


--
-- Name: employee_historicalbonuspoint_modified_by_id_438cff6e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalbonuspoint_modified_by_id_438cff6e ON public.employee_historicalbonuspoint USING btree (modified_by_id);


--
-- Name: employee_historicalemploye_audittag_id_b7e25442; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalemploye_audittag_id_b7e25442 ON public.employee_historicalemployeeworkinformation_history_tags USING btree (audittag_id);


--
-- Name: employee_historicalemploye_company_id_id_cff2a07a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalemploye_company_id_id_cff2a07a ON public.employee_historicalemployeeworkinformation USING btree (company_id_id);


--
-- Name: employee_historicalemploye_department_id_id_865f5100; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalemploye_department_id_id_865f5100 ON public.employee_historicalemployeeworkinformation USING btree (department_id_id);


--
-- Name: employee_historicalemploye_employee_id_id_aba4dc3f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalemploye_employee_id_id_aba4dc3f ON public.employee_historicalemployeeworkinformation USING btree (employee_id_id);


--
-- Name: employee_historicalemploye_employee_type_id_id_e9645a32; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalemploye_employee_type_id_id_e9645a32 ON public.employee_historicalemployeeworkinformation USING btree (employee_type_id_id);


--
-- Name: employee_historicalemploye_historicalemployeeworkinfo_ebf6f81c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalemploye_historicalemployeeworkinfo_ebf6f81c ON public.employee_historicalemployeeworkinformation_history_tags USING btree (historicalemployeeworkinformation_id);


--
-- Name: employee_historicalemploye_history_date_280ba80b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalemploye_history_date_280ba80b ON public.employee_historicalemployeeworkinformation USING btree (history_date);


--
-- Name: employee_historicalemploye_history_relation_id_a688dbcd; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalemploye_history_relation_id_a688dbcd ON public.employee_historicalemployeeworkinformation USING btree (history_relation_id);


--
-- Name: employee_historicalemploye_history_user_id_1977e79f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalemploye_history_user_id_1977e79f ON public.employee_historicalemployeeworkinformation USING btree (history_user_id);


--
-- Name: employee_historicalemploye_job_position_id_id_f2def7a4; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalemploye_job_position_id_id_f2def7a4 ON public.employee_historicalemployeeworkinformation USING btree (job_position_id_id);


--
-- Name: employee_historicalemploye_job_role_id_id_1ddca879; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalemploye_job_role_id_id_1ddca879 ON public.employee_historicalemployeeworkinformation USING btree (job_role_id_id);


--
-- Name: employee_historicalemploye_reporting_manager_id_id_e9aa69e5; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalemploye_reporting_manager_id_id_e9aa69e5 ON public.employee_historicalemployeeworkinformation USING btree (reporting_manager_id_id);


--
-- Name: employee_historicalemploye_work_type_id_id_bd1d8b2d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalemploye_work_type_id_id_bd1d8b2d ON public.employee_historicalemployeeworkinformation USING btree (work_type_id_id);


--
-- Name: employee_historicalemployeeworkinformation_id_535f41ff; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalemployeeworkinformation_id_535f41ff ON public.employee_historicalemployeeworkinformation USING btree (id);


--
-- Name: employee_historicalemployeeworkinformation_shift_id_id_8e8623a6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_historicalemployeeworkinformation_shift_id_id_8e8623a6 ON public.employee_historicalemployeeworkinformation USING btree (shift_id_id);


--
-- Name: employee_notefiles_created_by_id_52d05add; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_notefiles_created_by_id_52d05add ON public.employee_notefiles USING btree (created_by_id);


--
-- Name: employee_notefiles_modified_by_id_6f97580a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_notefiles_modified_by_id_6f97580a ON public.employee_notefiles USING btree (modified_by_id);


--
-- Name: employee_policy_attachments_policy_id_d1ac21df; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_policy_attachments_policy_id_d1ac21df ON public.employee_policy_attachments USING btree (policy_id);


--
-- Name: employee_policy_attachments_policymultiplefile_id_5a893d6a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_policy_attachments_policymultiplefile_id_5a893d6a ON public.employee_policy_attachments USING btree (policymultiplefile_id);


--
-- Name: employee_policy_company_id_company_id_423bd625; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_policy_company_id_company_id_423bd625 ON public.employee_policy_company_id USING btree (company_id);


--
-- Name: employee_policy_company_id_policy_id_76c891af; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_policy_company_id_policy_id_76c891af ON public.employee_policy_company_id USING btree (policy_id);


--
-- Name: employee_policy_created_by_id_9bd13cc9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_policy_created_by_id_9bd13cc9 ON public.employee_policy USING btree (created_by_id);


--
-- Name: employee_policy_modified_by_id_30e119fc; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_policy_modified_by_id_30e119fc ON public.employee_policy USING btree (modified_by_id);


--
-- Name: employee_policy_specific_employees_employee_id_25986e79; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_policy_specific_employees_employee_id_25986e79 ON public.employee_policy_specific_employees USING btree (employee_id);


--
-- Name: employee_policy_specific_employees_policy_id_7a905ba6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_policy_specific_employees_policy_id_7a905ba6 ON public.employee_policy_specific_employees USING btree (policy_id);


--
-- Name: employee_policymultiplefile_created_by_id_ad34b84e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_policymultiplefile_created_by_id_ad34b84e ON public.employee_policymultiplefile USING btree (created_by_id);


--
-- Name: employee_policymultiplefile_modified_by_id_212f8be6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_policymultiplefile_modified_by_id_212f8be6 ON public.employee_policymultiplefile USING btree (modified_by_id);


--
-- Name: employee_profileeditfeature_created_by_id_91dbab11; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_profileeditfeature_created_by_id_91dbab11 ON public.employee_profileeditfeature USING btree (created_by_id);


--
-- Name: employee_profileeditfeature_modified_by_id_a601d18a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX employee_profileeditfeature_modified_by_id_a601d18a ON public.employee_profileeditfeature USING btree (modified_by_id);


--
-- Name: helpdesk_attachment_comment_id_91b1d9ce; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_attachment_comment_id_91b1d9ce ON public.helpdesk_attachment USING btree (comment_id);


--
-- Name: helpdesk_attachment_created_by_id_1c9c4492; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_attachment_created_by_id_1c9c4492 ON public.helpdesk_attachment USING btree (created_by_id);


--
-- Name: helpdesk_attachment_modified_by_id_92fd74ee; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_attachment_modified_by_id_92fd74ee ON public.helpdesk_attachment USING btree (modified_by_id);


--
-- Name: helpdesk_attachment_ticket_id_9aa7f330; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_attachment_ticket_id_9aa7f330 ON public.helpdesk_attachment USING btree (ticket_id);


--
-- Name: helpdesk_claimrequest_created_by_id_b6780703; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_claimrequest_created_by_id_b6780703 ON public.helpdesk_claimrequest USING btree (created_by_id);


--
-- Name: helpdesk_claimrequest_employee_id_id_32aadd98; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_claimrequest_employee_id_id_32aadd98 ON public.helpdesk_claimrequest USING btree (employee_id_id);


--
-- Name: helpdesk_claimrequest_modified_by_id_7d52986e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_claimrequest_modified_by_id_7d52986e ON public.helpdesk_claimrequest USING btree (modified_by_id);


--
-- Name: helpdesk_claimrequest_ticket_id_id_d5306331; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_claimrequest_ticket_id_id_d5306331 ON public.helpdesk_claimrequest USING btree (ticket_id_id);


--
-- Name: helpdesk_comment_created_by_id_07b33a87; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_comment_created_by_id_07b33a87 ON public.helpdesk_comment USING btree (created_by_id);


--
-- Name: helpdesk_comment_employee_id_id_09671cb9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_comment_employee_id_id_09671cb9 ON public.helpdesk_comment USING btree (employee_id_id);


--
-- Name: helpdesk_comment_modified_by_id_9cecf91c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_comment_modified_by_id_9cecf91c ON public.helpdesk_comment USING btree (modified_by_id);


--
-- Name: helpdesk_comment_ticket_id_c00da1fb; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_comment_ticket_id_c00da1fb ON public.helpdesk_comment USING btree (ticket_id);


--
-- Name: helpdesk_departmentmanager_company_id_id_4aa258db; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_departmentmanager_company_id_id_4aa258db ON public.helpdesk_departmentmanager USING btree (company_id_id);


--
-- Name: helpdesk_departmentmanager_created_by_id_429ef9c3; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_departmentmanager_created_by_id_429ef9c3 ON public.helpdesk_departmentmanager USING btree (created_by_id);


--
-- Name: helpdesk_departmentmanager_department_id_aec70b87; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_departmentmanager_department_id_aec70b87 ON public.helpdesk_departmentmanager USING btree (department_id);


--
-- Name: helpdesk_departmentmanager_manager_id_826b081d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_departmentmanager_manager_id_826b081d ON public.helpdesk_departmentmanager USING btree (manager_id);


--
-- Name: helpdesk_departmentmanager_modified_by_id_99acea72; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_departmentmanager_modified_by_id_99acea72 ON public.helpdesk_departmentmanager USING btree (modified_by_id);


--
-- Name: helpdesk_faq_category_id_df198307; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_faq_category_id_df198307 ON public.helpdesk_faq USING btree (category_id);


--
-- Name: helpdesk_faq_company_id_id_5d618d3f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_faq_company_id_id_5d618d3f ON public.helpdesk_faq USING btree (company_id_id);


--
-- Name: helpdesk_faq_created_by_id_106edcde; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_faq_created_by_id_106edcde ON public.helpdesk_faq USING btree (created_by_id);


--
-- Name: helpdesk_faq_modified_by_id_95f51873; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_faq_modified_by_id_95f51873 ON public.helpdesk_faq USING btree (modified_by_id);


--
-- Name: helpdesk_faq_tags_faq_id_fb60403b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_faq_tags_faq_id_fb60403b ON public.helpdesk_faq_tags USING btree (faq_id);


--
-- Name: helpdesk_faq_tags_tags_id_8bf80890; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_faq_tags_tags_id_8bf80890 ON public.helpdesk_faq_tags USING btree (tags_id);


--
-- Name: helpdesk_faqcategory_company_id_id_804d6e9b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_faqcategory_company_id_id_804d6e9b ON public.helpdesk_faqcategory USING btree (company_id_id);


--
-- Name: helpdesk_faqcategory_created_by_id_551ed468; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_faqcategory_created_by_id_551ed468 ON public.helpdesk_faqcategory USING btree (created_by_id);


--
-- Name: helpdesk_faqcategory_modified_by_id_39f245eb; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_faqcategory_modified_by_id_39f245eb ON public.helpdesk_faqcategory USING btree (modified_by_id);


--
-- Name: helpdesk_historicalticket__historicalticket_id_2e6a3113; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_historicalticket__historicalticket_id_2e6a3113 ON public.helpdesk_historicalticket_history_tags USING btree (historicalticket_id);


--
-- Name: helpdesk_historicalticket_created_by_id_d412ca5c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_historicalticket_created_by_id_d412ca5c ON public.helpdesk_historicalticket USING btree (created_by_id);


--
-- Name: helpdesk_historicalticket_employee_id_id_897758d9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_historicalticket_employee_id_id_897758d9 ON public.helpdesk_historicalticket USING btree (employee_id_id);


--
-- Name: helpdesk_historicalticket_history_date_aad09962; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_historicalticket_history_date_aad09962 ON public.helpdesk_historicalticket USING btree (history_date);


--
-- Name: helpdesk_historicalticket_history_relation_id_633fb3cb; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_historicalticket_history_relation_id_633fb3cb ON public.helpdesk_historicalticket USING btree (history_relation_id);


--
-- Name: helpdesk_historicalticket_history_tags_audittag_id_5fd5a887; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_historicalticket_history_tags_audittag_id_5fd5a887 ON public.helpdesk_historicalticket_history_tags USING btree (audittag_id);


--
-- Name: helpdesk_historicalticket_history_user_id_fe620449; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_historicalticket_history_user_id_fe620449 ON public.helpdesk_historicalticket USING btree (history_user_id);


--
-- Name: helpdesk_historicalticket_id_4ff77a58; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_historicalticket_id_4ff77a58 ON public.helpdesk_historicalticket USING btree (id);


--
-- Name: helpdesk_historicalticket_modified_by_id_1cbc35c2; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_historicalticket_modified_by_id_1cbc35c2 ON public.helpdesk_historicalticket USING btree (modified_by_id);


--
-- Name: helpdesk_historicalticket_ticket_type_id_1732560f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_historicalticket_ticket_type_id_1732560f ON public.helpdesk_historicalticket USING btree (ticket_type_id);


--
-- Name: helpdesk_ticket_assigned_to_employee_id_0bb736bc; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_ticket_assigned_to_employee_id_0bb736bc ON public.helpdesk_ticket_assigned_to USING btree (employee_id);


--
-- Name: helpdesk_ticket_assigned_to_ticket_id_63d4ab83; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_ticket_assigned_to_ticket_id_63d4ab83 ON public.helpdesk_ticket_assigned_to USING btree (ticket_id);


--
-- Name: helpdesk_ticket_created_by_id_d27fab9b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_ticket_created_by_id_d27fab9b ON public.helpdesk_ticket USING btree (created_by_id);


--
-- Name: helpdesk_ticket_employee_id_id_8ee8c449; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_ticket_employee_id_id_8ee8c449 ON public.helpdesk_ticket USING btree (employee_id_id);


--
-- Name: helpdesk_ticket_modified_by_id_89892e93; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_ticket_modified_by_id_89892e93 ON public.helpdesk_ticket USING btree (modified_by_id);


--
-- Name: helpdesk_ticket_tags_tags_id_9964f9a6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_ticket_tags_tags_id_9964f9a6 ON public.helpdesk_ticket_tags USING btree (tags_id);


--
-- Name: helpdesk_ticket_tags_ticket_id_ee2dfd5d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_ticket_tags_ticket_id_ee2dfd5d ON public.helpdesk_ticket_tags USING btree (ticket_id);


--
-- Name: helpdesk_ticket_ticket_type_id_f444cfdc; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_ticket_ticket_type_id_f444cfdc ON public.helpdesk_ticket USING btree (ticket_type_id);


--
-- Name: helpdesk_tickettype_company_id_id_79c589c3; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_tickettype_company_id_id_79c589c3 ON public.helpdesk_tickettype USING btree (company_id_id);


--
-- Name: helpdesk_tickettype_created_by_id_2cec5ee8; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_tickettype_created_by_id_2cec5ee8 ON public.helpdesk_tickettype USING btree (created_by_id);


--
-- Name: helpdesk_tickettype_modified_by_id_009acadd; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_tickettype_modified_by_id_009acadd ON public.helpdesk_tickettype USING btree (modified_by_id);


--
-- Name: helpdesk_tickettype_prefix_34835c95_like; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_tickettype_prefix_34835c95_like ON public.helpdesk_tickettype USING btree (prefix varchar_pattern_ops);


--
-- Name: helpdesk_tickettype_title_a62559f1_like; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX helpdesk_tickettype_title_a62559f1_like ON public.helpdesk_tickettype USING btree (title varchar_pattern_ops);


--
-- Name: horilla_audit_accountblockunblock_created_by_id_2d0903f4; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_audit_accountblockunblock_created_by_id_2d0903f4 ON public.horilla_audit_accountblockunblock USING btree (created_by_id);


--
-- Name: horilla_audit_accountblockunblock_modified_by_id_e06c2411; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_audit_accountblockunblock_modified_by_id_e06c2411 ON public.horilla_audit_accountblockunblock USING btree (modified_by_id);


--
-- Name: horilla_audit_historytrackingfields_created_by_id_27e3200d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_audit_historytrackingfields_created_by_id_27e3200d ON public.horilla_audit_historytrackingfields USING btree (created_by_id);


--
-- Name: horilla_audit_historytrackingfields_modified_by_id_f18a1c2b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_audit_historytrackingfields_modified_by_id_f18a1c2b ON public.horilla_audit_historytrackingfields USING btree (modified_by_id);


--
-- Name: horilla_automations_mailau_employee_id_171dec3c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_automations_mailau_employee_id_171dec3c ON public.horilla_automations_mailautomation_also_sent_to USING btree (employee_id);


--
-- Name: horilla_automations_mailau_horillamailtemplate_id_5690af76; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_automations_mailau_horillamailtemplate_id_5690af76 ON public.horilla_automations_mailautomation_template_attachments USING btree (horillamailtemplate_id);


--
-- Name: horilla_automations_mailau_mailautomation_id_98de9e7f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_automations_mailau_mailautomation_id_98de9e7f ON public.horilla_automations_mailautomation_template_attachments USING btree (mailautomation_id);


--
-- Name: horilla_automations_mailau_mailautomation_id_f07a90e5; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_automations_mailau_mailautomation_id_f07a90e5 ON public.horilla_automations_mailautomation_also_sent_to USING btree (mailautomation_id);


--
-- Name: horilla_automations_mailautomation_created_by_id_f608ac56; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_automations_mailautomation_created_by_id_f608ac56 ON public.horilla_automations_mailautomation USING btree (created_by_id);


--
-- Name: horilla_automations_mailautomation_mail_template_id_2e72212b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_automations_mailautomation_mail_template_id_2e72212b ON public.horilla_automations_mailautomation USING btree (mail_template_id);


--
-- Name: horilla_automations_mailautomation_modified_by_id_6e3b0f9c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_automations_mailautomation_modified_by_id_6e3b0f9c ON public.horilla_automations_mailautomation USING btree (modified_by_id);


--
-- Name: horilla_automations_mailautomation_title_559fa34d_like; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_automations_mailautomation_title_559fa34d_like ON public.horilla_automations_mailautomation USING btree (title varchar_pattern_ops);


--
-- Name: horilla_documents_document_created_by_id_27ebe6f9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_documents_document_created_by_id_27ebe6f9 ON public.horilla_documents_document USING btree (created_by_id);


--
-- Name: horilla_documents_document_document_request_id_id_c7d87c9d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_documents_document_document_request_id_id_c7d87c9d ON public.horilla_documents_document USING btree (document_request_id_id);


--
-- Name: horilla_documents_document_documentrequest_id_946f3c45; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_documents_document_documentrequest_id_946f3c45 ON public.horilla_documents_documentrequest_employee_id USING btree (documentrequest_id);


--
-- Name: horilla_documents_document_employee_id_fae3d473; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_documents_document_employee_id_fae3d473 ON public.horilla_documents_documentrequest_employee_id USING btree (employee_id);


--
-- Name: horilla_documents_document_employee_id_id_5ef97a47; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_documents_document_employee_id_id_5ef97a47 ON public.horilla_documents_document USING btree (employee_id_id);


--
-- Name: horilla_documents_document_modified_by_id_fd191cc3; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_documents_document_modified_by_id_fd191cc3 ON public.horilla_documents_document USING btree (modified_by_id);


--
-- Name: horilla_documents_documentrequest_created_by_id_2d57c3d0; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_documents_documentrequest_created_by_id_2d57c3d0 ON public.horilla_documents_documentrequest USING btree (created_by_id);


--
-- Name: horilla_documents_documentrequest_modified_by_id_011217e2; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_documents_documentrequest_modified_by_id_011217e2 ON public.horilla_documents_documentrequest USING btree (modified_by_id);


--
-- Name: horilla_views_activegroup_created_by_id_1dfd304f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_views_activegroup_created_by_id_1dfd304f ON public.horilla_views_activegroup USING btree (created_by_id);


--
-- Name: horilla_views_activegroup_modified_by_id_c56c9f77; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_views_activegroup_modified_by_id_c56c9f77 ON public.horilla_views_activegroup USING btree (modified_by_id);


--
-- Name: horilla_views_activetab_created_by_id_51b1de73; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_views_activetab_created_by_id_51b1de73 ON public.horilla_views_activetab USING btree (created_by_id);


--
-- Name: horilla_views_activetab_modified_by_id_b2ed9a4f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_views_activetab_modified_by_id_b2ed9a4f ON public.horilla_views_activetab USING btree (modified_by_id);


--
-- Name: horilla_views_activeview_created_by_id_bd3fa3b0; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_views_activeview_created_by_id_bd3fa3b0 ON public.horilla_views_activeview USING btree (created_by_id);


--
-- Name: horilla_views_activeview_modified_by_id_76961f19; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_views_activeview_modified_by_id_76961f19 ON public.horilla_views_activeview USING btree (modified_by_id);


--
-- Name: horilla_views_savedfilter_created_by_id_b518dec7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_views_savedfilter_created_by_id_b518dec7 ON public.horilla_views_savedfilter USING btree (created_by_id);


--
-- Name: horilla_views_savedfilter_modified_by_id_b634027b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_views_savedfilter_modified_by_id_b634027b ON public.horilla_views_savedfilter USING btree (modified_by_id);


--
-- Name: horilla_views_togglecolumn_created_by_id_78544c63; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_views_togglecolumn_created_by_id_78544c63 ON public.horilla_views_togglecolumn USING btree (created_by_id);


--
-- Name: horilla_views_togglecolumn_modified_by_id_870460c9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_views_togglecolumn_modified_by_id_870460c9 ON public.horilla_views_togglecolumn USING btree (modified_by_id);


--
-- Name: horilla_views_togglecolumn_user_id_id_d9e19c10; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX horilla_views_togglecolumn_user_id_id_d9e19c10 ON public.horilla_views_togglecolumn USING btree (user_id_id);


--
-- Name: leave_availableleave_created_by_id_75d3a012; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_availableleave_created_by_id_75d3a012 ON public.leave_availableleave USING btree (created_by_id);


--
-- Name: leave_availableleave_employee_id_id_3de1ccfe; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_availableleave_employee_id_id_3de1ccfe ON public.leave_availableleave USING btree (employee_id_id);


--
-- Name: leave_availableleave_leave_type_id_id_b0a6a9df; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_availableleave_leave_type_id_id_b0a6a9df ON public.leave_availableleave USING btree (leave_type_id_id);


--
-- Name: leave_availableleave_modified_by_id_12a52a9f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_availableleave_modified_by_id_12a52a9f ON public.leave_availableleave USING btree (modified_by_id);


--
-- Name: leave_companyleave_company_id_id_3b9c39d2; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_companyleave_company_id_id_3b9c39d2 ON public.leave_companyleave USING btree (company_id_id);


--
-- Name: leave_companyleave_created_by_id_d1124f9a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_companyleave_created_by_id_d1124f9a ON public.leave_companyleave USING btree (created_by_id);


--
-- Name: leave_companyleave_modified_by_id_443e3b4e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_companyleave_modified_by_id_443e3b4e ON public.leave_companyleave USING btree (modified_by_id);


--
-- Name: leave_compensatoryleavereq_attendance_id_7ce6282a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_compensatoryleavereq_attendance_id_7ce6282a ON public.leave_compensatoryleaverequest_attendance_id USING btree (attendance_id);


--
-- Name: leave_compensatoryleavereq_compensatoryleaverequest_i_fb4c2ddd; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_compensatoryleavereq_compensatoryleaverequest_i_fb4c2ddd ON public.leave_compensatoryleaverequest_attendance_id USING btree (compensatoryleaverequest_id);


--
-- Name: leave_compensatoryleavereq_compensatoryleaverequestco_d9216e38; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_compensatoryleavereq_compensatoryleaverequestco_d9216e38 ON public.leave_compensatoryleaverequestcomment_files USING btree (compensatoryleaverequestcomment_id);


--
-- Name: leave_compensatoryleavereq_leaverequestfile_id_cc53628f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_compensatoryleavereq_leaverequestfile_id_cc53628f ON public.leave_compensatoryleaverequestcomment_files USING btree (leaverequestfile_id);


--
-- Name: leave_compensatoryleaverequest_created_by_id_a533f271; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_compensatoryleaverequest_created_by_id_a533f271 ON public.leave_compensatoryleaverequest USING btree (created_by_id);


--
-- Name: leave_compensatoryleaverequest_employee_id_id_c2d214d6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_compensatoryleaverequest_employee_id_id_c2d214d6 ON public.leave_compensatoryleaverequest USING btree (employee_id_id);


--
-- Name: leave_compensatoryleaverequest_leave_type_id_id_47c030a2; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_compensatoryleaverequest_leave_type_id_id_47c030a2 ON public.leave_compensatoryleaverequest USING btree (leave_type_id_id);


--
-- Name: leave_compensatoryleaverequest_modified_by_id_ea6163b7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_compensatoryleaverequest_modified_by_id_ea6163b7 ON public.leave_compensatoryleaverequest USING btree (modified_by_id);


--
-- Name: leave_compensatoryleaverequestcomment_created_by_id_598d2be4; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_compensatoryleaverequestcomment_created_by_id_598d2be4 ON public.leave_compensatoryleaverequestcomment USING btree (created_by_id);


--
-- Name: leave_compensatoryleaverequestcomment_employee_id_id_0641cfdd; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_compensatoryleaverequestcomment_employee_id_id_0641cfdd ON public.leave_compensatoryleaverequestcomment USING btree (employee_id_id);


--
-- Name: leave_compensatoryleaverequestcomment_modified_by_id_6a26749a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_compensatoryleaverequestcomment_modified_by_id_6a26749a ON public.leave_compensatoryleaverequestcomment USING btree (modified_by_id);


--
-- Name: leave_compensatoryleaverequestcomment_request_id_id_dd5729ca; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_compensatoryleaverequestcomment_request_id_id_dd5729ca ON public.leave_compensatoryleaverequestcomment USING btree (request_id_id);


--
-- Name: leave_employeepastleaverestrict_created_by_id_c1663d75; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_employeepastleaverestrict_created_by_id_c1663d75 ON public.leave_employeepastleaverestrict USING btree (created_by_id);


--
-- Name: leave_employeepastleaverestrict_modified_by_id_abfc1efe; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_employeepastleaverestrict_modified_by_id_abfc1efe ON public.leave_employeepastleaverestrict USING btree (modified_by_id);


--
-- Name: leave_historicalavailablel_audittag_id_16f9c7b7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalavailablel_audittag_id_16f9c7b7 ON public.leave_historicalavailableleave_history_tags USING btree (audittag_id);


--
-- Name: leave_historicalavailablel_historicalavailableleave_i_3015fcbf; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalavailablel_historicalavailableleave_i_3015fcbf ON public.leave_historicalavailableleave_history_tags USING btree (historicalavailableleave_id);


--
-- Name: leave_historicalavailableleave_created_by_id_0efaecfc; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalavailableleave_created_by_id_0efaecfc ON public.leave_historicalavailableleave USING btree (created_by_id);


--
-- Name: leave_historicalavailableleave_employee_id_id_51610009; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalavailableleave_employee_id_id_51610009 ON public.leave_historicalavailableleave USING btree (employee_id_id);


--
-- Name: leave_historicalavailableleave_history_date_08ada119; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalavailableleave_history_date_08ada119 ON public.leave_historicalavailableleave USING btree (history_date);


--
-- Name: leave_historicalavailableleave_history_relation_id_f10eea38; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalavailableleave_history_relation_id_f10eea38 ON public.leave_historicalavailableleave USING btree (history_relation_id);


--
-- Name: leave_historicalavailableleave_history_user_id_38f3a774; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalavailableleave_history_user_id_38f3a774 ON public.leave_historicalavailableleave USING btree (history_user_id);


--
-- Name: leave_historicalavailableleave_id_a95e4b3a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalavailableleave_id_a95e4b3a ON public.leave_historicalavailableleave USING btree (id);


--
-- Name: leave_historicalavailableleave_leave_type_id_id_32718e53; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalavailableleave_leave_type_id_id_32718e53 ON public.leave_historicalavailableleave USING btree (leave_type_id_id);


--
-- Name: leave_historicalavailableleave_modified_by_id_fd7825a7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalavailableleave_modified_by_id_fd7825a7 ON public.leave_historicalavailableleave USING btree (modified_by_id);


--
-- Name: leave_historicalcompensato_audittag_id_24ff99a6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalcompensato_audittag_id_24ff99a6 ON public.leave_historicalcompensatoryleaverequest_history_tags USING btree (audittag_id);


--
-- Name: leave_historicalcompensato_employee_id_id_61ea7ae1; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalcompensato_employee_id_id_61ea7ae1 ON public.leave_historicalcompensatoryleaverequest USING btree (employee_id_id);


--
-- Name: leave_historicalcompensato_historicalcompensatoryleav_6146f2d9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalcompensato_historicalcompensatoryleav_6146f2d9 ON public.leave_historicalcompensatoryleaverequest_history_tags USING btree (historicalcompensatoryleaverequest_id);


--
-- Name: leave_historicalcompensato_history_relation_id_868c3a67; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalcompensato_history_relation_id_868c3a67 ON public.leave_historicalcompensatoryleaverequest USING btree (history_relation_id);


--
-- Name: leave_historicalcompensato_history_user_id_20a9d7af; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalcompensato_history_user_id_20a9d7af ON public.leave_historicalcompensatoryleaverequest USING btree (history_user_id);


--
-- Name: leave_historicalcompensato_leave_type_id_id_6f5475fb; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalcompensato_leave_type_id_id_6f5475fb ON public.leave_historicalcompensatoryleaverequest USING btree (leave_type_id_id);


--
-- Name: leave_historicalcompensato_modified_by_id_f7ecf360; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalcompensato_modified_by_id_f7ecf360 ON public.leave_historicalcompensatoryleaverequest USING btree (modified_by_id);


--
-- Name: leave_historicalcompensatoryleaverequest_created_by_id_8ce0aa66; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalcompensatoryleaverequest_created_by_id_8ce0aa66 ON public.leave_historicalcompensatoryleaverequest USING btree (created_by_id);


--
-- Name: leave_historicalcompensatoryleaverequest_history_date_ec170bef; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalcompensatoryleaverequest_history_date_ec170bef ON public.leave_historicalcompensatoryleaverequest USING btree (history_date);


--
-- Name: leave_historicalcompensatoryleaverequest_id_7710c744; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalcompensatoryleaverequest_id_7710c744 ON public.leave_historicalcompensatoryleaverequest USING btree (id);


--
-- Name: leave_historicalleavealloc_audittag_id_b2aa60d9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalleavealloc_audittag_id_b2aa60d9 ON public.leave_historicalleaveallocationrequest_history_tags USING btree (audittag_id);


--
-- Name: leave_historicalleavealloc_historicalleaveallocationr_e3b6fb3a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalleavealloc_historicalleaveallocationr_e3b6fb3a ON public.leave_historicalleaveallocationrequest_history_tags USING btree (historicalleaveallocationrequest_id);


--
-- Name: leave_historicalleavealloc_history_relation_id_794f8177; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalleavealloc_history_relation_id_794f8177 ON public.leave_historicalleaveallocationrequest USING btree (history_relation_id);


--
-- Name: leave_historicalleavealloc_leave_type_id_id_eaf323c2; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalleavealloc_leave_type_id_id_eaf323c2 ON public.leave_historicalleaveallocationrequest USING btree (leave_type_id_id);


--
-- Name: leave_historicalleaveallocationrequest_created_by_id_0b0eb9f8; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalleaveallocationrequest_created_by_id_0b0eb9f8 ON public.leave_historicalleaveallocationrequest USING btree (created_by_id);


--
-- Name: leave_historicalleaveallocationrequest_employee_id_id_4fd984a6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalleaveallocationrequest_employee_id_id_4fd984a6 ON public.leave_historicalleaveallocationrequest USING btree (employee_id_id);


--
-- Name: leave_historicalleaveallocationrequest_history_date_b672610d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalleaveallocationrequest_history_date_b672610d ON public.leave_historicalleaveallocationrequest USING btree (history_date);


--
-- Name: leave_historicalleaveallocationrequest_history_user_id_4b781dd5; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalleaveallocationrequest_history_user_id_4b781dd5 ON public.leave_historicalleaveallocationrequest USING btree (history_user_id);


--
-- Name: leave_historicalleaveallocationrequest_id_7a662112; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalleaveallocationrequest_id_7a662112 ON public.leave_historicalleaveallocationrequest USING btree (id);


--
-- Name: leave_historicalleaveallocationrequest_modified_by_id_cfbcab04; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalleaveallocationrequest_modified_by_id_cfbcab04 ON public.leave_historicalleaveallocationrequest USING btree (modified_by_id);


--
-- Name: leave_historicalleavereque_historicalleaverequest_id_98d6407d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalleavereque_historicalleaverequest_id_98d6407d ON public.leave_historicalleaverequest_history_tags USING btree (historicalleaverequest_id);


--
-- Name: leave_historicalleaverequest_created_by_id_7681162e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalleaverequest_created_by_id_7681162e ON public.leave_historicalleaverequest USING btree (created_by_id);


--
-- Name: leave_historicalleaverequest_employee_id_id_d5c2543c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalleaverequest_employee_id_id_d5c2543c ON public.leave_historicalleaverequest USING btree (employee_id_id);


--
-- Name: leave_historicalleaverequest_history_date_d0e2c98e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalleaverequest_history_date_d0e2c98e ON public.leave_historicalleaverequest USING btree (history_date);


--
-- Name: leave_historicalleaverequest_history_relation_id_88ceed52; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalleaverequest_history_relation_id_88ceed52 ON public.leave_historicalleaverequest USING btree (history_relation_id);


--
-- Name: leave_historicalleaverequest_history_tags_audittag_id_53adf68d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalleaverequest_history_tags_audittag_id_53adf68d ON public.leave_historicalleaverequest_history_tags USING btree (audittag_id);


--
-- Name: leave_historicalleaverequest_history_user_id_e4091693; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalleaverequest_history_user_id_e4091693 ON public.leave_historicalleaverequest USING btree (history_user_id);


--
-- Name: leave_historicalleaverequest_id_4f93caea; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalleaverequest_id_4f93caea ON public.leave_historicalleaverequest USING btree (id);


--
-- Name: leave_historicalleaverequest_leave_type_id_id_d191c2d4; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalleaverequest_leave_type_id_id_d191c2d4 ON public.leave_historicalleaverequest USING btree (leave_type_id_id);


--
-- Name: leave_historicalleaverequest_modified_by_id_cf5fddb9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_historicalleaverequest_modified_by_id_cf5fddb9 ON public.leave_historicalleaverequest USING btree (modified_by_id);


--
-- Name: leave_holiday_company_id_id_13975602; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_holiday_company_id_id_13975602 ON public.leave_holiday USING btree (company_id_id);


--
-- Name: leave_holiday_created_by_id_053c9356; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_holiday_created_by_id_053c9356 ON public.leave_holiday USING btree (created_by_id);


--
-- Name: leave_holiday_modified_by_id_40ef9af8; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_holiday_modified_by_id_40ef9af8 ON public.leave_holiday USING btree (modified_by_id);


--
-- Name: leave_leaveallocationreque_leaveallocationrequestcomm_5aaf615b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leaveallocationreque_leaveallocationrequestcomm_5aaf615b ON public.leave_leaveallocationrequestcomment_files USING btree (leaveallocationrequestcomment_id);


--
-- Name: leave_leaveallocationreque_leaverequestfile_id_5298ebaf; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leaveallocationreque_leaverequestfile_id_5298ebaf ON public.leave_leaveallocationrequestcomment_files USING btree (leaverequestfile_id);


--
-- Name: leave_leaveallocationrequest_created_by_id_92cdfae6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leaveallocationrequest_created_by_id_92cdfae6 ON public.leave_leaveallocationrequest USING btree (created_by_id);


--
-- Name: leave_leaveallocationrequest_employee_id_id_5316112b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leaveallocationrequest_employee_id_id_5316112b ON public.leave_leaveallocationrequest USING btree (employee_id_id);


--
-- Name: leave_leaveallocationrequest_leave_type_id_id_d548f4a6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leaveallocationrequest_leave_type_id_id_d548f4a6 ON public.leave_leaveallocationrequest USING btree (leave_type_id_id);


--
-- Name: leave_leaveallocationrequest_modified_by_id_d7f086e9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leaveallocationrequest_modified_by_id_d7f086e9 ON public.leave_leaveallocationrequest USING btree (modified_by_id);


--
-- Name: leave_leaveallocationrequestcomment_created_by_id_284eb30c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leaveallocationrequestcomment_created_by_id_284eb30c ON public.leave_leaveallocationrequestcomment USING btree (created_by_id);


--
-- Name: leave_leaveallocationrequestcomment_employee_id_id_c7bb44c4; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leaveallocationrequestcomment_employee_id_id_c7bb44c4 ON public.leave_leaveallocationrequestcomment USING btree (employee_id_id);


--
-- Name: leave_leaveallocationrequestcomment_modified_by_id_8b578167; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leaveallocationrequestcomment_modified_by_id_8b578167 ON public.leave_leaveallocationrequestcomment USING btree (modified_by_id);


--
-- Name: leave_leaveallocationrequestcomment_request_id_id_6d41135e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leaveallocationrequestcomment_request_id_id_6d41135e ON public.leave_leaveallocationrequestcomment USING btree (request_id_id);


--
-- Name: leave_leavegeneralsetting_company_id_id_9f0b5af7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leavegeneralsetting_company_id_id_9f0b5af7 ON public.leave_leavegeneralsetting USING btree (company_id_id);


--
-- Name: leave_leavegeneralsetting_created_by_id_f09effc2; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leavegeneralsetting_created_by_id_f09effc2 ON public.leave_leavegeneralsetting USING btree (created_by_id);


--
-- Name: leave_leavegeneralsetting_modified_by_id_748bc603; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leavegeneralsetting_modified_by_id_748bc603 ON public.leave_leavegeneralsetting USING btree (modified_by_id);


--
-- Name: leave_leaverequest_created_by_id_138d1e03; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leaverequest_created_by_id_138d1e03 ON public.leave_leaverequest USING btree (created_by_id);


--
-- Name: leave_leaverequest_employee_id_id_5126d5dc; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leaverequest_employee_id_id_5126d5dc ON public.leave_leaverequest USING btree (employee_id_id);


--
-- Name: leave_leaverequest_leave_type_id_id_9e99d24a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leaverequest_leave_type_id_id_9e99d24a ON public.leave_leaverequest USING btree (leave_type_id_id);


--
-- Name: leave_leaverequest_modified_by_id_f81b1097; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leaverequest_modified_by_id_f81b1097 ON public.leave_leaverequest USING btree (modified_by_id);


--
-- Name: leave_leaverequestcomment_created_by_id_a2bd9ae7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leaverequestcomment_created_by_id_a2bd9ae7 ON public.leave_leaverequestcomment USING btree (created_by_id);


--
-- Name: leave_leaverequestcomment_employee_id_id_9468873e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leaverequestcomment_employee_id_id_9468873e ON public.leave_leaverequestcomment USING btree (employee_id_id);


--
-- Name: leave_leaverequestcomment_files_leaverequestcomment_id_07e0f8a7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leaverequestcomment_files_leaverequestcomment_id_07e0f8a7 ON public.leave_leaverequestcomment_files USING btree (leaverequestcomment_id);


--
-- Name: leave_leaverequestcomment_files_leaverequestfile_id_bf9a097c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leaverequestcomment_files_leaverequestfile_id_bf9a097c ON public.leave_leaverequestcomment_files USING btree (leaverequestfile_id);


--
-- Name: leave_leaverequestcomment_modified_by_id_c85fa15c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leaverequestcomment_modified_by_id_c85fa15c ON public.leave_leaverequestcomment USING btree (modified_by_id);


--
-- Name: leave_leaverequestcomment_request_id_id_c2c8ef1c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leaverequestcomment_request_id_id_c2c8ef1c ON public.leave_leaverequestcomment USING btree (request_id_id);


--
-- Name: leave_leaverequestconditio_leave_request_id_id_13609871; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leaverequestconditio_leave_request_id_id_13609871 ON public.leave_leaverequestconditionapproval USING btree (leave_request_id_id);


--
-- Name: leave_leaverequestconditionapproval_manager_id_id_8cb0a287; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leaverequestconditionapproval_manager_id_id_8cb0a287 ON public.leave_leaverequestconditionapproval USING btree (manager_id_id);


--
-- Name: leave_leavetype_company_id_id_cfef117a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leavetype_company_id_id_cfef117a ON public.leave_leavetype USING btree (company_id_id);


--
-- Name: leave_leavetype_created_by_id_351073eb; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leavetype_created_by_id_351073eb ON public.leave_leavetype USING btree (created_by_id);


--
-- Name: leave_leavetype_modified_by_id_beabc67d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_leavetype_modified_by_id_beabc67d ON public.leave_leavetype USING btree (modified_by_id);


--
-- Name: leave_restrictleave_company_id_id_b80b2702; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_restrictleave_company_id_id_b80b2702 ON public.leave_restrictleave USING btree (company_id_id);


--
-- Name: leave_restrictleave_created_by_id_f94684d0; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_restrictleave_created_by_id_f94684d0 ON public.leave_restrictleave USING btree (created_by_id);


--
-- Name: leave_restrictleave_department_id_75207328; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_restrictleave_department_id_75207328 ON public.leave_restrictleave USING btree (department_id);


--
-- Name: leave_restrictleave_exclue_restrictleave_id_9ab38ff7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_restrictleave_exclue_restrictleave_id_9ab38ff7 ON public.leave_restrictleave_exclued_leave_types USING btree (restrictleave_id);


--
-- Name: leave_restrictleave_exclued_leave_types_leavetype_id_742bf599; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_restrictleave_exclued_leave_types_leavetype_id_742bf599 ON public.leave_restrictleave_exclued_leave_types USING btree (leavetype_id);


--
-- Name: leave_restrictleave_job_position_jobposition_id_1f32135f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_restrictleave_job_position_jobposition_id_1f32135f ON public.leave_restrictleave_job_position USING btree (jobposition_id);


--
-- Name: leave_restrictleave_job_position_restrictleave_id_95f0bc8a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_restrictleave_job_position_restrictleave_id_95f0bc8a ON public.leave_restrictleave_job_position USING btree (restrictleave_id);


--
-- Name: leave_restrictleave_modified_by_id_9d60c77a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_restrictleave_modified_by_id_9d60c77a ON public.leave_restrictleave USING btree (modified_by_id);


--
-- Name: leave_restrictleave_spesif_restrictleave_id_7dd5075f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_restrictleave_spesif_restrictleave_id_7dd5075f ON public.leave_restrictleave_spesific_leave_types USING btree (restrictleave_id);


--
-- Name: leave_restrictleave_spesific_leave_types_leavetype_id_7173a1ff; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX leave_restrictleave_spesific_leave_types_leavetype_id_7173a1ff ON public.leave_restrictleave_spesific_leave_types USING btree (leavetype_id);


--
-- Name: notifications_notification_action_object_content_type_7d2b8ee9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX notifications_notification_action_object_content_type_7d2b8ee9 ON public.notifications_notification USING btree (action_object_content_type_id);


--
-- Name: notifications_notification_actor_content_type_id_0c69d7b7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX notifications_notification_actor_content_type_id_0c69d7b7 ON public.notifications_notification USING btree (actor_content_type_id);


--
-- Name: notifications_notification_deleted_b32b69e6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX notifications_notification_deleted_b32b69e6 ON public.notifications_notification USING btree (deleted);


--
-- Name: notifications_notification_emailed_23a5ad81; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX notifications_notification_emailed_23a5ad81 ON public.notifications_notification USING btree (emailed);


--
-- Name: notifications_notification_public_1bc30b1c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX notifications_notification_public_1bc30b1c ON public.notifications_notification USING btree (public);


--
-- Name: notifications_notification_recipient_id_d055f3f0; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX notifications_notification_recipient_id_d055f3f0 ON public.notifications_notification USING btree (recipient_id);


--
-- Name: notifications_notification_recipient_id_unread_253aadc9_idx; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX notifications_notification_recipient_id_unread_253aadc9_idx ON public.notifications_notification USING btree (recipient_id, unread);


--
-- Name: notifications_notification_target_content_type_id_ccb24d88; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX notifications_notification_target_content_type_id_ccb24d88 ON public.notifications_notification USING btree (target_content_type_id);


--
-- Name: notifications_notification_timestamp_6a797bad; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX notifications_notification_timestamp_6a797bad ON public.notifications_notification USING btree ("timestamp");


--
-- Name: notifications_notification_unread_cce4be30; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX notifications_notification_unread_cce4be30 ON public.notifications_notification USING btree (unread);


--
-- Name: offboarding_employeetask_created_by_id_11277aff; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_employeetask_created_by_id_11277aff ON public.offboarding_employeetask USING btree (created_by_id);


--
-- Name: offboarding_employeetask_employee_id_id_d0c791ba; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_employeetask_employee_id_id_d0c791ba ON public.offboarding_employeetask USING btree (employee_id_id);


--
-- Name: offboarding_employeetask_modified_by_id_564e145a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_employeetask_modified_by_id_564e145a ON public.offboarding_employeetask USING btree (modified_by_id);


--
-- Name: offboarding_employeetask_task_id_id_6f5a19ea; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_employeetask_task_id_id_6f5a19ea ON public.offboarding_employeetask USING btree (task_id_id);


--
-- Name: offboarding_exitreason_att_offboardingstagemultiplefi_4bd29ac5; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_exitreason_att_offboardingstagemultiplefi_4bd29ac5 ON public.offboarding_exitreason_attachments USING btree (offboardingstagemultiplefile_id);


--
-- Name: offboarding_exitreason_attachments_exitreason_id_187bf31f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_exitreason_attachments_exitreason_id_187bf31f ON public.offboarding_exitreason_attachments USING btree (exitreason_id);


--
-- Name: offboarding_exitreason_created_by_id_d6024369; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_exitreason_created_by_id_d6024369 ON public.offboarding_exitreason USING btree (created_by_id);


--
-- Name: offboarding_exitreason_modified_by_id_da33e427; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_exitreason_modified_by_id_da33e427 ON public.offboarding_exitreason USING btree (modified_by_id);


--
-- Name: offboarding_exitreason_offboarding_employee_id_id_d148fca3; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_exitreason_offboarding_employee_id_id_d148fca3 ON public.offboarding_exitreason USING btree (offboarding_employee_id_id);


--
-- Name: offboarding_historicalempl_audittag_id_699903e0; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_historicalempl_audittag_id_699903e0 ON public.offboarding_historicalemployeetask_history_tags USING btree (audittag_id);


--
-- Name: offboarding_historicalempl_historicalemployeetask_id_2286f22e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_historicalempl_historicalemployeetask_id_2286f22e ON public.offboarding_historicalemployeetask_history_tags USING btree (historicalemployeetask_id);


--
-- Name: offboarding_historicalemployeetask_created_by_id_843707b5; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_historicalemployeetask_created_by_id_843707b5 ON public.offboarding_historicalemployeetask USING btree (created_by_id);


--
-- Name: offboarding_historicalemployeetask_employee_id_id_3980b221; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_historicalemployeetask_employee_id_id_3980b221 ON public.offboarding_historicalemployeetask USING btree (employee_id_id);


--
-- Name: offboarding_historicalemployeetask_history_date_d12662df; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_historicalemployeetask_history_date_d12662df ON public.offboarding_historicalemployeetask USING btree (history_date);


--
-- Name: offboarding_historicalemployeetask_history_relation_id_bba7ad24; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_historicalemployeetask_history_relation_id_bba7ad24 ON public.offboarding_historicalemployeetask USING btree (history_relation_id);


--
-- Name: offboarding_historicalemployeetask_history_user_id_321703d9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_historicalemployeetask_history_user_id_321703d9 ON public.offboarding_historicalemployeetask USING btree (history_user_id);


--
-- Name: offboarding_historicalemployeetask_id_2c7a8122; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_historicalemployeetask_id_2c7a8122 ON public.offboarding_historicalemployeetask USING btree (id);


--
-- Name: offboarding_historicalemployeetask_modified_by_id_397df25d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_historicalemployeetask_modified_by_id_397df25d ON public.offboarding_historicalemployeetask USING btree (modified_by_id);


--
-- Name: offboarding_historicalemployeetask_task_id_id_36cec3fd; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_historicalemployeetask_task_id_id_36cec3fd ON public.offboarding_historicalemployeetask USING btree (task_id_id);


--
-- Name: offboarding_offboarding_company_id_id_6eb1a773; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboarding_company_id_id_6eb1a773 ON public.offboarding_offboarding USING btree (company_id_id);


--
-- Name: offboarding_offboarding_created_by_id_08c743a3; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboarding_created_by_id_08c743a3 ON public.offboarding_offboarding USING btree (created_by_id);


--
-- Name: offboarding_offboarding_managers_employee_id_bf56f847; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboarding_managers_employee_id_bf56f847 ON public.offboarding_offboarding_managers USING btree (employee_id);


--
-- Name: offboarding_offboarding_managers_offboarding_id_b2fa84b0; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboarding_managers_offboarding_id_b2fa84b0 ON public.offboarding_offboarding_managers USING btree (offboarding_id);


--
-- Name: offboarding_offboarding_modified_by_id_64c7c296; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboarding_modified_by_id_64c7c296 ON public.offboarding_offboarding USING btree (modified_by_id);


--
-- Name: offboarding_offboardingemployee_created_by_id_948a3f67; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardingemployee_created_by_id_948a3f67 ON public.offboarding_offboardingemployee USING btree (created_by_id);


--
-- Name: offboarding_offboardingemployee_modified_by_id_26d15b17; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardingemployee_modified_by_id_26d15b17 ON public.offboarding_offboardingemployee USING btree (modified_by_id);


--
-- Name: offboarding_offboardingemployee_stage_id_id_20811923; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardingemployee_stage_id_id_20811923 ON public.offboarding_offboardingemployee USING btree (stage_id_id);


--
-- Name: offboarding_offboardinggeneralsetting_company_id_id_01502765; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardinggeneralsetting_company_id_id_01502765 ON public.offboarding_offboardinggeneralsetting USING btree (company_id_id);


--
-- Name: offboarding_offboardinggeneralsetting_created_by_id_5e2e2e96; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardinggeneralsetting_created_by_id_5e2e2e96 ON public.offboarding_offboardinggeneralsetting USING btree (created_by_id);


--
-- Name: offboarding_offboardinggeneralsetting_modified_by_id_51027037; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardinggeneralsetting_modified_by_id_51027037 ON public.offboarding_offboardinggeneralsetting USING btree (modified_by_id);


--
-- Name: offboarding_offboardingnot_offboardingnote_id_8fff891a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardingnot_offboardingnote_id_8fff891a ON public.offboarding_offboardingnote_attachments USING btree (offboardingnote_id);


--
-- Name: offboarding_offboardingnot_offboardingstagemultiplefi_4ecbaca9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardingnot_offboardingstagemultiplefi_4ecbaca9 ON public.offboarding_offboardingnote_attachments USING btree (offboardingstagemultiplefile_id);


--
-- Name: offboarding_offboardingnote_created_by_id_8fe36e26; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardingnote_created_by_id_8fe36e26 ON public.offboarding_offboardingnote USING btree (created_by_id);


--
-- Name: offboarding_offboardingnote_employee_id_id_91402889; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardingnote_employee_id_id_91402889 ON public.offboarding_offboardingnote USING btree (employee_id_id);


--
-- Name: offboarding_offboardingnote_modified_by_id_6ffcc05b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardingnote_modified_by_id_6ffcc05b ON public.offboarding_offboardingnote USING btree (modified_by_id);


--
-- Name: offboarding_offboardingnote_note_by_id_f52f0996; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardingnote_note_by_id_f52f0996 ON public.offboarding_offboardingnote USING btree (note_by_id);


--
-- Name: offboarding_offboardingnote_stage_id_id_886a66b9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardingnote_stage_id_id_886a66b9 ON public.offboarding_offboardingnote USING btree (stage_id_id);


--
-- Name: offboarding_offboardingsta_modified_by_id_89479299; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardingsta_modified_by_id_89479299 ON public.offboarding_offboardingstagemultiplefile USING btree (modified_by_id);


--
-- Name: offboarding_offboardingsta_offboardingstage_id_717c52fc; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardingsta_offboardingstage_id_717c52fc ON public.offboarding_offboardingstage_managers USING btree (offboardingstage_id);


--
-- Name: offboarding_offboardingstage_created_by_id_59a2c750; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardingstage_created_by_id_59a2c750 ON public.offboarding_offboardingstage USING btree (created_by_id);


--
-- Name: offboarding_offboardingstage_managers_employee_id_e0f30dcf; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardingstage_managers_employee_id_e0f30dcf ON public.offboarding_offboardingstage_managers USING btree (employee_id);


--
-- Name: offboarding_offboardingstage_modified_by_id_b077ba09; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardingstage_modified_by_id_b077ba09 ON public.offboarding_offboardingstage USING btree (modified_by_id);


--
-- Name: offboarding_offboardingstage_offboarding_id_id_da071a69; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardingstage_offboarding_id_id_da071a69 ON public.offboarding_offboardingstage USING btree (offboarding_id_id);


--
-- Name: offboarding_offboardingstagemultiplefile_created_by_id_aeb6efb9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardingstagemultiplefile_created_by_id_aeb6efb9 ON public.offboarding_offboardingstagemultiplefile USING btree (created_by_id);


--
-- Name: offboarding_offboardingtas_offboardingtask_id_5b5b2ed8; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardingtas_offboardingtask_id_5b5b2ed8 ON public.offboarding_offboardingtask_managers USING btree (offboardingtask_id);


--
-- Name: offboarding_offboardingtask_created_by_id_2bf9dfe4; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardingtask_created_by_id_2bf9dfe4 ON public.offboarding_offboardingtask USING btree (created_by_id);


--
-- Name: offboarding_offboardingtask_managers_employee_id_7bf8bbd0; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardingtask_managers_employee_id_7bf8bbd0 ON public.offboarding_offboardingtask_managers USING btree (employee_id);


--
-- Name: offboarding_offboardingtask_modified_by_id_ca2e6344; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardingtask_modified_by_id_ca2e6344 ON public.offboarding_offboardingtask USING btree (modified_by_id);


--
-- Name: offboarding_offboardingtask_stage_id_id_da56fc56; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_offboardingtask_stage_id_id_da56fc56 ON public.offboarding_offboardingtask USING btree (stage_id_id);


--
-- Name: offboarding_resignationlet_offboarding_employee_id_id_a1772643; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_resignationlet_offboarding_employee_id_id_a1772643 ON public.offboarding_resignationletter USING btree (offboarding_employee_id_id);


--
-- Name: offboarding_resignationletter_created_by_id_16bb92a5; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_resignationletter_created_by_id_16bb92a5 ON public.offboarding_resignationletter USING btree (created_by_id);


--
-- Name: offboarding_resignationletter_employee_id_id_2951a12b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_resignationletter_employee_id_id_2951a12b ON public.offboarding_resignationletter USING btree (employee_id_id);


--
-- Name: offboarding_resignationletter_modified_by_id_7b981cef; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX offboarding_resignationletter_modified_by_id_7b981cef ON public.offboarding_resignationletter USING btree (modified_by_id);


--
-- Name: onboarding_candidatestage_created_by_id_778bf760; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_candidatestage_created_by_id_778bf760 ON public.onboarding_candidatestage USING btree (created_by_id);


--
-- Name: onboarding_candidatestage_modified_by_id_036edc7f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_candidatestage_modified_by_id_036edc7f ON public.onboarding_candidatestage USING btree (modified_by_id);


--
-- Name: onboarding_candidatestage_onboarding_stage_id_id_477080f9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_candidatestage_onboarding_stage_id_id_477080f9 ON public.onboarding_candidatestage USING btree (onboarding_stage_id_id);


--
-- Name: onboarding_candidatetask_candidate_id_id_8b0eef2b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_candidatetask_candidate_id_id_8b0eef2b ON public.onboarding_candidatetask USING btree (candidate_id_id);


--
-- Name: onboarding_candidatetask_created_by_id_e16f0e0b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_candidatetask_created_by_id_e16f0e0b ON public.onboarding_candidatetask USING btree (created_by_id);


--
-- Name: onboarding_candidatetask_modified_by_id_c15234a2; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_candidatetask_modified_by_id_c15234a2 ON public.onboarding_candidatetask USING btree (modified_by_id);


--
-- Name: onboarding_candidatetask_onboarding_task_id_id_66c5c3d8; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_candidatetask_onboarding_task_id_id_66c5c3d8 ON public.onboarding_candidatetask USING btree (onboarding_task_id_id);


--
-- Name: onboarding_candidatetask_stage_id_id_2bc5e4af; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_candidatetask_stage_id_id_2bc5e4af ON public.onboarding_candidatetask USING btree (stage_id_id);


--
-- Name: onboarding_historicalcandi_audittag_id_032900d1; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_historicalcandi_audittag_id_032900d1 ON public.onboarding_historicalcandidatetask_history_tags USING btree (audittag_id);


--
-- Name: onboarding_historicalcandi_historicalcandidatetask_id_f452cc88; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_historicalcandi_historicalcandidatetask_id_f452cc88 ON public.onboarding_historicalcandidatetask_history_tags USING btree (historicalcandidatetask_id);


--
-- Name: onboarding_historicalcandi_onboarding_task_id_id_10accdfd; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_historicalcandi_onboarding_task_id_id_10accdfd ON public.onboarding_historicalcandidatetask USING btree (onboarding_task_id_id);


--
-- Name: onboarding_historicalcandidatetask_candidate_id_id_01d342a9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_historicalcandidatetask_candidate_id_id_01d342a9 ON public.onboarding_historicalcandidatetask USING btree (candidate_id_id);


--
-- Name: onboarding_historicalcandidatetask_created_by_id_8885c403; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_historicalcandidatetask_created_by_id_8885c403 ON public.onboarding_historicalcandidatetask USING btree (created_by_id);


--
-- Name: onboarding_historicalcandidatetask_history_date_103f1570; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_historicalcandidatetask_history_date_103f1570 ON public.onboarding_historicalcandidatetask USING btree (history_date);


--
-- Name: onboarding_historicalcandidatetask_history_relation_id_bcf7462b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_historicalcandidatetask_history_relation_id_bcf7462b ON public.onboarding_historicalcandidatetask USING btree (history_relation_id);


--
-- Name: onboarding_historicalcandidatetask_history_user_id_a7e8bdf9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_historicalcandidatetask_history_user_id_a7e8bdf9 ON public.onboarding_historicalcandidatetask USING btree (history_user_id);


--
-- Name: onboarding_historicalcandidatetask_id_ec19e8b7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_historicalcandidatetask_id_ec19e8b7 ON public.onboarding_historicalcandidatetask USING btree (id);


--
-- Name: onboarding_historicalcandidatetask_modified_by_id_af88ba97; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_historicalcandidatetask_modified_by_id_af88ba97 ON public.onboarding_historicalcandidatetask USING btree (modified_by_id);


--
-- Name: onboarding_historicalcandidatetask_stage_id_id_4fcfd9c0; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_historicalcandidatetask_stage_id_id_4fcfd9c0 ON public.onboarding_historicalcandidatetask USING btree (stage_id_id);


--
-- Name: onboarding_onboardingportal_created_by_id_c9caa2a3; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_onboardingportal_created_by_id_c9caa2a3 ON public.onboarding_onboardingportal USING btree (created_by_id);


--
-- Name: onboarding_onboardingportal_modified_by_id_b6ad8806; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_onboardingportal_modified_by_id_b6ad8806 ON public.onboarding_onboardingportal USING btree (modified_by_id);


--
-- Name: onboarding_onboardingstage_created_by_id_025988ab; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_onboardingstage_created_by_id_025988ab ON public.onboarding_onboardingstage USING btree (created_by_id);


--
-- Name: onboarding_onboardingstage_employee_id_employee_id_a941974c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_onboardingstage_employee_id_employee_id_a941974c ON public.onboarding_onboardingstage_employee_id USING btree (employee_id);


--
-- Name: onboarding_onboardingstage_modified_by_id_c77bd25e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_onboardingstage_modified_by_id_c77bd25e ON public.onboarding_onboardingstage USING btree (modified_by_id);


--
-- Name: onboarding_onboardingstage_onboardingstage_id_5afa9618; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_onboardingstage_onboardingstage_id_5afa9618 ON public.onboarding_onboardingstage_employee_id USING btree (onboardingstage_id);


--
-- Name: onboarding_onboardingstage_recruitment_id_id_d1f224a7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_onboardingstage_recruitment_id_id_d1f224a7 ON public.onboarding_onboardingstage USING btree (recruitment_id_id);


--
-- Name: onboarding_onboardingtask__onboardingtask_id_55b23efb; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_onboardingtask__onboardingtask_id_55b23efb ON public.onboarding_onboardingtask_employee_id USING btree (onboardingtask_id);


--
-- Name: onboarding_onboardingtask_candidates_candidate_id_a2ad84c1; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_onboardingtask_candidates_candidate_id_a2ad84c1 ON public.onboarding_onboardingtask_candidates USING btree (candidate_id);


--
-- Name: onboarding_onboardingtask_candidates_onboardingtask_id_19de8041; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_onboardingtask_candidates_onboardingtask_id_19de8041 ON public.onboarding_onboardingtask_candidates USING btree (onboardingtask_id);


--
-- Name: onboarding_onboardingtask_created_by_id_cb6060a7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_onboardingtask_created_by_id_cb6060a7 ON public.onboarding_onboardingtask USING btree (created_by_id);


--
-- Name: onboarding_onboardingtask_employee_id_employee_id_6e59c408; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_onboardingtask_employee_id_employee_id_6e59c408 ON public.onboarding_onboardingtask_employee_id USING btree (employee_id);


--
-- Name: onboarding_onboardingtask_modified_by_id_a4de5468; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_onboardingtask_modified_by_id_a4de5468 ON public.onboarding_onboardingtask USING btree (modified_by_id);


--
-- Name: onboarding_onboardingtask_stage_id_id_9360b93d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX onboarding_onboardingtask_stage_id_id_9360b93d ON public.onboarding_onboardingtask USING btree (stage_id_id);


--
-- Name: payroll_allowance_company_id_id_5912bfe7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_allowance_company_id_id_5912bfe7 ON public.payroll_allowance USING btree (company_id_id);


--
-- Name: payroll_allowance_created_by_id_1c73f9ba; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_allowance_created_by_id_1c73f9ba ON public.payroll_allowance USING btree (created_by_id);


--
-- Name: payroll_allowance_exclude_employees_allowance_id_71401ad3; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_allowance_exclude_employees_allowance_id_71401ad3 ON public.payroll_allowance_exclude_employees USING btree (allowance_id);


--
-- Name: payroll_allowance_exclude_employees_employee_id_aa853e81; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_allowance_exclude_employees_employee_id_aa853e81 ON public.payroll_allowance_exclude_employees USING btree (employee_id);


--
-- Name: payroll_allowance_modified_by_id_947a87fd; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_allowance_modified_by_id_947a87fd ON public.payroll_allowance USING btree (modified_by_id);


--
-- Name: payroll_allowance_other_co_multiplecondition_id_c6d11700; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_allowance_other_co_multiplecondition_id_c6d11700 ON public.payroll_allowance_other_conditions USING btree (multiplecondition_id);


--
-- Name: payroll_allowance_other_conditions_allowance_id_91385ebf; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_allowance_other_conditions_allowance_id_91385ebf ON public.payroll_allowance_other_conditions USING btree (allowance_id);


--
-- Name: payroll_allowance_shift_id_id_2a990c10; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_allowance_shift_id_id_2a990c10 ON public.payroll_allowance USING btree (shift_id_id);


--
-- Name: payroll_allowance_specific_employees_allowance_id_447cbbe6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_allowance_specific_employees_allowance_id_447cbbe6 ON public.payroll_allowance_specific_employees USING btree (allowance_id);


--
-- Name: payroll_allowance_specific_employees_employee_id_8537de68; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_allowance_specific_employees_employee_id_8537de68 ON public.payroll_allowance_specific_employees USING btree (employee_id);


--
-- Name: payroll_allowance_work_type_id_id_da9a0d44; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_allowance_work_type_id_id_da9a0d44 ON public.payroll_allowance USING btree (work_type_id_id);


--
-- Name: payroll_contract_created_by_id_40695d65; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_contract_created_by_id_40695d65 ON public.payroll_contract USING btree (created_by_id);


--
-- Name: payroll_contract_department_id_1ae8aa22; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_contract_department_id_1ae8aa22 ON public.payroll_contract USING btree (department_id);


--
-- Name: payroll_contract_employee_id_id_73b14d20; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_contract_employee_id_id_73b14d20 ON public.payroll_contract USING btree (employee_id_id);


--
-- Name: payroll_contract_filing_status_id_c62f4cc1; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_contract_filing_status_id_c62f4cc1 ON public.payroll_contract USING btree (filing_status_id);


--
-- Name: payroll_contract_job_position_id_fa88268e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_contract_job_position_id_fa88268e ON public.payroll_contract USING btree (job_position_id);


--
-- Name: payroll_contract_job_role_id_41e136e0; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_contract_job_role_id_41e136e0 ON public.payroll_contract USING btree (job_role_id);


--
-- Name: payroll_contract_modified_by_id_afd91aba; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_contract_modified_by_id_afd91aba ON public.payroll_contract USING btree (modified_by_id);


--
-- Name: payroll_contract_shift_id_eda88904; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_contract_shift_id_eda88904 ON public.payroll_contract USING btree (shift_id);


--
-- Name: payroll_contract_work_type_id_82b0af54; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_contract_work_type_id_82b0af54 ON public.payroll_contract USING btree (work_type_id);


--
-- Name: payroll_deduction_company_id_id_d5546b8f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_deduction_company_id_id_d5546b8f ON public.payroll_deduction USING btree (company_id_id);


--
-- Name: payroll_deduction_created_by_id_433028c3; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_deduction_created_by_id_433028c3 ON public.payroll_deduction USING btree (created_by_id);


--
-- Name: payroll_deduction_exclude_employees_deduction_id_ab8324ba; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_deduction_exclude_employees_deduction_id_ab8324ba ON public.payroll_deduction_exclude_employees USING btree (deduction_id);


--
-- Name: payroll_deduction_exclude_employees_employee_id_f349f675; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_deduction_exclude_employees_employee_id_f349f675 ON public.payroll_deduction_exclude_employees USING btree (employee_id);


--
-- Name: payroll_deduction_modified_by_id_64c0dc3c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_deduction_modified_by_id_64c0dc3c ON public.payroll_deduction USING btree (modified_by_id);


--
-- Name: payroll_deduction_other_co_multiplecondition_id_6f0081eb; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_deduction_other_co_multiplecondition_id_6f0081eb ON public.payroll_deduction_other_conditions USING btree (multiplecondition_id);


--
-- Name: payroll_deduction_other_conditions_deduction_id_a96fe1ab; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_deduction_other_conditions_deduction_id_a96fe1ab ON public.payroll_deduction_other_conditions USING btree (deduction_id);


--
-- Name: payroll_deduction_specific_employees_deduction_id_40142fb7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_deduction_specific_employees_deduction_id_40142fb7 ON public.payroll_deduction_specific_employees USING btree (deduction_id);


--
-- Name: payroll_deduction_specific_employees_employee_id_5a7d19b7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_deduction_specific_employees_employee_id_5a7d19b7 ON public.payroll_deduction_specific_employees USING btree (employee_id);


--
-- Name: payroll_filingstatus_company_id_id_c4edc643; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_filingstatus_company_id_id_c4edc643 ON public.payroll_filingstatus USING btree (company_id_id);


--
-- Name: payroll_filingstatus_created_by_id_1585912b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_filingstatus_created_by_id_1585912b ON public.payroll_filingstatus USING btree (created_by_id);


--
-- Name: payroll_filingstatus_modified_by_id_8ee36489; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_filingstatus_modified_by_id_8ee36489 ON public.payroll_filingstatus USING btree (modified_by_id);


--
-- Name: payroll_historicalcontract_created_by_id_6912c2c8; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalcontract_created_by_id_6912c2c8 ON public.payroll_historicalcontract USING btree (created_by_id);


--
-- Name: payroll_historicalcontract_department_id_ba5c0ea2; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalcontract_department_id_ba5c0ea2 ON public.payroll_historicalcontract USING btree (department_id);


--
-- Name: payroll_historicalcontract_employee_id_id_ce631d33; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalcontract_employee_id_id_ce631d33 ON public.payroll_historicalcontract USING btree (employee_id_id);


--
-- Name: payroll_historicalcontract_filing_status_id_b1e556a3; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalcontract_filing_status_id_b1e556a3 ON public.payroll_historicalcontract USING btree (filing_status_id);


--
-- Name: payroll_historicalcontract_historicalcontract_id_ce51a07a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalcontract_historicalcontract_id_ce51a07a ON public.payroll_historicalcontract_history_tags USING btree (historicalcontract_id);


--
-- Name: payroll_historicalcontract_history_date_ae31cf09; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalcontract_history_date_ae31cf09 ON public.payroll_historicalcontract USING btree (history_date);


--
-- Name: payroll_historicalcontract_history_relation_id_ac42ddee; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalcontract_history_relation_id_ac42ddee ON public.payroll_historicalcontract USING btree (history_relation_id);


--
-- Name: payroll_historicalcontract_history_tags_audittag_id_ee2de581; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalcontract_history_tags_audittag_id_ee2de581 ON public.payroll_historicalcontract_history_tags USING btree (audittag_id);


--
-- Name: payroll_historicalcontract_history_user_id_60d308d1; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalcontract_history_user_id_60d308d1 ON public.payroll_historicalcontract USING btree (history_user_id);


--
-- Name: payroll_historicalcontract_id_3115709d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalcontract_id_3115709d ON public.payroll_historicalcontract USING btree (id);


--
-- Name: payroll_historicalcontract_job_position_id_cff61233; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalcontract_job_position_id_cff61233 ON public.payroll_historicalcontract USING btree (job_position_id);


--
-- Name: payroll_historicalcontract_job_role_id_10059c7f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalcontract_job_role_id_10059c7f ON public.payroll_historicalcontract USING btree (job_role_id);


--
-- Name: payroll_historicalcontract_modified_by_id_f9a8a752; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalcontract_modified_by_id_f9a8a752 ON public.payroll_historicalcontract USING btree (modified_by_id);


--
-- Name: payroll_historicalcontract_shift_id_23264673; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalcontract_shift_id_23264673 ON public.payroll_historicalcontract USING btree (shift_id);


--
-- Name: payroll_historicalcontract_work_type_id_c38ff257; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalcontract_work_type_id_c38ff257 ON public.payroll_historicalcontract USING btree (work_type_id);


--
-- Name: payroll_historicalpayslip__historicalpayslip_id_f12f5ff1; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalpayslip__historicalpayslip_id_f12f5ff1 ON public.payroll_historicalpayslip_history_tags USING btree (historicalpayslip_id);


--
-- Name: payroll_historicalpayslip_created_by_id_3ebd6360; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalpayslip_created_by_id_3ebd6360 ON public.payroll_historicalpayslip USING btree (created_by_id);


--
-- Name: payroll_historicalpayslip_employee_id_id_9d300a3a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalpayslip_employee_id_id_9d300a3a ON public.payroll_historicalpayslip USING btree (employee_id_id);


--
-- Name: payroll_historicalpayslip_history_date_8f6a56d5; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalpayslip_history_date_8f6a56d5 ON public.payroll_historicalpayslip USING btree (history_date);


--
-- Name: payroll_historicalpayslip_history_relation_id_adad95a7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalpayslip_history_relation_id_adad95a7 ON public.payroll_historicalpayslip USING btree (history_relation_id);


--
-- Name: payroll_historicalpayslip_history_tags_audittag_id_92f1fdad; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalpayslip_history_tags_audittag_id_92f1fdad ON public.payroll_historicalpayslip_history_tags USING btree (audittag_id);


--
-- Name: payroll_historicalpayslip_history_user_id_5ca3658a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalpayslip_history_user_id_5ca3658a ON public.payroll_historicalpayslip USING btree (history_user_id);


--
-- Name: payroll_historicalpayslip_id_1a2e9086; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalpayslip_id_1a2e9086 ON public.payroll_historicalpayslip USING btree (id);


--
-- Name: payroll_historicalpayslip_modified_by_id_c721f370; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_historicalpayslip_modified_by_id_c721f370 ON public.payroll_historicalpayslip USING btree (modified_by_id);


--
-- Name: payroll_loanaccount_allowance_id_id_d01d19ed; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_loanaccount_allowance_id_id_d01d19ed ON public.payroll_loanaccount USING btree (allowance_id_id);


--
-- Name: payroll_loanaccount_asset_id_id_b1a82434; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_loanaccount_asset_id_id_b1a82434 ON public.payroll_loanaccount USING btree (asset_id_id);


--
-- Name: payroll_loanaccount_created_by_id_c44cc155; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_loanaccount_created_by_id_c44cc155 ON public.payroll_loanaccount USING btree (created_by_id);


--
-- Name: payroll_loanaccount_deduction_ids_deduction_id_1e7b9cf9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_loanaccount_deduction_ids_deduction_id_1e7b9cf9 ON public.payroll_loanaccount_deduction_ids USING btree (deduction_id);


--
-- Name: payroll_loanaccount_deduction_ids_loanaccount_id_f9fb1ae9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_loanaccount_deduction_ids_loanaccount_id_f9fb1ae9 ON public.payroll_loanaccount_deduction_ids USING btree (loanaccount_id);


--
-- Name: payroll_loanaccount_employee_id_id_aa0f9eef; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_loanaccount_employee_id_id_aa0f9eef ON public.payroll_loanaccount USING btree (employee_id_id);


--
-- Name: payroll_loanaccount_modified_by_id_4b5d7154; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_loanaccount_modified_by_id_4b5d7154 ON public.payroll_loanaccount USING btree (modified_by_id);


--
-- Name: payroll_payrollgeneralsetting_company_id_id_e6427694; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_payrollgeneralsetting_company_id_id_e6427694 ON public.payroll_payrollgeneralsetting USING btree (company_id_id);


--
-- Name: payroll_payrollsettings_company_id_id_d9a945a2; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_payrollsettings_company_id_id_d9a945a2 ON public.payroll_payrollsettings USING btree (company_id_id);


--
-- Name: payroll_payrollsettings_created_by_id_6b62d3c9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_payrollsettings_created_by_id_6b62d3c9 ON public.payroll_payrollsettings USING btree (created_by_id);


--
-- Name: payroll_payrollsettings_modified_by_id_6c104a36; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_payrollsettings_modified_by_id_6c104a36 ON public.payroll_payrollsettings USING btree (modified_by_id);


--
-- Name: payroll_payslip_created_by_id_c32cd835; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_payslip_created_by_id_c32cd835 ON public.payroll_payslip USING btree (created_by_id);


--
-- Name: payroll_payslip_employee_id_id_f7edc1cc; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_payslip_employee_id_id_f7edc1cc ON public.payroll_payslip USING btree (employee_id_id);


--
-- Name: payroll_payslip_installment_ids_deduction_id_6ac3f4ed; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_payslip_installment_ids_deduction_id_6ac3f4ed ON public.payroll_payslip_installment_ids USING btree (deduction_id);


--
-- Name: payroll_payslip_installment_ids_payslip_id_6872c6c5; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_payslip_installment_ids_payslip_id_6872c6c5 ON public.payroll_payslip_installment_ids USING btree (payslip_id);


--
-- Name: payroll_payslip_modified_by_id_7fe374ca; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_payslip_modified_by_id_7fe374ca ON public.payroll_payslip USING btree (modified_by_id);


--
-- Name: payroll_reimbursement_allowance_id_id_d4869beb; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_reimbursement_allowance_id_id_d4869beb ON public.payroll_reimbursement USING btree (allowance_id_id);


--
-- Name: payroll_reimbursement_approved_by_id_a5077a7b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_reimbursement_approved_by_id_a5077a7b ON public.payroll_reimbursement USING btree (approved_by_id);


--
-- Name: payroll_reimbursement_created_by_id_faf47a67; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_reimbursement_created_by_id_faf47a67 ON public.payroll_reimbursement USING btree (created_by_id);


--
-- Name: payroll_reimbursement_employee_id_id_caaaa190; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_reimbursement_employee_id_id_caaaa190 ON public.payroll_reimbursement USING btree (employee_id_id);


--
-- Name: payroll_reimbursement_leave_type_id_id_827b2717; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_reimbursement_leave_type_id_id_827b2717 ON public.payroll_reimbursement USING btree (leave_type_id_id);


--
-- Name: payroll_reimbursement_modified_by_id_68fe469f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_reimbursement_modified_by_id_68fe469f ON public.payroll_reimbursement USING btree (modified_by_id);


--
-- Name: payroll_reimbursement_othe_reimbursement_id_0a9e691e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_reimbursement_othe_reimbursement_id_0a9e691e ON public.payroll_reimbursement_other_attachments USING btree (reimbursement_id);


--
-- Name: payroll_reimbursement_othe_reimbursementmultipleattac_bb6e8ac8; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_reimbursement_othe_reimbursementmultipleattac_bb6e8ac8 ON public.payroll_reimbursement_other_attachments USING btree (reimbursementmultipleattachment_id);


--
-- Name: payroll_reimbursementreque_reimbursementfile_id_346a9b2b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_reimbursementreque_reimbursementfile_id_346a9b2b ON public.payroll_reimbursementrequestcomment_files USING btree (reimbursementfile_id);


--
-- Name: payroll_reimbursementreque_reimbursementrequestcommen_a8d8524d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_reimbursementreque_reimbursementrequestcommen_a8d8524d ON public.payroll_reimbursementrequestcomment_files USING btree (reimbursementrequestcomment_id);


--
-- Name: payroll_reimbursementrequestcomment_created_by_id_bd8f0ee7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_reimbursementrequestcomment_created_by_id_bd8f0ee7 ON public.payroll_reimbursementrequestcomment USING btree (created_by_id);


--
-- Name: payroll_reimbursementrequestcomment_employee_id_id_b1ed852c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_reimbursementrequestcomment_employee_id_id_b1ed852c ON public.payroll_reimbursementrequestcomment USING btree (employee_id_id);


--
-- Name: payroll_reimbursementrequestcomment_modified_by_id_00a981b9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_reimbursementrequestcomment_modified_by_id_00a981b9 ON public.payroll_reimbursementrequestcomment USING btree (modified_by_id);


--
-- Name: payroll_reimbursementrequestcomment_request_id_id_c5248113; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_reimbursementrequestcomment_request_id_id_c5248113 ON public.payroll_reimbursementrequestcomment USING btree (request_id_id);


--
-- Name: payroll_taxbracket_created_by_id_9debe17b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_taxbracket_created_by_id_9debe17b ON public.payroll_taxbracket USING btree (created_by_id);


--
-- Name: payroll_taxbracket_filing_status_id_id_44db05c3; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_taxbracket_filing_status_id_id_44db05c3 ON public.payroll_taxbracket USING btree (filing_status_id_id);


--
-- Name: payroll_taxbracket_modified_by_id_975491eb; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_taxbracket_modified_by_id_975491eb ON public.payroll_taxbracket USING btree (modified_by_id);


--
-- Name: payroll_workrecord_employee_id_id_193463e2; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX payroll_workrecord_employee_id_id_193463e2 ON public.payroll_workrecord USING btree (employee_id_id);


--
-- Name: pms_anonymousfeedback_department_id_id_224e48aa; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_anonymousfeedback_department_id_id_224e48aa ON public.pms_anonymousfeedback USING btree (department_id_id);


--
-- Name: pms_anonymousfeedback_employee_id_id_b4c009d4; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_anonymousfeedback_employee_id_id_b4c009d4 ON public.pms_anonymousfeedback USING btree (employee_id_id);


--
-- Name: pms_anonymousfeedback_job_position_id_id_da5ab018; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_anonymousfeedback_job_position_id_id_da5ab018 ON public.pms_anonymousfeedback USING btree (job_position_id_id);


--
-- Name: pms_answer_employee_id_id_4daf966e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_answer_employee_id_id_4daf966e ON public.pms_answer USING btree (employee_id_id);


--
-- Name: pms_answer_feedback_id_id_bf251b00; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_answer_feedback_id_id_bf251b00 ON public.pms_answer USING btree (feedback_id_id);


--
-- Name: pms_answer_question_id_id_2f05562f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_answer_question_id_id_2f05562f ON public.pms_answer USING btree (question_id_id);


--
-- Name: pms_comment_employee_id_id_b77179f3; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_comment_employee_id_id_b77179f3 ON public.pms_comment USING btree (employee_id_id);


--
-- Name: pms_comment_employee_objective_id_id_6d8ce4f2; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_comment_employee_objective_id_id_6d8ce4f2 ON public.pms_comment USING btree (employee_objective_id_id);


--
-- Name: pms_employeebonuspoint_bonus_point_id_id_e34f3f54; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_employeebonuspoint_bonus_point_id_id_e34f3f54 ON public.pms_employeebonuspoint USING btree (bonus_point_id_id);


--
-- Name: pms_employeebonuspoint_created_by_id_544d2b68; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_employeebonuspoint_created_by_id_544d2b68 ON public.pms_employeebonuspoint USING btree (created_by_id);


--
-- Name: pms_employeebonuspoint_employee_id_id_94211f70; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_employeebonuspoint_employee_id_id_94211f70 ON public.pms_employeebonuspoint USING btree (employee_id_id);


--
-- Name: pms_employeebonuspoint_modified_by_id_23badb59; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_employeebonuspoint_modified_by_id_23badb59 ON public.pms_employeebonuspoint USING btree (modified_by_id);


--
-- Name: pms_employeekeyresult_employee_objective_id_id_f0bbcd7f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_employeekeyresult_employee_objective_id_id_f0bbcd7f ON public.pms_employeekeyresult USING btree (employee_objective_id_id);


--
-- Name: pms_employeekeyresult_key_result_id_id_78770afe; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_employeekeyresult_key_result_id_id_78770afe ON public.pms_employeekeyresult USING btree (key_result_id_id);


--
-- Name: pms_employeeobjective_created_by_id_7f721659; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_employeeobjective_created_by_id_7f721659 ON public.pms_employeeobjective USING btree (created_by_id);


--
-- Name: pms_employeeobjective_employee_id_id_15ddf5ea; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_employeeobjective_employee_id_id_15ddf5ea ON public.pms_employeeobjective USING btree (employee_id_id);


--
-- Name: pms_employeeobjective_key__employeeobjective_id_2f7a1ea5; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_employeeobjective_key__employeeobjective_id_2f7a1ea5 ON public.pms_employeeobjective_key_result_id USING btree (employeeobjective_id);


--
-- Name: pms_employeeobjective_key_result_id_keyresult_id_0561edce; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_employeeobjective_key_result_id_keyresult_id_0561edce ON public.pms_employeeobjective_key_result_id USING btree (keyresult_id);


--
-- Name: pms_employeeobjective_modified_by_id_e64ba2f4; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_employeeobjective_modified_by_id_e64ba2f4 ON public.pms_employeeobjective USING btree (modified_by_id);


--
-- Name: pms_employeeobjective_objective_id_id_ee2ed9a2; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_employeeobjective_objective_id_id_ee2ed9a2 ON public.pms_employeeobjective USING btree (objective_id_id);


--
-- Name: pms_feedback_colleague_id_employee_id_929c106e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_feedback_colleague_id_employee_id_929c106e ON public.pms_feedback_colleague_id USING btree (employee_id);


--
-- Name: pms_feedback_colleague_id_feedback_id_5f17190a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_feedback_colleague_id_feedback_id_5f17190a ON public.pms_feedback_colleague_id USING btree (feedback_id);


--
-- Name: pms_feedback_created_by_id_5fc4765b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_feedback_created_by_id_5fc4765b ON public.pms_feedback USING btree (created_by_id);


--
-- Name: pms_feedback_employee_id_id_fc981583; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_feedback_employee_id_id_fc981583 ON public.pms_feedback USING btree (employee_id_id);


--
-- Name: pms_feedback_employee_key__employeekeyresult_id_04a18d62; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_feedback_employee_key__employeekeyresult_id_04a18d62 ON public.pms_feedback_employee_key_results_id USING btree (employeekeyresult_id);


--
-- Name: pms_feedback_employee_key_results_id_feedback_id_2e148291; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_feedback_employee_key_results_id_feedback_id_2e148291 ON public.pms_feedback_employee_key_results_id USING btree (feedback_id);


--
-- Name: pms_feedback_manager_id_id_29e8eaa1; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_feedback_manager_id_id_29e8eaa1 ON public.pms_feedback USING btree (manager_id_id);


--
-- Name: pms_feedback_modified_by_id_2d8fa73a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_feedback_modified_by_id_2d8fa73a ON public.pms_feedback USING btree (modified_by_id);


--
-- Name: pms_feedback_others_id_employee_id_975b0597; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_feedback_others_id_employee_id_975b0597 ON public.pms_feedback_others_id USING btree (employee_id);


--
-- Name: pms_feedback_others_id_feedback_id_b9dde79a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_feedback_others_id_feedback_id_b9dde79a ON public.pms_feedback_others_id USING btree (feedback_id);


--
-- Name: pms_feedback_question_template_id_id_55891304; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_feedback_question_template_id_id_55891304 ON public.pms_feedback USING btree (question_template_id_id);


--
-- Name: pms_feedback_subordinate_id_employee_id_0eff7b1a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_feedback_subordinate_id_employee_id_0eff7b1a ON public.pms_feedback_subordinate_id USING btree (employee_id);


--
-- Name: pms_feedback_subordinate_id_feedback_id_cd0bc731; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_feedback_subordinate_id_feedback_id_cd0bc731 ON public.pms_feedback_subordinate_id USING btree (feedback_id);


--
-- Name: pms_historicalcomment_employee_id_id_e53da903; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalcomment_employee_id_id_e53da903 ON public.pms_historicalcomment USING btree (employee_id_id);


--
-- Name: pms_historicalcomment_employee_objective_id_id_19a86f34; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalcomment_employee_objective_id_id_19a86f34 ON public.pms_historicalcomment USING btree (employee_objective_id_id);


--
-- Name: pms_historicalcomment_hist_historicalcomment_id_7a748c3e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalcomment_hist_historicalcomment_id_7a748c3e ON public.pms_historicalcomment_history_tags USING btree (historicalcomment_id);


--
-- Name: pms_historicalcomment_history_date_1b11e99b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalcomment_history_date_1b11e99b ON public.pms_historicalcomment USING btree (history_date);


--
-- Name: pms_historicalcomment_history_tags_audittag_id_8a327b8b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalcomment_history_tags_audittag_id_8a327b8b ON public.pms_historicalcomment_history_tags USING btree (audittag_id);


--
-- Name: pms_historicalcomment_history_user_id_105b2495; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalcomment_history_user_id_105b2495 ON public.pms_historicalcomment USING btree (history_user_id);


--
-- Name: pms_historicalcomment_id_c40180b6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalcomment_id_c40180b6 ON public.pms_historicalcomment USING btree (id);


--
-- Name: pms_historicalemployeekeyr_audittag_id_782b2bab; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalemployeekeyr_audittag_id_782b2bab ON public.pms_historicalemployeekeyresult_history_tags USING btree (audittag_id);


--
-- Name: pms_historicalemployeekeyr_employee_objective_id_id_05e50ddf; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalemployeekeyr_employee_objective_id_id_05e50ddf ON public.pms_historicalemployeekeyresult USING btree (employee_objective_id_id);


--
-- Name: pms_historicalemployeekeyr_historicalemployeekeyresul_39756650; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalemployeekeyr_historicalemployeekeyresul_39756650 ON public.pms_historicalemployeekeyresult_history_tags USING btree (historicalemployeekeyresult_id);


--
-- Name: pms_historicalemployeekeyresult_history_date_cae8e1bd; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalemployeekeyresult_history_date_cae8e1bd ON public.pms_historicalemployeekeyresult USING btree (history_date);


--
-- Name: pms_historicalemployeekeyresult_history_user_id_27036f6a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalemployeekeyresult_history_user_id_27036f6a ON public.pms_historicalemployeekeyresult USING btree (history_user_id);


--
-- Name: pms_historicalemployeekeyresult_id_a2e1f04e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalemployeekeyresult_id_a2e1f04e ON public.pms_historicalemployeekeyresult USING btree (id);


--
-- Name: pms_historicalemployeekeyresult_key_result_id_id_0183fe0c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalemployeekeyresult_key_result_id_id_0183fe0c ON public.pms_historicalemployeekeyresult USING btree (key_result_id_id);


--
-- Name: pms_historicalemployeeobje_audittag_id_1910337f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalemployeeobje_audittag_id_1910337f ON public.pms_historicalemployeeobjective_history_tags USING btree (audittag_id);


--
-- Name: pms_historicalemployeeobje_historicalemployeeobjectiv_cee862a5; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalemployeeobje_historicalemployeeobjectiv_cee862a5 ON public.pms_historicalemployeeobjective_history_tags USING btree (historicalemployeeobjective_id);


--
-- Name: pms_historicalemployeeobjective_created_by_id_bd83b3c1; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalemployeeobjective_created_by_id_bd83b3c1 ON public.pms_historicalemployeeobjective USING btree (created_by_id);


--
-- Name: pms_historicalemployeeobjective_employee_id_id_b1bf227b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalemployeeobjective_employee_id_id_b1bf227b ON public.pms_historicalemployeeobjective USING btree (employee_id_id);


--
-- Name: pms_historicalemployeeobjective_history_date_7f2fc8f7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalemployeeobjective_history_date_7f2fc8f7 ON public.pms_historicalemployeeobjective USING btree (history_date);


--
-- Name: pms_historicalemployeeobjective_history_relation_id_c91ff66c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalemployeeobjective_history_relation_id_c91ff66c ON public.pms_historicalemployeeobjective USING btree (history_relation_id);


--
-- Name: pms_historicalemployeeobjective_history_user_id_e6a4deea; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalemployeeobjective_history_user_id_e6a4deea ON public.pms_historicalemployeeobjective USING btree (history_user_id);


--
-- Name: pms_historicalemployeeobjective_id_2deed8db; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalemployeeobjective_id_2deed8db ON public.pms_historicalemployeeobjective USING btree (id);


--
-- Name: pms_historicalemployeeobjective_modified_by_id_d80ae051; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalemployeeobjective_modified_by_id_d80ae051 ON public.pms_historicalemployeeobjective USING btree (modified_by_id);


--
-- Name: pms_historicalemployeeobjective_objective_id_id_d44f1526; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalemployeeobjective_objective_id_id_d44f1526 ON public.pms_historicalemployeeobjective USING btree (objective_id_id);


--
-- Name: pms_historicalkeyresult_company_id_id_5a76114f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalkeyresult_company_id_id_5a76114f ON public.pms_historicalkeyresult USING btree (company_id_id);


--
-- Name: pms_historicalkeyresult_created_by_id_04306abf; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalkeyresult_created_by_id_04306abf ON public.pms_historicalkeyresult USING btree (created_by_id);


--
-- Name: pms_historicalkeyresult_hi_historicalkeyresult_id_e3104884; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalkeyresult_hi_historicalkeyresult_id_e3104884 ON public.pms_historicalkeyresult_history_tags USING btree (historicalkeyresult_id);


--
-- Name: pms_historicalkeyresult_history_date_c8832947; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalkeyresult_history_date_c8832947 ON public.pms_historicalkeyresult USING btree (history_date);


--
-- Name: pms_historicalkeyresult_history_tags_audittag_id_4f7451ad; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalkeyresult_history_tags_audittag_id_4f7451ad ON public.pms_historicalkeyresult_history_tags USING btree (audittag_id);


--
-- Name: pms_historicalkeyresult_history_user_id_252d47dc; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalkeyresult_history_user_id_252d47dc ON public.pms_historicalkeyresult USING btree (history_user_id);


--
-- Name: pms_historicalkeyresult_id_946a9777; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalkeyresult_id_946a9777 ON public.pms_historicalkeyresult USING btree (id);


--
-- Name: pms_historicalkeyresult_modified_by_id_b0371450; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalkeyresult_modified_by_id_b0371450 ON public.pms_historicalkeyresult USING btree (modified_by_id);


--
-- Name: pms_historicalobjective_company_id_id_ed3589c5; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalobjective_company_id_id_ed3589c5 ON public.pms_historicalobjective USING btree (company_id_id);


--
-- Name: pms_historicalobjective_created_by_id_0102dc57; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalobjective_created_by_id_0102dc57 ON public.pms_historicalobjective USING btree (created_by_id);


--
-- Name: pms_historicalobjective_hi_historicalobjective_id_5ca7029b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalobjective_hi_historicalobjective_id_5ca7029b ON public.pms_historicalobjective_history_tags USING btree (historicalobjective_id);


--
-- Name: pms_historicalobjective_history_date_3583f63e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalobjective_history_date_3583f63e ON public.pms_historicalobjective USING btree (history_date);


--
-- Name: pms_historicalobjective_history_tags_audittag_id_bfa7c78c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalobjective_history_tags_audittag_id_bfa7c78c ON public.pms_historicalobjective_history_tags USING btree (audittag_id);


--
-- Name: pms_historicalobjective_history_user_id_39aa8815; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalobjective_history_user_id_39aa8815 ON public.pms_historicalobjective USING btree (history_user_id);


--
-- Name: pms_historicalobjective_id_69f74f83; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalobjective_id_69f74f83 ON public.pms_historicalobjective USING btree (id);


--
-- Name: pms_historicalobjective_modified_by_id_ca8df4d1; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_historicalobjective_modified_by_id_ca8df4d1 ON public.pms_historicalobjective USING btree (modified_by_id);


--
-- Name: pms_keyresult_company_id_id_aba9e43b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_keyresult_company_id_id_aba9e43b ON public.pms_keyresult USING btree (company_id_id);


--
-- Name: pms_keyresult_created_by_id_610bc0d5; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_keyresult_created_by_id_610bc0d5 ON public.pms_keyresult USING btree (created_by_id);


--
-- Name: pms_keyresult_modified_by_id_fb402cf1; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_keyresult_modified_by_id_fb402cf1 ON public.pms_keyresult USING btree (modified_by_id);


--
-- Name: pms_keyresultfeedback_employee_id_id_c7a3a640; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_keyresultfeedback_employee_id_id_c7a3a640 ON public.pms_keyresultfeedback USING btree (employee_id_id);


--
-- Name: pms_keyresultfeedback_feedback_id_id_0e5351b6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_keyresultfeedback_feedback_id_id_0e5351b6 ON public.pms_keyresultfeedback USING btree (feedback_id_id);


--
-- Name: pms_keyresultfeedback_key_result_id_id_a48b7226; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_keyresultfeedback_key_result_id_id_a48b7226 ON public.pms_keyresultfeedback USING btree (key_result_id_id);


--
-- Name: pms_meetings_answer_employees_employee_id_770d488c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_meetings_answer_employees_employee_id_770d488c ON public.pms_meetings_answer_employees USING btree (employee_id);


--
-- Name: pms_meetings_answer_employees_meetings_id_241405c7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_meetings_answer_employees_meetings_id_241405c7 ON public.pms_meetings_answer_employees USING btree (meetings_id);


--
-- Name: pms_meetings_company_id_id_2e4b7ae7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_meetings_company_id_id_2e4b7ae7 ON public.pms_meetings USING btree (company_id_id);


--
-- Name: pms_meetings_created_by_id_a66016da; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_meetings_created_by_id_a66016da ON public.pms_meetings USING btree (created_by_id);


--
-- Name: pms_meetings_employee_id_employee_id_31298146; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_meetings_employee_id_employee_id_31298146 ON public.pms_meetings_employee_id USING btree (employee_id);


--
-- Name: pms_meetings_employee_id_meetings_id_afe63fe0; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_meetings_employee_id_meetings_id_afe63fe0 ON public.pms_meetings_employee_id USING btree (meetings_id);


--
-- Name: pms_meetings_manager_employee_id_66475189; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_meetings_manager_employee_id_66475189 ON public.pms_meetings_manager USING btree (employee_id);


--
-- Name: pms_meetings_manager_meetings_id_477de095; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_meetings_manager_meetings_id_477de095 ON public.pms_meetings_manager USING btree (meetings_id);


--
-- Name: pms_meetings_modified_by_id_f4f4f4bf; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_meetings_modified_by_id_f4f4f4bf ON public.pms_meetings USING btree (modified_by_id);


--
-- Name: pms_meetings_question_template_id_4c5c155d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_meetings_question_template_id_4c5c155d ON public.pms_meetings USING btree (question_template_id);


--
-- Name: pms_meetingsanswer_employee_id_id_b151c6cb; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_meetingsanswer_employee_id_id_b151c6cb ON public.pms_meetingsanswer USING btree (employee_id_id);


--
-- Name: pms_meetingsanswer_meeting_id_id_68d8343e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_meetingsanswer_meeting_id_id_68d8343e ON public.pms_meetingsanswer USING btree (meeting_id_id);


--
-- Name: pms_meetingsanswer_question_id_id_d07fab0f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_meetingsanswer_question_id_id_d07fab0f ON public.pms_meetingsanswer USING btree (question_id_id);


--
-- Name: pms_objective_assignees_employee_id_1cf59cf6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_objective_assignees_employee_id_1cf59cf6 ON public.pms_objective_assignees USING btree (employee_id);


--
-- Name: pms_objective_assignees_objective_id_f28c7dd3; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_objective_assignees_objective_id_f28c7dd3 ON public.pms_objective_assignees USING btree (objective_id);


--
-- Name: pms_objective_company_id_id_4df6f8ca; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_objective_company_id_id_4df6f8ca ON public.pms_objective USING btree (company_id_id);


--
-- Name: pms_objective_created_by_id_d0943a41; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_objective_created_by_id_d0943a41 ON public.pms_objective USING btree (created_by_id);


--
-- Name: pms_objective_key_result_id_keyresult_id_6fd630ee; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_objective_key_result_id_keyresult_id_6fd630ee ON public.pms_objective_key_result_id USING btree (keyresult_id);


--
-- Name: pms_objective_key_result_id_objective_id_e5bfede7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_objective_key_result_id_objective_id_e5bfede7 ON public.pms_objective_key_result_id USING btree (objective_id);


--
-- Name: pms_objective_managers_employee_id_ff9ec02e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_objective_managers_employee_id_ff9ec02e ON public.pms_objective_managers USING btree (employee_id);


--
-- Name: pms_objective_managers_objective_id_c30c1375; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_objective_managers_objective_id_c30c1375 ON public.pms_objective_managers USING btree (objective_id);


--
-- Name: pms_objective_modified_by_id_fc79eb66; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_objective_modified_by_id_fc79eb66 ON public.pms_objective USING btree (modified_by_id);


--
-- Name: pms_period_company_id_company_id_5fa497bf; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_period_company_id_company_id_5fa497bf ON public.pms_period_company_id USING btree (company_id);


--
-- Name: pms_period_company_id_period_id_66f72252; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_period_company_id_period_id_66f72252 ON public.pms_period_company_id USING btree (period_id);


--
-- Name: pms_period_created_by_id_27961755; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_period_created_by_id_27961755 ON public.pms_period USING btree (created_by_id);


--
-- Name: pms_period_modified_by_id_6b790b4d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_period_modified_by_id_6b790b4d ON public.pms_period USING btree (modified_by_id);


--
-- Name: pms_period_period_name_0e2c313b_like; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_period_period_name_0e2c313b_like ON public.pms_period USING btree (period_name varchar_pattern_ops);


--
-- Name: pms_question_created_by_id_2ac15bc5; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_question_created_by_id_2ac15bc5 ON public.pms_question USING btree (created_by_id);


--
-- Name: pms_question_modified_by_id_a7ba6fec; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_question_modified_by_id_a7ba6fec ON public.pms_question USING btree (modified_by_id);


--
-- Name: pms_question_template_id_id_1d81b86c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_question_template_id_id_1d81b86c ON public.pms_question USING btree (template_id_id);


--
-- Name: pms_questionoptions_created_by_id_18690141; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_questionoptions_created_by_id_18690141 ON public.pms_questionoptions USING btree (created_by_id);


--
-- Name: pms_questionoptions_modified_by_id_4278dd85; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_questionoptions_modified_by_id_4278dd85 ON public.pms_questionoptions USING btree (modified_by_id);


--
-- Name: pms_questionoptions_question_id_id_79cd1205; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_questionoptions_question_id_id_79cd1205 ON public.pms_questionoptions USING btree (question_id_id);


--
-- Name: pms_questiontemplate_company_id_company_id_648e075d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_questiontemplate_company_id_company_id_648e075d ON public.pms_questiontemplate_company_id USING btree (company_id);


--
-- Name: pms_questiontemplate_company_id_questiontemplate_id_8b4847bb; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_questiontemplate_company_id_questiontemplate_id_8b4847bb ON public.pms_questiontemplate_company_id USING btree (questiontemplate_id);


--
-- Name: pms_questiontemplate_created_by_id_d6911099; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_questiontemplate_created_by_id_d6911099 ON public.pms_questiontemplate USING btree (created_by_id);


--
-- Name: pms_questiontemplate_modified_by_id_b47b4f16; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_questiontemplate_modified_by_id_b47b4f16 ON public.pms_questiontemplate USING btree (modified_by_id);


--
-- Name: pms_questiontemplate_question_template_e9026aa2_like; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX pms_questiontemplate_question_template_e9026aa2_like ON public.pms_questiontemplate USING btree (question_template varchar_pattern_ops);


--
-- Name: project_project_company_id_id_3b541f4d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_project_company_id_id_3b541f4d ON public.project_project USING btree (company_id_id);


--
-- Name: project_project_created_by_id_b4ef8dd6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_project_created_by_id_b4ef8dd6 ON public.project_project USING btree (created_by_id);


--
-- Name: project_project_managers_employee_id_52eccea8; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_project_managers_employee_id_52eccea8 ON public.project_project_managers USING btree (employee_id);


--
-- Name: project_project_managers_project_id_c8ee4c70; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_project_managers_project_id_c8ee4c70 ON public.project_project_managers USING btree (project_id);


--
-- Name: project_project_members_employee_id_6236dc25; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_project_members_employee_id_6236dc25 ON public.project_project_members USING btree (employee_id);


--
-- Name: project_project_members_project_id_0c0a7146; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_project_members_project_id_0c0a7146 ON public.project_project_members USING btree (project_id);


--
-- Name: project_project_modified_by_id_b07be181; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_project_modified_by_id_b07be181 ON public.project_project USING btree (modified_by_id);


--
-- Name: project_project_title_487e86e5_like; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_project_title_487e86e5_like ON public.project_project USING btree (title varchar_pattern_ops);


--
-- Name: project_projectstage_created_by_id_8031fcea; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_projectstage_created_by_id_8031fcea ON public.project_projectstage USING btree (created_by_id);


--
-- Name: project_projectstage_modified_by_id_b3fddb64; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_projectstage_modified_by_id_b3fddb64 ON public.project_projectstage USING btree (modified_by_id);


--
-- Name: project_projectstage_project_id_9b915412; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_projectstage_project_id_9b915412 ON public.project_projectstage USING btree (project_id);


--
-- Name: project_task_created_by_id_21916daf; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_task_created_by_id_21916daf ON public.project_task USING btree (created_by_id);


--
-- Name: project_task_modified_by_id_106a7e44; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_task_modified_by_id_106a7e44 ON public.project_task USING btree (modified_by_id);


--
-- Name: project_task_project_id_a8ab06ac; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_task_project_id_a8ab06ac ON public.project_task USING btree (project_id);


--
-- Name: project_task_stage_id_7333e419; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_task_stage_id_7333e419 ON public.project_task USING btree (stage_id);


--
-- Name: project_task_task_managers_employee_id_d81f09bb; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_task_task_managers_employee_id_d81f09bb ON public.project_task_task_managers USING btree (employee_id);


--
-- Name: project_task_task_managers_task_id_fbc2c5a4; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_task_task_managers_task_id_fbc2c5a4 ON public.project_task_task_managers USING btree (task_id);


--
-- Name: project_task_task_members_employee_id_fbd97e5f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_task_task_members_employee_id_fbd97e5f ON public.project_task_task_members USING btree (employee_id);


--
-- Name: project_task_task_members_task_id_af91b467; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_task_task_members_task_id_af91b467 ON public.project_task_task_members USING btree (task_id);


--
-- Name: project_timesheet_created_by_id_66f2f1be; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_timesheet_created_by_id_66f2f1be ON public.project_timesheet USING btree (created_by_id);


--
-- Name: project_timesheet_employee_id_id_8774a71d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_timesheet_employee_id_id_8774a71d ON public.project_timesheet USING btree (employee_id_id);


--
-- Name: project_timesheet_modified_by_id_8b8c57ba; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_timesheet_modified_by_id_8b8c57ba ON public.project_timesheet USING btree (modified_by_id);


--
-- Name: project_timesheet_project_id_id_daf90f6b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_timesheet_project_id_id_daf90f6b ON public.project_timesheet USING btree (project_id_id);


--
-- Name: project_timesheet_task_id_id_88ed4e3c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX project_timesheet_task_id_id_88ed4e3c ON public.project_timesheet USING btree (task_id_id);


--
-- Name: recruitment_candidate_converted_employee_id_id_aea3b89c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_candidate_converted_employee_id_id_aea3b89c ON public.recruitment_candidate USING btree (converted_employee_id_id);


--
-- Name: recruitment_candidate_created_by_id_e66d3f8b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_candidate_created_by_id_e66d3f8b ON public.recruitment_candidate USING btree (created_by_id);


--
-- Name: recruitment_candidate_email_2c8760b4_like; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_candidate_email_2c8760b4_like ON public.recruitment_candidate USING btree (email varchar_pattern_ops);


--
-- Name: recruitment_candidate_job_position_id_id_6d554ae7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_candidate_job_position_id_id_6d554ae7 ON public.recruitment_candidate USING btree (job_position_id_id);


--
-- Name: recruitment_candidate_modified_by_id_ea175e4b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_candidate_modified_by_id_ea175e4b ON public.recruitment_candidate USING btree (modified_by_id);


--
-- Name: recruitment_candidate_recruitment_id_id_3276947d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_candidate_recruitment_id_id_3276947d ON public.recruitment_candidate USING btree (recruitment_id_id);


--
-- Name: recruitment_candidate_referral_id_0aaff040; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_candidate_referral_id_0aaff040 ON public.recruitment_candidate USING btree (referral_id);


--
-- Name: recruitment_candidate_stage_id_id_95c8b982; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_candidate_stage_id_id_95c8b982 ON public.recruitment_candidate USING btree (stage_id_id);


--
-- Name: recruitment_candidatedocum_candidate_id_aa0c35ed; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_candidatedocum_candidate_id_aa0c35ed ON public.recruitment_candidatedocumentrequest_candidate_id USING btree (candidate_id);


--
-- Name: recruitment_candidatedocum_candidatedocumentrequest_i_58411ac1; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_candidatedocum_candidatedocumentrequest_i_58411ac1 ON public.recruitment_candidatedocumentrequest_candidate_id USING btree (candidatedocumentrequest_id);


--
-- Name: recruitment_candidatedocument_candidate_id_id_e3f353e9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_candidatedocument_candidate_id_id_e3f353e9 ON public.recruitment_candidatedocument USING btree (candidate_id_id);


--
-- Name: recruitment_candidatedocument_created_by_id_b99ad3d5; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_candidatedocument_created_by_id_b99ad3d5 ON public.recruitment_candidatedocument USING btree (created_by_id);


--
-- Name: recruitment_candidatedocument_document_request_id_id_f57b6648; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_candidatedocument_document_request_id_id_f57b6648 ON public.recruitment_candidatedocument USING btree (document_request_id_id);


--
-- Name: recruitment_candidatedocument_modified_by_id_bf50b147; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_candidatedocument_modified_by_id_bf50b147 ON public.recruitment_candidatedocument USING btree (modified_by_id);


--
-- Name: recruitment_candidatedocumentrequest_created_by_id_9aff83cf; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_candidatedocumentrequest_created_by_id_9aff83cf ON public.recruitment_candidatedocumentrequest USING btree (created_by_id);


--
-- Name: recruitment_candidatedocumentrequest_modified_by_id_0e961fa2; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_candidatedocumentrequest_modified_by_id_0e961fa2 ON public.recruitment_candidatedocumentrequest USING btree (modified_by_id);


--
-- Name: recruitment_candidaterating_candidate_id_id_1ede0d1f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_candidaterating_candidate_id_id_1ede0d1f ON public.recruitment_candidaterating USING btree (candidate_id_id);


--
-- Name: recruitment_candidaterating_created_by_id_0e9a4f8f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_candidaterating_created_by_id_0e9a4f8f ON public.recruitment_candidaterating USING btree (created_by_id);


--
-- Name: recruitment_candidaterating_employee_id_id_aa90a5e3; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_candidaterating_employee_id_id_aa90a5e3 ON public.recruitment_candidaterating USING btree (employee_id_id);


--
-- Name: recruitment_candidaterating_modified_by_id_3ab4f1fe; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_candidaterating_modified_by_id_3ab4f1fe ON public.recruitment_candidaterating USING btree (modified_by_id);


--
-- Name: recruitment_historicalcand_audittag_id_18d229c0; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalcand_audittag_id_18d229c0 ON public.recruitment_historicalcandidate_history_tags USING btree (audittag_id);


--
-- Name: recruitment_historicalcand_converted_employee_id_id_539259f7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalcand_converted_employee_id_id_539259f7 ON public.recruitment_historicalcandidate USING btree (converted_employee_id_id);


--
-- Name: recruitment_historicalcand_historicalcandidate_id_8b4729d7; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalcand_historicalcandidate_id_8b4729d7 ON public.recruitment_historicalcandidate_history_tags USING btree (historicalcandidate_id);


--
-- Name: recruitment_historicalcandidate_created_by_id_e0d2d80b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalcandidate_created_by_id_e0d2d80b ON public.recruitment_historicalcandidate USING btree (created_by_id);


--
-- Name: recruitment_historicalcandidate_email_04583399; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalcandidate_email_04583399 ON public.recruitment_historicalcandidate USING btree (email);


--
-- Name: recruitment_historicalcandidate_email_04583399_like; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalcandidate_email_04583399_like ON public.recruitment_historicalcandidate USING btree (email varchar_pattern_ops);


--
-- Name: recruitment_historicalcandidate_history_date_ab29a308; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalcandidate_history_date_ab29a308 ON public.recruitment_historicalcandidate USING btree (history_date);


--
-- Name: recruitment_historicalcandidate_history_relation_id_04af0535; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalcandidate_history_relation_id_04af0535 ON public.recruitment_historicalcandidate USING btree (history_relation_id);


--
-- Name: recruitment_historicalcandidate_history_user_id_c56fecb3; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalcandidate_history_user_id_c56fecb3 ON public.recruitment_historicalcandidate USING btree (history_user_id);


--
-- Name: recruitment_historicalcandidate_id_754f239c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalcandidate_id_754f239c ON public.recruitment_historicalcandidate USING btree (id);


--
-- Name: recruitment_historicalcandidate_job_position_id_id_f6fadcbc; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalcandidate_job_position_id_id_f6fadcbc ON public.recruitment_historicalcandidate USING btree (job_position_id_id);


--
-- Name: recruitment_historicalcandidate_modified_by_id_ffd9a8ac; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalcandidate_modified_by_id_ffd9a8ac ON public.recruitment_historicalcandidate USING btree (modified_by_id);


--
-- Name: recruitment_historicalcandidate_recruitment_id_id_bf78daa8; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalcandidate_recruitment_id_id_bf78daa8 ON public.recruitment_historicalcandidate USING btree (recruitment_id_id);


--
-- Name: recruitment_historicalcandidate_referral_id_66a55772; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalcandidate_referral_id_66a55772 ON public.recruitment_historicalcandidate USING btree (referral_id);


--
-- Name: recruitment_historicalcandidate_stage_id_id_a5d26037; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalcandidate_stage_id_id_a5d26037 ON public.recruitment_historicalcandidate USING btree (stage_id_id);


--
-- Name: recruitment_historicalreje_audittag_id_c5b10b47; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalreje_audittag_id_c5b10b47 ON public.recruitment_historicalrejectedcandidate_history_tags USING btree (audittag_id);


--
-- Name: recruitment_historicalreje_candidate_id_id_f590a22d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalreje_candidate_id_id_f590a22d ON public.recruitment_historicalrejectedcandidate USING btree (candidate_id_id);


--
-- Name: recruitment_historicalreje_historicalrejectedcandidat_4765b9a4; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalreje_historicalrejectedcandidat_4765b9a4 ON public.recruitment_historicalrejectedcandidate_history_tags USING btree (historicalrejectedcandidate_id);


--
-- Name: recruitment_historicalreje_history_relation_id_99021d48; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalreje_history_relation_id_99021d48 ON public.recruitment_historicalrejectedcandidate USING btree (history_relation_id);


--
-- Name: recruitment_historicalreje_history_user_id_ade3345e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalreje_history_user_id_ade3345e ON public.recruitment_historicalrejectedcandidate USING btree (history_user_id);


--
-- Name: recruitment_historicalrejectedcandidate_created_by_id_ad5f645f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalrejectedcandidate_created_by_id_ad5f645f ON public.recruitment_historicalrejectedcandidate USING btree (created_by_id);


--
-- Name: recruitment_historicalrejectedcandidate_history_date_cc4995db; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalrejectedcandidate_history_date_cc4995db ON public.recruitment_historicalrejectedcandidate USING btree (history_date);


--
-- Name: recruitment_historicalrejectedcandidate_id_30e1cc24; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalrejectedcandidate_id_30e1cc24 ON public.recruitment_historicalrejectedcandidate USING btree (id);


--
-- Name: recruitment_historicalrejectedcandidate_modified_by_id_9c81374f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_historicalrejectedcandidate_modified_by_id_9c81374f ON public.recruitment_historicalrejectedcandidate USING btree (modified_by_id);


--
-- Name: recruitment_interviewsched_interviewschedule_id_60873c42; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_interviewsched_interviewschedule_id_60873c42 ON public.recruitment_interviewschedule_employee_id USING btree (interviewschedule_id);


--
-- Name: recruitment_interviewschedule_candidate_id_id_bae2223f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_interviewschedule_candidate_id_id_bae2223f ON public.recruitment_interviewschedule USING btree (candidate_id_id);


--
-- Name: recruitment_interviewschedule_created_by_id_7ea3824e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_interviewschedule_created_by_id_7ea3824e ON public.recruitment_interviewschedule USING btree (created_by_id);


--
-- Name: recruitment_interviewschedule_employee_id_employee_id_ccd9a309; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_interviewschedule_employee_id_employee_id_ccd9a309 ON public.recruitment_interviewschedule_employee_id USING btree (employee_id);


--
-- Name: recruitment_interviewschedule_modified_by_id_d79442b1; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_interviewschedule_modified_by_id_d79442b1 ON public.recruitment_interviewschedule USING btree (modified_by_id);


--
-- Name: recruitment_linkedinaccount_company_id_id_92fc0d4f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_linkedinaccount_company_id_id_92fc0d4f ON public.recruitment_linkedinaccount USING btree (company_id_id);


--
-- Name: recruitment_linkedinaccount_created_by_id_d4c65311; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_linkedinaccount_created_by_id_d4c65311 ON public.recruitment_linkedinaccount USING btree (created_by_id);


--
-- Name: recruitment_linkedinaccount_modified_by_id_6f83d73b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_linkedinaccount_modified_by_id_6f83d73b ON public.recruitment_linkedinaccount USING btree (modified_by_id);


--
-- Name: recruitment_linkedinaccount_sub_id_4f12336d_like; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_linkedinaccount_sub_id_4f12336d_like ON public.recruitment_linkedinaccount USING btree (sub_id varchar_pattern_ops);


--
-- Name: recruitment_questionordering_created_by_id_f8771bb5; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_questionordering_created_by_id_f8771bb5 ON public.recruitment_questionordering USING btree (created_by_id);


--
-- Name: recruitment_questionordering_modified_by_id_0355a7a5; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_questionordering_modified_by_id_0355a7a5 ON public.recruitment_questionordering USING btree (modified_by_id);


--
-- Name: recruitment_questionordering_question_id_id_1b4adb1f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_questionordering_question_id_id_1b4adb1f ON public.recruitment_questionordering USING btree (question_id_id);


--
-- Name: recruitment_questionordering_recruitment_id_id_d35a120f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_questionordering_recruitment_id_id_d35a120f ON public.recruitment_questionordering USING btree (recruitment_id_id);


--
-- Name: recruitment_recruitment_company_id_id_35c39ac1; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitment_company_id_id_35c39ac1 ON public.recruitment_recruitment USING btree (company_id_id);


--
-- Name: recruitment_recruitment_created_by_id_7487d8a1; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitment_created_by_id_7487d8a1 ON public.recruitment_recruitment USING btree (created_by_id);


--
-- Name: recruitment_recruitment_job_position_id_id_253cfce6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitment_job_position_id_id_253cfce6 ON public.recruitment_recruitment USING btree (job_position_id_id);


--
-- Name: recruitment_recruitment_linkedin_account_id_id_ed119e75; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitment_linkedin_account_id_id_ed119e75 ON public.recruitment_recruitment USING btree (linkedin_account_id_id);


--
-- Name: recruitment_recruitment_modified_by_id_3da7024d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitment_modified_by_id_3da7024d ON public.recruitment_recruitment USING btree (modified_by_id);


--
-- Name: recruitment_recruitment_open_positions_jobposition_id_b152ea09; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitment_open_positions_jobposition_id_b152ea09 ON public.recruitment_recruitment_open_positions USING btree (jobposition_id);


--
-- Name: recruitment_recruitment_open_positions_recruitment_id_ecad5263; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitment_open_positions_recruitment_id_ecad5263 ON public.recruitment_recruitment_open_positions USING btree (recruitment_id);


--
-- Name: recruitment_recruitment_re_employee_id_a7139bba; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitment_re_employee_id_a7139bba ON public.recruitment_recruitment_recruitment_managers USING btree (employee_id);


--
-- Name: recruitment_recruitment_re_recruitment_id_a4c3404a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitment_re_recruitment_id_a4c3404a ON public.recruitment_recruitment_recruitment_managers USING btree (recruitment_id);


--
-- Name: recruitment_recruitment_skills_recruitment_id_c62ab337; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitment_skills_recruitment_id_c62ab337 ON public.recruitment_recruitment_skills USING btree (recruitment_id);


--
-- Name: recruitment_recruitment_skills_skill_id_659ac48e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitment_skills_skill_id_659ac48e ON public.recruitment_recruitment_skills USING btree (skill_id);


--
-- Name: recruitment_recruitment_su_recruitment_id_082d049d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitment_su_recruitment_id_082d049d ON public.recruitment_recruitment_survey_templates USING btree (recruitment_id);


--
-- Name: recruitment_recruitment_su_surveytemplate_id_536c97fa; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitment_su_surveytemplate_id_536c97fa ON public.recruitment_recruitment_survey_templates USING btree (surveytemplate_id);


--
-- Name: recruitment_recruitmentgeneralsetting_company_id_id_32a2ecaf; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitmentgeneralsetting_company_id_id_32a2ecaf ON public.recruitment_recruitmentgeneralsetting USING btree (company_id_id);


--
-- Name: recruitment_recruitmentgeneralsetting_created_by_id_86a5f511; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitmentgeneralsetting_created_by_id_86a5f511 ON public.recruitment_recruitmentgeneralsetting USING btree (created_by_id);


--
-- Name: recruitment_recruitmentgeneralsetting_modified_by_id_1e118681; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitmentgeneralsetting_modified_by_id_1e118681 ON public.recruitment_recruitmentgeneralsetting USING btree (modified_by_id);


--
-- Name: recruitment_recruitmentsur_jobposition_id_89704641; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitmentsur_jobposition_id_89704641 ON public.recruitment_recruitmentsurvey_job_position_ids USING btree (jobposition_id);


--
-- Name: recruitment_recruitmentsur_recruitment_id_e1b93c79; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitmentsur_recruitment_id_e1b93c79 ON public.recruitment_recruitmentsurvey_recruitment_ids USING btree (recruitment_id);


--
-- Name: recruitment_recruitmentsur_recruitmentsurvey_id_45834a00; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitmentsur_recruitmentsurvey_id_45834a00 ON public.recruitment_recruitmentsurvey_template_id USING btree (recruitmentsurvey_id);


--
-- Name: recruitment_recruitmentsur_recruitmentsurvey_id_711bd7eb; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitmentsur_recruitmentsurvey_id_711bd7eb ON public.recruitment_recruitmentsurvey_recruitment_ids USING btree (recruitmentsurvey_id);


--
-- Name: recruitment_recruitmentsur_recruitmentsurvey_id_75c9ce77; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitmentsur_recruitmentsurvey_id_75c9ce77 ON public.recruitment_recruitmentsurvey_job_position_ids USING btree (recruitmentsurvey_id);


--
-- Name: recruitment_recruitmentsur_surveytemplate_id_54a3a2e8; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitmentsur_surveytemplate_id_54a3a2e8 ON public.recruitment_recruitmentsurvey_template_id USING btree (surveytemplate_id);


--
-- Name: recruitment_recruitmentsurvey_created_by_id_1a345de1; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitmentsurvey_created_by_id_1a345de1 ON public.recruitment_recruitmentsurvey USING btree (created_by_id);


--
-- Name: recruitment_recruitmentsurvey_modified_by_id_3669d754; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitmentsurvey_modified_by_id_3669d754 ON public.recruitment_recruitmentsurvey USING btree (modified_by_id);


--
-- Name: recruitment_recruitmentsurveyanswer_candidate_id_id_e1b0fedb; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitmentsurveyanswer_candidate_id_id_e1b0fedb ON public.recruitment_recruitmentsurveyanswer USING btree (candidate_id_id);


--
-- Name: recruitment_recruitmentsurveyanswer_created_by_id_163d2633; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitmentsurveyanswer_created_by_id_163d2633 ON public.recruitment_recruitmentsurveyanswer USING btree (created_by_id);


--
-- Name: recruitment_recruitmentsurveyanswer_job_position_id_id_97a8b004; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitmentsurveyanswer_job_position_id_id_97a8b004 ON public.recruitment_recruitmentsurveyanswer USING btree (job_position_id_id);


--
-- Name: recruitment_recruitmentsurveyanswer_modified_by_id_1bfd6064; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitmentsurveyanswer_modified_by_id_1bfd6064 ON public.recruitment_recruitmentsurveyanswer USING btree (modified_by_id);


--
-- Name: recruitment_recruitmentsurveyanswer_recruitment_id_id_56888b17; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_recruitmentsurveyanswer_recruitment_id_id_56888b17 ON public.recruitment_recruitmentsurveyanswer USING btree (recruitment_id_id);


--
-- Name: recruitment_rejectedcandid_rejectedcandidate_id_0029fa4e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_rejectedcandid_rejectedcandidate_id_0029fa4e ON public.recruitment_rejectedcandidate_reject_reason_id USING btree (rejectedcandidate_id);


--
-- Name: recruitment_rejectedcandid_rejectreason_id_a5275520; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_rejectedcandid_rejectreason_id_a5275520 ON public.recruitment_rejectedcandidate_reject_reason_id USING btree (rejectreason_id);


--
-- Name: recruitment_rejectedcandidate_created_by_id_0d2b6a1a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_rejectedcandidate_created_by_id_0d2b6a1a ON public.recruitment_rejectedcandidate USING btree (created_by_id);


--
-- Name: recruitment_rejectedcandidate_modified_by_id_9bef5a46; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_rejectedcandidate_modified_by_id_9bef5a46 ON public.recruitment_rejectedcandidate USING btree (modified_by_id);


--
-- Name: recruitment_rejectreason_company_id_id_710f492e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_rejectreason_company_id_id_710f492e ON public.recruitment_rejectreason USING btree (company_id_id);


--
-- Name: recruitment_rejectreason_created_by_id_f79fee48; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_rejectreason_created_by_id_f79fee48 ON public.recruitment_rejectreason USING btree (created_by_id);


--
-- Name: recruitment_rejectreason_modified_by_id_87e738ae; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_rejectreason_modified_by_id_87e738ae ON public.recruitment_rejectreason USING btree (modified_by_id);


--
-- Name: recruitment_resume_recruitment_id_id_00eb694d; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_resume_recruitment_id_id_00eb694d ON public.recruitment_resume USING btree (recruitment_id_id);


--
-- Name: recruitment_skill_created_by_id_fbf18ae8; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_skill_created_by_id_fbf18ae8 ON public.recruitment_skill USING btree (created_by_id);


--
-- Name: recruitment_skill_modified_by_id_32de1bd8; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_skill_modified_by_id_32de1bd8 ON public.recruitment_skill USING btree (modified_by_id);


--
-- Name: recruitment_skillzone_company_id_id_a5d93a16; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_skillzone_company_id_id_a5d93a16 ON public.recruitment_skillzone USING btree (company_id_id);


--
-- Name: recruitment_skillzone_created_by_id_5d1ea287; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_skillzone_created_by_id_5d1ea287 ON public.recruitment_skillzone USING btree (created_by_id);


--
-- Name: recruitment_skillzone_modified_by_id_e00c979e; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_skillzone_modified_by_id_e00c979e ON public.recruitment_skillzone USING btree (modified_by_id);


--
-- Name: recruitment_skillzonecandidate_candidate_id_id_ac9e3998; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_skillzonecandidate_candidate_id_id_ac9e3998 ON public.recruitment_skillzonecandidate USING btree (candidate_id_id);


--
-- Name: recruitment_skillzonecandidate_created_by_id_bea62548; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_skillzonecandidate_created_by_id_bea62548 ON public.recruitment_skillzonecandidate USING btree (created_by_id);


--
-- Name: recruitment_skillzonecandidate_modified_by_id_a1ce64d0; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_skillzonecandidate_modified_by_id_a1ce64d0 ON public.recruitment_skillzonecandidate USING btree (modified_by_id);


--
-- Name: recruitment_skillzonecandidate_skill_zone_id_id_f55c73fc; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_skillzonecandidate_skill_zone_id_id_f55c73fc ON public.recruitment_skillzonecandidate USING btree (skill_zone_id_id);


--
-- Name: recruitment_stage_created_by_id_93d9a4be; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_stage_created_by_id_93d9a4be ON public.recruitment_stage USING btree (created_by_id);


--
-- Name: recruitment_stage_modified_by_id_96c190ac; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_stage_modified_by_id_96c190ac ON public.recruitment_stage USING btree (modified_by_id);


--
-- Name: recruitment_stage_recruitment_id_id_d63ee32a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_stage_recruitment_id_id_d63ee32a ON public.recruitment_stage USING btree (recruitment_id_id);


--
-- Name: recruitment_stage_stage_managers_employee_id_e7e5236a; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_stage_stage_managers_employee_id_e7e5236a ON public.recruitment_stage_stage_managers USING btree (employee_id);


--
-- Name: recruitment_stage_stage_managers_stage_id_6d61885b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_stage_stage_managers_stage_id_6d61885b ON public.recruitment_stage_stage_managers USING btree (stage_id);


--
-- Name: recruitment_stagefiles_created_by_id_a3b5b93f; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_stagefiles_created_by_id_a3b5b93f ON public.recruitment_stagefiles USING btree (created_by_id);


--
-- Name: recruitment_stagefiles_modified_by_id_cb03fbd9; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_stagefiles_modified_by_id_cb03fbd9 ON public.recruitment_stagefiles USING btree (modified_by_id);


--
-- Name: recruitment_stagenote_candidate_id_id_d1383dd3; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_stagenote_candidate_id_id_d1383dd3 ON public.recruitment_stagenote USING btree (candidate_id_id);


--
-- Name: recruitment_stagenote_created_by_id_b3a66e86; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_stagenote_created_by_id_b3a66e86 ON public.recruitment_stagenote USING btree (created_by_id);


--
-- Name: recruitment_stagenote_modified_by_id_c57c24d3; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_stagenote_modified_by_id_c57c24d3 ON public.recruitment_stagenote USING btree (modified_by_id);


--
-- Name: recruitment_stagenote_stage_files_stagefiles_id_c02993d0; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_stagenote_stage_files_stagefiles_id_c02993d0 ON public.recruitment_stagenote_stage_files USING btree (stagefiles_id);


--
-- Name: recruitment_stagenote_stage_files_stagenote_id_8a0b35b6; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_stagenote_stage_files_stagenote_id_8a0b35b6 ON public.recruitment_stagenote_stage_files USING btree (stagenote_id);


--
-- Name: recruitment_stagenote_stage_id_id_1a358085; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_stagenote_stage_id_id_1a358085 ON public.recruitment_stagenote USING btree (stage_id_id);


--
-- Name: recruitment_stagenote_updated_by_id_ed4ff558; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_stagenote_updated_by_id_ed4ff558 ON public.recruitment_stagenote USING btree (updated_by_id);


--
-- Name: recruitment_surveytemplate_company_id_id_5bae672b; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_surveytemplate_company_id_id_5bae672b ON public.recruitment_surveytemplate USING btree (company_id_id);


--
-- Name: recruitment_surveytemplate_created_by_id_38b804e2; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_surveytemplate_created_by_id_38b804e2 ON public.recruitment_surveytemplate USING btree (created_by_id);


--
-- Name: recruitment_surveytemplate_modified_by_id_6311950c; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_surveytemplate_modified_by_id_6311950c ON public.recruitment_surveytemplate USING btree (modified_by_id);


--
-- Name: recruitment_surveytemplate_title_5ec6bef8_like; Type: INDEX; Schema: public; Owner: horilla
--

CREATE INDEX recruitment_surveytemplate_title_5ec6bef8_like ON public.recruitment_surveytemplate USING btree (title varchar_pattern_ops);


--
-- Name: unique_badge_id; Type: INDEX; Schema: public; Owner: horilla
--

CREATE UNIQUE INDEX unique_badge_id ON public.employee_employee USING btree (badge_id) WHERE (badge_id IS NOT NULL);


--
-- Name: unique_company_id_when_not_null_facedetection; Type: INDEX; Schema: public; Owner: horilla
--

CREATE UNIQUE INDEX unique_company_id_when_not_null_facedetection ON public.facedetection_facedetection USING btree (company_id_id) WHERE (NOT (company_id_id IS NULL));


--
-- Name: unique_company_id_when_not_null_geofencing; Type: INDEX; Schema: public; Owner: horilla
--

CREATE UNIQUE INDEX unique_company_id_when_not_null_geofencing ON public.geofencing_geofencing USING btree (company_id_id) WHERE (NOT (company_id_id IS NULL));


--
-- Name: accessibility_defaultaccessibility accessibility_defaul_created_by_id_ff9332a2_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.accessibility_defaultaccessibility
    ADD CONSTRAINT accessibility_defaul_created_by_id_ff9332a2_fk_auth_user FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accessibility_defaultaccessibility_employees accessibility_defaul_defaultaccessibility_914de53f_fk_accessibi; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.accessibility_defaultaccessibility_employees
    ADD CONSTRAINT accessibility_defaul_defaultaccessibility_914de53f_fk_accessibi FOREIGN KEY (defaultaccessibility_id) REFERENCES public.accessibility_defaultaccessibility(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accessibility_defaultaccessibility_employees accessibility_defaul_employee_id_41ccfcfa_fk_employee_; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.accessibility_defaultaccessibility_employees
    ADD CONSTRAINT accessibility_defaul_employee_id_41ccfcfa_fk_employee_ FOREIGN KEY (employee_id) REFERENCES public.employee_employee(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: accessibility_defaultaccessibility accessibility_defaul_modified_by_id_0b00d519_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.accessibility_defaultaccessibility
    ADD CONSTRAINT accessibility_defaul_modified_by_id_0b00d519_fk_auth_user FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_asset asset_asset_asset_category_id_id_2d1f69ff_fk_asset_ass; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_asset
    ADD CONSTRAINT asset_asset_asset_category_id_id_2d1f69ff_fk_asset_ass FOREIGN KEY (asset_category_id_id) REFERENCES public.asset_assetcategory(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_asset asset_asset_asset_lot_number_id__5b307bec_fk_asset_ass; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_asset
    ADD CONSTRAINT asset_asset_asset_lot_number_id__5b307bec_fk_asset_ass FOREIGN KEY (asset_lot_number_id_id) REFERENCES public.asset_assetlot(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_asset asset_asset_created_by_id_3ee1315a_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_asset
    ADD CONSTRAINT asset_asset_created_by_id_3ee1315a_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_asset asset_asset_modified_by_id_b605c1ff_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_asset
    ADD CONSTRAINT asset_asset_modified_by_id_b605c1ff_fk_auth_user_id FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_asset asset_asset_owner_id_d2d14c87_fk_employee_employee_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_asset
    ADD CONSTRAINT asset_asset_owner_id_d2d14c87_fk_employee_employee_id FOREIGN KEY (owner_id) REFERENCES public.employee_employee(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetassignment_assign_images asset_assetassignmen_assetassignment_id_27ad361a_fk_asset_ass; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetassignment_assign_images
    ADD CONSTRAINT asset_assetassignmen_assetassignment_id_27ad361a_fk_asset_ass FOREIGN KEY (assetassignment_id) REFERENCES public.asset_assetassignment(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetassignment_return_images asset_assetassignmen_assetassignment_id_f72aa0a3_fk_asset_ass; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetassignment_return_images
    ADD CONSTRAINT asset_assetassignmen_assetassignment_id_f72aa0a3_fk_asset_ass FOREIGN KEY (assetassignment_id) REFERENCES public.asset_assetassignment(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetassignment asset_assetassignmen_assigned_by_employee_0f42bd27_fk_employee_; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetassignment
    ADD CONSTRAINT asset_assetassignmen_assigned_by_employee_0f42bd27_fk_employee_ FOREIGN KEY (assigned_by_employee_id_id) REFERENCES public.employee_employee(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetassignment asset_assetassignmen_assigned_to_employee_79cc5925_fk_employee_; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetassignment
    ADD CONSTRAINT asset_assetassignmen_assigned_to_employee_79cc5925_fk_employee_ FOREIGN KEY (assigned_to_employee_id_id) REFERENCES public.employee_employee(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetassignment_return_images asset_assetassignmen_returnimages_id_b0ee2930_fk_asset_ret; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetassignment_return_images
    ADD CONSTRAINT asset_assetassignmen_returnimages_id_b0ee2930_fk_asset_ret FOREIGN KEY (returnimages_id) REFERENCES public.asset_returnimages(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetassignment_assign_images asset_assetassignmen_returnimages_id_cedd3c37_fk_asset_ret; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetassignment_assign_images
    ADD CONSTRAINT asset_assetassignmen_returnimages_id_cedd3c37_fk_asset_ret FOREIGN KEY (returnimages_id) REFERENCES public.asset_returnimages(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetassignment asset_assetassignment_asset_id_id_40e00806_fk_asset_asset_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetassignment
    ADD CONSTRAINT asset_assetassignment_asset_id_id_40e00806_fk_asset_asset_id FOREIGN KEY (asset_id_id) REFERENCES public.asset_asset(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetassignment asset_assetassignment_created_by_id_d7b91bfa_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetassignment
    ADD CONSTRAINT asset_assetassignment_created_by_id_d7b91bfa_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetassignment asset_assetassignment_modified_by_id_f4f5446e_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetassignment
    ADD CONSTRAINT asset_assetassignment_modified_by_id_f4f5446e_fk_auth_user_id FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetcategory_company_id asset_assetcategory__assetcategory_id_bbbe3f1d_fk_asset_ass; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetcategory_company_id
    ADD CONSTRAINT asset_assetcategory__assetcategory_id_bbbe3f1d_fk_asset_ass FOREIGN KEY (assetcategory_id) REFERENCES public.asset_assetcategory(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetcategory_company_id asset_assetcategory__company_id_61918643_fk_base_comp; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetcategory_company_id
    ADD CONSTRAINT asset_assetcategory__company_id_61918643_fk_base_comp FOREIGN KEY (company_id) REFERENCES public.base_company(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetcategory asset_assetcategory_created_by_id_c99b90f0_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetcategory
    ADD CONSTRAINT asset_assetcategory_created_by_id_c99b90f0_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetcategory asset_assetcategory_modified_by_id_bd92ea34_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetcategory
    ADD CONSTRAINT asset_assetcategory_modified_by_id_bd92ea34_fk_auth_user_id FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetdocuments asset_assetdocuments_asset_report_id_5d283992_fk_asset_ass; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetdocuments
    ADD CONSTRAINT asset_assetdocuments_asset_report_id_5d283992_fk_asset_ass FOREIGN KEY (asset_report_id) REFERENCES public.asset_assetreport(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetdocuments asset_assetdocuments_created_by_id_ed1eb431_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetdocuments
    ADD CONSTRAINT asset_assetdocuments_created_by_id_ed1eb431_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetdocuments asset_assetdocuments_modified_by_id_2263fe64_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetdocuments
    ADD CONSTRAINT asset_assetdocuments_modified_by_id_2263fe64_fk_auth_user_id FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetlot_company_id asset_assetlot_compa_assetlot_id_3625ff56_fk_asset_ass; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetlot_company_id
    ADD CONSTRAINT asset_assetlot_compa_assetlot_id_3625ff56_fk_asset_ass FOREIGN KEY (assetlot_id) REFERENCES public.asset_assetlot(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetlot_company_id asset_assetlot_compa_company_id_d784df99_fk_base_comp; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetlot_company_id
    ADD CONSTRAINT asset_assetlot_compa_company_id_d784df99_fk_base_comp FOREIGN KEY (company_id) REFERENCES public.base_company(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetlot asset_assetlot_created_by_id_67eb34f5_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetlot
    ADD CONSTRAINT asset_assetlot_created_by_id_67eb34f5_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetlot asset_assetlot_modified_by_id_06990993_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetlot
    ADD CONSTRAINT asset_assetlot_modified_by_id_06990993_fk_auth_user_id FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetreport asset_assetreport_asset_id_id_f03a6292_fk_asset_asset_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetreport
    ADD CONSTRAINT asset_assetreport_asset_id_id_f03a6292_fk_asset_asset_id FOREIGN KEY (asset_id_id) REFERENCES public.asset_asset(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetreport asset_assetreport_created_by_id_65f2a72b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetreport
    ADD CONSTRAINT asset_assetreport_created_by_id_65f2a72b_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetreport asset_assetreport_modified_by_id_bd66b671_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetreport
    ADD CONSTRAINT asset_assetreport_modified_by_id_bd66b671_fk_auth_user_id FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetrequest asset_assetrequest_asset_category_id_id_818a04db_fk_asset_ass; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetrequest
    ADD CONSTRAINT asset_assetrequest_asset_category_id_id_818a04db_fk_asset_ass FOREIGN KEY (asset_category_id_id) REFERENCES public.asset_assetcategory(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetrequest asset_assetrequest_created_by_id_142e3757_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetrequest
    ADD CONSTRAINT asset_assetrequest_created_by_id_142e3757_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetrequest asset_assetrequest_modified_by_id_ede6ba77_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetrequest
    ADD CONSTRAINT asset_assetrequest_modified_by_id_ede6ba77_fk_auth_user_id FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_assetrequest asset_assetrequest_requested_employee_i_51386fae_fk_employee_; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetrequest
    ADD CONSTRAINT asset_assetrequest_requested_employee_i_51386fae_fk_employee_ FOREIGN KEY (requested_employee_id_id) REFERENCES public.employee_employee(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_returnimages asset_returnimages_created_by_id_593a7b20_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_returnimages
    ADD CONSTRAINT asset_returnimages_created_by_id_593a7b20_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: asset_returnimages asset_returnimages_modified_by_id_9dcbbb09_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_returnimages
    ADD CONSTRAINT asset_returnimages_modified_by_id_9dcbbb09_fk_auth_user_id FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendance attendance_attendanc_attendance_day_id_8bb2b869_fk_base_empl; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendance
    ADD CONSTRAINT attendance_attendanc_attendance_day_id_8bb2b869_fk_base_empl FOREIGN KEY (attendance_day_id) REFERENCES public.base_employeeshiftday(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendancelatecomeearlyout attendance_attendanc_attendance_id_id_86e48a6d_fk_attendanc; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancelatecomeearlyout
    ADD CONSTRAINT attendance_attendanc_attendance_id_id_86e48a6d_fk_attendanc FOREIGN KEY (attendance_id_id) REFERENCES public.attendance_attendance(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendancerequestcomment_files attendance_attendanc_attendancerequestcom_a80fed87_fk_attendanc; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancerequestcomment_files
    ADD CONSTRAINT attendance_attendanc_attendancerequestcom_a80fed87_fk_attendanc FOREIGN KEY (attendancerequestcomment_id) REFERENCES public.attendance_attendancerequestcomment(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendancerequestcomment_files attendance_attendanc_attendancerequestfil_f9332418_fk_attendanc; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancerequestcomment_files
    ADD CONSTRAINT attendance_attendanc_attendancerequestfil_f9332418_fk_attendanc FOREIGN KEY (attendancerequestfile_id) REFERENCES public.attendance_attendancerequestfile(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendancevalidationcondition_company_id attendance_attendanc_attendancevalidation_435e89ec_fk_attendanc; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancevalidationcondition_company_id
    ADD CONSTRAINT attendance_attendanc_attendancevalidation_435e89ec_fk_attendanc FOREIGN KEY (attendancevalidationcondition_id) REFERENCES public.attendance_attendancevalidationcondition(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendance attendance_attendanc_batch_attendance_id__3f1b552b_fk_attendanc; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendance
    ADD CONSTRAINT attendance_attendanc_batch_attendance_id__3f1b552b_fk_attendanc FOREIGN KEY (batch_attendance_id_id) REFERENCES public.attendance_batchattendance(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendancevalidationcondition_company_id attendance_attendanc_company_id_15bf7647_fk_base_comp; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancevalidationcondition_company_id
    ADD CONSTRAINT attendance_attendanc_company_id_15bf7647_fk_base_comp FOREIGN KEY (company_id) REFERENCES public.base_company(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendancegeneralsetting attendance_attendanc_company_id_id_49d8b388_fk_base_comp; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancegeneralsetting
    ADD CONSTRAINT attendance_attendanc_company_id_id_49d8b388_fk_base_comp FOREIGN KEY (company_id_id) REFERENCES public.base_company(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendancerequestfile attendance_attendanc_created_by_id_0b196a4d_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancerequestfile
    ADD CONSTRAINT attendance_attendanc_created_by_id_0b196a4d_fk_auth_user FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendancegeneralsetting attendance_attendanc_created_by_id_5d369b31_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancegeneralsetting
    ADD CONSTRAINT attendance_attendanc_created_by_id_5d369b31_fk_auth_user FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendanceovertime attendance_attendanc_created_by_id_8128ac7c_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendanceovertime
    ADD CONSTRAINT attendance_attendanc_created_by_id_8128ac7c_fk_auth_user FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendancevalidationcondition attendance_attendanc_created_by_id_b84b1ab2_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancevalidationcondition
    ADD CONSTRAINT attendance_attendanc_created_by_id_b84b1ab2_fk_auth_user FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendancelatecomeearlyout attendance_attendanc_created_by_id_c07050a1_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancelatecomeearlyout
    ADD CONSTRAINT attendance_attendanc_created_by_id_c07050a1_fk_auth_user FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendanceactivity attendance_attendanc_created_by_id_c64cdac8_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendanceactivity
    ADD CONSTRAINT attendance_attendanc_created_by_id_c64cdac8_fk_auth_user FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendancerequestcomment attendance_attendanc_created_by_id_d47327ee_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancerequestcomment
    ADD CONSTRAINT attendance_attendanc_created_by_id_d47327ee_fk_auth_user FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendancerequestcomment attendance_attendanc_employee_id_id_287f91f6_fk_employee_; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancerequestcomment
    ADD CONSTRAINT attendance_attendanc_employee_id_id_287f91f6_fk_employee_ FOREIGN KEY (employee_id_id) REFERENCES public.employee_employee(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendanceactivity attendance_attendanc_employee_id_id_387d5d6c_fk_employee_; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendanceactivity
    ADD CONSTRAINT attendance_attendanc_employee_id_id_387d5d6c_fk_employee_ FOREIGN KEY (employee_id_id) REFERENCES public.employee_employee(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendancelatecomeearlyout attendance_attendanc_employee_id_id_98d63dab_fk_employee_; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancelatecomeearlyout
    ADD CONSTRAINT attendance_attendanc_employee_id_id_98d63dab_fk_employee_ FOREIGN KEY (employee_id_id) REFERENCES public.employee_employee(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendance attendance_attendanc_employee_id_id_a63854dc_fk_employee_; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendance
    ADD CONSTRAINT attendance_attendanc_employee_id_id_a63854dc_fk_employee_ FOREIGN KEY (employee_id_id) REFERENCES public.employee_employee(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendanceovertime attendance_attendanc_employee_id_id_b7422c25_fk_employee_; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendanceovertime
    ADD CONSTRAINT attendance_attendanc_employee_id_id_b7422c25_fk_employee_ FOREIGN KEY (employee_id_id) REFERENCES public.employee_employee(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendancevalidationcondition attendance_attendanc_modified_by_id_2e4b51ba_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancevalidationcondition
    ADD CONSTRAINT attendance_attendanc_modified_by_id_2e4b51ba_fk_auth_user FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendancegeneralsetting attendance_attendanc_modified_by_id_3b013cdc_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancegeneralsetting
    ADD CONSTRAINT attendance_attendanc_modified_by_id_3b013cdc_fk_auth_user FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendancerequestcomment attendance_attendanc_modified_by_id_574591a7_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancerequestcomment
    ADD CONSTRAINT attendance_attendanc_modified_by_id_574591a7_fk_auth_user FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendanceovertime attendance_attendanc_modified_by_id_7a752250_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendanceovertime
    ADD CONSTRAINT attendance_attendanc_modified_by_id_7a752250_fk_auth_user FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendanceactivity attendance_attendanc_modified_by_id_90e38a42_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendanceactivity
    ADD CONSTRAINT attendance_attendanc_modified_by_id_90e38a42_fk_auth_user FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendancelatecomeearlyout attendance_attendanc_modified_by_id_ca21b8da_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancelatecomeearlyout
    ADD CONSTRAINT attendance_attendanc_modified_by_id_ca21b8da_fk_auth_user FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendancerequestfile attendance_attendanc_modified_by_id_ed5b3154_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancerequestfile
    ADD CONSTRAINT attendance_attendanc_modified_by_id_ed5b3154_fk_auth_user FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendancerequestcomment attendance_attendanc_request_id_id_e906b582_fk_attendanc; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancerequestcomment
    ADD CONSTRAINT attendance_attendanc_request_id_id_e906b582_fk_attendanc FOREIGN KEY (request_id_id) REFERENCES public.attendance_attendance(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendanceactivity attendance_attendanc_shift_day_id_21632240_fk_base_empl; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendanceactivity
    ADD CONSTRAINT attendance_attendanc_shift_day_id_21632240_fk_base_empl FOREIGN KEY (shift_day_id) REFERENCES public.base_employeeshiftday(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendance attendance_attendanc_shift_id_id_6fba51aa_fk_base_empl; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendance
    ADD CONSTRAINT attendance_attendanc_shift_id_id_6fba51aa_fk_base_empl FOREIGN KEY (shift_id_id) REFERENCES public.base_employeeshift(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendance attendance_attendanc_work_type_id_id_f370eeed_fk_base_work; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendance
    ADD CONSTRAINT attendance_attendanc_work_type_id_id_f370eeed_fk_base_work FOREIGN KEY (work_type_id_id) REFERENCES public.base_worktype(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendance attendance_attendance_created_by_id_621a60fa_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendance
    ADD CONSTRAINT attendance_attendance_created_by_id_621a60fa_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_attendance attendance_attendance_modified_by_id_e2e344c7_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendance
    ADD CONSTRAINT attendance_attendance_modified_by_id_e2e344c7_fk_auth_user_id FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_batchattendance attendance_batchatte_created_by_id_3e782e45_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_batchattendance
    ADD CONSTRAINT attendance_batchatte_created_by_id_3e782e45_fk_auth_user FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_batchattendance attendance_batchatte_modified_by_id_b5388e3b_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_batchattendance
    ADD CONSTRAINT attendance_batchatte_modified_by_id_b5388e3b_fk_auth_user FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_gracetime_company_id attendance_gracetime_company_id_942808b8_fk_base_comp; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_gracetime_company_id
    ADD CONSTRAINT attendance_gracetime_company_id_942808b8_fk_base_comp FOREIGN KEY (company_id) REFERENCES public.base_company(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_gracetime attendance_gracetime_created_by_id_2819c6c7_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_gracetime
    ADD CONSTRAINT attendance_gracetime_created_by_id_2819c6c7_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_gracetime_company_id attendance_gracetime_gracetime_id_a47c5ae4_fk_attendanc; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_gracetime_company_id
    ADD CONSTRAINT attendance_gracetime_gracetime_id_a47c5ae4_fk_attendanc FOREIGN KEY (gracetime_id) REFERENCES public.attendance_gracetime(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_gracetime attendance_gracetime_modified_by_id_e0be5422_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_gracetime
    ADD CONSTRAINT attendance_gracetime_modified_by_id_e0be5422_fk_auth_user_id FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_historicalattendance_history_tags attendance_historica_audittag_id_22b5d483_fk_horilla_a; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_historicalattendance_history_tags
    ADD CONSTRAINT attendance_historica_audittag_id_22b5d483_fk_horilla_a FOREIGN KEY (audittag_id) REFERENCES public.horilla_audit_audittag(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_historicalattendance_history_tags attendance_historica_historicalattendance_cd419b72_fk_attendanc; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_historicalattendance_history_tags
    ADD CONSTRAINT attendance_historica_historicalattendance_cd419b72_fk_attendanc FOREIGN KEY (historicalattendance_id) REFERENCES public.attendance_historicalattendance(history_id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_historicalattendance attendance_historica_history_user_id_0cb04709_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_historicalattendance
    ADD CONSTRAINT attendance_historica_history_user_id_0cb04709_fk_auth_user FOREIGN KEY (history_user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_workrecords attendance_workrecor_attendance_id_id_132d38b9_fk_attendanc; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_workrecords
    ADD CONSTRAINT attendance_workrecor_attendance_id_id_132d38b9_fk_attendanc FOREIGN KEY (attendance_id_id) REFERENCES public.attendance_attendance(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_workrecords attendance_workrecor_employee_id_id_a533961f_fk_employee_; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_workrecords
    ADD CONSTRAINT attendance_workrecor_employee_id_id_a533961f_fk_employee_ FOREIGN KEY (employee_id_id) REFERENCES public.employee_employee(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_workrecords attendance_workrecor_leave_request_id_id_1c671bdb_fk_leave_lea; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_workrecords
    ADD CONSTRAINT attendance_workrecor_leave_request_id_id_1c671bdb_fk_leave_lea FOREIGN KEY (leave_request_id_id) REFERENCES public.leave_leaverequest(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: attendance_workrecords attendance_workrecor_shift_id_id_d25e8ebb_fk_base_empl; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_workrecords
    ADD CONSTRAINT attendance_workrecor_shift_id_id_d25e8ebb_fk_base_empl FOREIGN KEY (shift_id_id) REFERENCES public.base_employeeshift(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auditlog_logentry auditlog_logentry_actor_id_959271d2_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.auditlog_logentry
    ADD CONSTRAINT auditlog_logentry_actor_id_959271d2_fk_auth_user_id FOREIGN KEY (actor_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auditlog_logentry auditlog_logentry_content_type_id_75830218_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.auditlog_logentry
    ADD CONSTRAINT auditlog_logentry_content_type_id_75830218_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_group_permissions auth_group_permissio_permission_id_84c5c92e_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissio_permission_id_84c5c92e_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_group_permissions auth_group_permissions_group_id_b120cbf9_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_b120cbf9_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_permission auth_permission_content_type_id_2f476e4b_fk_django_co; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_content_type_id_2f476e4b_fk_django_co FOREIGN KEY (content_type_id) REFERENCES public.django_content_type(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_groups auth_user_groups_group_id_97559544_fk_auth_group_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_group_id_97559544_fk_auth_group_id FOREIGN KEY (group_id) REFERENCES public.auth_group(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_groups auth_user_groups_user_id_6a12ed8b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_user_id_6a12ed8b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_user_permissions auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permi_permission_id_1fbb5f2c_fk_auth_perm FOREIGN KEY (permission_id) REFERENCES public.auth_permission(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_user_id_a95ead1b_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_announcement_attachments base_announcement_at_announcement_id_28c89de7_fk_base_anno; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_attachments
    ADD CONSTRAINT base_announcement_at_announcement_id_28c89de7_fk_base_anno FOREIGN KEY (announcement_id) REFERENCES public.base_announcement(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_announcement_attachments base_announcement_at_attachment_id_d426ada6_fk_base_atta; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_attachments
    ADD CONSTRAINT base_announcement_at_attachment_id_d426ada6_fk_base_atta FOREIGN KEY (attachment_id) REFERENCES public.base_attachment(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_announcement_company_id base_announcement_co_announcement_id_88c3a5db_fk_base_anno; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_company_id
    ADD CONSTRAINT base_announcement_co_announcement_id_88c3a5db_fk_base_anno FOREIGN KEY (announcement_id) REFERENCES public.base_announcement(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_announcement_company_id base_announcement_co_company_id_3159799c_fk_base_comp; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_company_id
    ADD CONSTRAINT base_announcement_co_company_id_3159799c_fk_base_comp FOREIGN KEY (company_id) REFERENCES public.base_company(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_announcement base_announcement_created_by_id_60c3675f_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement
    ADD CONSTRAINT base_announcement_created_by_id_60c3675f_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_announcement_department base_announcement_de_announcement_id_1fc854a1_fk_base_anno; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_department
    ADD CONSTRAINT base_announcement_de_announcement_id_1fc854a1_fk_base_anno FOREIGN KEY (announcement_id) REFERENCES public.base_announcement(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_announcement_department base_announcement_de_department_id_58667008_fk_base_depa; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_department
    ADD CONSTRAINT base_announcement_de_department_id_58667008_fk_base_depa FOREIGN KEY (department_id) REFERENCES public.base_department(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_announcement_employees base_announcement_em_announcement_id_6420dc09_fk_base_anno; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_employees
    ADD CONSTRAINT base_announcement_em_announcement_id_6420dc09_fk_base_anno FOREIGN KEY (announcement_id) REFERENCES public.base_announcement(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_announcement_employees base_announcement_em_employee_id_59b0c73f_fk_employee_; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_employees
    ADD CONSTRAINT base_announcement_em_employee_id_59b0c73f_fk_employee_ FOREIGN KEY (employee_id) REFERENCES public.employee_employee(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_announcement_filtered_employees base_announcement_fi_announcement_id_d818df54_fk_base_anno; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_filtered_employees
    ADD CONSTRAINT base_announcement_fi_announcement_id_d818df54_fk_base_anno FOREIGN KEY (announcement_id) REFERENCES public.base_announcement(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_announcement_filtered_employees base_announcement_fi_employee_id_6b6dcc8c_fk_employee_; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_filtered_employees
    ADD CONSTRAINT base_announcement_fi_employee_id_6b6dcc8c_fk_employee_ FOREIGN KEY (employee_id) REFERENCES public.employee_employee(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_announcement_job_position base_announcement_jo_announcement_id_733faa88_fk_base_anno; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_job_position
    ADD CONSTRAINT base_announcement_jo_announcement_id_733faa88_fk_base_anno FOREIGN KEY (announcement_id) REFERENCES public.base_announcement(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_announcement_job_position base_announcement_jo_jobposition_id_884b606d_fk_base_jobp; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_job_position
    ADD CONSTRAINT base_announcement_jo_jobposition_id_884b606d_fk_base_jobp FOREIGN KEY (jobposition_id) REFERENCES public.base_jobposition(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_announcement base_announcement_modified_by_id_bd30f74b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement
    ADD CONSTRAINT base_announcement_modified_by_id_bd30f74b_fk_auth_user_id FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_announcementcomment base_announcementcom_announcement_id_id_6b41613d_fk_base_anno; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcementcomment
    ADD CONSTRAINT base_announcementcom_announcement_id_id_6b41613d_fk_base_anno FOREIGN KEY (announcement_id_id) REFERENCES public.base_announcement(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_announcementcomment base_announcementcom_employee_id_id_1aba795e_fk_employee_; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcementcomment
    ADD CONSTRAINT base_announcementcom_employee_id_id_1aba795e_fk_employee_ FOREIGN KEY (employee_id_id) REFERENCES public.employee_employee(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_announcementcomment base_announcementcom_modified_by_id_cec87a65_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcementcomment
    ADD CONSTRAINT base_announcementcom_modified_by_id_cec87a65_fk_auth_user FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_announcementcomment base_announcementcomment_created_by_id_4972b6e5_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcementcomment
    ADD CONSTRAINT base_announcementcomment_created_by_id_4972b6e5_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_announcementview base_announcementvie_announcement_id_30dc6c43_fk_base_anno; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcementview
    ADD CONSTRAINT base_announcementvie_announcement_id_30dc6c43_fk_base_anno FOREIGN KEY (announcement_id) REFERENCES public.base_announcement(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_announcementview base_announcementview_user_id_3de12961_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcementview
    ADD CONSTRAINT base_announcementview_user_id_3de12961_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_biometricattendance base_biometricattend_company_id_id_79e0cd9e_fk_base_comp; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_biometricattendance
    ADD CONSTRAINT base_biometricattend_company_id_id_79e0cd9e_fk_base_comp FOREIGN KEY (company_id_id) REFERENCES public.base_company(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_company base_company_created_by_id_0a5eae8c_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_company
    ADD CONSTRAINT base_company_created_by_id_0a5eae8c_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_company base_company_modified_by_id_7f84ef61_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_company
    ADD CONSTRAINT base_company_modified_by_id_7f84ef61_fk_auth_user_id FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_companyleaves base_companyleaves_company_id_id_59a8dee0_fk_base_company_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_companyleaves
    ADD CONSTRAINT base_companyleaves_company_id_id_59a8dee0_fk_base_company_id FOREIGN KEY (company_id_id) REFERENCES public.base_company(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_companyleaves base_companyleaves_created_by_id_c5d3ba1d_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_companyleaves
    ADD CONSTRAINT base_companyleaves_created_by_id_c5d3ba1d_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_companyleaves base_companyleaves_modified_by_id_d98a6c67_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_companyleaves
    ADD CONSTRAINT base_companyleaves_modified_by_id_d98a6c67_fk_auth_user_id FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_dashboardemployeecharts base_dashboardemploy_created_by_id_7a6c88d1_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_dashboardemployeecharts
    ADD CONSTRAINT base_dashboardemploy_created_by_id_7a6c88d1_fk_auth_user FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_dashboardemployeecharts base_dashboardemploy_employee_id_af804f1a_fk_employee_; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_dashboardemployeecharts
    ADD CONSTRAINT base_dashboardemploy_employee_id_af804f1a_fk_employee_ FOREIGN KEY (employee_id) REFERENCES public.employee_employee(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_dashboardemployeecharts base_dashboardemploy_modified_by_id_58988408_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_dashboardemployeecharts
    ADD CONSTRAINT base_dashboardemploy_modified_by_id_58988408_fk_auth_user FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_department_company_id base_department_comp_company_id_3e26ba00_fk_base_comp; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_department_company_id
    ADD CONSTRAINT base_department_comp_company_id_3e26ba00_fk_base_comp FOREIGN KEY (company_id) REFERENCES public.base_company(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_department_company_id base_department_comp_department_id_4aded189_fk_base_depa; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_department_company_id
    ADD CONSTRAINT base_department_comp_department_id_4aded189_fk_base_depa FOREIGN KEY (department_id) REFERENCES public.base_department(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_department base_department_created_by_id_86fcb76a_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_department
    ADD CONSTRAINT base_department_created_by_id_86fcb76a_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_department base_department_modified_by_id_2539afce_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_department
    ADD CONSTRAINT base_department_modified_by_id_2539afce_fk_auth_user_id FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_driverviewed base_driverviewed_user_id_78f9f2a5_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_driverviewed
    ADD CONSTRAINT base_driverviewed_user_id_78f9f2a5_fk_auth_user_id FOREIGN KEY (user_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_dynamicemailconfiguration base_dynamicemailcon_company_id_id_c13c59ca_fk_base_comp; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_dynamicemailconfiguration
    ADD CONSTRAINT base_dynamicemailcon_company_id_id_c13c59ca_fk_base_comp FOREIGN KEY (company_id_id) REFERENCES public.base_company(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_dynamicemailconfiguration base_dynamicemailcon_created_by_id_52e9b73b_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_dynamicemailconfiguration
    ADD CONSTRAINT base_dynamicemailcon_created_by_id_52e9b73b_fk_auth_user FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_dynamicemailconfiguration base_dynamicemailcon_modified_by_id_80c89277_fk_auth_user; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_dynamicemailconfiguration
    ADD CONSTRAINT base_dynamicemailcon_modified_by_id_80c89277_fk_auth_user FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_dynamicpagination base_dynamicpagination_user_id_id_ee3a6b7b_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_dynamicpagination
    ADD CONSTRAINT base_dynamicpagination_user_id_id_ee3a6b7b_fk_auth_user_id FOREIGN KEY (user_id_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_emaillog base_emaillog_company_id_id_ed759e09_fk_base_company_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_emaillog
    ADD CONSTRAINT base_emaillog_company_id_id_ed759e09_fk_base_company_id FOREIGN KEY (company_id_id) REFERENCES public.base_company(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_employeeshift_company_id base_employeeshift_c_company_id_93281d0d_fk_base_comp; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_employeeshift_company_id
    ADD CONSTRAINT base_employeeshift_c_company_id_93281d0d_fk_base_comp FOREIGN KEY (company_id) REFERENCES public.base_company(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_employeeshift_company_id base_employeeshift_c_employeeshift_id_196dad8a_fk_base_empl; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_employeeshift_company_id
    ADD CONSTRAINT base_employeeshift_c_employeeshift_id_196dad8a_fk_base_empl FOREIGN KEY (employeeshift_id) REFERENCES public.base_employeeshift(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_employeeshift base_employeeshift_created_by_id_dbf8a807_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_employeeshift
    ADD CONSTRAINT base_employeeshift_created_by_id_dbf8a807_fk_auth_user_id FOREIGN KEY (created_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_employeeshift base_employeeshift_grace_time_id_id_15569b8e_fk_attendanc; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_employeeshift
    ADD CONSTRAINT base_employeeshift_grace_time_id_id_15569b8e_fk_attendanc FOREIGN KEY (grace_time_id_id) REFERENCES public.attendance_gracetime(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_employeeshift base_employeeshift_modified_by_id_9075134f_fk_auth_user_id; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_employeeshift
    ADD CONSTRAINT base_employeeshift_modified_by_id_9075134f_fk_auth_user_id FOREIGN KEY (modified_by_id) REFERENCES public.auth_user(id) DEFERRABLE INITIALLY DEFERRED;


--
-- Name: base_employeeshiftday_company_id base_employeeshiftda_company_id_2c4eeb07_fk_base_comp; Type: FK CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_employeeshiftday_company_id
    ADD CONSTRAINT base_employeeshiftda_company_id_2c4eeb07_fk_base_comp FOREIGN KEY (company_id) REFERENCES public.base_company(id) DEFERRABLE INITIALLY DEFERRED;


--
