-- Data for Name: recruitment_historicalcandidate_history_tags; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_historicalcandidate_history_tags (id, historicalcandidate_id, audittag_id) FROM stdin;
\.


--
-- Data for Name: recruitment_historicalrejectedcandidate; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_historicalrejectedcandidate (id, created_at, is_active, history_title, history_description, history_highlight, description, history_id, history_date, history_change_reason, history_type, candidate_id_id, created_by_id, history_relation_id, history_user_id, modified_by_id) FROM stdin;
\.


--
-- Data for Name: recruitment_historicalrejectedcandidate_history_tags; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_historicalrejectedcandidate_history_tags (id, historicalrejectedcandidate_id, audittag_id) FROM stdin;
\.


--
-- Data for Name: recruitment_interviewschedule; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_interviewschedule (id, created_at, is_active, interview_date, interview_time, description, completed, candidate_id_id, created_by_id, modified_by_id) FROM stdin;
1	2025-06-22 15:29:26.359+05:30	t	2025-06-24	10:30:00		f	15	1	1
2	2025-07-24 16:19:28.925509+05:30	t	2025-07-24	23:23:00	test	t	18	1	1
3	2025-07-29 16:33:49.018058+05:30	t	2025-07-30	09:45:00	React Developer	t	22	1	1
\.


--
-- Data for Name: recruitment_interviewschedule_employee_id; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_interviewschedule_employee_id (id, interviewschedule_id, employee_id) FROM stdin;
1	1	1
2	2	12
4	3	131
\.


--
-- Data for Name: recruitment_linkedinaccount; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_linkedinaccount (id, created_at, is_active, username, email, api_token, sub_id, company_id_id, created_by_id, modified_by_id) FROM stdin;
\.


--
-- Data for Name: recruitment_questionordering; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_questionordering (id, created_at, is_active, sequence, created_by_id, modified_by_id, question_id_id, recruitment_id_id) FROM stdin;
\.


--
-- Data for Name: recruitment_recruitment; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_recruitment (id, created_at, is_active, title, description, is_event_based, closed, is_published, vacancy, start_date, end_date, linkedin_post_id, publish_in_linkedin, optional_profile_image, optional_resume, company_id_id, created_by_id, job_position_id_id, linkedin_account_id_id, modified_by_id) FROM stdin;
3	2025-06-22 14:33:26.892+05:30	t	Hiring Employees	<p>We are seeking a skilled Django Developer to join our dynamic team. The ideal candidate will have a strong background in web development with a focus on the Django framework. You will be responsible for designing, building, and maintaining high-performance web applications that are scalable and secure.<br></p>	f	t	t	5	2025-06-01	2025-06-30	\N	t	f	f	\N	1	\N	\N	1
2	2025-06-22 14:25:43.899+05:30	t	FutureForce Recruitment	<p>We are looking for a motivated and dynamic <b>Salesman</b> to join our team. The ideal candidate will have a passion for <b>sales, excellent communication skills, and a knack for building relationships with customers</b>. You will play a key role in driving our business growth by meeting sales targets and providing outstanding customer service.<br></p>	f	f	f	10	2025-06-01	2025-06-30	\N	f	f	f	1	1	\N	\N	1
7	2025-07-29 15:17:05.833005+05:30	t	React Developer	<p>Strong knowledge in JavaScript</p><p>Understanding of JS libraries</p><p>React Profecient&nbsp;</p>	f	f	t	10	2025-05-13	2025-08-31	\N	f	f	f	4	1	\N	\N	1
4	2025-07-29 11:54:06.161963+05:30	t	HR	<p>Management</p>	f	t	f	5	2025-07-16	2025-07-29	\N	f	f	t	4	1	\N	\N	1
6	2025-07-29 12:24:39.031451+05:30	t	Business Development Executive	<p>Good Sales skills</p><p>Understanding Peoples need</p>	f	t	f	5	2025-06-01	2025-07-29	\N	f	f	f	4	1	\N	\N	1
5	2025-07-29 12:03:14.020224+05:30	t	IT Project Coordinator	<p>Bachelor's degree in IT, Computer Science, or related field</p><p>Understanding of IT project lifecycle and methodologies (Agile, Waterfall)</p><p>Proficiency in project management tools (Jira, Trello, Asana, MS Project)</p>	f	f	t	6	2025-05-02	2025-09-30	\N	f	f	f	4	1	\N	\N	1
1	2025-06-22 14:18:40.136+05:30	t	Recruitment Drive	<p><b><u><span style="font-size: 18px;">Position: Django Developer &amp; ODOO dev</span></u></b></p><p><b>Job Description:</b></p><p>We are seeking a skilled Django Developers and ODOO developers to join our dynamic team. The ideal candidate will have a strong background in web development with a focus on the Django framework. You will be responsible for designing, building, and maintaining high-performance web applications that are scalable and secure.</p><p><b>Key Responsibilities:</b></p><p>Develop and maintain web applications using Django.</p><p>Write clean, maintainable, and efficient code.</p><p>Design and implement robust APIs.</p><p>Collaborate with front-end developers to integrate user-facing elements.</p><p>Optimize applications for maximum speed and scalability.</p><p>Participate in code reviews to maintain code quality and share knowledge.</p><p>Stay updated with the latest industry trends and technologies.</p><p><b>Requirements:</b></p><p>Proven experience as a Django Developer.</p><p>Proficient in Python and Django framework.</p><p>Familiarity with front-end technologies (JavaScript, HTML5, CSS3).</p><p>Experience with relational databases (PostgreSQL, MySQL).</p><p>Knowledge of version control systems (Git).</p><p>Understanding of RESTful APIs and web services.</p><p>Strong problem-solving skills and attention to detail.</p><p>Excellent communication and teamwork skills.</p><p>BachelorÆs degree in Computer Science, Engineering, or a related field.</p><p><b>Preferred Qualifications:</b></p><p>Experience with cloud platforms (AWS, Azure, GCP).</p><p>Knowledge of containerization and orchestration (Docker, Kubernetes).</p><p>Familiarity with Agile development methodologies.</p>	f	f	f	15	2025-06-01	2025-06-30	\N	f	t	t	1	1	\N	\N	1
\.


--
-- Data for Name: recruitment_recruitment_open_positions; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_recruitment_open_positions (id, recruitment_id, jobposition_id) FROM stdin;
1	1	1
2	1	2
3	2	3
4	3	1
5	3	2
6	3	4
7	4	4
8	5	4
9	6	20
10	7	16
\.


--
-- Data for Name: recruitment_recruitment_recruitment_managers; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_recruitment_recruitment_managers (id, recruitment_id, employee_id) FROM stdin;
1	1	1
2	1	12
3	2	68
4	3	1
5	4	127
6	5	127
7	6	129
8	7	131
\.


--
-- Data for Name: recruitment_recruitment_skills; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_recruitment_skills (id, recruitment_id, skill_id) FROM stdin;
1	4	1
2	5	1
3	6	3
4	7	4
\.


--
-- Data for Name: recruitment_recruitment_survey_templates; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_recruitment_survey_templates (id, recruitment_id, surveytemplate_id) FROM stdin;
\.


--
-- Data for Name: recruitment_recruitmentgeneralsetting; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_recruitmentgeneralsetting (id, created_at, is_active, candidate_self_tracking, show_overall_rating, company_id_id, created_by_id, modified_by_id) FROM stdin;
\.


--
-- Data for Name: recruitment_recruitmentsurvey; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_recruitmentsurvey (id, created_at, is_active, is_mandatory, question, sequence, type, options, created_by_id, modified_by_id) FROM stdin;
1	2025-06-17 14:36:47.055+05:30	t	f	What is Python, and what are its key features?	0	text		1	1
2	2025-06-17 14:37:14.1+05:30	t	f	What is the difference between a list and a tuple?	0	text		1	1
3	2025-06-15 09:38:37.429+05:30	t	t	Have you worked with Odoo's ORM before ?	0	checkbox		1	1
4	2025-06-15 09:39:33.102+05:30	t	t	Which Odoo module have you worked on the most?	0	options	Sales, Inventory, Accounting, Human Resources	1	1
5	2025-06-15 09:40:25.767+05:30	t	t	Which of the following are key features of OdooÆs ORM?	0	multiple	Data modeling, SQL query generation, Form building, Workflow automation	1	1
6	2025-06-15 09:40:47.869+05:30	t	f	Explain how you would customize an Odoo report for a client.	0	text		1	1
7	2025-06-15 09:41:01.784+05:30	t	f	How many years of experience do you have working with Odoo?	0	number		1	1
8	2025-06-15 09:41:20.757+05:30	t	f	Estimate your proficiency with Python in relation to Odoo development (0-100%).	0	percentage		1	1
9	2025-06-15 09:41:41.456+05:30	t	t	Rate your experience in using Odoo Studio on a scale of 1 to 5.	0	rating		1	1
10	2025-06-15 09:43:39.132+05:30	t	t	Have you implemented class-based views (CBVs) in Django?	0	checkbox		1	1
11	2025-06-15 09:44:26.896+05:30	t	t	Which ORM-related tasks have you most frequently used in Django?	0	options	Writing custom queries, Query optimization, Database migrations, Managing relations between models	1	1
12	2025-06-15 09:45:18.85+05:30	t	t	Which of the following are key components of Django's architecture ?	0	options	Views, Models, Controllers, Templates	1	1
13	2025-06-15 09:45:35.442+05:30	t	f	How do you handle user authentication in a Django project?	0	text		1	1
\.


--
-- Data for Name: recruitment_recruitmentsurvey_job_position_ids; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_recruitmentsurvey_job_position_ids (id, recruitmentsurvey_id, jobposition_id) FROM stdin;
\.


--
-- Data for Name: recruitment_recruitmentsurvey_recruitment_ids; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_recruitmentsurvey_recruitment_ids (id, recruitmentsurvey_id, recruitment_id) FROM stdin;
1	1	1
2	2	1
3	3	1
4	4	1
5	5	1
6	6	1
7	7	1
8	8	1
9	9	1
10	10	2
11	11	2
12	12	2
13	13	2
\.


--
-- Data for Name: recruitment_recruitmentsurvey_template_id; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_recruitmentsurvey_template_id (id, recruitmentsurvey_id, surveytemplate_id) FROM stdin;
1	1	1
2	2	1
3	3	2
4	4	2
5	5	2
6	6	2
7	7	2
8	8	2
9	9	2
10	10	3
11	11	3
12	12	3
13	13	3
\.


--
-- Data for Name: recruitment_recruitmentsurveyanswer; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_recruitmentsurveyanswer (id, created_at, is_active, answer_json, attachment, candidate_id_id, created_by_id, job_position_id_id, modified_by_id, recruitment_id_id) FROM stdin;
1	2025-07-24 15:26:55.628885+05:30	t	"{\\"csrfmiddlewaretoken\\": [\\"rdZxMmTZTK27SoC5AjxIbwlD8ea2j3Slz7i1CBR6uqQifWZGrbL3Wv1vlT9kkj7V\\"], \\"What is Python, and what are its key features?\\": [\\"ABCD\\"], \\"What is the difference between a list and a tuple?\\": [\\"345\\"], \\"Have you worked with Odoo's ORM before ?\\": [\\"Yes\\"], \\"Which Odoo module have you worked on the most?\\": [\\"Sales\\"], \\"Which of the following are key features of Odoo\\\\u00c6s ORM?\\": [\\"Data modeling\\"], \\"Explain how you would customize an Odoo report for a client.\\": [\\"ERT\\"], \\"How many years of experience do you have working with Odoo?\\": [\\"\\"], \\"percentage_Estimate your proficiency with Python in relation to Odoo development (0-100%).\\": [\\"0\\"], \\"rating_Rate your experience in using Odoo Studio on a scale of 1 to 5.\\": [\\"5\\"]}"		18	1	\N	1	\N
2	2025-07-29 12:28:19.141363+05:30	t	"{\\"csrfmiddlewaretoken\\": [\\"45a3cAkHgamnEDZnbQRTe2U6OVmlHgfGNj1KdbVBSCJoxCrlwp8n35q3ER9SJHIx\\"], \\"Which ORM-related tasks have you most frequently used in Django?\\": [\\"Writing custom queries\\"], \\"Which of the following are key components of Django's architecture ?\\": [\\"Models\\"], \\"How do you handle user authentication in a Django project?\\": [\\"Strongly\\"]}"		21	\N	\N	\N	\N
\.


--
-- Data for Name: recruitment_rejectedcandidate; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_rejectedcandidate (id, created_at, is_active, description, candidate_id_id, created_by_id, modified_by_id) FROM stdin;
\.


--
-- Data for Name: recruitment_rejectedcandidate_reject_reason_id; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_rejectedcandidate_reject_reason_id (id, rejectedcandidate_id, rejectreason_id) FROM stdin;
\.


--
-- Data for Name: recruitment_rejectreason; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_rejectreason (id, created_at, is_active, title, description, company_id_id, created_by_id, modified_by_id) FROM stdin;
1	2025-06-22 13:57:14.458+05:30	t	Long distance	Employee have to travel long distance	\N	1	1
2	2025-06-22 13:58:07.731+05:30	t	Salary misagreement	Employees not statisfied the salary package	\N	1	1
\.


--
-- Data for Name: recruitment_resume; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_resume (id, file, is_candidate, recruitment_id_id) FROM stdin;
\.


--
-- Data for Name: recruitment_skill; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_skill (id, created_at, is_active, title, created_by_id, modified_by_id) FROM stdin;
1	2025-07-29 11:51:00.380612+05:30	t	Management	1	1
2	2025-07-29 11:51:19.473215+05:30	t	Java developer	1	1
3	2025-07-29 12:24:25.664049+05:30	t	Sales	1	1
4	2025-07-29 15:16:56.988251+05:30	t	React	1	1
\.


--
-- Data for Name: recruitment_skillzone; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_skillzone (id, created_at, is_active, title, description, company_id_id, created_by_id, modified_by_id) FROM stdin;
1	2025-06-22 15:40:06.363+05:30	t	Designer	candidates with promising design skill are added here	\N	1	1
2	2025-06-22 15:41:06.363+05:30	t	Social Media Influencer	candidates with promising design skill are added here	\N	1	1
\.


--
-- Data for Name: recruitment_skillzonecandidate; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_skillzonecandidate (id, created_at, is_active, reason, added_on, candidate_id_id, created_by_id, modified_by_id, skill_zone_id_id) FROM stdin;
1	2025-06-22 15:40:37.109+05:30	t	better design knowledge	2025-06-22	3	1	1	1
\.


--
-- Data for Name: recruitment_stage; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_stage (id, created_at, is_active, stage, stage_type, sequence, created_by_id, modified_by_id, recruitment_id_id) FROM stdin;
1	2025-07-17 11:32:17.550718+05:30	t	Applied	applied	0	\N	\N	1
2	2025-07-17 11:32:17.552726+05:30	t	Initial	initial	1	\N	\N	1
4	2025-06-22 14:45:46.474+05:30	t	Interview	interview	1	1	1	1
5	2025-06-22 14:46:06.315+05:30	t	Hired	hired	2	1	1	1
6	2025-06-22 14:46:23.112+05:30	t	Cancelled	cancelled	3	1	1	1
8	2025-07-29 11:54:06.171877+05:30	t	Applied	applied	0	1	1	4
9	2025-07-29 11:54:06.175823+05:30	t	Initial	initial	1	1	1	4
10	2025-07-29 12:03:14.026214+05:30	t	Applied	applied	0	1	1	5
11	2025-07-29 12:03:14.029209+05:30	t	Initial	initial	1	1	1	5
12	2025-07-29 12:24:39.036921+05:30	t	Applied	applied	0	1	1	6
13	2025-07-29 12:24:39.039878+05:30	t	Initial	initial	1	1	1	6
14	2025-07-29 15:17:05.840232+05:30	t	Applied	applied	0	1	1	7
15	2025-07-29 15:17:05.84429+05:30	t	Initial	initial	1	1	1	7
3	2025-07-17 11:32:17.576445+05:30	t	Applied	applied	1	\N	1	2
7	2025-06-22 15:20:57.811+05:30	t	Hired	hired	2	1	1	2
\.


--
-- Data for Name: recruitment_stage_stage_managers; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_stage_stage_managers (id, stage_id, employee_id) FROM stdin;
1	4	1
2	5	12
3	6	12
4	7	37
\.


--
-- Data for Name: recruitment_stagefiles; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_stagefiles (id, created_at, is_active, files, created_by_id, modified_by_id) FROM stdin;
\.


--
-- Data for Name: recruitment_stagenote; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_stagenote (id, created_at, is_active, description, candidate_can_view, candidate_id_id, created_by_id, modified_by_id, stage_id_id, updated_by_id) FROM stdin;
\.


--
-- Data for Name: recruitment_stagenote_stage_files; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_stagenote_stage_files (id, stagenote_id, stagefiles_id) FROM stdin;
\.


--
-- Data for Name: recruitment_surveytemplate; Type: TABLE DATA; Schema: public; Owner: horilla
--

COPY public.recruitment_surveytemplate (id, created_at, is_active, title, description, is_general_template, company_id_id, created_by_id, modified_by_id) FROM stdin;
1	2025-06-17 14:33:25.711+05:30	t	Python Question Template	Description	f	1	1	1
2	2025-06-15 09:38:07.657+05:30	t	Odoo Developer Template	For an Odoo developer interview exam, here are some types of questions that can be asked using the provided	f	1	1	1
3	2025-06-15 09:43:08.737+05:30	t	Django Developer Template	Here are some types of questions you can ask in a Django developer interview exam.	f	1	1	1
\.


--
-- Name: accessibility_defaultaccessibility_employees_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.accessibility_defaultaccessibility_employees_id_seq', 1, false);


--
-- Name: accessibility_defaultaccessibility_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.accessibility_defaultaccessibility_id_seq', 1, false);


--
-- Name: asset_asset_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.asset_asset_id_seq', 194, true);


--
-- Name: asset_assetassignment_assign_images_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.asset_assetassignment_assign_images_id_seq', 1, false);


--
-- Name: asset_assetassignment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.asset_assetassignment_id_seq', 3, true);


--
-- Name: asset_assetassignment_return_images_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.asset_assetassignment_return_images_id_seq', 1, false);


--
-- Name: asset_assetcategory_company_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.asset_assetcategory_company_id_id_seq', 1, true);


--
-- Name: asset_assetcategory_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.asset_assetcategory_id_seq', 8, true);


--
-- Name: asset_assetdocuments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.asset_assetdocuments_id_seq', 1, false);


--
-- Name: asset_assetlot_company_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.asset_assetlot_company_id_id_seq', 1, false);


--
-- Name: asset_assetlot_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.asset_assetlot_id_seq', 12, true);


--
-- Name: asset_assetreport_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.asset_assetreport_id_seq', 1, false);


--
-- Name: asset_assetrequest_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.asset_assetrequest_id_seq', 7, true);


--
-- Name: asset_returnimages_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.asset_returnimages_id_seq', 1, false);


--
-- Name: attendance_attendance_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.attendance_attendance_id_seq', 314, true);


--
-- Name: attendance_attendanceactivity_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.attendance_attendanceactivity_id_seq', 40, true);


--
-- Name: attendance_attendancegeneralsetting_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.attendance_attendancegeneralsetting_id_seq', 5, true);


--
-- Name: attendance_attendancelatecomeearlyout_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.attendance_attendancelatecomeearlyout_id_seq', 34, true);


--
-- Name: attendance_attendanceovertime_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.attendance_attendanceovertime_id_seq', 109, true);


--
-- Name: attendance_attendancerequestcomment_files_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.attendance_attendancerequestcomment_files_id_seq', 1, false);


--
-- Name: attendance_attendancerequestcomment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.attendance_attendancerequestcomment_id_seq', 1, false);


--
-- Name: attendance_attendancerequestfile_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.attendance_attendancerequestfile_id_seq', 1, false);


--
-- Name: attendance_attendancevalidationcondition_company_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.attendance_attendancevalidationcondition_company_id_id_seq', 1, false);


--
-- Name: attendance_attendancevalidationcondition_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.attendance_attendancevalidationcondition_id_seq', 1, true);


--
-- Name: attendance_batchattendance_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.attendance_batchattendance_id_seq', 1, false);


--
-- Name: attendance_gracetime_company_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.attendance_gracetime_company_id_id_seq', 1, false);


--
-- Name: attendance_gracetime_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.attendance_gracetime_id_seq', 3, true);


--
-- Name: attendance_historicalattendance_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.attendance_historicalattendance_history_id_seq', 72, true);


--
-- Name: attendance_historicalattendance_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.attendance_historicalattendance_history_tags_id_seq', 1, false);


--
-- Name: attendance_workrecords_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.attendance_workrecords_id_seq', 1016, true);


--
-- Name: auditlog_logentry_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.auditlog_logentry_id_seq', 6960, true);


--
-- Name: auth_group_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.auth_group_id_seq', 1, true);


--
-- Name: auth_group_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.auth_group_permissions_id_seq', 8, true);


--
-- Name: auth_permission_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.auth_permission_id_seq', 912, true);


--
-- Name: auth_user_groups_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.auth_user_groups_id_seq', 1, false);


--
-- Name: auth_user_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.auth_user_id_seq', 136, true);


--
-- Name: auth_user_user_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.auth_user_user_permissions_id_seq', 141, true);


--
-- Name: base_announcement_attachments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_announcement_attachments_id_seq', 1, false);


--
-- Name: base_announcement_company_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_announcement_company_id_id_seq', 2, true);


--
-- Name: base_announcement_department_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_announcement_department_id_seq', 2, true);


--
-- Name: base_announcement_employees_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_announcement_employees_id_seq', 8, true);


--
-- Name: base_announcement_filtered_employees_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_announcement_filtered_employees_id_seq', 8, true);


--
-- Name: base_announcement_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_announcement_id_seq', 2, true);


--
-- Name: base_announcement_job_position_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_announcement_job_position_id_seq', 2, true);


--
-- Name: base_announcementcomment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_announcementcomment_id_seq', 1, true);


--
-- Name: base_announcementexpire_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_announcementexpire_id_seq', 1, false);


--
-- Name: base_announcementview_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_announcementview_id_seq', 4, true);


--
-- Name: base_attachment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_attachment_id_seq', 1, false);


--
-- Name: base_attendanceallowedip_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_attendanceallowedip_id_seq', 1, true);


--
-- Name: base_baserequestfile_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_baserequestfile_id_seq', 1, false);


--
-- Name: base_biometricattendance_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_biometricattendance_id_seq', 1, true);


--
-- Name: base_company_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_company_id_seq', 4, true);


--
-- Name: base_companyleaves_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_companyleaves_id_seq', 3, true);


--
-- Name: base_dashboardemployeecharts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_dashboardemployeecharts_id_seq', 6, true);


--
-- Name: base_department_company_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_department_company_id_id_seq', 3, true);


--
-- Name: base_department_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_department_id_seq', 6, true);


--
-- Name: base_driverviewed_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_driverviewed_id_seq', 11, true);


--
-- Name: base_dynamicemailconfiguration_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_dynamicemailconfiguration_id_seq', 1, true);


--
-- Name: base_dynamicpagination_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_dynamicpagination_id_seq', 1, true);


--
-- Name: base_emaillog_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_emaillog_id_seq', 35, true);


--
-- Name: base_employeeshift_company_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_employeeshift_company_id_id_seq', 1, false);


--
-- Name: base_employeeshift_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_employeeshift_id_seq', 3, true);


--
-- Name: base_employeeshiftday_company_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_employeeshiftday_company_id_id_seq', 1, false);


--
-- Name: base_employeeshiftday_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_employeeshiftday_id_seq', 7, true);


--
-- Name: base_employeeshiftschedule_company_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_employeeshiftschedule_company_id_id_seq', 1, false);


--
-- Name: base_employeeshiftschedule_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_employeeshiftschedule_id_seq', 16, true);


--
-- Name: base_employeetype_company_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_employeetype_company_id_id_seq', 1, false);


--
-- Name: base_employeetype_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_employeetype_id_seq', 3, true);


--
-- Name: base_historicalrotatingshiftassign_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_historicalrotatingshiftassign_history_id_seq', 1, false);


--
-- Name: base_historicalrotatingshiftassign_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_historicalrotatingshiftassign_history_tags_id_seq', 1, false);


--
-- Name: base_historicalrotatingworktypeassign_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_historicalrotatingworktypeassign_history_id_seq', 1, false);


--
-- Name: base_historicalrotatingworktypeassign_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_historicalrotatingworktypeassign_history_tags_id_seq', 1, false);


--
-- Name: base_historicalshiftrequest_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_historicalshiftrequest_history_id_seq', 5, true);


--
-- Name: base_historicalshiftrequest_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_historicalshiftrequest_history_tags_id_seq', 1, false);


--
-- Name: base_historicalworktyperequest_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_historicalworktyperequest_history_id_seq', 2, true);


--
-- Name: base_historicalworktyperequest_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_historicalworktyperequest_history_tags_id_seq', 1, false);


--
-- Name: base_holidays_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_holidays_id_seq', 11, true);


--
-- Name: base_horillamailtemplate_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_horillamailtemplate_id_seq', 3, true);


--
-- Name: base_jobposition_company_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_jobposition_company_id_id_seq', 1, false);


--
-- Name: base_jobposition_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_jobposition_id_seq', 24, true);


--
-- Name: base_jobrole_company_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_jobrole_company_id_id_seq', 1, false);


--
-- Name: base_jobrole_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_jobrole_id_seq', 46, true);


--
-- Name: base_multipleapprovalcondition_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_multipleapprovalcondition_id_seq', 1, true);


--
-- Name: base_multipleapprovalmanagers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_multipleapprovalmanagers_id_seq', 1, false);


--
-- Name: base_notificationsound_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_notificationsound_id_seq', 1, true);


--
-- Name: base_penaltyaccounts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_penaltyaccounts_id_seq', 3, true);


--
-- Name: base_rotatingshift_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_rotatingshift_id_seq', 2, true);


--
-- Name: base_rotatingshiftassign_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_rotatingshiftassign_id_seq', 10, true);


--
-- Name: base_rotatingworktype_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_rotatingworktype_id_seq', 2, true);


--
-- Name: base_rotatingworktypeassign_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_rotatingworktypeassign_id_seq', 19, true);


--
-- Name: base_shiftrequest_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_shiftrequest_id_seq', 11, true);


--
-- Name: base_shiftrequestcomment_files_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_shiftrequestcomment_files_id_seq', 1, false);


--
-- Name: base_shiftrequestcomment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_shiftrequestcomment_id_seq', 1, false);


--
-- Name: base_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_tags_id_seq', 29, true);


--
-- Name: base_tracklatecomeearlyout_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_tracklatecomeearlyout_id_seq', 1, true);


--
-- Name: base_worktype_company_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_worktype_company_id_id_seq', 1, false);


--
-- Name: base_worktype_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_worktype_id_seq', 4, true);


--
-- Name: base_worktyperequest_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_worktyperequest_id_seq', 6, true);


--
-- Name: base_worktyperequestcomment_files_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_worktyperequestcomment_files_id_seq', 1, false);


--
-- Name: base_worktyperequestcomment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.base_worktyperequestcomment_id_seq', 1, false);


--
-- Name: django_admin_log_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.django_admin_log_id_seq', 1, true);


--
-- Name: django_apscheduler_djangojobexecution_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.django_apscheduler_djangojobexecution_id_seq', 1, false);


--
-- Name: django_content_type_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.django_content_type_id_seq', 225, true);


--
-- Name: django_migrations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.django_migrations_id_seq', 79, true);


--
-- Name: employee_actiontype_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_actiontype_id_seq', 4, true);


--
-- Name: employee_bonuspoint_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_bonuspoint_id_seq', 134, true);


--
-- Name: employee_disciplinaryaction_employee_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_disciplinaryaction_employee_id_id_seq', 4, true);


--
-- Name: employee_disciplinaryaction_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_disciplinaryaction_id_seq', 2, true);


--
-- Name: employee_employee_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_employee_id_seq', 134, true);


--
-- Name: employee_employeebankdetails_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_employeebankdetails_id_seq', 5, true);


--
-- Name: employee_employeegeneralsetting_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_employeegeneralsetting_id_seq', 1, false);


--
-- Name: employee_employeenote_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_employeenote_id_seq', 1, false);


--
-- Name: employee_employeenote_note_files_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_employeenote_note_files_id_seq', 1, false);


--
-- Name: employee_employeetag_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_employeetag_id_seq', 2, true);


--
-- Name: employee_employeeworkinformation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_employeeworkinformation_id_seq', 134, true);


--
-- Name: employee_employeeworkinformation_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_employeeworkinformation_tags_id_seq', 1, true);


--
-- Name: employee_historicalbonuspoint_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_historicalbonuspoint_history_id_seq', 135, true);


--
-- Name: employee_historicalbonuspoint_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_historicalbonuspoint_history_tags_id_seq', 1, false);


--
-- Name: employee_historicalemployeeworkinformation_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_historicalemployeeworkinformation_history_id_seq', 494, true);


--
-- Name: employee_historicalemployeeworkinformation_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_historicalemployeeworkinformation_history_tags_id_seq', 1, false);


--
-- Name: employee_notefiles_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_notefiles_id_seq', 1, false);


--
-- Name: employee_policy_attachments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_policy_attachments_id_seq', 1, false);


--
-- Name: employee_policy_company_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_policy_company_id_id_seq', 27, true);


--
-- Name: employee_policy_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_policy_id_seq', 9, true);


--
-- Name: employee_policy_specific_employees_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_policy_specific_employees_id_seq', 1, false);


--
-- Name: employee_policymultiplefile_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_policymultiplefile_id_seq', 1, false);


--
-- Name: employee_profileeditfeature_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.employee_profileeditfeature_id_seq', 1, false);


--
-- Name: facedetection_employeefacedetection_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.facedetection_employeefacedetection_id_seq', 1, false);


--
-- Name: facedetection_facedetection_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.facedetection_facedetection_id_seq', 1, true);


--
-- Name: geofencing_geofencing_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.geofencing_geofencing_id_seq', 1, true);


--
-- Name: helpdesk_attachment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.helpdesk_attachment_id_seq', 1, false);


--
-- Name: helpdesk_claimrequest_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.helpdesk_claimrequest_id_seq', 1, false);


--
-- Name: helpdesk_comment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.helpdesk_comment_id_seq', 1, false);


--
-- Name: helpdesk_departmentmanager_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.helpdesk_departmentmanager_id_seq', 1, false);


--
-- Name: helpdesk_faq_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.helpdesk_faq_id_seq', 56, true);


--
-- Name: helpdesk_faq_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.helpdesk_faq_tags_id_seq', 76, true);


--
-- Name: helpdesk_faqcategory_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.helpdesk_faqcategory_id_seq', 7, true);


--
-- Name: helpdesk_historicalticket_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.helpdesk_historicalticket_history_id_seq', 9, true);


--
-- Name: helpdesk_historicalticket_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.helpdesk_historicalticket_history_tags_id_seq', 1, false);


--
-- Name: helpdesk_ticket_assigned_to_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.helpdesk_ticket_assigned_to_id_seq', 1, false);


--
-- Name: helpdesk_ticket_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.helpdesk_ticket_id_seq', 3, true);


--
-- Name: helpdesk_ticket_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.helpdesk_ticket_tags_id_seq', 1, false);


--
-- Name: helpdesk_tickettype_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.helpdesk_tickettype_id_seq', 1, true);


--
-- Name: horilla_audit_accountblockunblock_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.horilla_audit_accountblockunblock_id_seq', 1, false);


--
-- Name: horilla_audit_audittag_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.horilla_audit_audittag_id_seq', 1, false);


--
-- Name: horilla_audit_historytrackingfields_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.horilla_audit_historytrackingfields_id_seq', 1, false);


--
-- Name: horilla_automations_mailautomation_also_sent_to_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.horilla_automations_mailautomation_also_sent_to_id_seq', 1, true);


--
-- Name: horilla_automations_mailautomation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.horilla_automations_mailautomation_id_seq', 1, true);


--
-- Name: horilla_automations_mailautomation_template_attachments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.horilla_automations_mailautomation_template_attachments_id_seq', 1, false);


--
-- Name: horilla_backup_googledrivebackup_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.horilla_backup_googledrivebackup_id_seq', 1, false);


--
-- Name: horilla_backup_localbackup_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.horilla_backup_localbackup_id_seq', 1, false);


--
-- Name: horilla_documents_document_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.horilla_documents_document_id_seq', 22, true);


--
-- Name: horilla_documents_documentrequest_employee_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.horilla_documents_documentrequest_employee_id_id_seq', 22, true);


--
-- Name: horilla_documents_documentrequest_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.horilla_documents_documentrequest_id_seq', 2, true);


--
-- Name: horilla_views_activegroup_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.horilla_views_activegroup_id_seq', 2, true);


--
-- Name: horilla_views_activetab_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.horilla_views_activetab_id_seq', 1, false);


--
-- Name: horilla_views_activeview_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.horilla_views_activeview_id_seq', 1, false);


--
-- Name: horilla_views_savedfilter_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.horilla_views_savedfilter_id_seq', 1, false);


--
-- Name: horilla_views_togglecolumn_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.horilla_views_togglecolumn_id_seq', 1, false);


--
-- Name: leave_availableleave_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_availableleave_id_seq', 155, true);


--
-- Name: leave_companyleave_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_companyleave_id_seq', 1, false);


--
-- Name: leave_compensatoryleaverequest_attendance_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_compensatoryleaverequest_attendance_id_id_seq', 1, false);


--
-- Name: leave_compensatoryleaverequest_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_compensatoryleaverequest_id_seq', 1, false);


--
-- Name: leave_compensatoryleaverequestcomment_files_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_compensatoryleaverequestcomment_files_id_seq', 1, false);


--
-- Name: leave_compensatoryleaverequestcomment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_compensatoryleaverequestcomment_id_seq', 1, false);


--
-- Name: leave_employeepastleaverestrict_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_employeepastleaverestrict_id_seq', 1, true);


--
-- Name: leave_historicalavailableleave_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_historicalavailableleave_history_id_seq', 16, true);


--
-- Name: leave_historicalavailableleave_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_historicalavailableleave_history_tags_id_seq', 1, false);


--
-- Name: leave_historicalcompensatoryleaverequest_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_historicalcompensatoryleaverequest_history_id_seq', 1, false);


--
-- Name: leave_historicalcompensatoryleaverequest_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_historicalcompensatoryleaverequest_history_tags_id_seq', 1, false);


--
-- Name: leave_historicalleaveallocationrequest_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_historicalleaveallocationrequest_history_id_seq', 3, true);


--
-- Name: leave_historicalleaveallocationrequest_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_historicalleaveallocationrequest_history_tags_id_seq', 1, false);


--
-- Name: leave_historicalleaverequest_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_historicalleaverequest_history_id_seq', 21, true);


--
-- Name: leave_historicalleaverequest_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_historicalleaverequest_history_tags_id_seq', 1, false);


--
-- Name: leave_holiday_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_holiday_id_seq', 1, false);


--
-- Name: leave_leaveallocationrequest_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_leaveallocationrequest_id_seq', 6, true);


--
-- Name: leave_leaveallocationrequestcomment_files_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_leaveallocationrequestcomment_files_id_seq', 1, false);


--
-- Name: leave_leaveallocationrequestcomment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_leaveallocationrequestcomment_id_seq', 1, false);


--
-- Name: leave_leavegeneralsetting_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_leavegeneralsetting_id_seq', 1, false);


--
-- Name: leave_leaverequest_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_leaverequest_id_seq', 26, true);


--
-- Name: leave_leaverequestcomment_files_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_leaverequestcomment_files_id_seq', 1, false);


--
-- Name: leave_leaverequestcomment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_leaverequestcomment_id_seq', 1, false);


--
-- Name: leave_leaverequestconditionapproval_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_leaverequestconditionapproval_id_seq', 1, false);


--
-- Name: leave_leaverequestfile_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_leaverequestfile_id_seq', 1, false);


--
-- Name: leave_leavetype_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_leavetype_id_seq', 7, true);


--
-- Name: leave_restrictleave_exclued_leave_types_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_restrictleave_exclued_leave_types_id_seq', 2, true);


--
-- Name: leave_restrictleave_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_restrictleave_id_seq', 5, true);


--
-- Name: leave_restrictleave_job_position_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_restrictleave_job_position_id_seq', 1, false);


--
-- Name: leave_restrictleave_spesific_leave_types_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.leave_restrictleave_spesific_leave_types_id_seq', 1, false);


--
-- Name: notifications_notification_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.notifications_notification_id_seq', 214, true);


--
-- Name: offboarding_employeetask_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.offboarding_employeetask_id_seq', 1, false);


--
-- Name: offboarding_exitreason_attachments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.offboarding_exitreason_attachments_id_seq', 1, false);


--
-- Name: offboarding_exitreason_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.offboarding_exitreason_id_seq', 1, false);


--
-- Name: offboarding_historicalemployeetask_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.offboarding_historicalemployeetask_history_id_seq', 1, false);


--
-- Name: offboarding_historicalemployeetask_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.offboarding_historicalemployeetask_history_tags_id_seq', 1, false);


--
-- Name: offboarding_offboarding_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.offboarding_offboarding_id_seq', 1, true);


--
-- Name: offboarding_offboarding_managers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.offboarding_offboarding_managers_id_seq', 1, true);


--
-- Name: offboarding_offboardingemployee_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.offboarding_offboardingemployee_id_seq', 1, false);


--
-- Name: offboarding_offboardinggeneralsetting_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.offboarding_offboardinggeneralsetting_id_seq', 1, true);


--
-- Name: offboarding_offboardingnote_attachments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.offboarding_offboardingnote_attachments_id_seq', 1, false);


--
-- Name: offboarding_offboardingnote_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.offboarding_offboardingnote_id_seq', 1, false);


--
-- Name: offboarding_offboardingstage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.offboarding_offboardingstage_id_seq', 18, true);


--
-- Name: offboarding_offboardingstage_managers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.offboarding_offboardingstage_managers_id_seq', 1, false);


--
-- Name: offboarding_offboardingstagemultiplefile_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.offboarding_offboardingstagemultiplefile_id_seq', 1, false);


--
-- Name: offboarding_offboardingtask_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.offboarding_offboardingtask_id_seq', 1, false);


--
-- Name: offboarding_offboardingtask_managers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.offboarding_offboardingtask_managers_id_seq', 1, false);


--
-- Name: offboarding_resignationletter_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.offboarding_resignationletter_id_seq', 2, true);


--
-- Name: onboarding_candidatestage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.onboarding_candidatestage_id_seq', 1, true);


--
-- Name: onboarding_candidatetask_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.onboarding_candidatetask_id_seq', 1, false);


--
-- Name: onboarding_historicalcandidatetask_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.onboarding_historicalcandidatetask_history_id_seq', 1, false);


--
-- Name: onboarding_historicalcandidatetask_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.onboarding_historicalcandidatetask_history_tags_id_seq', 1, false);


--
-- Name: onboarding_onboardingportal_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.onboarding_onboardingportal_id_seq', 1, true);


--
-- Name: onboarding_onboardingstage_employee_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.onboarding_onboardingstage_employee_id_id_seq', 7, true);


--
-- Name: onboarding_onboardingstage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.onboarding_onboardingstage_id_seq', 14, true);


--
-- Name: onboarding_onboardingtask_candidates_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.onboarding_onboardingtask_candidates_id_seq', 1, false);


--
-- Name: onboarding_onboardingtask_employee_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.onboarding_onboardingtask_employee_id_id_seq', 2, true);


--
-- Name: onboarding_onboardingtask_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.onboarding_onboardingtask_id_seq', 1, true);


--
-- Name: payroll_allowance_exclude_employees_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_allowance_exclude_employees_id_seq', 1, false);


--
-- Name: payroll_allowance_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_allowance_id_seq', 5, true);


--
-- Name: payroll_allowance_other_conditions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_allowance_other_conditions_id_seq', 1, false);


--
-- Name: payroll_allowance_specific_employees_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_allowance_specific_employees_id_seq', 14, true);


--
-- Name: payroll_contract_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_contract_id_seq', 133, true);


--
-- Name: payroll_deduction_exclude_employees_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_deduction_exclude_employees_id_seq', 1, false);


--
-- Name: payroll_deduction_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_deduction_id_seq', 36, true);


--
-- Name: payroll_deduction_other_conditions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_deduction_other_conditions_id_seq', 1, false);


--
-- Name: payroll_deduction_specific_employees_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_deduction_specific_employees_id_seq', 33, true);


--
-- Name: payroll_encashmentgeneralsettings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_encashmentgeneralsettings_id_seq', 1, false);


--
-- Name: payroll_filingstatus_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_filingstatus_id_seq', 4, true);


--
-- Name: payroll_historicalcontract_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_historicalcontract_history_id_seq', 137, true);


--
-- Name: payroll_historicalcontract_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_historicalcontract_history_tags_id_seq', 1, false);


--
-- Name: payroll_historicalpayslip_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_historicalpayslip_history_id_seq', 6, true);


--
-- Name: payroll_historicalpayslip_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_historicalpayslip_history_tags_id_seq', 1, false);


--
-- Name: payroll_loanaccount_deduction_ids_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_loanaccount_deduction_ids_id_seq', 15, true);


--
-- Name: payroll_loanaccount_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_loanaccount_id_seq', 1, true);


--
-- Name: payroll_multiplecondition_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_multiplecondition_id_seq', 1, false);


--
-- Name: payroll_payrollgeneralsetting_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_payrollgeneralsetting_id_seq', 1, false);


--
-- Name: payroll_payrollsettings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_payrollsettings_id_seq', 1, true);


--
-- Name: payroll_payslip_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_payslip_id_seq', 2, true);


--
-- Name: payroll_payslip_installment_ids_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_payslip_installment_ids_id_seq', 1, false);


--
-- Name: payroll_payslipautogenerate_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_payslipautogenerate_id_seq', 1, false);


--
-- Name: payroll_reimbursement_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_reimbursement_id_seq', 30, true);


--
-- Name: payroll_reimbursement_other_attachments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_reimbursement_other_attachments_id_seq', 13, true);


--
-- Name: payroll_reimbursementfile_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_reimbursementfile_id_seq', 1, false);


--
-- Name: payroll_reimbursementmultipleattachment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_reimbursementmultipleattachment_id_seq', 13, true);


--
-- Name: payroll_reimbursementrequestcomment_files_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_reimbursementrequestcomment_files_id_seq', 1, false);


--
-- Name: payroll_reimbursementrequestcomment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_reimbursementrequestcomment_id_seq', 1, false);


--
-- Name: payroll_taxbracket_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_taxbracket_id_seq', 28, true);


--
-- Name: payroll_workrecord_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.payroll_workrecord_id_seq', 1, false);


--
-- Name: pms_anonymousfeedback_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_anonymousfeedback_id_seq', 1, false);


--
-- Name: pms_answer_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_answer_id_seq', 1, false);


--
-- Name: pms_bonuspointsetting_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_bonuspointsetting_id_seq', 1, true);


--
-- Name: pms_comment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_comment_id_seq', 1, false);


--
-- Name: pms_employeebonuspoint_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_employeebonuspoint_id_seq', 1, true);


--
-- Name: pms_employeekeyresult_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_employeekeyresult_id_seq', 9, true);


--
-- Name: pms_employeeobjective_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_employeeobjective_id_seq', 3, true);


--
-- Name: pms_employeeobjective_key_result_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_employeeobjective_key_result_id_id_seq', 1, false);


--
-- Name: pms_feedback_colleague_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_feedback_colleague_id_id_seq', 2, true);


--
-- Name: pms_feedback_employee_key_results_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_feedback_employee_key_results_id_id_seq', 1, false);


--
-- Name: pms_feedback_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_feedback_id_seq', 1, true);


--
-- Name: pms_feedback_others_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_feedback_others_id_id_seq', 1, false);


--
-- Name: pms_feedback_subordinate_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_feedback_subordinate_id_id_seq', 1, false);


--
-- Name: pms_historicalcomment_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_historicalcomment_history_id_seq', 1, false);


--
-- Name: pms_historicalcomment_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_historicalcomment_history_tags_id_seq', 1, false);


--
-- Name: pms_historicalemployeekeyresult_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_historicalemployeekeyresult_history_id_seq', 1, false);


--
-- Name: pms_historicalemployeekeyresult_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_historicalemployeekeyresult_history_tags_id_seq', 1, false);


--
-- Name: pms_historicalemployeeobjective_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_historicalemployeeobjective_history_id_seq', 1, false);


--
-- Name: pms_historicalemployeeobjective_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_historicalemployeeobjective_history_tags_id_seq', 1, false);


--
-- Name: pms_historicalkeyresult_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_historicalkeyresult_history_id_seq', 218, true);


--
-- Name: pms_historicalkeyresult_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_historicalkeyresult_history_tags_id_seq', 1, false);


--
-- Name: pms_historicalobjective_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_historicalobjective_history_id_seq', 2, true);


--
-- Name: pms_historicalobjective_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_historicalobjective_history_tags_id_seq', 1, false);


--
-- Name: pms_keyresult_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_keyresult_id_seq', 4, true);


--
-- Name: pms_keyresultfeedback_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_keyresultfeedback_id_seq', 1, false);


--
-- Name: pms_meetings_answer_employees_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_meetings_answer_employees_id_seq', 3, true);


--
-- Name: pms_meetings_employee_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_meetings_employee_id_id_seq', 4, true);


--
-- Name: pms_meetings_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_meetings_id_seq', 1, true);


--
-- Name: pms_meetings_manager_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_meetings_manager_id_seq', 1, true);


--
-- Name: pms_meetingsanswer_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_meetingsanswer_id_seq', 1, false);


--
-- Name: pms_objective_assignees_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_objective_assignees_id_seq', 12, true);


--
-- Name: pms_objective_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_objective_id_seq', 5, true);


--
-- Name: pms_objective_key_result_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_objective_key_result_id_id_seq', 13, true);


--
-- Name: pms_objective_managers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_objective_managers_id_seq', 5, true);


--
-- Name: pms_period_company_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_period_company_id_id_seq', 6, true);


--
-- Name: pms_period_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_period_id_seq', 2, true);


--
-- Name: pms_question_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_question_id_seq', 5, true);


--
-- Name: pms_questionoptions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_questionoptions_id_seq', 2, true);


--
-- Name: pms_questiontemplate_company_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_questiontemplate_company_id_id_seq', 4, true);


--
-- Name: pms_questiontemplate_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.pms_questiontemplate_id_seq', 2, true);


--
-- Name: project_project_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.project_project_id_seq', 2, true);


--
-- Name: project_project_managers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.project_project_managers_id_seq', 2, true);


--
-- Name: project_project_members_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.project_project_members_id_seq', 9, true);


--
-- Name: project_projectstage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.project_projectstage_id_seq', 6, true);


--
-- Name: project_task_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.project_task_id_seq', 13, true);


--
-- Name: project_task_task_managers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.project_task_task_managers_id_seq', 14, true);


--
-- Name: project_task_task_members_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.project_task_task_members_id_seq', 11, true);


--
-- Name: project_timesheet_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.project_timesheet_id_seq', 4, true);


--
-- Name: recruitment_candidate_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_candidate_id_seq', 23, true);


--
-- Name: recruitment_candidatedocument_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_candidatedocument_id_seq', 1, false);


--
-- Name: recruitment_candidatedocumentrequest_candidate_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_candidatedocumentrequest_candidate_id_id_seq', 1, false);


--
-- Name: recruitment_candidatedocumentrequest_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_candidatedocumentrequest_id_seq', 1, false);


--
-- Name: recruitment_candidaterating_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_candidaterating_id_seq', 4, true);


--
-- Name: recruitment_historicalcandidate_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_historicalcandidate_history_id_seq', 1265, true);


--
-- Name: recruitment_historicalcandidate_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_historicalcandidate_history_tags_id_seq', 1, false);


--
-- Name: recruitment_historicalrejectedcandidate_history_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_historicalrejectedcandidate_history_id_seq', 1, false);


--
-- Name: recruitment_historicalrejectedcandidate_history_tags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_historicalrejectedcandidate_history_tags_id_seq', 1, false);


--
-- Name: recruitment_interviewschedule_employee_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_interviewschedule_employee_id_id_seq', 4, true);


--
-- Name: recruitment_interviewschedule_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_interviewschedule_id_seq', 3, true);


--
-- Name: recruitment_linkedinaccount_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_linkedinaccount_id_seq', 1, false);


--
-- Name: recruitment_questionordering_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_questionordering_id_seq', 1, false);


--
-- Name: recruitment_recruitment_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_recruitment_id_seq', 7, true);


--
-- Name: recruitment_recruitment_open_positions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_recruitment_open_positions_id_seq', 10, true);


--
-- Name: recruitment_recruitment_recruitment_managers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_recruitment_recruitment_managers_id_seq', 8, true);


--
-- Name: recruitment_recruitment_skills_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_recruitment_skills_id_seq', 4, true);


--
-- Name: recruitment_recruitment_survey_templates_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_recruitment_survey_templates_id_seq', 1, false);


--
-- Name: recruitment_recruitmentgeneralsetting_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_recruitmentgeneralsetting_id_seq', 1, false);


--
-- Name: recruitment_recruitmentsurvey_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_recruitmentsurvey_id_seq', 13, true);


--
-- Name: recruitment_recruitmentsurvey_job_position_ids_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_recruitmentsurvey_job_position_ids_id_seq', 1, false);


--
-- Name: recruitment_recruitmentsurvey_recruitment_ids_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_recruitmentsurvey_recruitment_ids_id_seq', 13, true);


--
-- Name: recruitment_recruitmentsurvey_template_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_recruitmentsurvey_template_id_id_seq', 13, true);


--
-- Name: recruitment_recruitmentsurveyanswer_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_recruitmentsurveyanswer_id_seq', 2, true);


--
-- Name: recruitment_rejectedcandidate_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_rejectedcandidate_id_seq', 1, false);


--
-- Name: recruitment_rejectedcandidate_reject_reason_id_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_rejectedcandidate_reject_reason_id_id_seq', 1, false);


--
-- Name: recruitment_rejectreason_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_rejectreason_id_seq', 2, true);


--
-- Name: recruitment_resume_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_resume_id_seq', 1, false);


--
-- Name: recruitment_skill_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_skill_id_seq', 4, true);


--
-- Name: recruitment_skillzone_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_skillzone_id_seq', 2, true);


--
-- Name: recruitment_skillzonecandidate_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_skillzonecandidate_id_seq', 1, true);


--
-- Name: recruitment_stage_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_stage_id_seq', 15, true);


--
-- Name: recruitment_stage_stage_managers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_stage_stage_managers_id_seq', 4, true);


--
-- Name: recruitment_stagefiles_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_stagefiles_id_seq', 1, false);


--
-- Name: recruitment_stagenote_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_stagenote_id_seq', 1, false);


--
-- Name: recruitment_stagenote_stage_files_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_stagenote_stage_files_id_seq', 1, false);


--
-- Name: recruitment_surveytemplate_id_seq; Type: SEQUENCE SET; Schema: public; Owner: horilla
--

SELECT pg_catalog.setval('public.recruitment_surveytemplate_id_seq', 3, true);


--
-- Name: accessibility_defaultaccessibility_employees accessibility_defaultacc_defaultaccessibility_id__ce4c5db1_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.accessibility_defaultaccessibility_employees
    ADD CONSTRAINT accessibility_defaultacc_defaultaccessibility_id__ce4c5db1_uniq UNIQUE (defaultaccessibility_id, employee_id);


--
-- Name: accessibility_defaultaccessibility_employees accessibility_defaultaccessibility_employees_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.accessibility_defaultaccessibility_employees
    ADD CONSTRAINT accessibility_defaultaccessibility_employees_pkey PRIMARY KEY (id);


--
-- Name: accessibility_defaultaccessibility accessibility_defaultaccessibility_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.accessibility_defaultaccessibility
    ADD CONSTRAINT accessibility_defaultaccessibility_pkey PRIMARY KEY (id);


--
-- Name: asset_asset asset_asset_asset_tracking_id_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_asset
    ADD CONSTRAINT asset_asset_asset_tracking_id_key UNIQUE (asset_tracking_id);


--
-- Name: asset_asset asset_asset_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_asset
    ADD CONSTRAINT asset_asset_pkey PRIMARY KEY (id);


--
-- Name: asset_assetassignment_assign_images asset_assetassignment_as_assetassignment_id_retur_fce3fbc4_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetassignment_assign_images
    ADD CONSTRAINT asset_assetassignment_as_assetassignment_id_retur_fce3fbc4_uniq UNIQUE (assetassignment_id, returnimages_id);


--
-- Name: asset_assetassignment_assign_images asset_assetassignment_assign_images_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetassignment_assign_images
    ADD CONSTRAINT asset_assetassignment_assign_images_pkey PRIMARY KEY (id);


--
-- Name: asset_assetassignment asset_assetassignment_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetassignment
    ADD CONSTRAINT asset_assetassignment_pkey PRIMARY KEY (id);


--
-- Name: asset_assetassignment_return_images asset_assetassignment_re_assetassignment_id_retur_d09031a0_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetassignment_return_images
    ADD CONSTRAINT asset_assetassignment_re_assetassignment_id_retur_d09031a0_uniq UNIQUE (assetassignment_id, returnimages_id);


--
-- Name: asset_assetassignment_return_images asset_assetassignment_return_images_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetassignment_return_images
    ADD CONSTRAINT asset_assetassignment_return_images_pkey PRIMARY KEY (id);


--
-- Name: asset_assetcategory asset_assetcategory_asset_category_name_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetcategory
    ADD CONSTRAINT asset_assetcategory_asset_category_name_key UNIQUE (asset_category_name);


--
-- Name: asset_assetcategory_company_id asset_assetcategory_comp_assetcategory_id_company_cd9193ab_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetcategory_company_id
    ADD CONSTRAINT asset_assetcategory_comp_assetcategory_id_company_cd9193ab_uniq UNIQUE (assetcategory_id, company_id);


--
-- Name: asset_assetcategory_company_id asset_assetcategory_company_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetcategory_company_id
    ADD CONSTRAINT asset_assetcategory_company_id_pkey PRIMARY KEY (id);


--
-- Name: asset_assetcategory asset_assetcategory_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetcategory
    ADD CONSTRAINT asset_assetcategory_pkey PRIMARY KEY (id);


--
-- Name: asset_assetdocuments asset_assetdocuments_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetdocuments
    ADD CONSTRAINT asset_assetdocuments_pkey PRIMARY KEY (id);


--
-- Name: asset_assetlot_company_id asset_assetlot_company_id_assetlot_id_company_id_f1b8a3fe_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetlot_company_id
    ADD CONSTRAINT asset_assetlot_company_id_assetlot_id_company_id_f1b8a3fe_uniq UNIQUE (assetlot_id, company_id);


--
-- Name: asset_assetlot_company_id asset_assetlot_company_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetlot_company_id
    ADD CONSTRAINT asset_assetlot_company_id_pkey PRIMARY KEY (id);


--
-- Name: asset_assetlot asset_assetlot_lot_number_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetlot
    ADD CONSTRAINT asset_assetlot_lot_number_key UNIQUE (lot_number);


--
-- Name: asset_assetlot asset_assetlot_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetlot
    ADD CONSTRAINT asset_assetlot_pkey PRIMARY KEY (id);


--
-- Name: asset_assetreport asset_assetreport_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetreport
    ADD CONSTRAINT asset_assetreport_pkey PRIMARY KEY (id);


--
-- Name: asset_assetrequest asset_assetrequest_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_assetrequest
    ADD CONSTRAINT asset_assetrequest_pkey PRIMARY KEY (id);


--
-- Name: asset_returnimages asset_returnimages_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.asset_returnimages
    ADD CONSTRAINT asset_returnimages_pkey PRIMARY KEY (id);


--
-- Name: attendance_attendance attendance_attendance_employee_id_id_attendanc_a9a57f3e_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendance
    ADD CONSTRAINT attendance_attendance_employee_id_id_attendanc_a9a57f3e_uniq UNIQUE (employee_id_id, attendance_date);


--
-- Name: attendance_attendance attendance_attendance_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendance
    ADD CONSTRAINT attendance_attendance_pkey PRIMARY KEY (id);


--
-- Name: attendance_attendanceactivity attendance_attendanceactivity_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendanceactivity
    ADD CONSTRAINT attendance_attendanceactivity_pkey PRIMARY KEY (id);


--
-- Name: attendance_attendancegeneralsetting attendance_attendancegeneralsetting_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancegeneralsetting
    ADD CONSTRAINT attendance_attendancegeneralsetting_pkey PRIMARY KEY (id);


--
-- Name: attendance_attendancelatecomeearlyout attendance_attendancelat_attendance_id_id_type_1b658e2f_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancelatecomeearlyout
    ADD CONSTRAINT attendance_attendancelat_attendance_id_id_type_1b658e2f_uniq UNIQUE (attendance_id_id, type);


--
-- Name: attendance_attendancelatecomeearlyout attendance_attendancelatecomeearlyout_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancelatecomeearlyout
    ADD CONSTRAINT attendance_attendancelatecomeearlyout_pkey PRIMARY KEY (id);


--
-- Name: attendance_attendanceovertime attendance_attendanceove_employee_id_id_month_yea_98bd34d8_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendanceovertime
    ADD CONSTRAINT attendance_attendanceove_employee_id_id_month_yea_98bd34d8_uniq UNIQUE (employee_id_id, month, year);


--
-- Name: attendance_attendanceovertime attendance_attendanceovertime_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendanceovertime
    ADD CONSTRAINT attendance_attendanceovertime_pkey PRIMARY KEY (id);


--
-- Name: attendance_attendancerequestcomment_files attendance_attendancereq_attendancerequestcomment_022e9e3c_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancerequestcomment_files
    ADD CONSTRAINT attendance_attendancereq_attendancerequestcomment_022e9e3c_uniq UNIQUE (attendancerequestcomment_id, attendancerequestfile_id);


--
-- Name: attendance_attendancerequestcomment_files attendance_attendancerequestcomment_files_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancerequestcomment_files
    ADD CONSTRAINT attendance_attendancerequestcomment_files_pkey PRIMARY KEY (id);


--
-- Name: attendance_attendancerequestcomment attendance_attendancerequestcomment_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancerequestcomment
    ADD CONSTRAINT attendance_attendancerequestcomment_pkey PRIMARY KEY (id);


--
-- Name: attendance_attendancerequestfile attendance_attendancerequestfile_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancerequestfile
    ADD CONSTRAINT attendance_attendancerequestfile_pkey PRIMARY KEY (id);


--
-- Name: attendance_attendancevalidationcondition_company_id attendance_attendanceval_attendancevalidationcond_b22132c5_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancevalidationcondition_company_id
    ADD CONSTRAINT attendance_attendanceval_attendancevalidationcond_b22132c5_uniq UNIQUE (attendancevalidationcondition_id, company_id);


--
-- Name: attendance_attendancevalidationcondition_company_id attendance_attendancevalidationcondition_company_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancevalidationcondition_company_id
    ADD CONSTRAINT attendance_attendancevalidationcondition_company_id_pkey PRIMARY KEY (id);


--
-- Name: attendance_attendancevalidationcondition attendance_attendancevalidationcondition_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_attendancevalidationcondition
    ADD CONSTRAINT attendance_attendancevalidationcondition_pkey PRIMARY KEY (id);


--
-- Name: attendance_batchattendance attendance_batchattendance_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_batchattendance
    ADD CONSTRAINT attendance_batchattendance_pkey PRIMARY KEY (id);


--
-- Name: attendance_gracetime_company_id attendance_gracetime_com_gracetime_id_company_id_e668b552_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_gracetime_company_id
    ADD CONSTRAINT attendance_gracetime_com_gracetime_id_company_id_e668b552_uniq UNIQUE (gracetime_id, company_id);


--
-- Name: attendance_gracetime_company_id attendance_gracetime_company_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_gracetime_company_id
    ADD CONSTRAINT attendance_gracetime_company_id_pkey PRIMARY KEY (id);


--
-- Name: attendance_gracetime attendance_gracetime_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_gracetime
    ADD CONSTRAINT attendance_gracetime_pkey PRIMARY KEY (id);


--
-- Name: attendance_historicalattendance_history_tags attendance_historicalatt_historicalattendance_id__3385842d_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_historicalattendance_history_tags
    ADD CONSTRAINT attendance_historicalatt_historicalattendance_id__3385842d_uniq UNIQUE (historicalattendance_id, audittag_id);


--
-- Name: attendance_historicalattendance_history_tags attendance_historicalattendance_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_historicalattendance_history_tags
    ADD CONSTRAINT attendance_historicalattendance_history_tags_pkey PRIMARY KEY (id);


--
-- Name: attendance_historicalattendance attendance_historicalattendance_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_historicalattendance
    ADD CONSTRAINT attendance_historicalattendance_pkey PRIMARY KEY (history_id);


--
-- Name: attendance_workrecords attendance_workrecords_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.attendance_workrecords
    ADD CONSTRAINT attendance_workrecords_pkey PRIMARY KEY (id);


--
-- Name: auditlog_logentry auditlog_logentry_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.auditlog_logentry
    ADD CONSTRAINT auditlog_logentry_pkey PRIMARY KEY (id);


--
-- Name: auth_group auth_group_name_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.auth_group
    ADD CONSTRAINT auth_group_name_key UNIQUE (name);


--
-- Name: auth_group_permissions auth_group_permissions_group_id_permission_id_0cd325b0_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_group_id_permission_id_0cd325b0_uniq UNIQUE (group_id, permission_id);


--
-- Name: auth_group_permissions auth_group_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.auth_group_permissions
    ADD CONSTRAINT auth_group_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_group auth_group_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.auth_group
    ADD CONSTRAINT auth_group_pkey PRIMARY KEY (id);


--
-- Name: auth_permission auth_permission_content_type_id_codename_01ab375a_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_content_type_id_codename_01ab375a_uniq UNIQUE (content_type_id, codename);


--
-- Name: auth_permission auth_permission_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.auth_permission
    ADD CONSTRAINT auth_permission_pkey PRIMARY KEY (id);


--
-- Name: auth_user_groups auth_user_groups_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_pkey PRIMARY KEY (id);


--
-- Name: auth_user_groups auth_user_groups_user_id_group_id_94350c0c_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.auth_user_groups
    ADD CONSTRAINT auth_user_groups_user_id_group_id_94350c0c_uniq UNIQUE (user_id, group_id);


--
-- Name: auth_user auth_user_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.auth_user
    ADD CONSTRAINT auth_user_pkey PRIMARY KEY (id);


--
-- Name: auth_user_user_permissions auth_user_user_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_pkey PRIMARY KEY (id);


--
-- Name: auth_user_user_permissions auth_user_user_permissions_user_id_permission_id_14a6b632_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.auth_user_user_permissions
    ADD CONSTRAINT auth_user_user_permissions_user_id_permission_id_14a6b632_uniq UNIQUE (user_id, permission_id);


--
-- Name: auth_user auth_user_username_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.auth_user
    ADD CONSTRAINT auth_user_username_key UNIQUE (username);


--
-- Name: base_announcement_attachments base_announcement_attach_announcement_id_attachme_d0147299_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_attachments
    ADD CONSTRAINT base_announcement_attach_announcement_id_attachme_d0147299_uniq UNIQUE (announcement_id, attachment_id);


--
-- Name: base_announcement_attachments base_announcement_attachments_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_attachments
    ADD CONSTRAINT base_announcement_attachments_pkey PRIMARY KEY (id);


--
-- Name: base_announcement_company_id base_announcement_compan_announcement_id_company__544233be_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_company_id
    ADD CONSTRAINT base_announcement_compan_announcement_id_company__544233be_uniq UNIQUE (announcement_id, company_id);


--
-- Name: base_announcement_company_id base_announcement_company_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_company_id
    ADD CONSTRAINT base_announcement_company_id_pkey PRIMARY KEY (id);


--
-- Name: base_announcement_department base_announcement_depart_announcement_id_departme_65aebed2_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_department
    ADD CONSTRAINT base_announcement_depart_announcement_id_departme_65aebed2_uniq UNIQUE (announcement_id, department_id);


--
-- Name: base_announcement_department base_announcement_department_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_department
    ADD CONSTRAINT base_announcement_department_pkey PRIMARY KEY (id);


--
-- Name: base_announcement_employees base_announcement_employ_announcement_id_employee_fd08521b_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_employees
    ADD CONSTRAINT base_announcement_employ_announcement_id_employee_fd08521b_uniq UNIQUE (announcement_id, employee_id);


--
-- Name: base_announcement_employees base_announcement_employees_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_employees
    ADD CONSTRAINT base_announcement_employees_pkey PRIMARY KEY (id);


--
-- Name: base_announcement_filtered_employees base_announcement_filter_announcement_id_employee_877070fd_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_filtered_employees
    ADD CONSTRAINT base_announcement_filter_announcement_id_employee_877070fd_uniq UNIQUE (announcement_id, employee_id);


--
-- Name: base_announcement_filtered_employees base_announcement_filtered_employees_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_filtered_employees
    ADD CONSTRAINT base_announcement_filtered_employees_pkey PRIMARY KEY (id);


--
-- Name: base_announcement_job_position base_announcement_job_po_announcement_id_jobposit_3abce70a_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_job_position
    ADD CONSTRAINT base_announcement_job_po_announcement_id_jobposit_3abce70a_uniq UNIQUE (announcement_id, jobposition_id);


--
-- Name: base_announcement_job_position base_announcement_job_position_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement_job_position
    ADD CONSTRAINT base_announcement_job_position_pkey PRIMARY KEY (id);


--
-- Name: base_announcement base_announcement_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcement
    ADD CONSTRAINT base_announcement_pkey PRIMARY KEY (id);


--
-- Name: base_announcementcomment base_announcementcomment_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcementcomment
    ADD CONSTRAINT base_announcementcomment_pkey PRIMARY KEY (id);


--
-- Name: base_announcementexpire base_announcementexpire_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcementexpire
    ADD CONSTRAINT base_announcementexpire_pkey PRIMARY KEY (id);


--
-- Name: base_announcementview base_announcementview_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_announcementview
    ADD CONSTRAINT base_announcementview_pkey PRIMARY KEY (id);


--
-- Name: base_attachment base_attachment_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_attachment
    ADD CONSTRAINT base_attachment_pkey PRIMARY KEY (id);


--
-- Name: base_attendanceallowedip base_attendanceallowedip_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_attendanceallowedip
    ADD CONSTRAINT base_attendanceallowedip_pkey PRIMARY KEY (id);


--
-- Name: base_baserequestfile base_baserequestfile_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_baserequestfile
    ADD CONSTRAINT base_baserequestfile_pkey PRIMARY KEY (id);


--
-- Name: base_biometricattendance base_biometricattendance_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_biometricattendance
    ADD CONSTRAINT base_biometricattendance_pkey PRIMARY KEY (id);


--
-- Name: base_company base_company_company_address_0205f120_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_company
    ADD CONSTRAINT base_company_company_address_0205f120_uniq UNIQUE (company, address);


--
-- Name: base_company base_company_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_company
    ADD CONSTRAINT base_company_pkey PRIMARY KEY (id);


--
-- Name: base_companyleaves base_companyleaves_based_on_week_based_on_w_ae1142e7_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_companyleaves
    ADD CONSTRAINT base_companyleaves_based_on_week_based_on_w_ae1142e7_uniq UNIQUE (based_on_week, based_on_week_day);


--
-- Name: base_companyleaves base_companyleaves_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_companyleaves
    ADD CONSTRAINT base_companyleaves_pkey PRIMARY KEY (id);


--
-- Name: base_dashboardemployeecharts base_dashboardemployeecharts_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_dashboardemployeecharts
    ADD CONSTRAINT base_dashboardemployeecharts_pkey PRIMARY KEY (id);


--
-- Name: base_department_company_id base_department_company__department_id_company_id_ccaa34c4_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_department_company_id
    ADD CONSTRAINT base_department_company__department_id_company_id_ccaa34c4_uniq UNIQUE (department_id, company_id);


--
-- Name: base_department_company_id base_department_company_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_department_company_id
    ADD CONSTRAINT base_department_company_id_pkey PRIMARY KEY (id);


--
-- Name: base_department base_department_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_department
    ADD CONSTRAINT base_department_pkey PRIMARY KEY (id);


--
-- Name: base_driverviewed base_driverviewed_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_driverviewed
    ADD CONSTRAINT base_driverviewed_pkey PRIMARY KEY (id);


--
-- Name: base_dynamicemailconfiguration base_dynamicemailconfiguration_company_id_id_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_dynamicemailconfiguration
    ADD CONSTRAINT base_dynamicemailconfiguration_company_id_id_key UNIQUE (company_id_id);


--
-- Name: base_dynamicemailconfiguration base_dynamicemailconfiguration_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_dynamicemailconfiguration
    ADD CONSTRAINT base_dynamicemailconfiguration_pkey PRIMARY KEY (id);


--
-- Name: base_dynamicpagination base_dynamicpagination_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_dynamicpagination
    ADD CONSTRAINT base_dynamicpagination_pkey PRIMARY KEY (id);


--
-- Name: base_dynamicpagination base_dynamicpagination_user_id_id_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_dynamicpagination
    ADD CONSTRAINT base_dynamicpagination_user_id_id_key UNIQUE (user_id_id);


--
-- Name: base_emaillog base_emaillog_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_emaillog
    ADD CONSTRAINT base_emaillog_pkey PRIMARY KEY (id);


--
-- Name: base_employeeshift_company_id base_employeeshift_compa_employeeshift_id_company_f4e05bd4_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_employeeshift_company_id
    ADD CONSTRAINT base_employeeshift_compa_employeeshift_id_company_f4e05bd4_uniq UNIQUE (employeeshift_id, company_id);


--
-- Name: base_employeeshift_company_id base_employeeshift_company_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_employeeshift_company_id
    ADD CONSTRAINT base_employeeshift_company_id_pkey PRIMARY KEY (id);


--
-- Name: base_employeeshift base_employeeshift_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_employeeshift
    ADD CONSTRAINT base_employeeshift_pkey PRIMARY KEY (id);


--
-- Name: base_employeeshiftday_company_id base_employeeshiftday_co_employeeshiftday_id_comp_5986b684_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_employeeshiftday_company_id
    ADD CONSTRAINT base_employeeshiftday_co_employeeshiftday_id_comp_5986b684_uniq UNIQUE (employeeshiftday_id, company_id);


--
-- Name: base_employeeshiftday_company_id base_employeeshiftday_company_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_employeeshiftday_company_id
    ADD CONSTRAINT base_employeeshiftday_company_id_pkey PRIMARY KEY (id);


--
-- Name: base_employeeshiftday base_employeeshiftday_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_employeeshiftday
    ADD CONSTRAINT base_employeeshiftday_pkey PRIMARY KEY (id);


--
-- Name: base_employeeshiftschedule_company_id base_employeeshiftschedu_employeeshiftschedule_id_e88d292f_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_employeeshiftschedule_company_id
    ADD CONSTRAINT base_employeeshiftschedu_employeeshiftschedule_id_e88d292f_uniq UNIQUE (employeeshiftschedule_id, company_id);


--
-- Name: base_employeeshiftschedule_company_id base_employeeshiftschedule_company_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_employeeshiftschedule_company_id
    ADD CONSTRAINT base_employeeshiftschedule_company_id_pkey PRIMARY KEY (id);


--
-- Name: base_employeeshiftschedule base_employeeshiftschedule_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_employeeshiftschedule
    ADD CONSTRAINT base_employeeshiftschedule_pkey PRIMARY KEY (id);


--
-- Name: base_employeeshiftschedule base_employeeshiftschedule_shift_id_id_day_id_cb5c24e1_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_employeeshiftschedule
    ADD CONSTRAINT base_employeeshiftschedule_shift_id_id_day_id_cb5c24e1_uniq UNIQUE (shift_id_id, day_id);


--
-- Name: base_employeetype_company_id base_employeetype_compan_employeetype_id_company__fb19a24d_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_employeetype_company_id
    ADD CONSTRAINT base_employeetype_compan_employeetype_id_company__fb19a24d_uniq UNIQUE (employeetype_id, company_id);


--
-- Name: base_employeetype_company_id base_employeetype_company_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_employeetype_company_id
    ADD CONSTRAINT base_employeetype_company_id_pkey PRIMARY KEY (id);


--
-- Name: base_employeetype base_employeetype_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_employeetype
    ADD CONSTRAINT base_employeetype_pkey PRIMARY KEY (id);


--
-- Name: base_historicalrotatingshiftassign_history_tags base_historicalrotatings_historicalrotatingshifta_2dc84adf_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_historicalrotatingshiftassign_history_tags
    ADD CONSTRAINT base_historicalrotatings_historicalrotatingshifta_2dc84adf_uniq UNIQUE (historicalrotatingshiftassign_id, audittag_id);


--
-- Name: base_historicalrotatingshiftassign_history_tags base_historicalrotatingshiftassign_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_historicalrotatingshiftassign_history_tags
    ADD CONSTRAINT base_historicalrotatingshiftassign_history_tags_pkey PRIMARY KEY (id);


--
-- Name: base_historicalrotatingshiftassign base_historicalrotatingshiftassign_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_historicalrotatingshiftassign
    ADD CONSTRAINT base_historicalrotatingshiftassign_pkey PRIMARY KEY (history_id);


--
-- Name: base_historicalrotatingworktypeassign_history_tags base_historicalrotatingw_historicalrotatingworkty_1a15b3ee_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_historicalrotatingworktypeassign_history_tags
    ADD CONSTRAINT base_historicalrotatingw_historicalrotatingworkty_1a15b3ee_uniq UNIQUE (historicalrotatingworktypeassign_id, audittag_id);


--
-- Name: base_historicalrotatingworktypeassign_history_tags base_historicalrotatingworktypeassign_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_historicalrotatingworktypeassign_history_tags
    ADD CONSTRAINT base_historicalrotatingworktypeassign_history_tags_pkey PRIMARY KEY (id);


--
-- Name: base_historicalrotatingworktypeassign base_historicalrotatingworktypeassign_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_historicalrotatingworktypeassign
    ADD CONSTRAINT base_historicalrotatingworktypeassign_pkey PRIMARY KEY (history_id);


--
-- Name: base_historicalshiftrequest_history_tags base_historicalshiftrequ_historicalshiftrequest_i_f67984f8_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_historicalshiftrequest_history_tags
    ADD CONSTRAINT base_historicalshiftrequ_historicalshiftrequest_i_f67984f8_uniq UNIQUE (historicalshiftrequest_id, audittag_id);


--
-- Name: base_historicalshiftrequest_history_tags base_historicalshiftrequest_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_historicalshiftrequest_history_tags
    ADD CONSTRAINT base_historicalshiftrequest_history_tags_pkey PRIMARY KEY (id);


--
-- Name: base_historicalshiftrequest base_historicalshiftrequest_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_historicalshiftrequest
    ADD CONSTRAINT base_historicalshiftrequest_pkey PRIMARY KEY (history_id);


--
-- Name: base_historicalworktyperequest_history_tags base_historicalworktyper_historicalworktypereques_9872c74a_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_historicalworktyperequest_history_tags
    ADD CONSTRAINT base_historicalworktyper_historicalworktypereques_9872c74a_uniq UNIQUE (historicalworktyperequest_id, audittag_id);


--
-- Name: base_historicalworktyperequest_history_tags base_historicalworktyperequest_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_historicalworktyperequest_history_tags
    ADD CONSTRAINT base_historicalworktyperequest_history_tags_pkey PRIMARY KEY (id);


--
-- Name: base_historicalworktyperequest base_historicalworktyperequest_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_historicalworktyperequest
    ADD CONSTRAINT base_historicalworktyperequest_pkey PRIMARY KEY (history_id);


--
-- Name: base_holidays base_holidays_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_holidays
    ADD CONSTRAINT base_holidays_pkey PRIMARY KEY (id);


--
-- Name: base_horillamailtemplate base_horillamailtemplate_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_horillamailtemplate
    ADD CONSTRAINT base_horillamailtemplate_pkey PRIMARY KEY (id);


--
-- Name: base_horillamailtemplate base_horillamailtemplate_title_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_horillamailtemplate
    ADD CONSTRAINT base_horillamailtemplate_title_key UNIQUE (title);


--
-- Name: base_jobposition_company_id base_jobposition_company_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_jobposition_company_id
    ADD CONSTRAINT base_jobposition_company_id_pkey PRIMARY KEY (id);


--
-- Name: base_jobposition_company_id base_jobposition_company_jobposition_id_company_i_3cc4d480_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_jobposition_company_id
    ADD CONSTRAINT base_jobposition_company_jobposition_id_company_i_3cc4d480_uniq UNIQUE (jobposition_id, company_id);


--
-- Name: base_jobposition base_jobposition_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_jobposition
    ADD CONSTRAINT base_jobposition_pkey PRIMARY KEY (id);


--
-- Name: base_jobrole_company_id base_jobrole_company_id_jobrole_id_company_id_bec196f7_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_jobrole_company_id
    ADD CONSTRAINT base_jobrole_company_id_jobrole_id_company_id_bec196f7_uniq UNIQUE (jobrole_id, company_id);


--
-- Name: base_jobrole_company_id base_jobrole_company_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_jobrole_company_id
    ADD CONSTRAINT base_jobrole_company_id_pkey PRIMARY KEY (id);


--
-- Name: base_jobrole base_jobrole_job_position_id_id_job_role_8e2fa70b_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_jobrole
    ADD CONSTRAINT base_jobrole_job_position_id_id_job_role_8e2fa70b_uniq UNIQUE (job_position_id_id, job_role);


--
-- Name: base_jobrole base_jobrole_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_jobrole
    ADD CONSTRAINT base_jobrole_pkey PRIMARY KEY (id);


--
-- Name: base_multipleapprovalcondition base_multipleapprovalcondition_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_multipleapprovalcondition
    ADD CONSTRAINT base_multipleapprovalcondition_pkey PRIMARY KEY (id);


--
-- Name: base_multipleapprovalmanagers base_multipleapprovalmanagers_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_multipleapprovalmanagers
    ADD CONSTRAINT base_multipleapprovalmanagers_pkey PRIMARY KEY (id);


--
-- Name: base_notificationsound base_notificationsound_employee_id_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_notificationsound
    ADD CONSTRAINT base_notificationsound_employee_id_key UNIQUE (employee_id);


--
-- Name: base_notificationsound base_notificationsound_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_notificationsound
    ADD CONSTRAINT base_notificationsound_pkey PRIMARY KEY (id);


--
-- Name: base_penaltyaccounts base_penaltyaccounts_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_penaltyaccounts
    ADD CONSTRAINT base_penaltyaccounts_pkey PRIMARY KEY (id);


--
-- Name: base_rotatingshift base_rotatingshift_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_rotatingshift
    ADD CONSTRAINT base_rotatingshift_pkey PRIMARY KEY (id);


--
-- Name: base_rotatingshiftassign base_rotatingshiftassign_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_rotatingshiftassign
    ADD CONSTRAINT base_rotatingshiftassign_pkey PRIMARY KEY (id);


--
-- Name: base_rotatingworktype base_rotatingworktype_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_rotatingworktype
    ADD CONSTRAINT base_rotatingworktype_pkey PRIMARY KEY (id);


--
-- Name: base_rotatingworktypeassign base_rotatingworktypeassign_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_rotatingworktypeassign
    ADD CONSTRAINT base_rotatingworktypeassign_pkey PRIMARY KEY (id);


--
-- Name: base_shiftrequest base_shiftrequest_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_shiftrequest
    ADD CONSTRAINT base_shiftrequest_pkey PRIMARY KEY (id);


--
-- Name: base_shiftrequestcomment_files base_shiftrequestcomment_files_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_shiftrequestcomment_files
    ADD CONSTRAINT base_shiftrequestcomment_files_pkey PRIMARY KEY (id);


--
-- Name: base_shiftrequestcomment base_shiftrequestcomment_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_shiftrequestcomment
    ADD CONSTRAINT base_shiftrequestcomment_pkey PRIMARY KEY (id);


--
-- Name: base_shiftrequestcomment_files base_shiftrequestcomment_shiftrequestcomment_id_b_3d088052_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_shiftrequestcomment_files
    ADD CONSTRAINT base_shiftrequestcomment_shiftrequestcomment_id_b_3d088052_uniq UNIQUE (shiftrequestcomment_id, baserequestfile_id);


--
-- Name: base_tags base_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_tags
    ADD CONSTRAINT base_tags_pkey PRIMARY KEY (id);


--
-- Name: base_tracklatecomeearlyout base_tracklatecomeearlyout_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_tracklatecomeearlyout
    ADD CONSTRAINT base_tracklatecomeearlyout_pkey PRIMARY KEY (id);


--
-- Name: base_worktype_company_id base_worktype_company_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_worktype_company_id
    ADD CONSTRAINT base_worktype_company_id_pkey PRIMARY KEY (id);


--
-- Name: base_worktype_company_id base_worktype_company_id_worktype_id_company_id_b60b5273_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_worktype_company_id
    ADD CONSTRAINT base_worktype_company_id_worktype_id_company_id_b60b5273_uniq UNIQUE (worktype_id, company_id);


--
-- Name: base_worktype base_worktype_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_worktype
    ADD CONSTRAINT base_worktype_pkey PRIMARY KEY (id);


--
-- Name: base_worktyperequest base_worktyperequest_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_worktyperequest
    ADD CONSTRAINT base_worktyperequest_pkey PRIMARY KEY (id);


--
-- Name: base_worktyperequestcomment_files base_worktyperequestcomm_worktyperequestcomment_i_11279360_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_worktyperequestcomment_files
    ADD CONSTRAINT base_worktyperequestcomm_worktyperequestcomment_i_11279360_uniq UNIQUE (worktyperequestcomment_id, baserequestfile_id);


--
-- Name: base_worktyperequestcomment_files base_worktyperequestcomment_files_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_worktyperequestcomment_files
    ADD CONSTRAINT base_worktyperequestcomment_files_pkey PRIMARY KEY (id);


--
-- Name: base_worktyperequestcomment base_worktyperequestcomment_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.base_worktyperequestcomment
    ADD CONSTRAINT base_worktyperequestcomment_pkey PRIMARY KEY (id);


--
-- Name: biometric_biometricdevices biometric_biometricdevices_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.biometric_biometricdevices
    ADD CONSTRAINT biometric_biometricdevices_pkey PRIMARY KEY (id);


--
-- Name: biometric_biometricemployees biometric_biometricemployees_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.biometric_biometricemployees
    ADD CONSTRAINT biometric_biometricemployees_pkey PRIMARY KEY (id);


--
-- Name: biometric_cosecattendancearguments biometric_cosecattendancearguments_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.biometric_cosecattendancearguments
    ADD CONSTRAINT biometric_cosecattendancearguments_pkey PRIMARY KEY (id);


--
-- Name: django_admin_log django_admin_log_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.django_admin_log
    ADD CONSTRAINT django_admin_log_pkey PRIMARY KEY (id);


--
-- Name: django_apscheduler_djangojob django_apscheduler_djangojob_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.django_apscheduler_djangojob
    ADD CONSTRAINT django_apscheduler_djangojob_pkey PRIMARY KEY (id);


--
-- Name: django_apscheduler_djangojobexecution django_apscheduler_djangojobexecution_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.django_apscheduler_djangojobexecution
    ADD CONSTRAINT django_apscheduler_djangojobexecution_pkey PRIMARY KEY (id);


--
-- Name: django_content_type django_content_type_app_label_model_76bd3d3b_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.django_content_type
    ADD CONSTRAINT django_content_type_app_label_model_76bd3d3b_uniq UNIQUE (app_label, model);


--
-- Name: django_content_type django_content_type_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.django_content_type
    ADD CONSTRAINT django_content_type_pkey PRIMARY KEY (id);


--
-- Name: django_migrations django_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.django_migrations
    ADD CONSTRAINT django_migrations_pkey PRIMARY KEY (id);


--
-- Name: django_session django_session_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.django_session
    ADD CONSTRAINT django_session_pkey PRIMARY KEY (session_key);


--
-- Name: employee_actiontype employee_actiontype_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_actiontype
    ADD CONSTRAINT employee_actiontype_pkey PRIMARY KEY (id);


--
-- Name: employee_bonuspoint employee_bonuspoint_employee_id_id_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_bonuspoint
    ADD CONSTRAINT employee_bonuspoint_employee_id_id_key UNIQUE (employee_id_id);


--
-- Name: employee_bonuspoint employee_bonuspoint_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_bonuspoint
    ADD CONSTRAINT employee_bonuspoint_pkey PRIMARY KEY (id);


--
-- Name: employee_disciplinaryaction_employee_id employee_disciplinaryact_disciplinaryaction_id_em_ba1d46a5_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_disciplinaryaction_employee_id
    ADD CONSTRAINT employee_disciplinaryact_disciplinaryaction_id_em_ba1d46a5_uniq UNIQUE (disciplinaryaction_id, employee_id);


--
-- Name: employee_disciplinaryaction_employee_id employee_disciplinaryaction_employee_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_disciplinaryaction_employee_id
    ADD CONSTRAINT employee_disciplinaryaction_employee_id_pkey PRIMARY KEY (id);


--
-- Name: employee_disciplinaryaction employee_disciplinaryaction_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_disciplinaryaction
    ADD CONSTRAINT employee_disciplinaryaction_pkey PRIMARY KEY (id);


--
-- Name: employee_employee employee_employee_email_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_employee
    ADD CONSTRAINT employee_employee_email_key UNIQUE (email);


--
-- Name: employee_employee employee_employee_employee_first_name_empl_b193a07f_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_employee
    ADD CONSTRAINT employee_employee_employee_first_name_empl_b193a07f_uniq UNIQUE (employee_first_name, employee_last_name, email);


--
-- Name: employee_employee employee_employee_employee_user_id_id_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_employee
    ADD CONSTRAINT employee_employee_employee_user_id_id_key UNIQUE (employee_user_id_id);


--
-- Name: employee_employee employee_employee_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_employee
    ADD CONSTRAINT employee_employee_pkey PRIMARY KEY (id);


--
-- Name: employee_employeebankdetails employee_employeebankdetails_employee_id_id_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_employeebankdetails
    ADD CONSTRAINT employee_employeebankdetails_employee_id_id_key UNIQUE (employee_id_id);


--
-- Name: employee_employeebankdetails employee_employeebankdetails_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_employeebankdetails
    ADD CONSTRAINT employee_employeebankdetails_pkey PRIMARY KEY (id);


--
-- Name: employee_employeegeneralsetting employee_employeegeneralsetting_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_employeegeneralsetting
    ADD CONSTRAINT employee_employeegeneralsetting_pkey PRIMARY KEY (id);


--
-- Name: employee_employeenote_note_files employee_employeenote_no_employeenote_id_notefile_73466035_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_employeenote_note_files
    ADD CONSTRAINT employee_employeenote_no_employeenote_id_notefile_73466035_uniq UNIQUE (employeenote_id, notefiles_id);


--
-- Name: employee_employeenote_note_files employee_employeenote_note_files_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_employeenote_note_files
    ADD CONSTRAINT employee_employeenote_note_files_pkey PRIMARY KEY (id);


--
-- Name: employee_employeenote employee_employeenote_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_employeenote
    ADD CONSTRAINT employee_employeenote_pkey PRIMARY KEY (id);


--
-- Name: employee_employeetag employee_employeetag_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_employeetag
    ADD CONSTRAINT employee_employeetag_pkey PRIMARY KEY (id);


--
-- Name: employee_employeeworkinformation_tags employee_employeeworkinf_employeeworkinformation__f57a8e85_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_employeeworkinformation_tags
    ADD CONSTRAINT employee_employeeworkinf_employeeworkinformation__f57a8e85_uniq UNIQUE (employeeworkinformation_id, employeetag_id);


--
-- Name: employee_employeeworkinformation employee_employeeworkinformation_employee_id_id_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_employeeworkinformation
    ADD CONSTRAINT employee_employeeworkinformation_employee_id_id_key UNIQUE (employee_id_id);


--
-- Name: employee_employeeworkinformation employee_employeeworkinformation_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_employeeworkinformation
    ADD CONSTRAINT employee_employeeworkinformation_pkey PRIMARY KEY (id);


--
-- Name: employee_employeeworkinformation_tags employee_employeeworkinformation_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_employeeworkinformation_tags
    ADD CONSTRAINT employee_employeeworkinformation_tags_pkey PRIMARY KEY (id);


--
-- Name: employee_historicalbonuspoint_history_tags employee_historicalbonus_historicalbonuspoint_id__16ee8b1c_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_historicalbonuspoint_history_tags
    ADD CONSTRAINT employee_historicalbonus_historicalbonuspoint_id__16ee8b1c_uniq UNIQUE (historicalbonuspoint_id, audittag_id);


--
-- Name: employee_historicalbonuspoint_history_tags employee_historicalbonuspoint_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_historicalbonuspoint_history_tags
    ADD CONSTRAINT employee_historicalbonuspoint_history_tags_pkey PRIMARY KEY (id);


--
-- Name: employee_historicalbonuspoint employee_historicalbonuspoint_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_historicalbonuspoint
    ADD CONSTRAINT employee_historicalbonuspoint_pkey PRIMARY KEY (history_id);


--
-- Name: employee_historicalemployeeworkinformation_history_tags employee_historicalemplo_historicalemployeeworkin_ee12d2f8_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_historicalemployeeworkinformation_history_tags
    ADD CONSTRAINT employee_historicalemplo_historicalemployeeworkin_ee12d2f8_uniq UNIQUE (historicalemployeeworkinformation_id, audittag_id);


--
-- Name: employee_historicalemployeeworkinformation_history_tags employee_historicalemployeeworkinformation_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_historicalemployeeworkinformation_history_tags
    ADD CONSTRAINT employee_historicalemployeeworkinformation_history_tags_pkey PRIMARY KEY (id);


--
-- Name: employee_historicalemployeeworkinformation employee_historicalemployeeworkinformation_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_historicalemployeeworkinformation
    ADD CONSTRAINT employee_historicalemployeeworkinformation_pkey PRIMARY KEY (history_id);


--
-- Name: employee_notefiles employee_notefiles_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_notefiles
    ADD CONSTRAINT employee_notefiles_pkey PRIMARY KEY (id);


--
-- Name: employee_policy_attachments employee_policy_attachme_policy_id_policymultiple_66acf84c_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_policy_attachments
    ADD CONSTRAINT employee_policy_attachme_policy_id_policymultiple_66acf84c_uniq UNIQUE (policy_id, policymultiplefile_id);


--
-- Name: employee_policy_attachments employee_policy_attachments_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_policy_attachments
    ADD CONSTRAINT employee_policy_attachments_pkey PRIMARY KEY (id);


--
-- Name: employee_policy_company_id employee_policy_company_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_policy_company_id
    ADD CONSTRAINT employee_policy_company_id_pkey PRIMARY KEY (id);


--
-- Name: employee_policy_company_id employee_policy_company_id_policy_id_company_id_e633da71_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_policy_company_id
    ADD CONSTRAINT employee_policy_company_id_policy_id_company_id_e633da71_uniq UNIQUE (policy_id, company_id);


--
-- Name: employee_policy employee_policy_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_policy
    ADD CONSTRAINT employee_policy_pkey PRIMARY KEY (id);


--
-- Name: employee_policy_specific_employees employee_policy_specific_employees_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_policy_specific_employees
    ADD CONSTRAINT employee_policy_specific_employees_pkey PRIMARY KEY (id);


--
-- Name: employee_policy_specific_employees employee_policy_specific_policy_id_employee_id_a94d13bd_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_policy_specific_employees
    ADD CONSTRAINT employee_policy_specific_policy_id_employee_id_a94d13bd_uniq UNIQUE (policy_id, employee_id);


--
-- Name: employee_policymultiplefile employee_policymultiplefile_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_policymultiplefile
    ADD CONSTRAINT employee_policymultiplefile_pkey PRIMARY KEY (id);


--
-- Name: employee_profileeditfeature employee_profileeditfeature_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.employee_profileeditfeature
    ADD CONSTRAINT employee_profileeditfeature_pkey PRIMARY KEY (id);


--
-- Name: facedetection_employeefacedetection facedetection_employeefacedetection_employee_id_id_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.facedetection_employeefacedetection
    ADD CONSTRAINT facedetection_employeefacedetection_employee_id_id_key UNIQUE (employee_id_id);


--
-- Name: facedetection_employeefacedetection facedetection_employeefacedetection_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.facedetection_employeefacedetection
    ADD CONSTRAINT facedetection_employeefacedetection_pkey PRIMARY KEY (id);


--
-- Name: facedetection_facedetection facedetection_facedetection_company_id_id_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.facedetection_facedetection
    ADD CONSTRAINT facedetection_facedetection_company_id_id_key UNIQUE (company_id_id);


--
-- Name: facedetection_facedetection facedetection_facedetection_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.facedetection_facedetection
    ADD CONSTRAINT facedetection_facedetection_pkey PRIMARY KEY (id);


--
-- Name: geofencing_geofencing geofencing_geofencing_company_id_id_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.geofencing_geofencing
    ADD CONSTRAINT geofencing_geofencing_company_id_id_key UNIQUE (company_id_id);


--
-- Name: geofencing_geofencing geofencing_geofencing_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.geofencing_geofencing
    ADD CONSTRAINT geofencing_geofencing_pkey PRIMARY KEY (id);


--
-- Name: helpdesk_attachment helpdesk_attachment_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.helpdesk_attachment
    ADD CONSTRAINT helpdesk_attachment_pkey PRIMARY KEY (id);


--
-- Name: helpdesk_claimrequest helpdesk_claimrequest_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.helpdesk_claimrequest
    ADD CONSTRAINT helpdesk_claimrequest_pkey PRIMARY KEY (id);


--
-- Name: helpdesk_claimrequest helpdesk_claimrequest_ticket_id_id_employee_id_id_2307c9fd_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.helpdesk_claimrequest
    ADD CONSTRAINT helpdesk_claimrequest_ticket_id_id_employee_id_id_2307c9fd_uniq UNIQUE (ticket_id_id, employee_id_id);


--
-- Name: helpdesk_comment helpdesk_comment_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.helpdesk_comment
    ADD CONSTRAINT helpdesk_comment_pkey PRIMARY KEY (id);


--
-- Name: helpdesk_departmentmanager helpdesk_departmentmanag_department_id_manager_id_a370e535_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.helpdesk_departmentmanager
    ADD CONSTRAINT helpdesk_departmentmanag_department_id_manager_id_a370e535_uniq UNIQUE (department_id, manager_id);


--
-- Name: helpdesk_departmentmanager helpdesk_departmentmanager_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.helpdesk_departmentmanager
    ADD CONSTRAINT helpdesk_departmentmanager_pkey PRIMARY KEY (id);


--
-- Name: helpdesk_faq helpdesk_faq_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.helpdesk_faq
    ADD CONSTRAINT helpdesk_faq_pkey PRIMARY KEY (id);


--
-- Name: helpdesk_faq_tags helpdesk_faq_tags_faq_id_tags_id_d3ca2d3f_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.helpdesk_faq_tags
    ADD CONSTRAINT helpdesk_faq_tags_faq_id_tags_id_d3ca2d3f_uniq UNIQUE (faq_id, tags_id);


--
-- Name: helpdesk_faq_tags helpdesk_faq_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.helpdesk_faq_tags
    ADD CONSTRAINT helpdesk_faq_tags_pkey PRIMARY KEY (id);


--
-- Name: helpdesk_faqcategory helpdesk_faqcategory_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.helpdesk_faqcategory
    ADD CONSTRAINT helpdesk_faqcategory_pkey PRIMARY KEY (id);


--
-- Name: helpdesk_historicalticket_history_tags helpdesk_historicalticke_historicalticket_id_audi_3bae2dc1_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.helpdesk_historicalticket_history_tags
    ADD CONSTRAINT helpdesk_historicalticke_historicalticket_id_audi_3bae2dc1_uniq UNIQUE (historicalticket_id, audittag_id);


--
-- Name: helpdesk_historicalticket_history_tags helpdesk_historicalticket_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.helpdesk_historicalticket_history_tags
    ADD CONSTRAINT helpdesk_historicalticket_history_tags_pkey PRIMARY KEY (id);


--
-- Name: helpdesk_historicalticket helpdesk_historicalticket_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.helpdesk_historicalticket
    ADD CONSTRAINT helpdesk_historicalticket_pkey PRIMARY KEY (history_id);


--
-- Name: helpdesk_ticket_assigned_to helpdesk_ticket_assigned_to_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.helpdesk_ticket_assigned_to
    ADD CONSTRAINT helpdesk_ticket_assigned_to_pkey PRIMARY KEY (id);


--
-- Name: helpdesk_ticket_assigned_to helpdesk_ticket_assigned_to_ticket_id_employee_id_56d49739_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.helpdesk_ticket_assigned_to
    ADD CONSTRAINT helpdesk_ticket_assigned_to_ticket_id_employee_id_56d49739_uniq UNIQUE (ticket_id, employee_id);


--
-- Name: helpdesk_ticket helpdesk_ticket_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.helpdesk_ticket
    ADD CONSTRAINT helpdesk_ticket_pkey PRIMARY KEY (id);


--
-- Name: helpdesk_ticket_tags helpdesk_ticket_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.helpdesk_ticket_tags
    ADD CONSTRAINT helpdesk_ticket_tags_pkey PRIMARY KEY (id);


--
-- Name: helpdesk_ticket_tags helpdesk_ticket_tags_ticket_id_tags_id_154d805a_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.helpdesk_ticket_tags
    ADD CONSTRAINT helpdesk_ticket_tags_ticket_id_tags_id_154d805a_uniq UNIQUE (ticket_id, tags_id);


--
-- Name: helpdesk_tickettype helpdesk_tickettype_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.helpdesk_tickettype
    ADD CONSTRAINT helpdesk_tickettype_pkey PRIMARY KEY (id);


--
-- Name: helpdesk_tickettype helpdesk_tickettype_prefix_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.helpdesk_tickettype
    ADD CONSTRAINT helpdesk_tickettype_prefix_key UNIQUE (prefix);


--
-- Name: helpdesk_tickettype helpdesk_tickettype_title_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.helpdesk_tickettype
    ADD CONSTRAINT helpdesk_tickettype_title_key UNIQUE (title);


--
-- Name: horilla_audit_accountblockunblock horilla_audit_accountblockunblock_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.horilla_audit_accountblockunblock
    ADD CONSTRAINT horilla_audit_accountblockunblock_pkey PRIMARY KEY (id);


--
-- Name: horilla_audit_audittag horilla_audit_audittag_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.horilla_audit_audittag
    ADD CONSTRAINT horilla_audit_audittag_pkey PRIMARY KEY (id);


--
-- Name: horilla_audit_historytrackingfields horilla_audit_historytrackingfields_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.horilla_audit_historytrackingfields
    ADD CONSTRAINT horilla_audit_historytrackingfields_pkey PRIMARY KEY (id);


--
-- Name: horilla_automations_mailautomation_also_sent_to horilla_automations_mail_mailautomation_id_employ_6793f268_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.horilla_automations_mailautomation_also_sent_to
    ADD CONSTRAINT horilla_automations_mail_mailautomation_id_employ_6793f268_uniq UNIQUE (mailautomation_id, employee_id);


--
-- Name: horilla_automations_mailautomation_template_attachments horilla_automations_mail_mailautomation_id_horill_e578a182_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.horilla_automations_mailautomation_template_attachments
    ADD CONSTRAINT horilla_automations_mail_mailautomation_id_horill_e578a182_uniq UNIQUE (mailautomation_id, horillamailtemplate_id);


--
-- Name: horilla_automations_mailautomation_also_sent_to horilla_automations_mailautomation_also_sent_to_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.horilla_automations_mailautomation_also_sent_to
    ADD CONSTRAINT horilla_automations_mailautomation_also_sent_to_pkey PRIMARY KEY (id);


--
-- Name: horilla_automations_mailautomation horilla_automations_mailautomation_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.horilla_automations_mailautomation
    ADD CONSTRAINT horilla_automations_mailautomation_pkey PRIMARY KEY (id);


--
-- Name: horilla_automations_mailautomation_template_attachments horilla_automations_mailautomation_template_attachments_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.horilla_automations_mailautomation_template_attachments
    ADD CONSTRAINT horilla_automations_mailautomation_template_attachments_pkey PRIMARY KEY (id);


--
-- Name: horilla_automations_mailautomation horilla_automations_mailautomation_title_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.horilla_automations_mailautomation
    ADD CONSTRAINT horilla_automations_mailautomation_title_key UNIQUE (title);


--
-- Name: horilla_backup_googledrivebackup horilla_backup_googledrivebackup_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.horilla_backup_googledrivebackup
    ADD CONSTRAINT horilla_backup_googledrivebackup_pkey PRIMARY KEY (id);


--
-- Name: horilla_backup_localbackup horilla_backup_localbackup_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.horilla_backup_localbackup
    ADD CONSTRAINT horilla_backup_localbackup_pkey PRIMARY KEY (id);


--
-- Name: horilla_documents_documentrequest_employee_id horilla_documents_docume_documentrequest_id_emplo_e925aeea_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.horilla_documents_documentrequest_employee_id
    ADD CONSTRAINT horilla_documents_docume_documentrequest_id_emplo_e925aeea_uniq UNIQUE (documentrequest_id, employee_id);


--
-- Name: horilla_documents_document horilla_documents_document_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.horilla_documents_document
    ADD CONSTRAINT horilla_documents_document_pkey PRIMARY KEY (id);


--
-- Name: horilla_documents_documentrequest_employee_id horilla_documents_documentrequest_employee_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.horilla_documents_documentrequest_employee_id
    ADD CONSTRAINT horilla_documents_documentrequest_employee_id_pkey PRIMARY KEY (id);


--
-- Name: horilla_documents_documentrequest horilla_documents_documentrequest_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.horilla_documents_documentrequest
    ADD CONSTRAINT horilla_documents_documentrequest_pkey PRIMARY KEY (id);


--
-- Name: horilla_views_activegroup horilla_views_activegroup_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.horilla_views_activegroup
    ADD CONSTRAINT horilla_views_activegroup_pkey PRIMARY KEY (id);


--
-- Name: horilla_views_activetab horilla_views_activetab_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.horilla_views_activetab
    ADD CONSTRAINT horilla_views_activetab_pkey PRIMARY KEY (id);


--
-- Name: horilla_views_activeview horilla_views_activeview_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.horilla_views_activeview
    ADD CONSTRAINT horilla_views_activeview_pkey PRIMARY KEY (id);


--
-- Name: horilla_views_savedfilter horilla_views_savedfilter_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.horilla_views_savedfilter
    ADD CONSTRAINT horilla_views_savedfilter_pkey PRIMARY KEY (id);


--
-- Name: horilla_views_togglecolumn horilla_views_togglecolumn_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.horilla_views_togglecolumn
    ADD CONSTRAINT horilla_views_togglecolumn_pkey PRIMARY KEY (id);


--
-- Name: leave_availableleave leave_availableleave_leave_type_id_id_employe_bf1a152b_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_availableleave
    ADD CONSTRAINT leave_availableleave_leave_type_id_id_employe_bf1a152b_uniq UNIQUE (leave_type_id_id, employee_id_id);


--
-- Name: leave_availableleave leave_availableleave_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_availableleave
    ADD CONSTRAINT leave_availableleave_pkey PRIMARY KEY (id);


--
-- Name: leave_companyleave leave_companyleave_based_on_week_based_on_w_bb1889f4_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_companyleave
    ADD CONSTRAINT leave_companyleave_based_on_week_based_on_w_bb1889f4_uniq UNIQUE (based_on_week, based_on_week_day);


--
-- Name: leave_companyleave leave_companyleave_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_companyleave
    ADD CONSTRAINT leave_companyleave_pkey PRIMARY KEY (id);


--
-- Name: leave_compensatoryleaverequest_attendance_id leave_compensatoryleaver_compensatoryleaverequest_87907589_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_compensatoryleaverequest_attendance_id
    ADD CONSTRAINT leave_compensatoryleaver_compensatoryleaverequest_87907589_uniq UNIQUE (compensatoryleaverequest_id, attendance_id);


--
-- Name: leave_compensatoryleaverequestcomment_files leave_compensatoryleaver_compensatoryleaverequest_dd7596fe_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_compensatoryleaverequestcomment_files
    ADD CONSTRAINT leave_compensatoryleaver_compensatoryleaverequest_dd7596fe_uniq UNIQUE (compensatoryleaverequestcomment_id, leaverequestfile_id);


--
-- Name: leave_compensatoryleaverequest_attendance_id leave_compensatoryleaverequest_attendance_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_compensatoryleaverequest_attendance_id
    ADD CONSTRAINT leave_compensatoryleaverequest_attendance_id_pkey PRIMARY KEY (id);


--
-- Name: leave_compensatoryleaverequest leave_compensatoryleaverequest_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_compensatoryleaverequest
    ADD CONSTRAINT leave_compensatoryleaverequest_pkey PRIMARY KEY (id);


--
-- Name: leave_compensatoryleaverequestcomment_files leave_compensatoryleaverequestcomment_files_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_compensatoryleaverequestcomment_files
    ADD CONSTRAINT leave_compensatoryleaverequestcomment_files_pkey PRIMARY KEY (id);


--
-- Name: leave_compensatoryleaverequestcomment leave_compensatoryleaverequestcomment_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_compensatoryleaverequestcomment
    ADD CONSTRAINT leave_compensatoryleaverequestcomment_pkey PRIMARY KEY (id);


--
-- Name: leave_employeepastleaverestrict leave_employeepastleaverestrict_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_employeepastleaverestrict
    ADD CONSTRAINT leave_employeepastleaverestrict_pkey PRIMARY KEY (id);


--
-- Name: leave_historicalavailableleave_history_tags leave_historicalavailabl_historicalavailableleave_d0664182_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_historicalavailableleave_history_tags
    ADD CONSTRAINT leave_historicalavailabl_historicalavailableleave_d0664182_uniq UNIQUE (historicalavailableleave_id, audittag_id);


--
-- Name: leave_historicalavailableleave_history_tags leave_historicalavailableleave_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_historicalavailableleave_history_tags
    ADD CONSTRAINT leave_historicalavailableleave_history_tags_pkey PRIMARY KEY (id);


--
-- Name: leave_historicalavailableleave leave_historicalavailableleave_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_historicalavailableleave
    ADD CONSTRAINT leave_historicalavailableleave_pkey PRIMARY KEY (history_id);


--
-- Name: leave_historicalcompensatoryleaverequest_history_tags leave_historicalcompensa_historicalcompensatoryle_bba17be0_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_historicalcompensatoryleaverequest_history_tags
    ADD CONSTRAINT leave_historicalcompensa_historicalcompensatoryle_bba17be0_uniq UNIQUE (historicalcompensatoryleaverequest_id, audittag_id);


--
-- Name: leave_historicalcompensatoryleaverequest_history_tags leave_historicalcompensatoryleaverequest_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_historicalcompensatoryleaverequest_history_tags
    ADD CONSTRAINT leave_historicalcompensatoryleaverequest_history_tags_pkey PRIMARY KEY (id);


--
-- Name: leave_historicalcompensatoryleaverequest leave_historicalcompensatoryleaverequest_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_historicalcompensatoryleaverequest
    ADD CONSTRAINT leave_historicalcompensatoryleaverequest_pkey PRIMARY KEY (history_id);


--
-- Name: leave_historicalleaveallocationrequest_history_tags leave_historicalleaveall_historicalleaveallocatio_7e0a694f_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_historicalleaveallocationrequest_history_tags
    ADD CONSTRAINT leave_historicalleaveall_historicalleaveallocatio_7e0a694f_uniq UNIQUE (historicalleaveallocationrequest_id, audittag_id);


--
-- Name: leave_historicalleaveallocationrequest_history_tags leave_historicalleaveallocationrequest_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_historicalleaveallocationrequest_history_tags
    ADD CONSTRAINT leave_historicalleaveallocationrequest_history_tags_pkey PRIMARY KEY (id);


--
-- Name: leave_historicalleaveallocationrequest leave_historicalleaveallocationrequest_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_historicalleaveallocationrequest
    ADD CONSTRAINT leave_historicalleaveallocationrequest_pkey PRIMARY KEY (history_id);


--
-- Name: leave_historicalleaverequest_history_tags leave_historicalleavereq_historicalleaverequest_i_372dde8e_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_historicalleaverequest_history_tags
    ADD CONSTRAINT leave_historicalleavereq_historicalleaverequest_i_372dde8e_uniq UNIQUE (historicalleaverequest_id, audittag_id);


--
-- Name: leave_historicalleaverequest_history_tags leave_historicalleaverequest_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_historicalleaverequest_history_tags
    ADD CONSTRAINT leave_historicalleaverequest_history_tags_pkey PRIMARY KEY (id);


--
-- Name: leave_historicalleaverequest leave_historicalleaverequest_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_historicalleaverequest
    ADD CONSTRAINT leave_historicalleaverequest_pkey PRIMARY KEY (history_id);


--
-- Name: leave_holiday leave_holiday_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_holiday
    ADD CONSTRAINT leave_holiday_pkey PRIMARY KEY (id);


--
-- Name: leave_leaveallocationrequestcomment_files leave_leaveallocationreq_leaveallocationrequestco_af245abc_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_leaveallocationrequestcomment_files
    ADD CONSTRAINT leave_leaveallocationreq_leaveallocationrequestco_af245abc_uniq UNIQUE (leaveallocationrequestcomment_id, leaverequestfile_id);


--
-- Name: leave_leaveallocationrequest leave_leaveallocationrequest_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_leaveallocationrequest
    ADD CONSTRAINT leave_leaveallocationrequest_pkey PRIMARY KEY (id);


--
-- Name: leave_leaveallocationrequestcomment_files leave_leaveallocationrequestcomment_files_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_leaveallocationrequestcomment_files
    ADD CONSTRAINT leave_leaveallocationrequestcomment_files_pkey PRIMARY KEY (id);


--
-- Name: leave_leaveallocationrequestcomment leave_leaveallocationrequestcomment_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_leaveallocationrequestcomment
    ADD CONSTRAINT leave_leaveallocationrequestcomment_pkey PRIMARY KEY (id);


--
-- Name: leave_leavegeneralsetting leave_leavegeneralsetting_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_leavegeneralsetting
    ADD CONSTRAINT leave_leavegeneralsetting_pkey PRIMARY KEY (id);


--
-- Name: leave_leaverequest leave_leaverequest_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_leaverequest
    ADD CONSTRAINT leave_leaverequest_pkey PRIMARY KEY (id);


--
-- Name: leave_leaverequestcomment_files leave_leaverequestcommen_leaverequestcomment_id_l_ee6bd659_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_leaverequestcomment_files
    ADD CONSTRAINT leave_leaverequestcommen_leaverequestcomment_id_l_ee6bd659_uniq UNIQUE (leaverequestcomment_id, leaverequestfile_id);


--
-- Name: leave_leaverequestcomment_files leave_leaverequestcomment_files_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_leaverequestcomment_files
    ADD CONSTRAINT leave_leaverequestcomment_files_pkey PRIMARY KEY (id);


--
-- Name: leave_leaverequestcomment leave_leaverequestcomment_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_leaverequestcomment
    ADD CONSTRAINT leave_leaverequestcomment_pkey PRIMARY KEY (id);


--
-- Name: leave_leaverequestconditionapproval leave_leaverequestconditionapproval_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_leaverequestconditionapproval
    ADD CONSTRAINT leave_leaverequestconditionapproval_pkey PRIMARY KEY (id);


--
-- Name: leave_leaverequestfile leave_leaverequestfile_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_leaverequestfile
    ADD CONSTRAINT leave_leaverequestfile_pkey PRIMARY KEY (id);


--
-- Name: leave_leavetype leave_leavetype_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_leavetype
    ADD CONSTRAINT leave_leavetype_pkey PRIMARY KEY (id);


--
-- Name: leave_overrideleaverequests leave_overrideleaverequests_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_overrideleaverequests
    ADD CONSTRAINT leave_overrideleaverequests_pkey PRIMARY KEY (leaverequest_ptr_id);


--
-- Name: leave_restrictleave_exclued_leave_types leave_restrictleave_excl_restrictleave_id_leavety_1a764607_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_restrictleave_exclued_leave_types
    ADD CONSTRAINT leave_restrictleave_excl_restrictleave_id_leavety_1a764607_uniq UNIQUE (restrictleave_id, leavetype_id);


--
-- Name: leave_restrictleave_exclued_leave_types leave_restrictleave_exclued_leave_types_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_restrictleave_exclued_leave_types
    ADD CONSTRAINT leave_restrictleave_exclued_leave_types_pkey PRIMARY KEY (id);


--
-- Name: leave_restrictleave_job_position leave_restrictleave_job__restrictleave_id_jobposi_2942864b_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_restrictleave_job_position
    ADD CONSTRAINT leave_restrictleave_job__restrictleave_id_jobposi_2942864b_uniq UNIQUE (restrictleave_id, jobposition_id);


--
-- Name: leave_restrictleave_job_position leave_restrictleave_job_position_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_restrictleave_job_position
    ADD CONSTRAINT leave_restrictleave_job_position_pkey PRIMARY KEY (id);


--
-- Name: leave_restrictleave leave_restrictleave_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_restrictleave
    ADD CONSTRAINT leave_restrictleave_pkey PRIMARY KEY (id);


--
-- Name: leave_restrictleave_spesific_leave_types leave_restrictleave_spes_restrictleave_id_leavety_7afd39f1_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_restrictleave_spesific_leave_types
    ADD CONSTRAINT leave_restrictleave_spes_restrictleave_id_leavety_7afd39f1_uniq UNIQUE (restrictleave_id, leavetype_id);


--
-- Name: leave_restrictleave_spesific_leave_types leave_restrictleave_spesific_leave_types_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.leave_restrictleave_spesific_leave_types
    ADD CONSTRAINT leave_restrictleave_spesific_leave_types_pkey PRIMARY KEY (id);


--
-- Name: notifications_notification notifications_notification_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.notifications_notification
    ADD CONSTRAINT notifications_notification_pkey PRIMARY KEY (id);


--
-- Name: offboarding_employeetask offboarding_employeetask_employee_id_id_task_id_i_bcf65e60_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_employeetask
    ADD CONSTRAINT offboarding_employeetask_employee_id_id_task_id_i_bcf65e60_uniq UNIQUE (employee_id_id, task_id_id);


--
-- Name: offboarding_employeetask offboarding_employeetask_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_employeetask
    ADD CONSTRAINT offboarding_employeetask_pkey PRIMARY KEY (id);


--
-- Name: offboarding_exitreason_attachments offboarding_exitreason_a_exitreason_id_offboardin_c9d6b1c4_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_exitreason_attachments
    ADD CONSTRAINT offboarding_exitreason_a_exitreason_id_offboardin_c9d6b1c4_uniq UNIQUE (exitreason_id, offboardingstagemultiplefile_id);


--
-- Name: offboarding_exitreason_attachments offboarding_exitreason_attachments_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_exitreason_attachments
    ADD CONSTRAINT offboarding_exitreason_attachments_pkey PRIMARY KEY (id);


--
-- Name: offboarding_exitreason offboarding_exitreason_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_exitreason
    ADD CONSTRAINT offboarding_exitreason_pkey PRIMARY KEY (id);


--
-- Name: offboarding_historicalemployeetask_history_tags offboarding_historicalem_historicalemployeetask_i_f7313a04_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_historicalemployeetask_history_tags
    ADD CONSTRAINT offboarding_historicalem_historicalemployeetask_i_f7313a04_uniq UNIQUE (historicalemployeetask_id, audittag_id);


--
-- Name: offboarding_historicalemployeetask_history_tags offboarding_historicalemployeetask_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_historicalemployeetask_history_tags
    ADD CONSTRAINT offboarding_historicalemployeetask_history_tags_pkey PRIMARY KEY (id);


--
-- Name: offboarding_historicalemployeetask offboarding_historicalemployeetask_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_historicalemployeetask
    ADD CONSTRAINT offboarding_historicalemployeetask_pkey PRIMARY KEY (history_id);


--
-- Name: offboarding_offboarding_managers offboarding_offboarding__offboarding_id_employee__5c67fd17_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_offboarding_managers
    ADD CONSTRAINT offboarding_offboarding__offboarding_id_employee__5c67fd17_uniq UNIQUE (offboarding_id, employee_id);


--
-- Name: offboarding_offboarding_managers offboarding_offboarding_managers_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_offboarding_managers
    ADD CONSTRAINT offboarding_offboarding_managers_pkey PRIMARY KEY (id);


--
-- Name: offboarding_offboarding offboarding_offboarding_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_offboarding
    ADD CONSTRAINT offboarding_offboarding_pkey PRIMARY KEY (id);


--
-- Name: offboarding_offboardingemployee offboarding_offboardingemployee_employee_id_id_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_offboardingemployee
    ADD CONSTRAINT offboarding_offboardingemployee_employee_id_id_key UNIQUE (employee_id_id);


--
-- Name: offboarding_offboardingemployee offboarding_offboardingemployee_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_offboardingemployee
    ADD CONSTRAINT offboarding_offboardingemployee_pkey PRIMARY KEY (id);


--
-- Name: offboarding_offboardinggeneralsetting offboarding_offboardinggeneralsetting_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_offboardinggeneralsetting
    ADD CONSTRAINT offboarding_offboardinggeneralsetting_pkey PRIMARY KEY (id);


--
-- Name: offboarding_offboardingnote_attachments offboarding_offboardingn_offboardingnote_id_offbo_07700d00_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_offboardingnote_attachments
    ADD CONSTRAINT offboarding_offboardingn_offboardingnote_id_offbo_07700d00_uniq UNIQUE (offboardingnote_id, offboardingstagemultiplefile_id);


--
-- Name: offboarding_offboardingnote_attachments offboarding_offboardingnote_attachments_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_offboardingnote_attachments
    ADD CONSTRAINT offboarding_offboardingnote_attachments_pkey PRIMARY KEY (id);


--
-- Name: offboarding_offboardingnote offboarding_offboardingnote_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_offboardingnote
    ADD CONSTRAINT offboarding_offboardingnote_pkey PRIMARY KEY (id);


--
-- Name: offboarding_offboardingstage_managers offboarding_offboardings_offboardingstage_id_empl_4eb651fd_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_offboardingstage_managers
    ADD CONSTRAINT offboarding_offboardings_offboardingstage_id_empl_4eb651fd_uniq UNIQUE (offboardingstage_id, employee_id);


--
-- Name: offboarding_offboardingstage_managers offboarding_offboardingstage_managers_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_offboardingstage_managers
    ADD CONSTRAINT offboarding_offboardingstage_managers_pkey PRIMARY KEY (id);


--
-- Name: offboarding_offboardingstage offboarding_offboardingstage_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_offboardingstage
    ADD CONSTRAINT offboarding_offboardingstage_pkey PRIMARY KEY (id);


--
-- Name: offboarding_offboardingstagemultiplefile offboarding_offboardingstagemultiplefile_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_offboardingstagemultiplefile
    ADD CONSTRAINT offboarding_offboardingstagemultiplefile_pkey PRIMARY KEY (id);


--
-- Name: offboarding_offboardingtask_managers offboarding_offboardingt_offboardingtask_id_emplo_89c39d5e_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_offboardingtask_managers
    ADD CONSTRAINT offboarding_offboardingt_offboardingtask_id_emplo_89c39d5e_uniq UNIQUE (offboardingtask_id, employee_id);


--
-- Name: offboarding_offboardingtask_managers offboarding_offboardingtask_managers_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_offboardingtask_managers
    ADD CONSTRAINT offboarding_offboardingtask_managers_pkey PRIMARY KEY (id);


--
-- Name: offboarding_offboardingtask offboarding_offboardingtask_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_offboardingtask
    ADD CONSTRAINT offboarding_offboardingtask_pkey PRIMARY KEY (id);


--
-- Name: offboarding_offboardingtask offboarding_offboardingtask_title_stage_id_id_0b02fd34_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_offboardingtask
    ADD CONSTRAINT offboarding_offboardingtask_title_stage_id_id_0b02fd34_uniq UNIQUE (title, stage_id_id);


--
-- Name: offboarding_resignationletter offboarding_resignationletter_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.offboarding_resignationletter
    ADD CONSTRAINT offboarding_resignationletter_pkey PRIMARY KEY (id);


--
-- Name: onboarding_candidatestage onboarding_candidatestage_candidate_id_id_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.onboarding_candidatestage
    ADD CONSTRAINT onboarding_candidatestage_candidate_id_id_key UNIQUE (candidate_id_id);


--
-- Name: onboarding_candidatestage onboarding_candidatestage_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.onboarding_candidatestage
    ADD CONSTRAINT onboarding_candidatestage_pkey PRIMARY KEY (id);


--
-- Name: onboarding_candidatetask onboarding_candidatetask_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.onboarding_candidatetask
    ADD CONSTRAINT onboarding_candidatetask_pkey PRIMARY KEY (id);


--
-- Name: onboarding_historicalcandidatetask_history_tags onboarding_historicalcan_historicalcandidatetask__c5eeb41e_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.onboarding_historicalcandidatetask_history_tags
    ADD CONSTRAINT onboarding_historicalcan_historicalcandidatetask__c5eeb41e_uniq UNIQUE (historicalcandidatetask_id, audittag_id);


--
-- Name: onboarding_historicalcandidatetask_history_tags onboarding_historicalcandidatetask_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.onboarding_historicalcandidatetask_history_tags
    ADD CONSTRAINT onboarding_historicalcandidatetask_history_tags_pkey PRIMARY KEY (id);


--
-- Name: onboarding_historicalcandidatetask onboarding_historicalcandidatetask_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.onboarding_historicalcandidatetask
    ADD CONSTRAINT onboarding_historicalcandidatetask_pkey PRIMARY KEY (history_id);


--
-- Name: onboarding_onboardingportal onboarding_onboardingportal_candidate_id_id_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.onboarding_onboardingportal
    ADD CONSTRAINT onboarding_onboardingportal_candidate_id_id_key UNIQUE (candidate_id_id);


--
-- Name: onboarding_onboardingportal onboarding_onboardingportal_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.onboarding_onboardingportal
    ADD CONSTRAINT onboarding_onboardingportal_pkey PRIMARY KEY (id);


--
-- Name: onboarding_onboardingstage_employee_id onboarding_onboardingsta_onboardingstage_id_emplo_37a5f72a_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.onboarding_onboardingstage_employee_id
    ADD CONSTRAINT onboarding_onboardingsta_onboardingstage_id_emplo_37a5f72a_uniq UNIQUE (onboardingstage_id, employee_id);


--
-- Name: onboarding_onboardingstage_employee_id onboarding_onboardingstage_employee_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.onboarding_onboardingstage_employee_id
    ADD CONSTRAINT onboarding_onboardingstage_employee_id_pkey PRIMARY KEY (id);


--
-- Name: onboarding_onboardingstage onboarding_onboardingstage_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.onboarding_onboardingstage
    ADD CONSTRAINT onboarding_onboardingstage_pkey PRIMARY KEY (id);


--
-- Name: onboarding_onboardingtask_candidates onboarding_onboardingtas_onboardingtask_id_candid_40a4bedb_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.onboarding_onboardingtask_candidates
    ADD CONSTRAINT onboarding_onboardingtas_onboardingtask_id_candid_40a4bedb_uniq UNIQUE (onboardingtask_id, candidate_id);


--
-- Name: onboarding_onboardingtask_employee_id onboarding_onboardingtas_onboardingtask_id_employ_14e249fa_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.onboarding_onboardingtask_employee_id
    ADD CONSTRAINT onboarding_onboardingtas_onboardingtask_id_employ_14e249fa_uniq UNIQUE (onboardingtask_id, employee_id);


--
-- Name: onboarding_onboardingtask_candidates onboarding_onboardingtask_candidates_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.onboarding_onboardingtask_candidates
    ADD CONSTRAINT onboarding_onboardingtask_candidates_pkey PRIMARY KEY (id);


--
-- Name: onboarding_onboardingtask_employee_id onboarding_onboardingtask_employee_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.onboarding_onboardingtask_employee_id
    ADD CONSTRAINT onboarding_onboardingtask_employee_id_pkey PRIMARY KEY (id);


--
-- Name: onboarding_onboardingtask onboarding_onboardingtask_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.onboarding_onboardingtask
    ADD CONSTRAINT onboarding_onboardingtask_pkey PRIMARY KEY (id);


--
-- Name: payroll_allowance_exclude_employees payroll_allowance_exclud_allowance_id_employee_id_1c31b105_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_allowance_exclude_employees
    ADD CONSTRAINT payroll_allowance_exclud_allowance_id_employee_id_1c31b105_uniq UNIQUE (allowance_id, employee_id);


--
-- Name: payroll_allowance_exclude_employees payroll_allowance_exclude_employees_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_allowance_exclude_employees
    ADD CONSTRAINT payroll_allowance_exclude_employees_pkey PRIMARY KEY (id);


--
-- Name: payroll_allowance_other_conditions payroll_allowance_other__allowance_id_multiplecon_ff137d60_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_allowance_other_conditions
    ADD CONSTRAINT payroll_allowance_other__allowance_id_multiplecon_ff137d60_uniq UNIQUE (allowance_id, multiplecondition_id);


--
-- Name: payroll_allowance_other_conditions payroll_allowance_other_conditions_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_allowance_other_conditions
    ADD CONSTRAINT payroll_allowance_other_conditions_pkey PRIMARY KEY (id);


--
-- Name: payroll_allowance payroll_allowance_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_allowance
    ADD CONSTRAINT payroll_allowance_pkey PRIMARY KEY (id);


--
-- Name: payroll_allowance_specific_employees payroll_allowance_specif_allowance_id_employee_id_00a48a04_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_allowance_specific_employees
    ADD CONSTRAINT payroll_allowance_specif_allowance_id_employee_id_00a48a04_uniq UNIQUE (allowance_id, employee_id);


--
-- Name: payroll_allowance_specific_employees payroll_allowance_specific_employees_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_allowance_specific_employees
    ADD CONSTRAINT payroll_allowance_specific_employees_pkey PRIMARY KEY (id);


--
-- Name: payroll_allowance payroll_allowance_title_is_taxable_is_cond_6fe89b5e_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_allowance
    ADD CONSTRAINT payroll_allowance_title_is_taxable_is_cond_6fe89b5e_uniq UNIQUE (title, is_taxable, is_condition_based, field, condition, value, is_fixed, amount, based_on, rate, per_attendance_fixed_amount, shift_id_id, shift_per_attendance_amount, amount_per_one_hr, work_type_id_id, work_type_per_attendance_amount);


--
-- Name: payroll_contract payroll_contract_employee_id_id_contract__eb2a98b3_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_contract
    ADD CONSTRAINT payroll_contract_employee_id_id_contract__eb2a98b3_uniq UNIQUE (employee_id_id, contract_start_date, contract_end_date);


--
-- Name: payroll_contract payroll_contract_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_contract
    ADD CONSTRAINT payroll_contract_pkey PRIMARY KEY (id);


--
-- Name: payroll_deduction_exclude_employees payroll_deduction_exclud_deduction_id_employee_id_dc35ad86_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_deduction_exclude_employees
    ADD CONSTRAINT payroll_deduction_exclud_deduction_id_employee_id_dc35ad86_uniq UNIQUE (deduction_id, employee_id);


--
-- Name: payroll_deduction_exclude_employees payroll_deduction_exclude_employees_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_deduction_exclude_employees
    ADD CONSTRAINT payroll_deduction_exclude_employees_pkey PRIMARY KEY (id);


--
-- Name: payroll_deduction_other_conditions payroll_deduction_other__deduction_id_multiplecon_0c6b2fc2_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_deduction_other_conditions
    ADD CONSTRAINT payroll_deduction_other__deduction_id_multiplecon_0c6b2fc2_uniq UNIQUE (deduction_id, multiplecondition_id);


--
-- Name: payroll_deduction_other_conditions payroll_deduction_other_conditions_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_deduction_other_conditions
    ADD CONSTRAINT payroll_deduction_other_conditions_pkey PRIMARY KEY (id);


--
-- Name: payroll_deduction payroll_deduction_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_deduction
    ADD CONSTRAINT payroll_deduction_pkey PRIMARY KEY (id);


--
-- Name: payroll_deduction_specific_employees payroll_deduction_specif_deduction_id_employee_id_5a87e86f_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_deduction_specific_employees
    ADD CONSTRAINT payroll_deduction_specif_deduction_id_employee_id_5a87e86f_uniq UNIQUE (deduction_id, employee_id);


--
-- Name: payroll_deduction_specific_employees payroll_deduction_specific_employees_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_deduction_specific_employees
    ADD CONSTRAINT payroll_deduction_specific_employees_pkey PRIMARY KEY (id);


--
-- Name: payroll_encashmentgeneralsettings payroll_encashmentgeneralsettings_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_encashmentgeneralsettings
    ADD CONSTRAINT payroll_encashmentgeneralsettings_pkey PRIMARY KEY (id);


--
-- Name: payroll_filingstatus payroll_filingstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_filingstatus
    ADD CONSTRAINT payroll_filingstatus_pkey PRIMARY KEY (id);


--
-- Name: payroll_historicalcontract_history_tags payroll_historicalcontra_historicalcontract_id_au_076972f8_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_historicalcontract_history_tags
    ADD CONSTRAINT payroll_historicalcontra_historicalcontract_id_au_076972f8_uniq UNIQUE (historicalcontract_id, audittag_id);


--
-- Name: payroll_historicalcontract_history_tags payroll_historicalcontract_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_historicalcontract_history_tags
    ADD CONSTRAINT payroll_historicalcontract_history_tags_pkey PRIMARY KEY (id);


--
-- Name: payroll_historicalcontract payroll_historicalcontract_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_historicalcontract
    ADD CONSTRAINT payroll_historicalcontract_pkey PRIMARY KEY (history_id);


--
-- Name: payroll_historicalpayslip_history_tags payroll_historicalpaysli_historicalpayslip_id_aud_eba05fac_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_historicalpayslip_history_tags
    ADD CONSTRAINT payroll_historicalpaysli_historicalpayslip_id_aud_eba05fac_uniq UNIQUE (historicalpayslip_id, audittag_id);


--
-- Name: payroll_historicalpayslip_history_tags payroll_historicalpayslip_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_historicalpayslip_history_tags
    ADD CONSTRAINT payroll_historicalpayslip_history_tags_pkey PRIMARY KEY (id);


--
-- Name: payroll_historicalpayslip payroll_historicalpayslip_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_historicalpayslip
    ADD CONSTRAINT payroll_historicalpayslip_pkey PRIMARY KEY (history_id);


--
-- Name: payroll_loanaccount_deduction_ids payroll_loanaccount_dedu_loanaccount_id_deduction_c7fe8d5b_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_loanaccount_deduction_ids
    ADD CONSTRAINT payroll_loanaccount_dedu_loanaccount_id_deduction_c7fe8d5b_uniq UNIQUE (loanaccount_id, deduction_id);


--
-- Name: payroll_loanaccount_deduction_ids payroll_loanaccount_deduction_ids_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_loanaccount_deduction_ids
    ADD CONSTRAINT payroll_loanaccount_deduction_ids_pkey PRIMARY KEY (id);


--
-- Name: payroll_loanaccount payroll_loanaccount_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_loanaccount
    ADD CONSTRAINT payroll_loanaccount_pkey PRIMARY KEY (id);


--
-- Name: payroll_multiplecondition payroll_multiplecondition_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_multiplecondition
    ADD CONSTRAINT payroll_multiplecondition_pkey PRIMARY KEY (id);


--
-- Name: payroll_overrideattendance payroll_overrideattendance_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_overrideattendance
    ADD CONSTRAINT payroll_overrideattendance_pkey PRIMARY KEY (attendance_ptr_id);


--
-- Name: payroll_overrideleaverequest payroll_overrideleaverequest_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_overrideleaverequest
    ADD CONSTRAINT payroll_overrideleaverequest_pkey PRIMARY KEY (leaverequest_ptr_id);


--
-- Name: payroll_payrollgeneralsetting payroll_payrollgeneralsetting_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_payrollgeneralsetting
    ADD CONSTRAINT payroll_payrollgeneralsetting_pkey PRIMARY KEY (id);


--
-- Name: payroll_payrollsettings payroll_payrollsettings_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_payrollsettings
    ADD CONSTRAINT payroll_payrollsettings_pkey PRIMARY KEY (id);


--
-- Name: payroll_payslip_installment_ids payroll_payslip_installm_payslip_id_deduction_id_35cc6afc_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_payslip_installment_ids
    ADD CONSTRAINT payroll_payslip_installm_payslip_id_deduction_id_35cc6afc_uniq UNIQUE (payslip_id, deduction_id);


--
-- Name: payroll_payslip_installment_ids payroll_payslip_installment_ids_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_payslip_installment_ids
    ADD CONSTRAINT payroll_payslip_installment_ids_pkey PRIMARY KEY (id);


--
-- Name: payroll_payslip payroll_payslip_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_payslip
    ADD CONSTRAINT payroll_payslip_pkey PRIMARY KEY (id);


--
-- Name: payroll_payslipautogenerate payroll_payslipautogenerate_company_id_id_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_payslipautogenerate
    ADD CONSTRAINT payroll_payslipautogenerate_company_id_id_key UNIQUE (company_id_id);


--
-- Name: payroll_payslipautogenerate payroll_payslipautogenerate_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_payslipautogenerate
    ADD CONSTRAINT payroll_payslipautogenerate_pkey PRIMARY KEY (id);


--
-- Name: payroll_reimbursement_other_attachments payroll_reimbursement_ot_reimbursement_id_reimbur_1f69f3e4_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_reimbursement_other_attachments
    ADD CONSTRAINT payroll_reimbursement_ot_reimbursement_id_reimbur_1f69f3e4_uniq UNIQUE (reimbursement_id, reimbursementmultipleattachment_id);


--
-- Name: payroll_reimbursement_other_attachments payroll_reimbursement_other_attachments_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_reimbursement_other_attachments
    ADD CONSTRAINT payroll_reimbursement_other_attachments_pkey PRIMARY KEY (id);


--
-- Name: payroll_reimbursement payroll_reimbursement_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_reimbursement
    ADD CONSTRAINT payroll_reimbursement_pkey PRIMARY KEY (id);


--
-- Name: payroll_reimbursementfile payroll_reimbursementfile_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_reimbursementfile
    ADD CONSTRAINT payroll_reimbursementfile_pkey PRIMARY KEY (id);


--
-- Name: payroll_reimbursementmultipleattachment payroll_reimbursementmultipleattachment_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_reimbursementmultipleattachment
    ADD CONSTRAINT payroll_reimbursementmultipleattachment_pkey PRIMARY KEY (id);


--
-- Name: payroll_reimbursementrequestcomment_files payroll_reimbursementreq_reimbursementrequestcomm_74c24a9a_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_reimbursementrequestcomment_files
    ADD CONSTRAINT payroll_reimbursementreq_reimbursementrequestcomm_74c24a9a_uniq UNIQUE (reimbursementrequestcomment_id, reimbursementfile_id);


--
-- Name: payroll_reimbursementrequestcomment_files payroll_reimbursementrequestcomment_files_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_reimbursementrequestcomment_files
    ADD CONSTRAINT payroll_reimbursementrequestcomment_files_pkey PRIMARY KEY (id);


--
-- Name: payroll_reimbursementrequestcomment payroll_reimbursementrequestcomment_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_reimbursementrequestcomment
    ADD CONSTRAINT payroll_reimbursementrequestcomment_pkey PRIMARY KEY (id);


--
-- Name: payroll_taxbracket payroll_taxbracket_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_taxbracket
    ADD CONSTRAINT payroll_taxbracket_pkey PRIMARY KEY (id);


--
-- Name: payroll_workrecord payroll_workrecord_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.payroll_workrecord
    ADD CONSTRAINT payroll_workrecord_pkey PRIMARY KEY (id);


--
-- Name: pms_anonymousfeedback pms_anonymousfeedback_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_anonymousfeedback
    ADD CONSTRAINT pms_anonymousfeedback_pkey PRIMARY KEY (id);


--
-- Name: pms_answer pms_answer_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_answer
    ADD CONSTRAINT pms_answer_pkey PRIMARY KEY (id);


--
-- Name: pms_bonuspointsetting pms_bonuspointsetting_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_bonuspointsetting
    ADD CONSTRAINT pms_bonuspointsetting_pkey PRIMARY KEY (id);


--
-- Name: pms_comment pms_comment_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_comment
    ADD CONSTRAINT pms_comment_pkey PRIMARY KEY (id);


--
-- Name: pms_employeebonuspoint pms_employeebonuspoint_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_employeebonuspoint
    ADD CONSTRAINT pms_employeebonuspoint_pkey PRIMARY KEY (id);


--
-- Name: pms_employeekeyresult pms_employeekeyresult_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_employeekeyresult
    ADD CONSTRAINT pms_employeekeyresult_pkey PRIMARY KEY (id);


--
-- Name: pms_employeeobjective pms_employeeobjective_employee_id_id_objective_43958940_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_employeeobjective
    ADD CONSTRAINT pms_employeeobjective_employee_id_id_objective_43958940_uniq UNIQUE (employee_id_id, objective_id_id);


--
-- Name: pms_employeeobjective_key_result_id pms_employeeobjective_ke_employeeobjective_id_key_5805522f_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_employeeobjective_key_result_id
    ADD CONSTRAINT pms_employeeobjective_ke_employeeobjective_id_key_5805522f_uniq UNIQUE (employeeobjective_id, keyresult_id);


--
-- Name: pms_employeeobjective_key_result_id pms_employeeobjective_key_result_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_employeeobjective_key_result_id
    ADD CONSTRAINT pms_employeeobjective_key_result_id_pkey PRIMARY KEY (id);


--
-- Name: pms_employeeobjective pms_employeeobjective_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_employeeobjective
    ADD CONSTRAINT pms_employeeobjective_pkey PRIMARY KEY (id);


--
-- Name: pms_feedback_colleague_id pms_feedback_colleague_id_feedback_id_employee_id_5917eb05_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_feedback_colleague_id
    ADD CONSTRAINT pms_feedback_colleague_id_feedback_id_employee_id_5917eb05_uniq UNIQUE (feedback_id, employee_id);


--
-- Name: pms_feedback_colleague_id pms_feedback_colleague_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_feedback_colleague_id
    ADD CONSTRAINT pms_feedback_colleague_id_pkey PRIMARY KEY (id);


--
-- Name: pms_feedback_employee_key_results_id pms_feedback_employee_ke_feedback_id_employeekeyr_94683c65_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_feedback_employee_key_results_id
    ADD CONSTRAINT pms_feedback_employee_ke_feedback_id_employeekeyr_94683c65_uniq UNIQUE (feedback_id, employeekeyresult_id);


--
-- Name: pms_feedback_employee_key_results_id pms_feedback_employee_key_results_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_feedback_employee_key_results_id
    ADD CONSTRAINT pms_feedback_employee_key_results_id_pkey PRIMARY KEY (id);


--
-- Name: pms_feedback_others_id pms_feedback_others_id_feedback_id_employee_id_2387a2b5_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_feedback_others_id
    ADD CONSTRAINT pms_feedback_others_id_feedback_id_employee_id_2387a2b5_uniq UNIQUE (feedback_id, employee_id);


--
-- Name: pms_feedback_others_id pms_feedback_others_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_feedback_others_id
    ADD CONSTRAINT pms_feedback_others_id_pkey PRIMARY KEY (id);


--
-- Name: pms_feedback pms_feedback_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_feedback
    ADD CONSTRAINT pms_feedback_pkey PRIMARY KEY (id);


--
-- Name: pms_feedback_subordinate_id pms_feedback_subordinate_feedback_id_employee_id_1d1e97b3_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_feedback_subordinate_id
    ADD CONSTRAINT pms_feedback_subordinate_feedback_id_employee_id_1d1e97b3_uniq UNIQUE (feedback_id, employee_id);


--
-- Name: pms_feedback_subordinate_id pms_feedback_subordinate_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_feedback_subordinate_id
    ADD CONSTRAINT pms_feedback_subordinate_id_pkey PRIMARY KEY (id);


--
-- Name: pms_historicalcomment_history_tags pms_historicalcomment_hi_historicalcomment_id_aud_4f42d5e5_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_historicalcomment_history_tags
    ADD CONSTRAINT pms_historicalcomment_hi_historicalcomment_id_aud_4f42d5e5_uniq UNIQUE (historicalcomment_id, audittag_id);


--
-- Name: pms_historicalcomment_history_tags pms_historicalcomment_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_historicalcomment_history_tags
    ADD CONSTRAINT pms_historicalcomment_history_tags_pkey PRIMARY KEY (id);


--
-- Name: pms_historicalcomment pms_historicalcomment_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_historicalcomment
    ADD CONSTRAINT pms_historicalcomment_pkey PRIMARY KEY (history_id);


--
-- Name: pms_historicalemployeekeyresult_history_tags pms_historicalemployeeke_historicalemployeekeyres_4d7877d9_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_historicalemployeekeyresult_history_tags
    ADD CONSTRAINT pms_historicalemployeeke_historicalemployeekeyres_4d7877d9_uniq UNIQUE (historicalemployeekeyresult_id, audittag_id);


--
-- Name: pms_historicalemployeekeyresult_history_tags pms_historicalemployeekeyresult_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_historicalemployeekeyresult_history_tags
    ADD CONSTRAINT pms_historicalemployeekeyresult_history_tags_pkey PRIMARY KEY (id);


--
-- Name: pms_historicalemployeekeyresult pms_historicalemployeekeyresult_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_historicalemployeekeyresult
    ADD CONSTRAINT pms_historicalemployeekeyresult_pkey PRIMARY KEY (history_id);


--
-- Name: pms_historicalemployeeobjective_history_tags pms_historicalemployeeob_historicalemployeeobject_9a5033a7_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_historicalemployeeobjective_history_tags
    ADD CONSTRAINT pms_historicalemployeeob_historicalemployeeobject_9a5033a7_uniq UNIQUE (historicalemployeeobjective_id, audittag_id);


--
-- Name: pms_historicalemployeeobjective_history_tags pms_historicalemployeeobjective_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_historicalemployeeobjective_history_tags
    ADD CONSTRAINT pms_historicalemployeeobjective_history_tags_pkey PRIMARY KEY (id);


--
-- Name: pms_historicalemployeeobjective pms_historicalemployeeobjective_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_historicalemployeeobjective
    ADD CONSTRAINT pms_historicalemployeeobjective_pkey PRIMARY KEY (history_id);


--
-- Name: pms_historicalkeyresult_history_tags pms_historicalkeyresult__historicalkeyresult_id_a_6dd852d3_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_historicalkeyresult_history_tags
    ADD CONSTRAINT pms_historicalkeyresult__historicalkeyresult_id_a_6dd852d3_uniq UNIQUE (historicalkeyresult_id, audittag_id);


--
-- Name: pms_historicalkeyresult_history_tags pms_historicalkeyresult_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_historicalkeyresult_history_tags
    ADD CONSTRAINT pms_historicalkeyresult_history_tags_pkey PRIMARY KEY (id);


--
-- Name: pms_historicalkeyresult pms_historicalkeyresult_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_historicalkeyresult
    ADD CONSTRAINT pms_historicalkeyresult_pkey PRIMARY KEY (history_id);


--
-- Name: pms_historicalobjective_history_tags pms_historicalobjective__historicalobjective_id_a_b040f07c_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_historicalobjective_history_tags
    ADD CONSTRAINT pms_historicalobjective__historicalobjective_id_a_b040f07c_uniq UNIQUE (historicalobjective_id, audittag_id);


--
-- Name: pms_historicalobjective_history_tags pms_historicalobjective_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_historicalobjective_history_tags
    ADD CONSTRAINT pms_historicalobjective_history_tags_pkey PRIMARY KEY (id);


--
-- Name: pms_historicalobjective pms_historicalobjective_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_historicalobjective
    ADD CONSTRAINT pms_historicalobjective_pkey PRIMARY KEY (history_id);


--
-- Name: pms_keyresult pms_keyresult_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_keyresult
    ADD CONSTRAINT pms_keyresult_pkey PRIMARY KEY (id);


--
-- Name: pms_keyresultfeedback pms_keyresultfeedback_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_keyresultfeedback
    ADD CONSTRAINT pms_keyresultfeedback_pkey PRIMARY KEY (id);


--
-- Name: pms_meetings_answer_employees pms_meetings_answer_empl_meetings_id_employee_id_dc7c3906_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_meetings_answer_employees
    ADD CONSTRAINT pms_meetings_answer_empl_meetings_id_employee_id_dc7c3906_uniq UNIQUE (meetings_id, employee_id);


--
-- Name: pms_meetings_answer_employees pms_meetings_answer_employees_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_meetings_answer_employees
    ADD CONSTRAINT pms_meetings_answer_employees_pkey PRIMARY KEY (id);


--
-- Name: pms_meetings_employee_id pms_meetings_employee_id_meetings_id_employee_id_2a3f7b31_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_meetings_employee_id
    ADD CONSTRAINT pms_meetings_employee_id_meetings_id_employee_id_2a3f7b31_uniq UNIQUE (meetings_id, employee_id);


--
-- Name: pms_meetings_employee_id pms_meetings_employee_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_meetings_employee_id
    ADD CONSTRAINT pms_meetings_employee_id_pkey PRIMARY KEY (id);


--
-- Name: pms_meetings_manager pms_meetings_manager_meetings_id_employee_id_df2c379c_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_meetings_manager
    ADD CONSTRAINT pms_meetings_manager_meetings_id_employee_id_df2c379c_uniq UNIQUE (meetings_id, employee_id);


--
-- Name: pms_meetings_manager pms_meetings_manager_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_meetings_manager
    ADD CONSTRAINT pms_meetings_manager_pkey PRIMARY KEY (id);


--
-- Name: pms_meetings pms_meetings_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_meetings
    ADD CONSTRAINT pms_meetings_pkey PRIMARY KEY (id);


--
-- Name: pms_meetingsanswer pms_meetingsanswer_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_meetingsanswer
    ADD CONSTRAINT pms_meetingsanswer_pkey PRIMARY KEY (id);


--
-- Name: pms_objective_assignees pms_objective_assignees_objective_id_employee_id_ad2dd765_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_objective_assignees
    ADD CONSTRAINT pms_objective_assignees_objective_id_employee_id_ad2dd765_uniq UNIQUE (objective_id, employee_id);


--
-- Name: pms_objective_assignees pms_objective_assignees_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_objective_assignees
    ADD CONSTRAINT pms_objective_assignees_pkey PRIMARY KEY (id);


--
-- Name: pms_objective_key_result_id pms_objective_key_result_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_objective_key_result_id
    ADD CONSTRAINT pms_objective_key_result_id_pkey PRIMARY KEY (id);


--
-- Name: pms_objective_key_result_id pms_objective_key_result_objective_id_keyresult_i_497b7b26_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_objective_key_result_id
    ADD CONSTRAINT pms_objective_key_result_objective_id_keyresult_i_497b7b26_uniq UNIQUE (objective_id, keyresult_id);


--
-- Name: pms_objective_managers pms_objective_managers_objective_id_employee_id_f4870c00_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_objective_managers
    ADD CONSTRAINT pms_objective_managers_objective_id_employee_id_f4870c00_uniq UNIQUE (objective_id, employee_id);


--
-- Name: pms_objective_managers pms_objective_managers_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_objective_managers
    ADD CONSTRAINT pms_objective_managers_pkey PRIMARY KEY (id);


--
-- Name: pms_objective pms_objective_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_objective
    ADD CONSTRAINT pms_objective_pkey PRIMARY KEY (id);


--
-- Name: pms_period_company_id pms_period_company_id_period_id_company_id_6e9a8642_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_period_company_id
    ADD CONSTRAINT pms_period_company_id_period_id_company_id_6e9a8642_uniq UNIQUE (period_id, company_id);


--
-- Name: pms_period_company_id pms_period_company_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_period_company_id
    ADD CONSTRAINT pms_period_company_id_pkey PRIMARY KEY (id);


--
-- Name: pms_period pms_period_period_name_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_period
    ADD CONSTRAINT pms_period_period_name_key UNIQUE (period_name);


--
-- Name: pms_period pms_period_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_period
    ADD CONSTRAINT pms_period_pkey PRIMARY KEY (id);


--
-- Name: pms_question pms_question_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_question
    ADD CONSTRAINT pms_question_pkey PRIMARY KEY (id);


--
-- Name: pms_questionoptions pms_questionoptions_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_questionoptions
    ADD CONSTRAINT pms_questionoptions_pkey PRIMARY KEY (id);


--
-- Name: pms_questiontemplate_company_id pms_questiontemplate_com_questiontemplate_id_comp_438940ba_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_questiontemplate_company_id
    ADD CONSTRAINT pms_questiontemplate_com_questiontemplate_id_comp_438940ba_uniq UNIQUE (questiontemplate_id, company_id);


--
-- Name: pms_questiontemplate_company_id pms_questiontemplate_company_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_questiontemplate_company_id
    ADD CONSTRAINT pms_questiontemplate_company_id_pkey PRIMARY KEY (id);


--
-- Name: pms_questiontemplate pms_questiontemplate_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_questiontemplate
    ADD CONSTRAINT pms_questiontemplate_pkey PRIMARY KEY (id);


--
-- Name: pms_questiontemplate pms_questiontemplate_question_template_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.pms_questiontemplate
    ADD CONSTRAINT pms_questiontemplate_question_template_key UNIQUE (question_template);


--
-- Name: project_project_managers project_project_managers_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.project_project_managers
    ADD CONSTRAINT project_project_managers_pkey PRIMARY KEY (id);


--
-- Name: project_project_managers project_project_managers_project_id_employee_id_c59a3413_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.project_project_managers
    ADD CONSTRAINT project_project_managers_project_id_employee_id_c59a3413_uniq UNIQUE (project_id, employee_id);


--
-- Name: project_project_members project_project_members_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.project_project_members
    ADD CONSTRAINT project_project_members_pkey PRIMARY KEY (id);


--
-- Name: project_project_members project_project_members_project_id_employee_id_7f97fe37_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.project_project_members
    ADD CONSTRAINT project_project_members_project_id_employee_id_7f97fe37_uniq UNIQUE (project_id, employee_id);


--
-- Name: project_project project_project_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.project_project
    ADD CONSTRAINT project_project_pkey PRIMARY KEY (id);


--
-- Name: project_project project_project_title_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.project_project
    ADD CONSTRAINT project_project_title_key UNIQUE (title);


--
-- Name: project_projectstage project_projectstage_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.project_projectstage
    ADD CONSTRAINT project_projectstage_pkey PRIMARY KEY (id);


--
-- Name: project_projectstage project_projectstage_project_id_title_a112c883_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.project_projectstage
    ADD CONSTRAINT project_projectstage_project_id_title_a112c883_uniq UNIQUE (project_id, title);


--
-- Name: project_task project_task_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.project_task
    ADD CONSTRAINT project_task_pkey PRIMARY KEY (id);


--
-- Name: project_task project_task_project_id_title_6fcfd47f_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.project_task
    ADD CONSTRAINT project_task_project_id_title_6fcfd47f_uniq UNIQUE (project_id, title);


--
-- Name: project_task_task_managers project_task_task_managers_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.project_task_task_managers
    ADD CONSTRAINT project_task_task_managers_pkey PRIMARY KEY (id);


--
-- Name: project_task_task_managers project_task_task_managers_task_id_employee_id_0b566032_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.project_task_task_managers
    ADD CONSTRAINT project_task_task_managers_task_id_employee_id_0b566032_uniq UNIQUE (task_id, employee_id);


--
-- Name: project_task_task_members project_task_task_members_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.project_task_task_members
    ADD CONSTRAINT project_task_task_members_pkey PRIMARY KEY (id);


--
-- Name: project_task_task_members project_task_task_members_task_id_employee_id_cec0475b_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.project_task_task_members
    ADD CONSTRAINT project_task_task_members_task_id_employee_id_cec0475b_uniq UNIQUE (task_id, employee_id);


--
-- Name: project_timesheet project_timesheet_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.project_timesheet
    ADD CONSTRAINT project_timesheet_pkey PRIMARY KEY (id);


--
-- Name: recruitment_candidate recruitment_candidate_email_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_candidate
    ADD CONSTRAINT recruitment_candidate_email_key UNIQUE (email);


--
-- Name: recruitment_candidate recruitment_candidate_email_recruitment_id_id_2d38a838_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_candidate
    ADD CONSTRAINT recruitment_candidate_email_recruitment_id_id_2d38a838_uniq UNIQUE (email, recruitment_id_id);


--
-- Name: recruitment_candidate recruitment_candidate_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_candidate
    ADD CONSTRAINT recruitment_candidate_pkey PRIMARY KEY (id);


--
-- Name: recruitment_candidatedocumentrequest_candidate_id recruitment_candidatedoc_candidatedocumentrequest_287d5959_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_candidatedocumentrequest_candidate_id
    ADD CONSTRAINT recruitment_candidatedoc_candidatedocumentrequest_287d5959_uniq UNIQUE (candidatedocumentrequest_id, candidate_id);


--
-- Name: recruitment_candidatedocument recruitment_candidatedocument_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_candidatedocument
    ADD CONSTRAINT recruitment_candidatedocument_pkey PRIMARY KEY (id);


--
-- Name: recruitment_candidatedocumentrequest_candidate_id recruitment_candidatedocumentrequest_candidate_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_candidatedocumentrequest_candidate_id
    ADD CONSTRAINT recruitment_candidatedocumentrequest_candidate_id_pkey PRIMARY KEY (id);


--
-- Name: recruitment_candidatedocumentrequest recruitment_candidatedocumentrequest_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_candidatedocumentrequest
    ADD CONSTRAINT recruitment_candidatedocumentrequest_pkey PRIMARY KEY (id);


--
-- Name: recruitment_candidaterating recruitment_candidaterat_employee_id_id_candidate_1e72748e_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_candidaterating
    ADD CONSTRAINT recruitment_candidaterat_employee_id_id_candidate_1e72748e_uniq UNIQUE (employee_id_id, candidate_id_id);


--
-- Name: recruitment_candidaterating recruitment_candidaterating_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_candidaterating
    ADD CONSTRAINT recruitment_candidaterating_pkey PRIMARY KEY (id);


--
-- Name: recruitment_historicalcandidate_history_tags recruitment_historicalca_historicalcandidate_id_a_8a9083b7_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_historicalcandidate_history_tags
    ADD CONSTRAINT recruitment_historicalca_historicalcandidate_id_a_8a9083b7_uniq UNIQUE (historicalcandidate_id, audittag_id);


--
-- Name: recruitment_historicalcandidate_history_tags recruitment_historicalcandidate_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_historicalcandidate_history_tags
    ADD CONSTRAINT recruitment_historicalcandidate_history_tags_pkey PRIMARY KEY (id);


--
-- Name: recruitment_historicalcandidate recruitment_historicalcandidate_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_historicalcandidate
    ADD CONSTRAINT recruitment_historicalcandidate_pkey PRIMARY KEY (history_id);


--
-- Name: recruitment_historicalrejectedcandidate_history_tags recruitment_historicalre_historicalrejectedcandid_eb843d90_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_historicalrejectedcandidate_history_tags
    ADD CONSTRAINT recruitment_historicalre_historicalrejectedcandid_eb843d90_uniq UNIQUE (historicalrejectedcandidate_id, audittag_id);


--
-- Name: recruitment_historicalrejectedcandidate_history_tags recruitment_historicalrejectedcandidate_history_tags_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_historicalrejectedcandidate_history_tags
    ADD CONSTRAINT recruitment_historicalrejectedcandidate_history_tags_pkey PRIMARY KEY (id);


--
-- Name: recruitment_historicalrejectedcandidate recruitment_historicalrejectedcandidate_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_historicalrejectedcandidate
    ADD CONSTRAINT recruitment_historicalrejectedcandidate_pkey PRIMARY KEY (history_id);


--
-- Name: recruitment_interviewschedule_employee_id recruitment_interviewsch_interviewschedule_id_emp_34c14bfc_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_interviewschedule_employee_id
    ADD CONSTRAINT recruitment_interviewsch_interviewschedule_id_emp_34c14bfc_uniq UNIQUE (interviewschedule_id, employee_id);


--
-- Name: recruitment_interviewschedule_employee_id recruitment_interviewschedule_employee_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_interviewschedule_employee_id
    ADD CONSTRAINT recruitment_interviewschedule_employee_id_pkey PRIMARY KEY (id);


--
-- Name: recruitment_interviewschedule recruitment_interviewschedule_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_interviewschedule
    ADD CONSTRAINT recruitment_interviewschedule_pkey PRIMARY KEY (id);


--
-- Name: recruitment_linkedinaccount recruitment_linkedinaccount_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_linkedinaccount
    ADD CONSTRAINT recruitment_linkedinaccount_pkey PRIMARY KEY (id);


--
-- Name: recruitment_linkedinaccount recruitment_linkedinaccount_sub_id_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_linkedinaccount
    ADD CONSTRAINT recruitment_linkedinaccount_sub_id_key UNIQUE (sub_id);


--
-- Name: recruitment_questionordering recruitment_questionordering_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_questionordering
    ADD CONSTRAINT recruitment_questionordering_pkey PRIMARY KEY (id);


--
-- Name: recruitment_recruitment_recruitment_managers recruitment_recruitment__recruitment_id_employee__685bc030_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_recruitment_recruitment_managers
    ADD CONSTRAINT recruitment_recruitment__recruitment_id_employee__685bc030_uniq UNIQUE (recruitment_id, employee_id);


--
-- Name: recruitment_recruitment_open_positions recruitment_recruitment__recruitment_id_jobpositi_dd7d1b27_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_recruitment_open_positions
    ADD CONSTRAINT recruitment_recruitment__recruitment_id_jobpositi_dd7d1b27_uniq UNIQUE (recruitment_id, jobposition_id);


--
-- Name: recruitment_recruitment_skills recruitment_recruitment__recruitment_id_skill_id_9d15d780_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_recruitment_skills
    ADD CONSTRAINT recruitment_recruitment__recruitment_id_skill_id_9d15d780_uniq UNIQUE (recruitment_id, skill_id);


--
-- Name: recruitment_recruitment_survey_templates recruitment_recruitment__recruitment_id_surveytem_9d52b3b1_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_recruitment_survey_templates
    ADD CONSTRAINT recruitment_recruitment__recruitment_id_surveytem_9d52b3b1_uniq UNIQUE (recruitment_id, surveytemplate_id);


--
-- Name: recruitment_recruitment recruitment_recruitment_job_position_id_id_start_5247efe7_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_recruitment
    ADD CONSTRAINT recruitment_recruitment_job_position_id_id_start_5247efe7_uniq UNIQUE (job_position_id_id, start_date, company_id_id);


--
-- Name: recruitment_recruitment recruitment_recruitment_job_position_id_id_start_5785e5bf_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_recruitment
    ADD CONSTRAINT recruitment_recruitment_job_position_id_id_start_5785e5bf_uniq UNIQUE (job_position_id_id, start_date);


--
-- Name: recruitment_recruitment_open_positions recruitment_recruitment_open_positions_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_recruitment_open_positions
    ADD CONSTRAINT recruitment_recruitment_open_positions_pkey PRIMARY KEY (id);


--
-- Name: recruitment_recruitment recruitment_recruitment_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_recruitment
    ADD CONSTRAINT recruitment_recruitment_pkey PRIMARY KEY (id);


--
-- Name: recruitment_recruitment_recruitment_managers recruitment_recruitment_recruitment_managers_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_recruitment_recruitment_managers
    ADD CONSTRAINT recruitment_recruitment_recruitment_managers_pkey PRIMARY KEY (id);


--
-- Name: recruitment_recruitment_skills recruitment_recruitment_skills_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_recruitment_skills
    ADD CONSTRAINT recruitment_recruitment_skills_pkey PRIMARY KEY (id);


--
-- Name: recruitment_recruitment_survey_templates recruitment_recruitment_survey_templates_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_recruitment_survey_templates
    ADD CONSTRAINT recruitment_recruitment_survey_templates_pkey PRIMARY KEY (id);


--
-- Name: recruitment_recruitmentgeneralsetting recruitment_recruitmentgeneralsetting_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_recruitmentgeneralsetting
    ADD CONSTRAINT recruitment_recruitmentgeneralsetting_pkey PRIMARY KEY (id);


--
-- Name: recruitment_recruitmentsurvey_job_position_ids recruitment_recruitments_recruitmentsurvey_id_job_06322710_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_recruitmentsurvey_job_position_ids
    ADD CONSTRAINT recruitment_recruitments_recruitmentsurvey_id_job_06322710_uniq UNIQUE (recruitmentsurvey_id, jobposition_id);


--
-- Name: recruitment_recruitmentsurvey_recruitment_ids recruitment_recruitments_recruitmentsurvey_id_rec_71c5480b_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_recruitmentsurvey_recruitment_ids
    ADD CONSTRAINT recruitment_recruitments_recruitmentsurvey_id_rec_71c5480b_uniq UNIQUE (recruitmentsurvey_id, recruitment_id);


--
-- Name: recruitment_recruitmentsurvey_template_id recruitment_recruitments_recruitmentsurvey_id_sur_4062fb17_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_recruitmentsurvey_template_id
    ADD CONSTRAINT recruitment_recruitments_recruitmentsurvey_id_sur_4062fb17_uniq UNIQUE (recruitmentsurvey_id, surveytemplate_id);


--
-- Name: recruitment_recruitmentsurvey_job_position_ids recruitment_recruitmentsurvey_job_position_ids_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_recruitmentsurvey_job_position_ids
    ADD CONSTRAINT recruitment_recruitmentsurvey_job_position_ids_pkey PRIMARY KEY (id);


--
-- Name: recruitment_recruitmentsurvey recruitment_recruitmentsurvey_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_recruitmentsurvey
    ADD CONSTRAINT recruitment_recruitmentsurvey_pkey PRIMARY KEY (id);


--
-- Name: recruitment_recruitmentsurvey_recruitment_ids recruitment_recruitmentsurvey_recruitment_ids_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_recruitmentsurvey_recruitment_ids
    ADD CONSTRAINT recruitment_recruitmentsurvey_recruitment_ids_pkey PRIMARY KEY (id);


--
-- Name: recruitment_recruitmentsurvey_template_id recruitment_recruitmentsurvey_template_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_recruitmentsurvey_template_id
    ADD CONSTRAINT recruitment_recruitmentsurvey_template_id_pkey PRIMARY KEY (id);


--
-- Name: recruitment_recruitmentsurveyanswer recruitment_recruitmentsurveyanswer_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_recruitmentsurveyanswer
    ADD CONSTRAINT recruitment_recruitmentsurveyanswer_pkey PRIMARY KEY (id);


--
-- Name: recruitment_rejectedcandidate_reject_reason_id recruitment_rejectedcand_rejectedcandidate_id_rej_c4d4a5a0_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_rejectedcandidate_reject_reason_id
    ADD CONSTRAINT recruitment_rejectedcand_rejectedcandidate_id_rej_c4d4a5a0_uniq UNIQUE (rejectedcandidate_id, rejectreason_id);


--
-- Name: recruitment_rejectedcandidate recruitment_rejectedcandidate_candidate_id_id_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_rejectedcandidate
    ADD CONSTRAINT recruitment_rejectedcandidate_candidate_id_id_key UNIQUE (candidate_id_id);


--
-- Name: recruitment_rejectedcandidate recruitment_rejectedcandidate_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_rejectedcandidate
    ADD CONSTRAINT recruitment_rejectedcandidate_pkey PRIMARY KEY (id);


--
-- Name: recruitment_rejectedcandidate_reject_reason_id recruitment_rejectedcandidate_reject_reason_id_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_rejectedcandidate_reject_reason_id
    ADD CONSTRAINT recruitment_rejectedcandidate_reject_reason_id_pkey PRIMARY KEY (id);


--
-- Name: recruitment_rejectreason recruitment_rejectreason_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_rejectreason
    ADD CONSTRAINT recruitment_rejectreason_pkey PRIMARY KEY (id);


--
-- Name: recruitment_resume recruitment_resume_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_resume
    ADD CONSTRAINT recruitment_resume_pkey PRIMARY KEY (id);


--
-- Name: recruitment_skill recruitment_skill_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_skill
    ADD CONSTRAINT recruitment_skill_pkey PRIMARY KEY (id);


--
-- Name: recruitment_skillzone recruitment_skillzone_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_skillzone
    ADD CONSTRAINT recruitment_skillzone_pkey PRIMARY KEY (id);


--
-- Name: recruitment_skillzonecandidate recruitment_skillzonecandidate_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_skillzonecandidate
    ADD CONSTRAINT recruitment_skillzonecandidate_pkey PRIMARY KEY (id);


--
-- Name: recruitment_stage recruitment_stage_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_stage
    ADD CONSTRAINT recruitment_stage_pkey PRIMARY KEY (id);


--
-- Name: recruitment_stage recruitment_stage_recruitment_id_id_stage_41b4d1c0_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_stage
    ADD CONSTRAINT recruitment_stage_recruitment_id_id_stage_41b4d1c0_uniq UNIQUE (recruitment_id_id, stage);


--
-- Name: recruitment_stage_stage_managers recruitment_stage_stage__stage_id_employee_id_2ce70681_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_stage_stage_managers
    ADD CONSTRAINT recruitment_stage_stage__stage_id_employee_id_2ce70681_uniq UNIQUE (stage_id, employee_id);


--
-- Name: recruitment_stage_stage_managers recruitment_stage_stage_managers_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_stage_stage_managers
    ADD CONSTRAINT recruitment_stage_stage_managers_pkey PRIMARY KEY (id);


--
-- Name: recruitment_stagefiles recruitment_stagefiles_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_stagefiles
    ADD CONSTRAINT recruitment_stagefiles_pkey PRIMARY KEY (id);


--
-- Name: recruitment_stagenote recruitment_stagenote_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_stagenote
    ADD CONSTRAINT recruitment_stagenote_pkey PRIMARY KEY (id);


--
-- Name: recruitment_stagenote_stage_files recruitment_stagenote_st_stagenote_id_stagefiles__2f931248_uniq; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_stagenote_stage_files
    ADD CONSTRAINT recruitment_stagenote_st_stagenote_id_stagefiles__2f931248_uniq UNIQUE (stagenote_id, stagefiles_id);


--
-- Name: recruitment_stagenote_stage_files recruitment_stagenote_stage_files_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_stagenote_stage_files
    ADD CONSTRAINT recruitment_stagenote_stage_files_pkey PRIMARY KEY (id);


--
-- Name: recruitment_surveytemplate recruitment_surveytemplate_pkey; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_surveytemplate
    ADD CONSTRAINT recruitment_surveytemplate_pkey PRIMARY KEY (id);


--
-- Name: recruitment_surveytemplate recruitment_surveytemplate_title_key; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.recruitment_surveytemplate
    ADD CONSTRAINT recruitment_surveytemplate_title_key UNIQUE (title);


--
-- Name: django_apscheduler_djangojobexecution unique_job_executions; Type: CONSTRAINT; Schema: public; Owner: horilla
--

ALTER TABLE ONLY public.django_apscheduler_djangojobexecution
    ADD CONSTRAINT unique_job_executions UNIQUE (job_id, run_time);


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

CREATE INDEX accessibility_defaultacces_defaultaccessibility_id_914de53f ON public.accessibility_defaultaccessibility_employees USING btree (defaultaccessibility_id);


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

CREATE INDEX accessibility_defaultacces_employee_id_41ccfcfa ON public.accessibility_defaultaccessibility_employees USING btree (employee_id);


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

CREATE INDEX accessibility_defaultaccessibility_created_by_id_ff9332a2 ON public.accessibility_defaultaccessibility USING btree (created_by_id);


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

CREATE INDEX accessibility_defaultaccessibility_modified_by_id_0b00d519 ON public.accessibility_defaultaccessibility USING btree (modified_by_id);


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

CREATE INDEX asset_asset_asset_category_id_id_2d1f69ff ON public.asset_asset USING btree (asset_category_id_id);


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

CREATE INDEX asset_asset_asset_lot_number_id_id_5b307bec ON public.asset_asset USING btree (asset_lot_number_id_id);


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

CREATE INDEX asset_asset_asset_tracking_id_1c945a40_like ON public.asset_asset USING btree (asset_tracking_id varchar_pattern_ops);


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

CREATE INDEX asset_asset_created_by_id_3ee1315a ON public.asset_asset USING btree (created_by_id);


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

CREATE INDEX asset_asset_modified_by_id_b605c1ff ON public.asset_asset USING btree (modified_by_id);


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

CREATE INDEX asset_asset_owner_id_d2d14c87 ON public.asset_asset USING btree (owner_id);


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

CREATE INDEX asset_assetassignment_asset_id_id_40e00806 ON public.asset_assetassignment USING btree (asset_id_id);


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

CREATE INDEX asset_assetassignment_assign_images_assetassignment_id_27ad361a ON public.asset_assetassignment_assign_images USING btree (assetassignment_id);


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

CREATE INDEX asset_assetassignment_assign_images_returnimages_id_cedd3c37 ON public.asset_assetassignment_assign_images USING btree (returnimages_id);


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

CREATE INDEX asset_assetassignment_assigned_by_employee_id_id_0f42bd27 ON public.asset_assetassignment USING btree (assigned_by_employee_id_id);


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

CREATE INDEX asset_assetassignment_assigned_to_employee_id_id_79cc5925 ON public.asset_assetassignment USING btree (assigned_to_employee_id_id);


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

CREATE INDEX asset_assetassignment_created_by_id_d7b91bfa ON public.asset_assetassignment USING btree (created_by_id);


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

CREATE INDEX asset_assetassignment_modified_by_id_f4f5446e ON public.asset_assetassignment USING btree (modified_by_id);


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

CREATE INDEX asset_assetassignment_return_images_assetassignment_id_f72aa0a3 ON public.asset_assetassignment_return_images USING btree (assetassignment_id);


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

CREATE INDEX asset_assetassignment_return_images_returnimages_id_b0ee2930 ON public.asset_assetassignment_return_images USING btree (returnimages_id);


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

CREATE INDEX asset_assetcategory_asset_category_name_cdf507f0_like ON public.asset_assetcategory USING btree (asset_category_name varchar_pattern_ops);


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

CREATE INDEX asset_assetcategory_company_id_assetcategory_id_bbbe3f1d ON public.asset_assetcategory_company_id USING btree (assetcategory_id);


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

CREATE INDEX asset_assetcategory_company_id_company_id_61918643 ON public.asset_assetcategory_company_id USING btree (company_id);


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

CREATE INDEX asset_assetcategory_created_by_id_c99b90f0 ON public.asset_assetcategory USING btree (created_by_id);


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

CREATE INDEX asset_assetcategory_modified_by_id_bd92ea34 ON public.asset_assetcategory USING btree (modified_by_id);


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

CREATE INDEX asset_assetdocuments_asset_report_id_5d283992 ON public.asset_assetdocuments USING btree (asset_report_id);


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

CREATE INDEX asset_assetdocuments_created_by_id_ed1eb431 ON public.asset_assetdocuments USING btree (created_by_id);


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

CREATE INDEX asset_assetdocuments_modified_by_id_2263fe64 ON public.asset_assetdocuments USING btree (modified_by_id);


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

CREATE INDEX asset_assetlot_company_id_assetlot_id_3625ff56 ON public.asset_assetlot_company_id USING btree (assetlot_id);


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

CREATE INDEX asset_assetlot_company_id_company_id_d784df99 ON public.asset_assetlot_company_id USING btree (company_id);


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

CREATE INDEX asset_assetlot_created_by_id_67eb34f5 ON public.asset_assetlot USING btree (created_by_id);


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

CREATE INDEX asset_assetlot_lot_number_9fae5e52_like ON public.asset_assetlot USING btree (lot_number varchar_pattern_ops);


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

CREATE INDEX asset_assetlot_modified_by_id_06990993 ON public.asset_assetlot USING btree (modified_by_id);


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

CREATE INDEX asset_assetreport_asset_id_id_f03a6292 ON public.asset_assetreport USING btree (asset_id_id);


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

CREATE INDEX asset_assetreport_created_by_id_65f2a72b ON public.asset_assetreport USING btree (created_by_id);


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

CREATE INDEX asset_assetreport_modified_by_id_bd66b671 ON public.asset_assetreport USING btree (modified_by_id);


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

CREATE INDEX asset_assetrequest_asset_category_id_id_818a04db ON public.asset_assetrequest USING btree (asset_category_id_id);


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

CREATE INDEX asset_assetrequest_created_by_id_142e3757 ON public.asset_assetrequest USING btree (created_by_id);


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

CREATE INDEX asset_assetrequest_modified_by_id_ede6ba77 ON public.asset_assetrequest USING btree (modified_by_id);


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

CREATE INDEX asset_assetrequest_requested_employee_id_id_51386fae ON public.asset_assetrequest USING btree (requested_employee_id_id);


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

CREATE INDEX asset_returnimages_created_by_id_593a7b20 ON public.asset_returnimages USING btree (created_by_id);


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

CREATE INDEX asset_returnimages_modified_by_id_9dcbbb09 ON public.asset_returnimages USING btree (modified_by_id);


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

CREATE INDEX attendance_attendance_attendance_day_id_8bb2b869 ON public.attendance_attendance USING btree (attendance_day_id);


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

CREATE INDEX attendance_attendance_batch_attendance_id_id_3f1b552b ON public.attendance_attendance USING btree (batch_attendance_id_id);


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

CREATE INDEX attendance_attendance_created_by_id_621a60fa ON public.attendance_attendance USING btree (created_by_id);


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

CREATE INDEX attendance_attendance_employee_id_id_a63854dc ON public.attendance_attendance USING btree (employee_id_id);


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

CREATE INDEX attendance_attendance_modified_by_id_e2e344c7 ON public.attendance_attendance USING btree (modified_by_id);


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

CREATE INDEX attendance_attendance_shift_id_id_6fba51aa ON public.attendance_attendance USING btree (shift_id_id);


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

CREATE INDEX attendance_attendance_work_type_id_id_f370eeed ON public.attendance_attendance USING btree (work_type_id_id);


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

CREATE INDEX attendance_attendanceactivity_created_by_id_c64cdac8 ON public.attendance_attendanceactivity USING btree (created_by_id);


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

CREATE INDEX attendance_attendanceactivity_employee_id_id_387d5d6c ON public.attendance_attendanceactivity USING btree (employee_id_id);


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

CREATE INDEX attendance_attendanceactivity_modified_by_id_90e38a42 ON public.attendance_attendanceactivity USING btree (modified_by_id);


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

CREATE INDEX attendance_attendanceactivity_shift_day_id_21632240 ON public.attendance_attendanceactivity USING btree (shift_day_id);


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

CREATE INDEX attendance_attendancegeneralsetting_company_id_id_49d8b388 ON public.attendance_attendancegeneralsetting USING btree (company_id_id);


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

CREATE INDEX attendance_attendancegeneralsetting_created_by_id_5d369b31 ON public.attendance_attendancegeneralsetting USING btree (created_by_id);


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

CREATE INDEX attendance_attendancegeneralsetting_modified_by_id_3b013cdc ON public.attendance_attendancegeneralsetting USING btree (modified_by_id);


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

CREATE INDEX attendance_attendancelatecomeearlyout_attendance_id_id_86e48a6d ON public.attendance_attendancelatecomeearlyout USING btree (attendance_id_id);


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

CREATE INDEX attendance_attendancelatecomeearlyout_created_by_id_c07050a1 ON public.attendance_attendancelatecomeearlyout USING btree (created_by_id);


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

CREATE INDEX attendance_attendancelatecomeearlyout_employee_id_id_98d63dab ON public.attendance_attendancelatecomeearlyout USING btree (employee_id_id);


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

CREATE INDEX attendance_attendancelatecomeearlyout_modified_by_id_ca21b8da ON public.attendance_attendancelatecomeearlyout USING btree (modified_by_id);


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

CREATE INDEX attendance_attendanceovertime_created_by_id_8128ac7c ON public.attendance_attendanceovertime USING btree (created_by_id);


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

CREATE INDEX attendance_attendanceovertime_employee_id_id_b7422c25 ON public.attendance_attendanceovertime USING btree (employee_id_id);


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

CREATE INDEX attendance_attendanceovertime_modified_by_id_7a752250 ON public.attendance_attendanceovertime USING btree (modified_by_id);


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

CREATE INDEX attendance_attendancereque_attendancerequestcomment_i_a80fed87 ON public.attendance_attendancerequestcomment_files USING btree (attendancerequestcomment_id);


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

CREATE INDEX attendance_attendancereque_attendancerequestfile_id_f9332418 ON public.attendance_attendancerequestcomment_files USING btree (attendancerequestfile_id);


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

CREATE INDEX attendance_attendancerequestcomment_created_by_id_d47327ee ON public.attendance_attendancerequestcomment USING btree (created_by_id);


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

CREATE INDEX attendance_attendancerequestcomment_employee_id_id_287f91f6 ON public.attendance_attendancerequestcomment USING btree (employee_id_id);


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

CREATE INDEX attendance_attendancerequestcomment_modified_by_id_574591a7 ON public.attendance_attendancerequestcomment USING btree (modified_by_id);


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

CREATE INDEX attendance_attendancerequestcomment_request_id_id_e906b582 ON public.attendance_attendancerequestcomment USING btree (request_id_id);


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

CREATE INDEX attendance_attendancerequestfile_created_by_id_0b196a4d ON public.attendance_attendancerequestfile USING btree (created_by_id);


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

CREATE INDEX attendance_attendancerequestfile_modified_by_id_ed5b3154 ON public.attendance_attendancerequestfile USING btree (modified_by_id);


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

CREATE INDEX attendance_attendancevalid_attendancevalidationcondit_435e89ec ON public.attendance_attendancevalidationcondition_company_id USING btree (attendancevalidationcondition_id);


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

CREATE INDEX attendance_attendancevalid_company_id_15bf7647 ON public.attendance_attendancevalidationcondition_company_id USING btree (company_id);


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

CREATE INDEX attendance_attendancevalid_modified_by_id_2e4b51ba ON public.attendance_attendancevalidationcondition USING btree (modified_by_id);


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

CREATE INDEX attendance_attendancevalidationcondition_created_by_id_b84b1ab2 ON public.attendance_attendancevalidationcondition USING btree (created_by_id);


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

CREATE INDEX attendance_batchattendance_created_by_id_3e782e45 ON public.attendance_batchattendance USING btree (created_by_id);


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

CREATE INDEX attendance_batchattendance_modified_by_id_b5388e3b ON public.attendance_batchattendance USING btree (modified_by_id);


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

CREATE INDEX attendance_gracetime_company_id_company_id_942808b8 ON public.attendance_gracetime_company_id USING btree (company_id);


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

CREATE INDEX attendance_gracetime_company_id_gracetime_id_a47c5ae4 ON public.attendance_gracetime_company_id USING btree (gracetime_id);


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

CREATE INDEX attendance_gracetime_created_by_id_2819c6c7 ON public.attendance_gracetime USING btree (created_by_id);


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

CREATE INDEX attendance_gracetime_modified_by_id_e0be5422 ON public.attendance_gracetime USING btree (modified_by_id);


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

CREATE INDEX attendance_historicalatten_audittag_id_22b5d483 ON public.attendance_historicalattendance_history_tags USING btree (audittag_id);


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

CREATE INDEX attendance_historicalatten_historicalattendance_id_cd419b72 ON public.attendance_historicalattendance_history_tags USING btree (historicalattendance_id);


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

CREATE INDEX attendance_historicalattendance_attendance_day_id_baac678e ON public.attendance_historicalattendance USING btree (attendance_day_id);


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

CREATE INDEX attendance_historicalattendance_batch_attendance_id_id_c198b93a ON public.attendance_historicalattendance USING btree (batch_attendance_id_id);


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

CREATE INDEX attendance_historicalattendance_created_by_id_9a6c92b3 ON public.attendance_historicalattendance USING btree (created_by_id);


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

CREATE INDEX attendance_historicalattendance_employee_id_id_61bf4b8b ON public.attendance_historicalattendance USING btree (employee_id_id);


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

CREATE INDEX attendance_historicalattendance_history_date_6bb06c70 ON public.attendance_historicalattendance USING btree (history_date);


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

CREATE INDEX attendance_historicalattendance_history_relation_id_8dd5eefa ON public.attendance_historicalattendance USING btree (history_relation_id);


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

CREATE INDEX attendance_historicalattendance_history_user_id_0cb04709 ON public.attendance_historicalattendance USING btree (history_user_id);


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

CREATE INDEX attendance_historicalattendance_id_f6ca4b2d ON public.attendance_historicalattendance USING btree (id);


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

CREATE INDEX attendance_historicalattendance_modified_by_id_4d29539a ON public.attendance_historicalattendance USING btree (modified_by_id);


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

CREATE INDEX attendance_historicalattendance_shift_id_id_f99f84a2 ON public.attendance_historicalattendance USING btree (shift_id_id);


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

CREATE INDEX attendance_historicalattendance_work_type_id_id_49209f61 ON public.attendance_historicalattendance USING btree (work_type_id_id);


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

CREATE INDEX attendance_workrecords_attendance_id_id_132d38b9 ON public.attendance_workrecords USING btree (attendance_id_id);


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

CREATE INDEX attendance_workrecords_employee_id_id_a533961f ON public.attendance_workrecords USING btree (employee_id_id);


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

CREATE INDEX attendance_workrecords_leave_request_id_id_1c671bdb ON public.attendance_workrecords USING btree (leave_request_id_id);


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

CREATE INDEX attendance_workrecords_shift_id_id_d25e8ebb ON public.attendance_workrecords USING btree (shift_id_id);


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

CREATE INDEX auditlog_logentry_action_229afe39 ON public.auditlog_logentry USING btree (action);


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

CREATE INDEX auditlog_logentry_actor_id_959271d2 ON public.auditlog_logentry USING btree (actor_id);


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

CREATE INDEX auditlog_logentry_cid_9f467263 ON public.auditlog_logentry USING btree (cid);


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

CREATE INDEX auditlog_logentry_cid_9f467263_like ON public.auditlog_logentry USING btree (cid varchar_pattern_ops);


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

CREATE INDEX auditlog_logentry_content_type_id_75830218 ON public.auditlog_logentry USING btree (content_type_id);


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

CREATE INDEX auditlog_logentry_object_id_09c2eee8 ON public.auditlog_logentry USING btree (object_id);


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

CREATE INDEX auditlog_logentry_object_pk_6e3219c0 ON public.auditlog_logentry USING btree (object_pk);


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

CREATE INDEX auditlog_logentry_object_pk_6e3219c0_like ON public.auditlog_logentry USING btree (object_pk varchar_pattern_ops);


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

CREATE INDEX auditlog_logentry_timestamp_37867bb0 ON public.auditlog_logentry USING btree ("timestamp");


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

CREATE INDEX auth_group_name_a6ea08ec_like ON public.auth_group USING btree (name varchar_pattern_ops);


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

CREATE INDEX auth_group_permissions_group_id_b120cbf9 ON public.auth_group_permissions USING btree (group_id);


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

CREATE INDEX auth_group_permissions_permission_id_84c5c92e ON public.auth_group_permissions USING btree (permission_id);


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

CREATE INDEX auth_permission_content_type_id_2f476e4b ON public.auth_permission USING btree (content_type_id);


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

CREATE INDEX auth_user_groups_group_id_97559544 ON public.auth_user_groups USING btree (group_id);


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

CREATE INDEX auth_user_groups_user_id_6a12ed8b ON public.auth_user_groups USING btree (user_id);


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

CREATE INDEX auth_user_user_permissions_permission_id_1fbb5f2c ON public.auth_user_user_permissions USING btree (permission_id);


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

CREATE INDEX auth_user_user_permissions_user_id_a95ead1b ON public.auth_user_user_permissions USING btree (user_id);


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

CREATE INDEX auth_user_username_6821ab7c_like ON public.auth_user USING btree (username varchar_pattern_ops);


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

CREATE INDEX base_announcement_attachments_announcement_id_28c89de7 ON public.base_announcement_attachments USING btree (announcement_id);


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

CREATE INDEX base_announcement_attachments_attachment_id_d426ada6 ON public.base_announcement_attachments USING btree (attachment_id);


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

CREATE INDEX base_announcement_company_id_announcement_id_88c3a5db ON public.base_announcement_company_id USING btree (announcement_id);


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

CREATE INDEX base_announcement_company_id_company_id_3159799c ON public.base_announcement_company_id USING btree (company_id);


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

CREATE INDEX base_announcement_created_by_id_60c3675f ON public.base_announcement USING btree (created_by_id);


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

CREATE INDEX base_announcement_department_announcement_id_1fc854a1 ON public.base_announcement_department USING btree (announcement_id);


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

CREATE INDEX base_announcement_department_department_id_58667008 ON public.base_announcement_department USING btree (department_id);


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

CREATE INDEX base_announcement_employees_announcement_id_6420dc09 ON public.base_announcement_employees USING btree (announcement_id);


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

CREATE INDEX base_announcement_employees_employee_id_59b0c73f ON public.base_announcement_employees USING btree (employee_id);


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

CREATE INDEX base_announcement_filtered_employees_announcement_id_d818df54 ON public.base_announcement_filtered_employees USING btree (announcement_id);


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

CREATE INDEX base_announcement_filtered_employees_employee_id_6b6dcc8c ON public.base_announcement_filtered_employees USING btree (employee_id);


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

CREATE INDEX base_announcement_job_position_announcement_id_733faa88 ON public.base_announcement_job_position USING btree (announcement_id);


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

CREATE INDEX base_announcement_job_position_jobposition_id_884b606d ON public.base_announcement_job_position USING btree (jobposition_id);


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

CREATE INDEX base_announcement_modified_by_id_bd30f74b ON public.base_announcement USING btree (modified_by_id);


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

CREATE INDEX base_announcementcomment_announcement_id_id_6b41613d ON public.base_announcementcomment USING btree (announcement_id_id);


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

CREATE INDEX base_announcementcomment_created_by_id_4972b6e5 ON public.base_announcementcomment USING btree (created_by_id);


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

CREATE INDEX base_announcementcomment_employee_id_id_1aba795e ON public.base_announcementcomment USING btree (employee_id_id);


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

CREATE INDEX base_announcementcomment_modified_by_id_cec87a65 ON public.base_announcementcomment USING btree (modified_by_id);


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

CREATE INDEX base_announcementview_announcement_id_30dc6c43 ON public.base_announcementview USING btree (announcement_id);


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

CREATE INDEX base_announcementview_user_id_3de12961 ON public.base_announcementview USING btree (user_id);


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

CREATE INDEX base_biometricattendance_company_id_id_79e0cd9e ON public.base_biometricattendance USING btree (company_id_id);


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

CREATE INDEX base_company_created_by_id_0a5eae8c ON public.base_company USING btree (created_by_id);


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

CREATE INDEX base_company_modified_by_id_7f84ef61 ON public.base_company USING btree (modified_by_id);


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

CREATE INDEX base_companyleaves_company_id_id_59a8dee0 ON public.base_companyleaves USING btree (company_id_id);


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

CREATE INDEX base_companyleaves_created_by_id_c5d3ba1d ON public.base_companyleaves USING btree (created_by_id);


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

CREATE INDEX base_companyleaves_modified_by_id_d98a6c67 ON public.base_companyleaves USING btree (modified_by_id);


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

CREATE INDEX base_dashboardemployeecharts_created_by_id_7a6c88d1 ON public.base_dashboardemployeecharts USING btree (created_by_id);


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

CREATE INDEX base_dashboardemployeecharts_employee_id_af804f1a ON public.base_dashboardemployeecharts USING btree (employee_id);


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

CREATE INDEX base_dashboardemployeecharts_modified_by_id_58988408 ON public.base_dashboardemployeecharts USING btree (modified_by_id);


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

CREATE INDEX base_department_company_id_company_id_3e26ba00 ON public.base_department_company_id USING btree (company_id);


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

CREATE INDEX base_department_company_id_department_id_4aded189 ON public.base_department_company_id USING btree (department_id);


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

CREATE INDEX base_department_created_by_id_86fcb76a ON public.base_department USING btree (created_by_id);


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

CREATE INDEX base_department_modified_by_id_2539afce ON public.base_department USING btree (modified_by_id);


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

CREATE INDEX base_driverviewed_user_id_78f9f2a5 ON public.base_driverviewed USING btree (user_id);


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

CREATE INDEX base_dynamicemailconfiguration_created_by_id_52e9b73b ON public.base_dynamicemailconfiguration USING btree (created_by_id);


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

CREATE INDEX base_dynamicemailconfiguration_modified_by_id_80c89277 ON public.base_dynamicemailconfiguration USING btree (modified_by_id);


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

CREATE INDEX base_emaillog_company_id_id_ed759e09 ON public.base_emaillog USING btree (company_id_id);


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

CREATE INDEX base_employeeshift_company_id_company_id_93281d0d ON public.base_employeeshift_company_id USING btree (company_id);


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

CREATE INDEX base_employeeshift_company_id_employeeshift_id_196dad8a ON public.base_employeeshift_company_id USING btree (employeeshift_id);


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

CREATE INDEX base_employeeshift_created_by_id_dbf8a807 ON public.base_employeeshift USING btree (created_by_id);


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

CREATE INDEX base_employeeshift_grace_time_id_id_15569b8e ON public.base_employeeshift USING btree (grace_time_id_id);


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

CREATE INDEX base_employeeshift_modified_by_id_9075134f ON public.base_employeeshift USING btree (modified_by_id);


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

CREATE INDEX base_employeeshiftday_company_id_company_id_2c4eeb07 ON public.base_employeeshiftday_company_id USING btree (company_id);


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

CREATE INDEX base_employeeshiftday_company_id_employeeshiftday_id_a860dbad ON public.base_employeeshiftday_company_id USING btree (employeeshiftday_id);


--
