71066	Bulera West	UG99834799	10717	2025-03-24 10:38:43.966362+00
71067	Butanjwa	UG38804390	10717	2025-03-24 10:38:43.968699+00
71068	Kidaiko	UG62777809	10717	2025-03-24 10:38:43.970984+00
71069	Kigarama	UG69053673	10717	2025-03-24 10:38:43.973234+00
71070	Kihanga	UG51340462	10717	2025-03-24 10:38:43.975474+00
71071	Kihemba	UG2233476	10717	2025-03-24 10:38:43.977845+00
71072	Kirindamaizi	UG39576819	10717	2025-03-24 10:38:43.980213+00
71073	Kisweeka	UG24846854	10717	2025-03-24 10:38:43.982527+00
71074	Kitaagi	UG20885402	10717	2025-03-24 10:38:43.984808+00
71075	Kyentale	UG5475177	10717	2025-03-24 10:38:43.987068+00
71076	Kiganda Middle	UG77896263	756	2025-03-24 10:38:43.988099+00
71077	Kiganda Mpunda	UG70428099	756	2025-03-24 10:38:43.989035+00
71078	Kiganda Upper	UG24306054	756	2025-03-24 10:38:43.990038+00
71079	Lusaka Lower	UG19281221	756	2025-03-24 10:38:43.990985+00
71080	Lusaka Middle	UG86150459	756	2025-03-24 10:38:43.991902+00
71081	Lusaka Upper	UG39410232	756	2025-03-24 10:38:43.992832+00
71082	Buhanika Lower	UG79133845	10719	2025-03-24 10:38:43.995111+00
71083	Buhanika Upper	UG7816752	10719	2025-03-24 10:38:43.997393+00
71084	Butebere North	UG51864423	10719	2025-03-24 10:38:43.999755+00
71085	Butebere South	UG56127141	10719	2025-03-24 10:38:44.00208+00
71086	Kacungiro	UG69891358	10719	2025-03-24 10:38:44.004348+00
71087	Kihuule North	UG39638560	10719	2025-03-24 10:38:44.006619+00
71088	Kihuule South	UG64783259	10719	2025-03-24 10:38:44.009008+00
71089	Kitinti	UG581450	10719	2025-03-24 10:38:44.011328+00
71090	Mbogwe	UG22118501	10719	2025-03-24 10:38:44.013653+00
71091	Nyakambugu	UG2272335	10719	2025-03-24 10:38:44.015934+00
71092	Busiisi East	UG83031499	757	2025-03-24 10:38:44.016929+00
71093	Kalyabuhire	UG24189229	757	2025-03-24 10:38:44.017902+00
71094	Katuugo	UG89954110	757	2025-03-24 10:38:44.018933+00
71095	Kibati I	UG57194058	757	2025-03-24 10:38:44.019853+00
71096	Kibati Ii	UG2582246	757	2025-03-24 10:38:44.020813+00
71097	Kigaragara	UG47867028	757	2025-03-24 10:38:44.021746+00
71098	Kiryatete East	UG70684473	757	2025-03-24 10:38:44.022684+00
71099	Kiryatete Lower	UG1616692	757	2025-03-24 10:38:44.0236+00
71100	Kiryatete Upper	UG69791828	757	2025-03-24 10:38:44.024531+00
71101	Budaka Lower	UG1438956	10721	2025-03-24 10:38:44.026947+00
71102	Budaka Upper	UG57546012	10721	2025-03-24 10:38:44.029338+00
71103	Bujura I	UG11256138	10721	2025-03-24 10:38:44.031738+00
71104	Bujura Ii	UG97009333	10721	2025-03-24 10:38:44.034037+00
71105	Kicweeke East	UG6289148	10721	2025-03-24 10:38:44.03625+00
71106	Kicweeke West	UG76870343	10721	2025-03-24 10:38:44.038599+00
71107	Kiteru	UG54456179	10721	2025-03-24 10:38:44.040825+00
71108	Kyakagundura	UG59018973	10721	2025-03-24 10:38:44.043044+00
71109	Bubaale North	UG16242573	1999	2025-03-24 10:38:44.044142+00
71110	Bubaale South	UG1027251	1999	2025-03-24 10:38:44.045262+00
71111	Buhiiga Lower	UG62614732	1999	2025-03-24 10:38:44.046356+00
71112	Buhiiga Upper	UG86185440	1999	2025-03-24 10:38:44.047471+00
71113	Karongo	UG81150893	1999	2025-03-24 10:38:44.048614+00
71114	Kikere	UG41389723	1999	2025-03-24 10:38:44.049758+00
71115	Kisiita	UG66689880	1999	2025-03-24 10:38:44.050801+00
71116	Mwendante	UG65144103	1999	2025-03-24 10:38:44.051872+00
71117	Butale	UG96431434	10723	2025-03-24 10:38:44.05425+00
71118	Kasasa	UG70690947	10723	2025-03-24 10:38:44.056546+00
71119	Kasingo	UG51628137	10723	2025-03-24 10:38:44.059052+00
71120	Katuugo	UG51912336	10723	2025-03-24 10:38:44.061398+00
71121	Kyabahesi	UG56536786	10723	2025-03-24 10:38:44.063716+00
71122	Kyakaliba	UG51499510	10723	2025-03-24 10:38:44.066099+00
71123	Mpaija	UG22255700	10723	2025-03-24 10:38:44.068413+00
71124	Rukooge	UG54488843	10723	2025-03-24 10:38:44.070757+00
71125	Itara	UG17267356	8857	2025-03-24 10:38:44.07281+00
71126	Kibingo Lower	UG76782548	8857	2025-03-24 10:38:44.074855+00
71127	Kibingo Upper	UG89787450	8857	2025-03-24 10:38:44.076871+00
71128	Kijogo	UG34938281	8857	2025-03-24 10:38:44.078994+00
71129	Kyakadongo	UG24672001	8857	2025-03-24 10:38:44.080998+00
71130	Ruyanja East	UG94535687	8857	2025-03-24 10:38:44.083041+00
71131	Ruyanja West	UG34837636	8857	2025-03-24 10:38:44.085043+00
71132	Kiduuma Central	UG49908679	10725	2025-03-24 10:38:44.087315+00
71133	Kigabu	UG92562128	10725	2025-03-24 10:38:44.089591+00
71134	Kihamba	UG50222311	10725	2025-03-24 10:38:44.092015+00
71135	Kihungura	UG93524444	10725	2025-03-24 10:38:44.094379+00
71136	Kiriisa	UG11475128	10725	2025-03-24 10:38:44.096667+00
71137	Kirubika	UG63088651	10725	2025-03-24 10:38:44.099137+00
71138	Kyabalanga	UG82397309	10725	2025-03-24 10:38:44.101493+00
71139	Nyarugabu	UG41566907	10725	2025-03-24 10:38:44.103781+00
71140	Wabiku	UG81157783	10725	2025-03-24 10:38:44.106072+00
71141	Wakyoya	UG39709416	10725	2025-03-24 10:38:44.108424+00
71142	Bujumbura East	UG75661514	10726	2025-03-24 10:38:44.110765+00
71143	Bujumbura West	UG26622598	10726	2025-03-24 10:38:44.11314+00
71144	Bujwahya East	UG47621934	10726	2025-03-24 10:38:44.115406+00
71145	Bujwahya West	UG81758636	10726	2025-03-24 10:38:44.117707+00
71146	Kaibalya	UG86791003	10726	2025-03-24 10:38:44.120037+00
71147	Kihomboza I	UG29592857	10726	2025-03-24 10:38:44.122297+00
71148	Kihomboza Ii	UG5892425	10726	2025-03-24 10:38:44.124551+00
71149	Kihomboza Iii	UG33277074	10726	2025-03-24 10:38:44.126835+00
71150	Kyarwabuyamba North	UG10668356	10726	2025-03-24 10:38:44.129407+00
71151	Kyarwabuyamba South	UG26172012	10726	2025-03-24 10:38:44.131894+00
71152	Rwenkobe	UG4032098	10726	2025-03-24 10:38:44.134257+00
71153	Buswekera North	UG71235983	10727	2025-03-24 10:38:44.136577+00
71154	Buswekera South	UG40222915	10727	2025-03-24 10:38:44.13889+00
71155	Kaitira	UG10127318	10727	2025-03-24 10:38:44.14125+00
71156	Kayanja	UG69218992	10727	2025-03-24 10:38:44.143604+00
71157	Kihukya	UG86716336	10727	2025-03-24 10:38:44.14588+00
71158	Kisonde	UG78432779	10727	2025-03-24 10:38:44.148189+00
71159	Kitemba	UG73886776	10727	2025-03-24 10:38:44.150465+00
71160	Kitoma	UG83197621	10727	2025-03-24 10:38:44.152874+00
71161	Bulemwa East	UG98515704	10728	2025-03-24 10:38:44.155222+00
71162	Bulemwa West	UG1483966	10728	2025-03-24 10:38:44.157516+00
71163	Kakundi	UG18210269	10728	2025-03-24 10:38:44.159812+00
71164	Katasiha Fort	UG8703675	10728	2025-03-24 10:38:44.162017+00
71165	Katasiha Main	UG53167126	10728	2025-03-24 10:38:44.16432+00
71166	Katasiha Wambabya	UG97656145	10728	2025-03-24 10:38:44.166635+00
71167	Kijwenge	UG41078709	10728	2025-03-24 10:38:44.168971+00
71168	Kizooba	UG61512209	10728	2025-03-24 10:38:44.171276+00
71169	Kyesiiga East	UG38116318	10728	2025-03-24 10:38:44.173604+00
71170	Kyesiiga West	UG41413657	10728	2025-03-24 10:38:44.175957+00
71171	Parajwoki	UG2827518	10728	2025-03-24 10:38:44.178267+00
71172	Bujwahya	UG66628139	2223	2025-03-24 10:38:44.179569+00
71173	Busiisi West	UG28547629	2223	2025-03-24 10:38:44.180742+00
71174	Kiganda I	UG36358434	2223	2025-03-24 10:38:44.18192+00
71175	Kiganda Ii	UG53242607	2223	2025-03-24 10:38:44.183075+00
71176	Kiryatete West	UG66300296	2223	2025-03-24 10:38:44.184203+00
71177	Rusembe I	UG53132060	2223	2025-03-24 10:38:44.185323+00
71178	Rusembe Ii	UG33916045	2223	2025-03-24 10:38:44.186444+00
71179	Mukoko	MUKOV	10730	2025-03-27 12:20:39.67379+00
\.


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

COPY public.zone_district (id, zone_id, district_id, created_at) FROM stdin;
1972b579-b04b-4d30-a133-fbd754b88866	1	112	2025-03-24 14:46:46.286463+00
ff7f02c3-4746-402f-992e-9de5a539d6b6	1	116	2025-03-24 14:46:46.306689+00
1f6e2b4b-5a06-448e-9565-7a017fce0791	1	122	2025-03-24 14:46:46.310674+00
e69f7e3f-3d46-408d-ba8a-c174b11eadba	1	120	2025-03-24 14:46:46.315197+00
e8a31f59-e1a2-4488-a046-3eb9f511ed5f	1	137	2025-03-24 14:46:46.319557+00
0eafb9a7-ec88-497b-b156-dd432865b678	1	138	2025-03-24 14:46:46.324394+00
7bef1fc8-8385-4898-b77e-f2b6da77de05	2	128	2025-03-24 14:46:46.329062+00
ba9eb7cf-ccd2-47e1-a5c6-18c6d501a758	2	110	2025-03-24 14:46:46.331886+00
1ac0445e-9e99-4433-92a0-88f5456c6911	2	125	2025-03-24 14:46:46.334226+00
f26a9b7a-17ff-4a4b-b6fb-2f85241bce81	2	126	2025-03-24 14:46:46.336958+00
77481446-a052-4ab5-aeea-eceba44cf982	2	141	2025-03-24 14:46:46.340998+00
69d1d28c-8afd-45a2-8a04-d7972ed99ded	2	127	2025-03-24 14:46:46.343675+00
5aa48d9d-e8b8-4c01-8ef7-9542f16a48be	2	118	2025-03-24 14:46:46.346133+00
95fb21ca-72c6-4769-a49b-9f24da5103f7	2	145	2025-03-24 14:46:46.348537+00
f65b2bb4-0e68-4900-96b0-049e6b2ad3d1	2	131	2025-03-24 14:46:46.350952+00
42d724ea-fe63-491d-80a4-6784fbc18ab9	2	119	2025-03-24 14:46:46.3547+00
de0ef11a-3882-4b89-a060-2106efeda62f	2	133	2025-03-24 14:46:46.359576+00
36839ce5-70f6-4e0f-bb57-2bcf90401cba	2	134	2025-03-24 14:46:46.362147+00
0669b282-9bf5-4f3d-a66d-2731ef930bb2	2	143	2025-03-24 14:46:46.365946+00
77c0f404-a603-4473-90b7-30a06f7e9387	3	29	2025-03-24 14:46:46.369374+00
0bad6dd2-4277-4f2c-9239-6fe324f108e0	3	28	2025-03-24 14:46:46.373404+00
0891ed78-e900-4f8b-9857-612694661e7e	3	53	2025-03-24 14:46:46.376537+00
2823a839-87c8-4080-967d-accd92545176	3	30	2025-03-24 14:46:46.379008+00
1773f596-2af5-4eb5-95a5-b0fdbe290740	3	31	2025-03-24 14:46:46.381296+00
c4496845-4070-4dc6-99f4-1385ebc3f81b	3	49	2025-03-24 14:46:46.384085+00
505892bf-56ce-4874-ac4f-d2a4b6d00d54	3	32	2025-03-24 14:46:46.386019+00
9eea17cb-21fb-42d4-9806-70242c3389b7	3	56	2025-03-24 14:46:46.388607+00
10bd4a1f-42bb-4300-9b23-beaef2ced475	3	41	2025-03-24 14:46:46.39197+00
9669f87f-7ac5-43e9-b720-8e045d1ffbcb	3	57	2025-03-24 14:46:46.394995+00
42df8569-7dfe-4290-a59e-557d98588a41	3	51	2025-03-24 14:46:46.397344+00
33cf2926-39cd-47bb-b2ad-7c9534b6020d	3	62	2025-03-24 14:46:46.399962+00
fa8fb249-3d04-4cd7-8bec-587eced42328	3	48	2025-03-24 14:46:46.402344+00
d05a3295-b9f4-45c4-b0d5-04ec0a8917ee	4	39	2025-03-24 14:46:46.40628+00
4a8520d0-2dd1-4899-a006-348e5f1e8e0a	4	36	2025-03-24 14:46:46.409071+00
813e77af-6600-4934-9957-81eaeee7124e	4	45	2025-03-24 14:46:46.411616+00
5289a3aa-6585-464f-8ae1-1641d0cb7e13	4	52	2025-03-24 14:46:46.414257+00
eeeb32f4-53b0-4ebc-b778-0ed3abef8ea4	4	61	2025-03-24 14:46:46.417433+00
c5dd6bbe-77be-4ec3-9359-1fcea63e0a85	4	42	2025-03-24 14:46:46.419991+00
0338eb0a-9670-4d84-afd1-66c552bd2360	4	33	2025-03-24 14:46:46.423569+00
e0c6ffa6-ec8c-4e9d-b671-ab8d3b45f078	4	47	2025-03-24 14:46:46.426528+00
d06ecce8-ca3b-49fe-83a8-8af79539d395	4	55	2025-03-24 14:46:46.42882+00
bbf239fb-c972-4bd8-b06f-14b30496fd7b	4	60	2025-03-24 14:46:46.432461+00
3bd96a53-6c06-4d55-b30e-d9099e90ed63	4	46	2025-03-24 14:46:46.434957+00
d5e39c73-711d-440a-97ad-de38c243d366	4	44	2025-03-24 14:46:46.437106+00
828f5738-297c-4a05-96d3-9eb3fb9ee7a5	4	54	2025-03-24 14:46:46.44035+00
159872f6-0614-46f1-b15a-7f2256169565	4	37	2025-03-24 14:46:46.443139+00
5601363a-b809-4fe1-8bdf-dfcb6bd6bc10	5	111	2025-03-24 14:46:46.44622+00
b104109a-fad8-45af-ae88-f8cd8d2e40af	5	117	2025-03-24 14:46:46.448882+00
40f5800c-0940-4288-b28c-9c745c78d8d0	5	124	2025-03-24 14:46:46.451377+00
88732587-c4ba-403f-a1d3-4d444f5b3672	5	115	2025-03-24 14:46:46.453922+00
afb255c1-391c-4e09-a0da-a5548ef75e25	5	129	2025-03-24 14:46:46.456313+00
c7992d77-945f-4dbb-b527-d7975b710d6d	6	7	2025-03-24 14:46:46.459954+00
d0ba1290-2737-4d4f-8224-78c95658992a	6	15	2025-03-24 14:46:46.462383+00
1ab31ecb-bd45-4c55-b493-ba7b9fa8f64f	6	4	2025-03-24 14:46:46.465682+00
8b7e0125-fe81-4dfc-aaa6-835a4868f0e1	6	23	2025-03-24 14:46:46.469594+00
8f2ae6ee-bcb6-4779-8cb8-c17f96fca4d5	6	8	2025-03-24 14:46:46.472394+00
733a1235-e007-4bf6-b349-e322ff663a5e	6	12	2025-03-24 14:46:46.475592+00
a7b234a1-b598-4c80-82f6-434cb36d83b8	6	9	2025-03-24 14:46:46.478292+00
e7d29448-a582-4759-9617-43a7a83732c2	6	16	2025-03-24 14:46:46.480574+00
25ab7692-117f-4a07-b2f1-47faa88185bb	6	17	2025-03-24 14:46:46.483212+00
a4ed46a3-5e23-4ec5-a753-1b197dd43f95	6	22	2025-03-24 14:46:46.485639+00
7d1d1084-ee1f-4ad8-b368-649661d99150	6	6	2025-03-24 14:46:46.488964+00
a518de6b-bfca-44b4-86a5-4fe4e644e32a	6	2	2025-03-24 14:46:46.491044+00
89b48a4c-12f8-4e5b-aa5b-bd99d8774d20	6	21	2025-03-24 14:46:46.493478+00
cf8b551b-c040-47fa-8b60-f2d1a9b3b10e	6	19	2025-03-24 14:46:46.495638+00
48984802-5172-4e0f-9243-f300a9545a11	6	13	2025-03-24 14:46:46.497849+00
ccc68f80-5dfa-4517-89f3-2a5e91ca507b	6	3	2025-03-24 14:46:46.500663+00
f0bb70fe-6f57-45eb-a182-61db9192a00f	6	26	2025-03-24 14:46:46.502806+00
4ea50621-f422-45c9-a7ec-e023ee26d8ff	7	5	2025-03-24 14:46:46.506557+00
33e7edf4-4165-4598-9bfa-555d4cad16d5	7	25	2025-03-24 14:46:46.508972+00
54af3f49-7980-4bbe-baa9-d9e7b6e3226f	7	14	2025-03-24 14:46:46.511343+00
9b88eece-482b-48d5-a486-6b5eb7cea19f	7	11	2025-03-24 14:46:46.513568+00
780e9748-9599-40f9-ae08-0c73fbc61f9a	7	10	2025-03-24 14:46:46.516925+00
df3c1d1b-0980-4ab0-8549-51f595f82471	7	24	2025-03-24 14:46:46.51953+00
ef73348c-b4e5-4ebf-a63d-d031a6327dda	7	1	2025-03-24 14:46:46.522832+00
b65494cc-519b-4b1a-a203-9f2fa93f3ac5	7	18	2025-03-24 14:46:46.52526+00
081c11f6-2197-4c1d-bd92-f1fa92cb6349	7	20	2025-03-24 14:46:46.528317+00
50958fdf-0053-4ee3-8565-3caa83f48dd3	8	81	2025-03-24 14:46:46.531856+00
c27712da-1343-45c6-a621-50e4a5c1ccf1	8	89	2025-03-24 14:46:46.534922+00
253772e9-6f15-45ee-bb80-9ffeb25c5e6d	8	69	2025-03-24 14:46:46.537888+00
8288d554-d5b8-4abd-bf7a-8a8d51c677ec	8	83	2025-03-24 14:46:46.540142+00
76aed09a-1cfd-4544-97f5-dcca9b3c1c5b	8	91	2025-03-24 14:46:46.542327+00
046d98ce-d612-45a9-8568-c91a6d52df82	8	73	2025-03-24 14:46:46.545329+00
ac22c30f-b201-49d2-9ef6-f02b4360f3a7	8	87	2025-03-24 14:46:46.547762+00
29019a5f-dee1-4066-a147-e06ca98d2a60	8	99	2025-03-24 14:46:46.55071+00
f9139255-72d3-4c83-a36b-db84320251d7	8	95	2025-03-24 14:46:46.553033+00
743f9da2-594e-4718-b6d0-fd57a1aa71ab	8	88	2025-03-24 14:46:46.556414+00
e277f9f8-f256-40e4-8a78-5412af11f6a0	8	82	2025-03-24 14:46:46.558554+00
2898edd9-ed76-408b-ac1b-41f927c282e2	8	70	2025-03-24 14:46:46.560479+00
e3f6bea3-7eab-4c2e-add5-79d7d1cd529a	8	71	2025-03-24 14:46:46.562882+00
f49cd55f-0f07-4ac7-8089-8082124377e8	8	92	2025-03-24 14:46:46.567416+00
92c0eeef-1e61-4a51-9ad0-3a8eaafc236d	8	97	2025-03-24 14:46:46.570189+00
61f32e73-3a94-475c-b902-c5a84286a89f	8	94	2025-03-24 14:46:46.573539+00
db70f6af-adcc-45c4-b146-6397e38d9872	8	78	2025-03-24 14:46:46.576509+00
11b5b97d-7114-471a-a364-f47d2332b40a	9	59	2025-03-24 14:46:46.580809+00
d2b28f14-757c-4bc3-9d81-5761f0ca6914	9	38	2025-03-24 14:46:46.583955+00
fb625937-9dd6-4883-a2d7-f1c1d8703a96	9	40	2025-03-24 14:46:46.587086+00
87803730-79e2-4d58-96b5-76038ac3bad6	9	58	2025-03-24 14:46:46.590482+00
2668c2d2-71b7-48c2-861a-b32f1078538f	9	35	2025-03-24 14:46:46.592679+00
5f8ee50b-18ca-4421-9b37-018e0e772f92	9	46	2025-03-24 14:46:46.594611+00
22323ae5-f317-4403-8b39-4b8c87df6125	9	43	2025-03-24 14:46:46.596832+00
14b01290-003a-4467-b2c7-35eb514b12ea	9	34	2025-03-24 14:46:46.599386+00
73d03cf4-3a28-45ae-a0a7-b720fb410f96	9	63	2025-03-24 14:46:46.602054+00
ca9f292f-f4a0-43ee-9468-41699689b4d4	9	93	2025-03-24 14:46:46.605398+00
ec66815f-b5bc-4716-bd10-89c9ade250f2	9	74	2025-03-24 14:46:46.608228+00
40cc25e1-32f9-4bb1-8bde-0116ac74203a	9	77	2025-03-24 14:46:46.610382+00
bd8c3a21-f1b8-4d4f-bff5-d169a94a276d	9	100	2025-03-24 14:46:46.612203+00
b01ae6ae-41d7-4307-8815-4b06f4180e00	9	72	2025-03-24 14:46:46.615188+00
4930cfa7-fd5f-4e75-90b2-dc899a52d498	9	80	2025-03-24 14:46:46.619459+00
62b0ecf8-e16f-4db7-a383-869848cabc42	9	84	2025-03-24 14:46:46.623422+00
79517f0a-bb9d-4492-949a-71b62340013b	9	90	2025-03-24 14:46:46.626774+00
50e29c5a-7045-4238-88e1-3b3a740efcc6	9	101	2025-03-24 14:46:46.62919+00
0a899a25-7541-456a-aba2-5e52649378ee	10	104	2025-03-24 14:46:46.633218+00
d75717bd-107e-40cc-9916-cf64a869f7c6	10	106	2025-03-24 14:46:46.636+00
ee72a066-4a25-4863-9326-4014067bfa77	10	108	2025-03-24 14:46:46.639549+00
dc7408f2-3ac6-46e5-80c0-dd5c3eaa61d1	10	102	2025-03-24 14:46:46.642224+00
dbf07303-bebd-4099-a2cc-b32133fd5e65	10	86	2025-03-24 14:46:46.644486+00
36926d00-0805-474b-bdfe-e0303aab5252	10	85	2025-03-24 14:46:46.646285+00
3f41334b-edb8-47c2-9af8-b1f438b5d110	10	108	2025-03-24 14:46:46.648494+00
e8bfe3e9-cbd9-45d9-8211-f2b57d7b8e58	10	79	2025-03-24 14:46:46.651226+00
c34fd129-5c28-478a-afb2-cea044c134c6	10	75	2025-03-24 14:46:46.654393+00
63cc21c9-c6d4-40bb-8983-fcd4bf6110c8	10	68	2025-03-24 14:46:46.657203+00
7a2468a8-22af-4d68-b21a-35d2df7da1c5	10	103	2025-03-24 14:46:46.65991+00
6cd6280b-46a4-48a9-bb1c-003b5c25498e	10	98	2025-03-24 14:46:46.661776+00
201ff79d-5615-4831-8c0f-9b00fb74d0b2	10	76	2025-03-24 14:46:46.663668+00
31759b8b-436d-4659-bf2e-9e44e5f9b501	10	96	2025-03-24 14:46:46.667104+00
\.


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

COPY public.zones (id, zone, created_at) FROM stdin;
1	KAZARDI	2025-03-24 14:46:46.266068+00
2	MBAZARDI	2025-03-24 14:46:46.326981+00
3	NAFIRI	2025-03-24 14:46:46.368066+00
4	BugiZARDI	2025-03-24 14:46:46.403985+00
5	BulindiZARDI	2025-03-24 14:46:46.444752+00
6	MUZARDI	2025-03-24 14:46:46.458321+00
7	KAMENYA MIGO-MUZARDI	2025-03-24 14:46:46.505021+00
8	NGETTA	2025-03-24 14:46:46.529966+00
9	NABUIN	2025-03-24 14:46:46.578768+00
10	AbiZARDI	2025-03-24 14:46:46.631175+00
\.


--
-- Name: airlines_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.airlines_id_seq', 339, true);


--
-- Name: boxes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.boxes_id_seq', 4517, true);


--
-- Name: clients_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.clients_id_seq', 241, true);


--
-- Name: consignment_queries_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: consignmentdoctypes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: consignmentreasonrejections_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: consignmentrejections_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: consignmentstatustracker_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.consignmentstatustracker_id_seq', 906, true);


--
-- Name: countries_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: crops_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.crops_id_seq', 497, true);


--
-- Name: destructionnotice_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: destructionothersnotice_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: districts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.districts_id_seq', 292, true);


--
-- Name: document_codes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.document_codes_id_seq', 2334, true);


--
-- Name: document_countries_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: document_crops_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.document_crops_id_seq', 98, true);


--
-- Name: documents_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: exithandlers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: exitpointroaster_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: exitpoints_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: exportcompanies_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.exportcompanies_id_seq', 276, true);


--
-- Name: farmer_contacts_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: farmer_exporter_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.farmer_exporter_id_seq', 1177, true);


--
-- Name: farmer_farms_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.farmer_farms_id_seq', 5276, true);


--
-- Name: farmer_produce_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: farmers_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.farmers_id_seq', 1026, true);


--
-- Name: inspectionreport_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.inspectionreport_id_seq', 759, true);


--
-- Name: inspectionreportrecommendation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.inspectionreportrecommendation_id_seq', 756, true);


--
-- Name: interceptionnotice_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: modesoftransport_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: notifications_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: order_crops_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.order_crops_id_seq', 4971, true);


--
-- Name: orders_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.orders_id_seq', 911, true);


--
-- Name: packagetypes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: packhouse_exporter_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.packhouse_exporter_id_seq', 151, true);


--
-- Name: packhouses_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.packhouses_id_seq', 244, true);


--
-- Name: packinglist_batch_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.packinglist_batch_id_seq', 4673, true);


--
-- Name: packinglist_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.packinglist_id_seq', 806, true);


--
-- Name: packinglist_others_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.packinglist_others_id_seq', 430, true);


--
-- Name: packinglist_products_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.packinglist_products_id_seq', 4583, true);


--
-- Name: parishes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.parishes_id_seq', 10730, true);


--
-- Name: plannedconsignments_documents_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.plannedconsignments_documents_id_seq', 20, true);


--
-- Name: plannedconsignments_otherdocuments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: plannedconsignments_tpdetails_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.plannedconsignments_tpdetails_id_seq', 822, true);


--
-- Name: process_broadcast_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: product_interception_notice_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: productdoctypes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: productothers_interception_notice_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: qcp1_attributes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qcp1_attributes_id_seq', 25, true);


--
-- Name: qcp1_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qcp1_id_seq', 4793, true);


--
-- Name: qcp1_recommendation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qcp1_recommendation_id_seq', 4710, true);


--
-- Name: qcp2_attributes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qcp2_attributes_id_seq', 25, true);


--
-- Name: qcp2_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qcp2_id_seq', 4702, true);


--
-- Name: qcp2_recommendation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qcp2_recommendation_id_seq', 4706, true);


--
-- Name: qcp3_attributes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: qcp3_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qcp3_id_seq', 4705, true);


--
-- Name: qcp3_recommendation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qcp3_recommendation_id_seq', 4673, true);


--
-- Name: qcp4_attributes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qcp4_attributes_id_seq', 2930, true);


--
-- Name: qcp4_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qcp4_id_seq', 782, true);


--
-- Name: qcp4_other_attributes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qcp4_other_attributes_id_seq', 249, true);


--
-- Name: qcp4_otherrecommendations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qcp4_otherrecommendations_id_seq', 412, true);


--
-- Name: qcp4_others_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qcp4_others_id_seq', 411, true);


--
-- Name: qcp4_products_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qcp4_products_id_seq', 4517, true);


--
-- Name: qcp4_recommendations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qcp4_recommendations_id_seq', 4420, true);


--
-- Name: qcp5_attributes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qcp5_attributes_id_seq', 2183, true);


--
-- Name: qcp5_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qcp5_id_seq', 756, true);


--
-- Name: qcp5_other_attributes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: qcp5_otherrecommendations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: qcp5_others_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qcp5_others_id_seq', 397, true);


--
-- Name: qcp5_products_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qcp5_products_id_seq', 4375, true);


--
-- Name: qcp5_recommendations_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qcp5_recommendations_id_seq', 3009, true);


--
-- Name: qcp5inspectionreport_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qcp5inspectionreport_id_seq', 509, true);


--
-- Name: qcp5inspectionreportrecommendation_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qcp5inspectionreportrecommendation_id_seq', 513, true);


--
-- Name: qualityattributes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.qualityattributes_id_seq', 48, true);


--
-- Name: reasonrejections_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: reception_attributes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.reception_attributes_id_seq', 32, true);


--
-- Name: reception_documents_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.reception_documents_id_seq', 404, true);


--
-- Name: reception_otherdocuments_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: receptionform_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.receptionform_id_seq', 4887, true);


--
-- Name: receptionform_qrcodes_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.receptionform_qrcodes_id_seq', 4793, true);


--
-- Name: redflags_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: rejections_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: roastercount_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: role_permissions_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.role_permissions_id_seq', 58, true);


--
-- Name: roles_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: subcounties_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.subcounties_id_seq', 4392, true);


--
-- Name: suspensionreport_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: trackhygiene_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: trackhygienereport_checklist_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.trackhygienereport_checklist_id_seq', 2194, true);


--
-- Name: trackhygienereport_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.trackhygienereport_id_seq', 900, true);


--
-- Name: trackstatus_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: user_broadcast_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: user_exporter_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.user_exporter_id_seq', 1984, true);


--
-- Name: user_packhouse_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: user_roles_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: user_zones_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: userotp_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.userotp_id_seq', 66, true);


--
-- Name: users_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.users_id_seq', 1133, true);


--
-- Name: villages_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

SELECT pg_catalog.setval('public.villages_id_seq', 71179, true);


--
-- Name: zones_id_seq; Type: SEQUENCE SET; Schema: public; Owner: -
--

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


--
-- Name: airlines airlines_airlinecode_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.airlines
    ADD CONSTRAINT airlines_airlinecode_key UNIQUE (airlinecode);


--
-- Name: airlines airlines_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.airlines
    ADD CONSTRAINT airlines_pkey PRIMARY KEY (id);


--
-- Name: boxes boxes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.boxes
    ADD CONSTRAINT boxes_pkey PRIMARY KEY (id);


--
-- Name: clients clients_companyname_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.clients
    ADD CONSTRAINT clients_companyname_key UNIQUE (companyname);


--
-- Name: clients clients_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.clients
    ADD CONSTRAINT clients_pkey PRIMARY KEY (id);


--
-- Name: consignment_queries consignment_queries_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.consignment_queries
    ADD CONSTRAINT consignment_queries_pkey PRIMARY KEY (id);


--
-- Name: consignmentdoctypes consignmentdoctypes_cdcode_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.consignmentdoctypes
    ADD CONSTRAINT consignmentdoctypes_cdcode_key UNIQUE (cdcode);


--
-- Name: consignmentdoctypes consignmentdoctypes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.consignmentdoctypes
    ADD CONSTRAINT consignmentdoctypes_pkey PRIMARY KEY (id);


--
-- Name: consignmentreasonrejections consignmentreasonrejections_crrcode_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.consignmentreasonrejections
    ADD CONSTRAINT consignmentreasonrejections_crrcode_key UNIQUE (crrcode);


--
-- Name: consignmentreasonrejections consignmentreasonrejections_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.consignmentreasonrejections
    ADD CONSTRAINT consignmentreasonrejections_pkey PRIMARY KEY (id);


--
-- Name: consignmentrejections consignmentrejections_cjcode_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.consignmentrejections
    ADD CONSTRAINT consignmentrejections_cjcode_key UNIQUE (cjcode);


--
-- Name: consignmentrejections consignmentrejections_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.consignmentrejections
    ADD CONSTRAINT consignmentrejections_pkey PRIMARY KEY (id);


--
-- Name: consignmentstatustracker consignmentstatustracker_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.consignmentstatustracker
    ADD CONSTRAINT consignmentstatustracker_pkey PRIMARY KEY (id);


--
-- Name: countries countries_countrycode_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.countries
    ADD CONSTRAINT countries_countrycode_key UNIQUE (countrycode);


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

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


--
-- Name: crops crops_cropname_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.crops
    ADD CONSTRAINT crops_cropname_key UNIQUE (cropname);


--
-- Name: crops crops_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.crops
    ADD CONSTRAINT crops_pkey PRIMARY KEY (id);


--
-- Name: destructionnotice destructionnotice_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.destructionnotice
    ADD CONSTRAINT destructionnotice_pkey PRIMARY KEY (id);


--
-- Name: destructionothersnotice destructionothersnotice_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.destructionothersnotice
    ADD CONSTRAINT destructionothersnotice_pkey PRIMARY KEY (id);


--
-- Name: districts districts_code_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.districts
    ADD CONSTRAINT districts_code_key UNIQUE (code);


--
-- Name: districts districts_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.districts
    ADD CONSTRAINT districts_name_key UNIQUE (name);


--
-- Name: districts districts_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.districts
    ADD CONSTRAINT districts_pkey PRIMARY KEY (id);


--
-- Name: document_codes document_codes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.document_codes
    ADD CONSTRAINT document_codes_pkey PRIMARY KEY (id);


--
-- Name: document_countries document_countries_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.document_countries
    ADD CONSTRAINT document_countries_pkey PRIMARY KEY (id);


--
-- Name: document_crops document_crops_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.document_crops
    ADD CONSTRAINT document_crops_pkey PRIMARY KEY (id);


--
-- Name: documents documents_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.documents
    ADD CONSTRAINT documents_pkey PRIMARY KEY (id);


--
-- Name: exithandlers exithandlers_exhcode_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.exithandlers
    ADD CONSTRAINT exithandlers_exhcode_key UNIQUE (exhcode);


--
-- Name: exithandlers exithandlers_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.exithandlers
    ADD CONSTRAINT exithandlers_pkey PRIMARY KEY (id);


--
-- Name: exitpointroaster exitpointroaster_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.exitpointroaster
    ADD CONSTRAINT exitpointroaster_pkey PRIMARY KEY (id);


--
-- Name: exitpoints exitpoints_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.exitpoints
    ADD CONSTRAINT exitpoints_pkey PRIMARY KEY (id);


--
-- Name: exportcompanies exportcompanies_expcompanyphone_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.exportcompanies
    ADD CONSTRAINT exportcompanies_expcompanyphone_key UNIQUE (expcompanyphone);


--
-- Name: exportcompanies exportcompanies_expemail_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.exportcompanies
    ADD CONSTRAINT exportcompanies_expemail_key UNIQUE (expemail);


--
-- Name: exportcompanies exportcompanies_expname_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.exportcompanies
    ADD CONSTRAINT exportcompanies_expname_key UNIQUE (expname);


--
-- Name: exportcompanies exportcompanies_expregno_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.exportcompanies
    ADD CONSTRAINT exportcompanies_expregno_key UNIQUE (expregno);


--
-- Name: exportcompanies exportcompanies_exprexno_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.exportcompanies
    ADD CONSTRAINT exportcompanies_exprexno_key UNIQUE (exprexno);


--
-- Name: exportcompanies exportcompanies_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.exportcompanies
    ADD CONSTRAINT exportcompanies_pkey PRIMARY KEY (id);


--
-- Name: farmer_contacts farmer_contacts_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmer_contacts
    ADD CONSTRAINT farmer_contacts_pkey PRIMARY KEY (id);


--
-- Name: farmer_exporter farmer_exporter_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmer_exporter
    ADD CONSTRAINT farmer_exporter_pkey PRIMARY KEY (id);


--
-- Name: farmer_farms farmer_farms_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmer_farms
    ADD CONSTRAINT farmer_farms_pkey PRIMARY KEY (id);


--
-- Name: farmer_farms farmer_farms_traceability_code_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmer_farms
    ADD CONSTRAINT farmer_farms_traceability_code_key UNIQUE (traceability_code);


--
-- Name: farmer_produce farmer_produce_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmer_produce
    ADD CONSTRAINT farmer_produce_pkey PRIMARY KEY (id);


--
-- Name: farmers farmers_fmcode_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmers
    ADD CONSTRAINT farmers_fmcode_key UNIQUE (fmcode);


--
-- Name: farmers farmers_fmemail_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmers
    ADD CONSTRAINT farmers_fmemail_key UNIQUE (fmemail);


--
-- Name: farmers farmers_fmid_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmers
    ADD CONSTRAINT farmers_fmid_key UNIQUE (fmid);


--
-- Name: farmers farmers_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmers
    ADD CONSTRAINT farmers_pkey PRIMARY KEY (id);


--
-- Name: inspectionreport inspectionreport_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.inspectionreport
    ADD CONSTRAINT inspectionreport_pkey PRIMARY KEY (id);


--
-- Name: inspectionreportrecommendation inspectionreportrecommendation_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.inspectionreportrecommendation
    ADD CONSTRAINT inspectionreportrecommendation_pkey PRIMARY KEY (id);


--
-- Name: interceptionnotice interceptionnotice_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.interceptionnotice
    ADD CONSTRAINT interceptionnotice_pkey PRIMARY KEY (id);


--
-- Name: modesoftransport modesoftransport_motdescription_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.modesoftransport
    ADD CONSTRAINT modesoftransport_motdescription_key UNIQUE (motdescription);


--
-- Name: modesoftransport modesoftransport_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.modesoftransport
    ADD CONSTRAINT modesoftransport_pkey PRIMARY KEY (id);


--
-- Name: notifications notifications_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.notifications
    ADD CONSTRAINT notifications_pkey PRIMARY KEY (id);


--
-- Name: order_crops order_crops_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.order_crops
    ADD CONSTRAINT order_crops_pkey PRIMARY KEY (id);


--
-- Name: orders orders_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.orders
    ADD CONSTRAINT orders_pkey PRIMARY KEY (id);


--
-- Name: packagetypes packagetypes_pgcode_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packagetypes
    ADD CONSTRAINT packagetypes_pgcode_key UNIQUE (pgcode);


--
-- Name: packagetypes packagetypes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packagetypes
    ADD CONSTRAINT packagetypes_pkey PRIMARY KEY (id);


--
-- Name: packhouse_exporter packhouse_exporter_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packhouse_exporter
    ADD CONSTRAINT packhouse_exporter_pkey PRIMARY KEY (id);


--
-- Name: packhouses packhouses_phname_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packhouses
    ADD CONSTRAINT packhouses_phname_key UNIQUE (phname);


--
-- Name: packhouses packhouses_phregno_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packhouses
    ADD CONSTRAINT packhouses_phregno_key UNIQUE (phregno);


--
-- Name: packhouses packhouses_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packhouses
    ADD CONSTRAINT packhouses_pkey PRIMARY KEY (id);


--
-- Name: packinglist_batch packinglist_batch_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packinglist_batch
    ADD CONSTRAINT packinglist_batch_pkey PRIMARY KEY (id);


--
-- Name: packinglist_others packinglist_others_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packinglist_others
    ADD CONSTRAINT packinglist_others_pkey PRIMARY KEY (id);


--
-- Name: packinglist packinglist_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packinglist
    ADD CONSTRAINT packinglist_pkey PRIMARY KEY (id);


--
-- Name: packinglist_products packinglist_products_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packinglist_products
    ADD CONSTRAINT packinglist_products_pkey PRIMARY KEY (id);


--
-- Name: parishes parishes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.parishes
    ADD CONSTRAINT parishes_pkey PRIMARY KEY (id);


--
-- Name: plannedconsignments_documents plannedconsignments_documents_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.plannedconsignments_documents
    ADD CONSTRAINT plannedconsignments_documents_pkey PRIMARY KEY (id);


--
-- Name: plannedconsignments_otherdocuments plannedconsignments_otherdocuments_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.plannedconsignments_otherdocuments
    ADD CONSTRAINT plannedconsignments_otherdocuments_pkey PRIMARY KEY (id);


--
-- Name: plannedconsignments plannedconsignments_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.plannedconsignments
    ADD CONSTRAINT plannedconsignments_pkey PRIMARY KEY (id);


--
-- Name: plannedconsignments_tpdetails plannedconsignments_tpdetails_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.plannedconsignments_tpdetails
    ADD CONSTRAINT plannedconsignments_tpdetails_pkey PRIMARY KEY (id);


--
-- Name: process_broadcast process_broadcast_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.process_broadcast
    ADD CONSTRAINT process_broadcast_pkey PRIMARY KEY (id);


--
-- Name: product_interception_notice product_interception_notice_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.product_interception_notice
    ADD CONSTRAINT product_interception_notice_pkey PRIMARY KEY (id);


--
-- Name: productdoctypes productdoctypes_pddocumentcode_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.productdoctypes
    ADD CONSTRAINT productdoctypes_pddocumentcode_key UNIQUE (pddocumentcode);


--
-- Name: productdoctypes productdoctypes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.productdoctypes
    ADD CONSTRAINT productdoctypes_pkey PRIMARY KEY (id);


--
-- Name: productothers_interception_notice productothers_interception_notice_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.productothers_interception_notice
    ADD CONSTRAINT productothers_interception_notice_pkey PRIMARY KEY (id);


--
-- Name: qcp1_attributes qcp1_attributes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp1_attributes
    ADD CONSTRAINT qcp1_attributes_pkey PRIMARY KEY (id);


--
-- Name: qcp1 qcp1_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp1
    ADD CONSTRAINT qcp1_pkey PRIMARY KEY (id);


--
-- Name: qcp1_recommendation qcp1_recommendation_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp1_recommendation
    ADD CONSTRAINT qcp1_recommendation_pkey PRIMARY KEY (id);


--
-- Name: qcp2_attributes qcp2_attributes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp2_attributes
    ADD CONSTRAINT qcp2_attributes_pkey PRIMARY KEY (id);


--
-- Name: qcp2 qcp2_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp2
    ADD CONSTRAINT qcp2_pkey PRIMARY KEY (id);


--
-- Name: qcp2_recommendation qcp2_recommendation_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp2_recommendation
    ADD CONSTRAINT qcp2_recommendation_pkey PRIMARY KEY (id);


--
-- Name: qcp3_attributes qcp3_attributes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp3_attributes
    ADD CONSTRAINT qcp3_attributes_pkey PRIMARY KEY (id);


--
-- Name: qcp3 qcp3_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp3
    ADD CONSTRAINT qcp3_pkey PRIMARY KEY (id);


--
-- Name: qcp3_recommendation qcp3_recommendation_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp3_recommendation
    ADD CONSTRAINT qcp3_recommendation_pkey PRIMARY KEY (id);


--
-- Name: qcp4_attributes qcp4_attributes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_attributes
    ADD CONSTRAINT qcp4_attributes_pkey PRIMARY KEY (id);


--
-- Name: qcp4_other_attributes qcp4_other_attributes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_other_attributes
    ADD CONSTRAINT qcp4_other_attributes_pkey PRIMARY KEY (id);


--
-- Name: qcp4_otherrecommendations qcp4_otherrecommendations_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_otherrecommendations
    ADD CONSTRAINT qcp4_otherrecommendations_pkey PRIMARY KEY (id);


--
-- Name: qcp4_others qcp4_others_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_others
    ADD CONSTRAINT qcp4_others_pkey PRIMARY KEY (id);


--
-- Name: qcp4 qcp4_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4
    ADD CONSTRAINT qcp4_pkey PRIMARY KEY (id);


--
-- Name: qcp4_products qcp4_products_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_products
    ADD CONSTRAINT qcp4_products_pkey PRIMARY KEY (id);


--
-- Name: qcp4_recommendations qcp4_recommendations_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_recommendations
    ADD CONSTRAINT qcp4_recommendations_pkey PRIMARY KEY (id);


--
-- Name: qcp5_attributes qcp5_attributes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_attributes
    ADD CONSTRAINT qcp5_attributes_pkey PRIMARY KEY (id);


--
-- Name: qcp5_other_attributes qcp5_other_attributes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_other_attributes
    ADD CONSTRAINT qcp5_other_attributes_pkey PRIMARY KEY (id);


--
-- Name: qcp5_otherrecommendations qcp5_otherrecommendations_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_otherrecommendations
    ADD CONSTRAINT qcp5_otherrecommendations_pkey PRIMARY KEY (id);


--
-- Name: qcp5_others qcp5_others_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_others
    ADD CONSTRAINT qcp5_others_pkey PRIMARY KEY (id);


--
-- Name: qcp5 qcp5_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5
    ADD CONSTRAINT qcp5_pkey PRIMARY KEY (id);


--
-- Name: qcp5_products qcp5_products_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_products
    ADD CONSTRAINT qcp5_products_pkey PRIMARY KEY (id);


--
-- Name: qcp5_recommendations qcp5_recommendations_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_recommendations
    ADD CONSTRAINT qcp5_recommendations_pkey PRIMARY KEY (id);


--
-- Name: qcp5inspectionreport qcp5inspectionreport_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5inspectionreport
    ADD CONSTRAINT qcp5inspectionreport_pkey PRIMARY KEY (id);


--
-- Name: qcp5inspectionreportrecommendation qcp5inspectionreportrecommendation_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5inspectionreportrecommendation
    ADD CONSTRAINT qcp5inspectionreportrecommendation_pkey PRIMARY KEY (id);


--
-- Name: qualityattributes qualityattributes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qualityattributes
    ADD CONSTRAINT qualityattributes_pkey PRIMARY KEY (id);


--
-- Name: reasonrejections reasonrejections_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.reasonrejections
    ADD CONSTRAINT reasonrejections_pkey PRIMARY KEY (id);


--
-- Name: reasonrejections reasonrejections_reasoncode_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.reasonrejections
    ADD CONSTRAINT reasonrejections_reasoncode_key UNIQUE (reasoncode);


--
-- Name: reception_attributes reception_attributes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.reception_attributes
    ADD CONSTRAINT reception_attributes_pkey PRIMARY KEY (id);


--
-- Name: reception_documents reception_documents_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.reception_documents
    ADD CONSTRAINT reception_documents_pkey PRIMARY KEY (id);


--
-- Name: reception_otherdocuments reception_otherdocuments_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.reception_otherdocuments
    ADD CONSTRAINT reception_otherdocuments_pkey PRIMARY KEY (id);


--
-- Name: receptionform receptionform_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.receptionform
    ADD CONSTRAINT receptionform_pkey PRIMARY KEY (id);


--
-- Name: receptionform_qrcodes receptionform_qrcodes_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.receptionform_qrcodes
    ADD CONSTRAINT receptionform_qrcodes_pkey PRIMARY KEY (id);


--
-- Name: redflags redflags_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.redflags
    ADD CONSTRAINT redflags_pkey PRIMARY KEY (id);


--
-- Name: rejections rejections_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.rejections
    ADD CONSTRAINT rejections_pkey PRIMARY KEY (id);


--
-- Name: rejections rejections_rejectioncode_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.rejections
    ADD CONSTRAINT rejections_rejectioncode_key UNIQUE (rejectioncode);


--
-- Name: roastercount roastercount_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.roastercount
    ADD CONSTRAINT roastercount_pkey PRIMARY KEY (id);


--
-- Name: role_permissions role_permissions_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.role_permissions
    ADD CONSTRAINT role_permissions_pkey PRIMARY KEY (id);


--
-- Name: roles roles_name_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.roles
    ADD CONSTRAINT roles_name_key UNIQUE (name);


--
-- Name: roles roles_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

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


--
-- Name: schema_migrations schema_migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.schema_migrations
    ADD CONSTRAINT schema_migrations_pkey PRIMARY KEY (version);


--
-- Name: sessions sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sessions
    ADD CONSTRAINT sessions_pkey PRIMARY KEY (id);


--
-- Name: subcounties subcounties_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.subcounties
    ADD CONSTRAINT subcounties_pkey PRIMARY KEY (id);


--
-- Name: suspensionreport suspensionreport_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.suspensionreport
    ADD CONSTRAINT suspensionreport_pkey PRIMARY KEY (id);


--
-- Name: trackhygiene trackhygiene_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.trackhygiene
    ADD CONSTRAINT trackhygiene_pkey PRIMARY KEY (id);


--
-- Name: trackhygienereport_checklist trackhygienereport_checklist_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.trackhygienereport_checklist
    ADD CONSTRAINT trackhygienereport_checklist_pkey PRIMARY KEY (id);


--
-- Name: trackhygienereport trackhygienereport_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.trackhygienereport
    ADD CONSTRAINT trackhygienereport_pkey PRIMARY KEY (id);


--
-- Name: trackstatus trackstatus_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.trackstatus
    ADD CONSTRAINT trackstatus_pkey PRIMARY KEY (id);


--
-- Name: user_broadcast user_broadcast_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.user_broadcast
    ADD CONSTRAINT user_broadcast_pkey PRIMARY KEY (id);


--
-- Name: user_exporter user_exporter_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.user_exporter
    ADD CONSTRAINT user_exporter_pkey PRIMARY KEY (id);


--
-- Name: user_packhouse user_packhouse_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.user_packhouse
    ADD CONSTRAINT user_packhouse_pkey PRIMARY KEY (id);


--
-- Name: user_roles user_roles_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.user_roles
    ADD CONSTRAINT user_roles_pkey PRIMARY KEY (id);


--
-- Name: user_zones user_zones_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.user_zones
    ADD CONSTRAINT user_zones_pkey PRIMARY KEY (id);


--
-- Name: userlogs userlogs_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.userlogs
    ADD CONSTRAINT userlogs_pkey PRIMARY KEY (id);


--
-- Name: userotp userotp_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.userotp
    ADD CONSTRAINT userotp_pkey PRIMARY KEY (id);


--
-- Name: users users_email_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_email_key UNIQUE (email);


--
-- Name: users users_nin_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_nin_key UNIQUE (nin);


--
-- Name: users users_phone_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_phone_key UNIQUE (phone);


--
-- Name: users users_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_pkey PRIMARY KEY (id);


--
-- Name: users users_regno_key; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.users
    ADD CONSTRAINT users_regno_key UNIQUE (regno);


--
-- Name: villages villages_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.villages
    ADD CONSTRAINT villages_pkey PRIMARY KEY (id);


--
-- Name: zone_district zone_district_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.zone_district
    ADD CONSTRAINT zone_district_pkey PRIMARY KEY (id);


--
-- Name: zones zones_pkey; Type: CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.zones
    ADD CONSTRAINT zones_pkey PRIMARY KEY (id);


--
-- Name: airlines airlines_modeoftransport_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.airlines
    ADD CONSTRAINT airlines_modeoftransport_id_fkey FOREIGN KEY (modeoftransport_id) REFERENCES public.modesoftransport(id);


--
-- Name: boxes boxes_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.boxes
    ADD CONSTRAINT boxes_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: boxes boxes_packinglist_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.boxes
    ADD CONSTRAINT boxes_packinglist_id_fkey FOREIGN KEY (packinglist_id) REFERENCES public.packinglist(id);


--
-- Name: boxes boxes_product_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.boxes
    ADD CONSTRAINT boxes_product_id_fkey FOREIGN KEY (product_id) REFERENCES public.crops(id);


--
-- Name: boxes boxes_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.boxes
    ADD CONSTRAINT boxes_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: clients clients_country_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.clients
    ADD CONSTRAINT clients_country_id_fkey FOREIGN KEY (country_id) REFERENCES public.countries(id);


--
-- Name: clients clients_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.clients
    ADD CONSTRAINT clients_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: consignment_queries consignment_queries_plannedconsignment_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.consignment_queries
    ADD CONSTRAINT consignment_queries_plannedconsignment_id_fkey FOREIGN KEY (plannedconsignment_id) REFERENCES public.plannedconsignments(id);


--
-- Name: consignment_queries consignment_queries_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.consignment_queries
    ADD CONSTRAINT consignment_queries_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: consignmentstatustracker consignmentstatustracker_consignment_no_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.consignmentstatustracker
    ADD CONSTRAINT consignmentstatustracker_consignment_no_fkey FOREIGN KEY (consignment_no) REFERENCES public.plannedconsignments(id);


--
-- Name: destructionnotice destructionnotice_boarder_inspector_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.destructionnotice
    ADD CONSTRAINT destructionnotice_boarder_inspector_fkey FOREIGN KEY (boarder_inspector) REFERENCES public.users(id);


--
-- Name: destructionnotice destructionnotice_company_rep_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.destructionnotice
    ADD CONSTRAINT destructionnotice_company_rep_fkey FOREIGN KEY (company_rep) REFERENCES public.users(id);


--
-- Name: destructionnotice destructionnotice_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.destructionnotice
    ADD CONSTRAINT destructionnotice_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: destructionnotice destructionnotice_nppo_inspector_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.destructionnotice
    ADD CONSTRAINT destructionnotice_nppo_inspector_fkey FOREIGN KEY (nppo_inspector) REFERENCES public.users(id);


--
-- Name: destructionnotice destructionnotice_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.destructionnotice
    ADD CONSTRAINT destructionnotice_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: destructionothersnotice destructionothersnotice_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.destructionothersnotice
    ADD CONSTRAINT destructionothersnotice_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: destructionothersnotice destructionothersnotice_packinglist_others_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.destructionothersnotice
    ADD CONSTRAINT destructionothersnotice_packinglist_others_id_fkey FOREIGN KEY (packinglist_others_id) REFERENCES public.packinglist_others(id);


--
-- Name: destructionothersnotice destructionothersnotice_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.destructionothersnotice
    ADD CONSTRAINT destructionothersnotice_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: document_countries document_countries_country_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.document_countries
    ADD CONSTRAINT document_countries_country_id_fkey FOREIGN KEY (country_id) REFERENCES public.countries(id);


--
-- Name: document_countries document_countries_document_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.document_countries
    ADD CONSTRAINT document_countries_document_id_fkey FOREIGN KEY (document_id) REFERENCES public.documents(id);


--
-- Name: document_crops document_crops_crop_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.document_crops
    ADD CONSTRAINT document_crops_crop_id_fkey FOREIGN KEY (crop_id) REFERENCES public.crops(id);


--
-- Name: document_crops document_crops_document_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.document_crops
    ADD CONSTRAINT document_crops_document_id_fkey FOREIGN KEY (document_id) REFERENCES public.documents(id);


--
-- Name: exithandlers exithandlers_exitpoint_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.exithandlers
    ADD CONSTRAINT exithandlers_exitpoint_fkey FOREIGN KEY (exitpoint) REFERENCES public.exitpoints(id);


--
-- Name: exitpointroaster exitpointroaster_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.exitpointroaster
    ADD CONSTRAINT exitpointroaster_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: exitpoints exitpoints_district_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.exitpoints
    ADD CONSTRAINT exitpoints_district_id_fkey FOREIGN KEY (district_id) REFERENCES public.districts(id);


--
-- Name: exitpoints exitpoints_modeoftransport_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.exitpoints
    ADD CONSTRAINT exitpoints_modeoftransport_id_fkey FOREIGN KEY (modeoftransport_id) REFERENCES public.modesoftransport(id);


--
-- Name: exitpoints exitpoints_parish_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.exitpoints
    ADD CONSTRAINT exitpoints_parish_id_fkey FOREIGN KEY (parish_id) REFERENCES public.parishes(id);


--
-- Name: exitpoints exitpoints_village_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.exitpoints
    ADD CONSTRAINT exitpoints_village_id_fkey FOREIGN KEY (village_id) REFERENCES public.villages(id);


--
-- Name: exportcompanies exportcompanies_expdistrict_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.exportcompanies
    ADD CONSTRAINT exportcompanies_expdistrict_id_fkey FOREIGN KEY (expdistrict_id) REFERENCES public.districts(id);


--
-- Name: exportcompanies exportcompanies_expparish_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.exportcompanies
    ADD CONSTRAINT exportcompanies_expparish_id_fkey FOREIGN KEY (expparish_id) REFERENCES public.parishes(id);


--
-- Name: exportcompanies exportcompanies_expvillage_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.exportcompanies
    ADD CONSTRAINT exportcompanies_expvillage_id_fkey FOREIGN KEY (expvillage_id) REFERENCES public.villages(id);


--
-- Name: farmer_contacts farmer_contacts_farmer_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmer_contacts
    ADD CONSTRAINT farmer_contacts_farmer_id_fkey FOREIGN KEY (farmer_id) REFERENCES public.farmers(id);


--
-- Name: farmer_exporter farmer_exporter_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmer_exporter
    ADD CONSTRAINT farmer_exporter_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: farmer_exporter farmer_exporter_farmer_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmer_exporter
    ADD CONSTRAINT farmer_exporter_farmer_id_fkey FOREIGN KEY (farmer_id) REFERENCES public.farmers(id);


--
-- Name: farmer_farms farmer_farms_crop_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmer_farms
    ADD CONSTRAINT farmer_farms_crop_id_fkey FOREIGN KEY (crop_id) REFERENCES public.crops(id);


--
-- Name: farmer_farms farmer_farms_district_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmer_farms
    ADD CONSTRAINT farmer_farms_district_id_fkey FOREIGN KEY (district_id) REFERENCES public.districts(id);


--
-- Name: farmer_farms farmer_farms_farmer_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmer_farms
    ADD CONSTRAINT farmer_farms_farmer_id_fkey FOREIGN KEY (farmer_id) REFERENCES public.farmers(id);


--
-- Name: farmer_farms farmer_farms_parish_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmer_farms
    ADD CONSTRAINT farmer_farms_parish_id_fkey FOREIGN KEY (parish_id) REFERENCES public.parishes(id);


--
-- Name: farmer_farms farmer_farms_village_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmer_farms
    ADD CONSTRAINT farmer_farms_village_id_fkey FOREIGN KEY (village_id) REFERENCES public.villages(id);


--
-- Name: farmer_produce farmer_produce_crop_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmer_produce
    ADD CONSTRAINT farmer_produce_crop_id_fkey FOREIGN KEY (crop_id) REFERENCES public.crops(id);


--
-- Name: farmer_produce farmer_produce_farmer_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.farmer_produce
    ADD CONSTRAINT farmer_produce_farmer_id_fkey FOREIGN KEY (farmer_id) REFERENCES public.farmers(id);


--
-- Name: reception_documents fk_document_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.reception_documents
    ADD CONSTRAINT fk_document_id FOREIGN KEY (document_id) REFERENCES public.documents(id);


--
-- Name: plannedconsignments_documents fk_document_id; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.plannedconsignments_documents
    ADD CONSTRAINT fk_document_id FOREIGN KEY (document_id) REFERENCES public.documents(id);


--
-- Name: product_interception_notice fk_product_interception_notice_qcp5_products; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.product_interception_notice
    ADD CONSTRAINT fk_product_interception_notice_qcp5_products FOREIGN KEY (qcp5_row_id) REFERENCES public.qcp5_products(id);


--
-- Name: productothers_interception_notice fk_productothers_interception_notice_qcp5_others; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.productothers_interception_notice
    ADD CONSTRAINT fk_productothers_interception_notice_qcp5_others FOREIGN KEY (qcp5_row_other_id) REFERENCES public.qcp5_others(id);


--
-- Name: userlogs fk_userlogs_organisationid; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.userlogs
    ADD CONSTRAINT fk_userlogs_organisationid FOREIGN KEY (organisationid) REFERENCES public.exportcompanies(id);


--
-- Name: inspectionreport inspectionreport_consignment_no_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.inspectionreport
    ADD CONSTRAINT inspectionreport_consignment_no_fkey FOREIGN KEY (consignment_no) REFERENCES public.plannedconsignments(id);


--
-- Name: inspectionreport inspectionreport_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.inspectionreport
    ADD CONSTRAINT inspectionreport_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: inspectionreport inspectionreport_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.inspectionreport
    ADD CONSTRAINT inspectionreport_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: inspectionreportrecommendation inspectionreportrecommendation_consignment_no_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.inspectionreportrecommendation
    ADD CONSTRAINT inspectionreportrecommendation_consignment_no_fkey FOREIGN KEY (consignment_no) REFERENCES public.plannedconsignments(id);


--
-- Name: inspectionreportrecommendation inspectionreportrecommendation_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.inspectionreportrecommendation
    ADD CONSTRAINT inspectionreportrecommendation_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: inspectionreportrecommendation inspectionreportrecommendation_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.inspectionreportrecommendation
    ADD CONSTRAINT inspectionreportrecommendation_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: notifications notifications_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.notifications
    ADD CONSTRAINT notifications_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: notifications notifications_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.notifications
    ADD CONSTRAINT notifications_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: order_crops order_crops_crop_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.order_crops
    ADD CONSTRAINT order_crops_crop_id_fkey FOREIGN KEY (crop_id) REFERENCES public.crops(id);


--
-- Name: order_crops order_crops_order_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.order_crops
    ADD CONSTRAINT order_crops_order_id_fkey FOREIGN KEY (order_id) REFERENCES public.orders(id);


--
-- Name: orders orders_client_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.orders
    ADD CONSTRAINT orders_client_id_fkey FOREIGN KEY (client_id) REFERENCES public.clients(id);


--
-- Name: orders orders_consignment_no_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.orders
    ADD CONSTRAINT orders_consignment_no_fkey FOREIGN KEY (consignment_no) REFERENCES public.plannedconsignments(id);


--
-- Name: orders orders_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.orders
    ADD CONSTRAINT orders_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: orders orders_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.orders
    ADD CONSTRAINT orders_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: packhouse_exporter packhouse_exporter_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packhouse_exporter
    ADD CONSTRAINT packhouse_exporter_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: packhouse_exporter packhouse_exporter_packhouse_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packhouse_exporter
    ADD CONSTRAINT packhouse_exporter_packhouse_id_fkey FOREIGN KEY (packhouse_id) REFERENCES public.packhouses(id);


--
-- Name: packhouses packhouses_district_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packhouses
    ADD CONSTRAINT packhouses_district_id_fkey FOREIGN KEY (district_id) REFERENCES public.districts(id);


--
-- Name: packhouses packhouses_parish_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packhouses
    ADD CONSTRAINT packhouses_parish_id_fkey FOREIGN KEY (parish_id) REFERENCES public.parishes(id);


--
-- Name: packhouses packhouses_village_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packhouses
    ADD CONSTRAINT packhouses_village_id_fkey FOREIGN KEY (village_id) REFERENCES public.villages(id);


--
-- Name: packinglist_batch packinglist_batch_order_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packinglist_batch
    ADD CONSTRAINT packinglist_batch_order_id_fkey FOREIGN KEY (order_id) REFERENCES public.orders(id);


--
-- Name: packinglist_batch packinglist_batch_packinglist_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packinglist_batch
    ADD CONSTRAINT packinglist_batch_packinglist_id_fkey FOREIGN KEY (packinglist_id) REFERENCES public.packinglist(id);


--
-- Name: packinglist_batch packinglist_batch_product_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packinglist_batch
    ADD CONSTRAINT packinglist_batch_product_id_fkey FOREIGN KEY (product_id) REFERENCES public.crops(id);


--
-- Name: packinglist_batch packinglist_batch_receptionform_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packinglist_batch
    ADD CONSTRAINT packinglist_batch_receptionform_id_fkey FOREIGN KEY (receptionform_id) REFERENCES public.receptionform(id);


--
-- Name: packinglist packinglist_order_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packinglist
    ADD CONSTRAINT packinglist_order_id_fkey FOREIGN KEY (order_id) REFERENCES public.orders(id);


--
-- Name: packinglist_others packinglist_others_packinglist_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packinglist_others
    ADD CONSTRAINT packinglist_others_packinglist_id_fkey FOREIGN KEY (packinglist_id) REFERENCES public.packinglist(id);


--
-- Name: packinglist_products packinglist_products_order_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packinglist_products
    ADD CONSTRAINT packinglist_products_order_id_fkey FOREIGN KEY (order_id) REFERENCES public.orders(id);


--
-- Name: packinglist_products packinglist_products_packinglist_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packinglist_products
    ADD CONSTRAINT packinglist_products_packinglist_id_fkey FOREIGN KEY (packinglist_id) REFERENCES public.packinglist(id);


--
-- Name: packinglist_products packinglist_products_product_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packinglist_products
    ADD CONSTRAINT packinglist_products_product_id_fkey FOREIGN KEY (product_id) REFERENCES public.crops(id);


--
-- Name: packinglist_products packinglist_products_receptionform_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.packinglist_products
    ADD CONSTRAINT packinglist_products_receptionform_id_fkey FOREIGN KEY (receptionform_id) REFERENCES public.receptionform(id);


--
-- Name: parishes parishes_subcounty_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.parishes
    ADD CONSTRAINT parishes_subcounty_id_fkey FOREIGN KEY (subcounty_id) REFERENCES public.subcounties(id);


--
-- Name: plannedconsignments_documents plannedconsignments_documents_plc_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.plannedconsignments_documents
    ADD CONSTRAINT plannedconsignments_documents_plc_id_fkey FOREIGN KEY (plc_id) REFERENCES public.plannedconsignments(id);


--
-- Name: plannedconsignments plannedconsignments_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.plannedconsignments
    ADD CONSTRAINT plannedconsignments_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: plannedconsignments_otherdocuments plannedconsignments_otherdocuments_plannedconsignments_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.plannedconsignments_otherdocuments
    ADD CONSTRAINT plannedconsignments_otherdocuments_plannedconsignments_id_fkey FOREIGN KEY (plannedconsignments_id) REFERENCES public.plannedconsignments(id);


--
-- Name: plannedconsignments_tpdetails plannedconsignments_tpdetails_airline_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.plannedconsignments_tpdetails
    ADD CONSTRAINT plannedconsignments_tpdetails_airline_id_fkey FOREIGN KEY (airline_id) REFERENCES public.airlines(id);


--
-- Name: plannedconsignments_tpdetails plannedconsignments_tpdetails_country_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.plannedconsignments_tpdetails
    ADD CONSTRAINT plannedconsignments_tpdetails_country_id_fkey FOREIGN KEY (country_id) REFERENCES public.countries(id);


--
-- Name: plannedconsignments_tpdetails plannedconsignments_tpdetails_exithandler_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.plannedconsignments_tpdetails
    ADD CONSTRAINT plannedconsignments_tpdetails_exithandler_id_fkey FOREIGN KEY (exithandler_id) REFERENCES public.exithandlers(id);


--
-- Name: plannedconsignments_tpdetails plannedconsignments_tpdetails_exitpoint_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.plannedconsignments_tpdetails
    ADD CONSTRAINT plannedconsignments_tpdetails_exitpoint_id_fkey FOREIGN KEY (exitpoint_id) REFERENCES public.exitpoints(id);


--
-- Name: plannedconsignments_tpdetails plannedconsignments_tpdetails_modesoftransport_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.plannedconsignments_tpdetails
    ADD CONSTRAINT plannedconsignments_tpdetails_modesoftransport_id_fkey FOREIGN KEY (modesoftransport_id) REFERENCES public.modesoftransport(id);


--
-- Name: plannedconsignments_tpdetails plannedconsignments_tpdetails_plannedconsignments_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.plannedconsignments_tpdetails
    ADD CONSTRAINT plannedconsignments_tpdetails_plannedconsignments_id_fkey FOREIGN KEY (plannedconsignments_id) REFERENCES public.plannedconsignments(id);


--
-- Name: plannedconsignments plannedconsignments_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.plannedconsignments
    ADD CONSTRAINT plannedconsignments_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: product_interception_notice product_interception_notice_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.product_interception_notice
    ADD CONSTRAINT product_interception_notice_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: product_interception_notice product_interception_notice_packinglist_product_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.product_interception_notice
    ADD CONSTRAINT product_interception_notice_packinglist_product_id_fkey FOREIGN KEY (packinglist_product_id) REFERENCES public.packinglist_products(id);


--
-- Name: product_interception_notice product_interception_notice_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.product_interception_notice
    ADD CONSTRAINT product_interception_notice_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: productothers_interception_notice productothers_interception_notice_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.productothers_interception_notice
    ADD CONSTRAINT productothers_interception_notice_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: productothers_interception_notice productothers_interception_notice_packinglist_other_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.productothers_interception_notice
    ADD CONSTRAINT productothers_interception_notice_packinglist_other_id_fkey FOREIGN KEY (packinglist_other_id) REFERENCES public.packinglist_others(id);


--
-- Name: productothers_interception_notice productothers_interception_notice_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.productothers_interception_notice
    ADD CONSTRAINT productothers_interception_notice_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: qcp1_attributes qcp1_attributes_qcp1_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp1_attributes
    ADD CONSTRAINT qcp1_attributes_qcp1_id_fkey FOREIGN KEY (qcp1_id) REFERENCES public.qcp1(id);


--
-- Name: qcp1_attributes qcp1_attributes_qualityattribute_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp1_attributes
    ADD CONSTRAINT qcp1_attributes_qualityattribute_id_fkey FOREIGN KEY (qualityattribute_id) REFERENCES public.qualityattributes(id);


--
-- Name: qcp1 qcp1_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp1
    ADD CONSTRAINT qcp1_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: qcp1 qcp1_receptionform_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp1
    ADD CONSTRAINT qcp1_receptionform_id_fkey FOREIGN KEY (receptionform_id) REFERENCES public.receptionform(id);


--
-- Name: qcp1_recommendation qcp1_recommendation_qcp1_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp1_recommendation
    ADD CONSTRAINT qcp1_recommendation_qcp1_id_fkey FOREIGN KEY (qcp1_id) REFERENCES public.qcp1(id);


--
-- Name: qcp1 qcp1_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp1
    ADD CONSTRAINT qcp1_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: qcp2_attributes qcp2_attributes_qcp2_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp2_attributes
    ADD CONSTRAINT qcp2_attributes_qcp2_id_fkey FOREIGN KEY (qcp2_id) REFERENCES public.qcp2(id);


--
-- Name: qcp2_attributes qcp2_attributes_qualityattribute_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp2_attributes
    ADD CONSTRAINT qcp2_attributes_qualityattribute_id_fkey FOREIGN KEY (qualityattribute_id) REFERENCES public.qualityattributes(id);


--
-- Name: qcp2 qcp2_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp2
    ADD CONSTRAINT qcp2_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: qcp2 qcp2_reception_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp2
    ADD CONSTRAINT qcp2_reception_id_fkey FOREIGN KEY (reception_id) REFERENCES public.receptionform(id);


--
-- Name: qcp2_recommendation qcp2_recommendation_qcp2_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp2_recommendation
    ADD CONSTRAINT qcp2_recommendation_qcp2_id_fkey FOREIGN KEY (qcp2_id) REFERENCES public.qcp2(id);


--
-- Name: qcp2 qcp2_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp2
    ADD CONSTRAINT qcp2_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: qcp3_attributes qcp3_attributes_qcp3_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp3_attributes
    ADD CONSTRAINT qcp3_attributes_qcp3_id_fkey FOREIGN KEY (qcp3_id) REFERENCES public.qcp3(id);


--
-- Name: qcp3_attributes qcp3_attributes_qualityattribute_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp3_attributes
    ADD CONSTRAINT qcp3_attributes_qualityattribute_id_fkey FOREIGN KEY (qualityattribute_id) REFERENCES public.qualityattributes(id);


--
-- Name: qcp3 qcp3_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp3
    ADD CONSTRAINT qcp3_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: qcp3 qcp3_reception_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp3
    ADD CONSTRAINT qcp3_reception_id_fkey FOREIGN KEY (reception_id) REFERENCES public.receptionform(id);


--
-- Name: qcp3_recommendation qcp3_recommendation_qcp3_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp3_recommendation
    ADD CONSTRAINT qcp3_recommendation_qcp3_id_fkey FOREIGN KEY (qcp3_id) REFERENCES public.qcp3(id);


--
-- Name: qcp3 qcp3_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp3
    ADD CONSTRAINT qcp3_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: qcp4_attributes qcp4_attributes_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_attributes
    ADD CONSTRAINT qcp4_attributes_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: qcp4_attributes qcp4_attributes_qcp4_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_attributes
    ADD CONSTRAINT qcp4_attributes_qcp4_id_fkey FOREIGN KEY (qcp4_id) REFERENCES public.qcp4(id);


--
-- Name: qcp4_attributes qcp4_attributes_qcp4_product_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_attributes
    ADD CONSTRAINT qcp4_attributes_qcp4_product_id_fkey FOREIGN KEY (qcp4_product_id) REFERENCES public.qcp4_products(id);


--
-- Name: qcp4_attributes qcp4_attributes_qualityattributes_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_attributes
    ADD CONSTRAINT qcp4_attributes_qualityattributes_id_fkey FOREIGN KEY (qualityattributes_id) REFERENCES public.qualityattributes(id);


--
-- Name: qcp4_attributes qcp4_attributes_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_attributes
    ADD CONSTRAINT qcp4_attributes_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: qcp4 qcp4_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4
    ADD CONSTRAINT qcp4_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: qcp4_other_attributes qcp4_other_attributes_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_other_attributes
    ADD CONSTRAINT qcp4_other_attributes_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: qcp4_other_attributes qcp4_other_attributes_qcp4_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_other_attributes
    ADD CONSTRAINT qcp4_other_attributes_qcp4_id_fkey FOREIGN KEY (qcp4_id) REFERENCES public.qcp4(id);


--
-- Name: qcp4_other_attributes qcp4_other_attributes_qcp4_other_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_other_attributes
    ADD CONSTRAINT qcp4_other_attributes_qcp4_other_id_fkey FOREIGN KEY (qcp4_other_id) REFERENCES public.qcp4_others(id);


--
-- Name: qcp4_other_attributes qcp4_other_attributes_qualityattributes_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_other_attributes
    ADD CONSTRAINT qcp4_other_attributes_qualityattributes_id_fkey FOREIGN KEY (qualityattributes_id) REFERENCES public.qualityattributes(id);


--
-- Name: qcp4_other_attributes qcp4_other_attributes_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_other_attributes
    ADD CONSTRAINT qcp4_other_attributes_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: qcp4_otherrecommendations qcp4_otherrecommendations_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_otherrecommendations
    ADD CONSTRAINT qcp4_otherrecommendations_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: qcp4_otherrecommendations qcp4_otherrecommendations_qcp4_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_otherrecommendations
    ADD CONSTRAINT qcp4_otherrecommendations_qcp4_id_fkey FOREIGN KEY (qcp4_id) REFERENCES public.qcp4(id);


--
-- Name: qcp4_otherrecommendations qcp4_otherrecommendations_qcp4_others_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_otherrecommendations
    ADD CONSTRAINT qcp4_otherrecommendations_qcp4_others_id_fkey FOREIGN KEY (qcp4_others_id) REFERENCES public.qcp4_others(id);


--
-- Name: qcp4_otherrecommendations qcp4_otherrecommendations_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_otherrecommendations
    ADD CONSTRAINT qcp4_otherrecommendations_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: qcp4_others qcp4_others_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_others
    ADD CONSTRAINT qcp4_others_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: qcp4_others qcp4_others_packinglist_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_others
    ADD CONSTRAINT qcp4_others_packinglist_id_fkey FOREIGN KEY (packinglist_id) REFERENCES public.packinglist(id);


--
-- Name: qcp4_others qcp4_others_qcp4_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_others
    ADD CONSTRAINT qcp4_others_qcp4_id_fkey FOREIGN KEY (qcp4_id) REFERENCES public.qcp4(id);


--
-- Name: qcp4_others qcp4_others_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_others
    ADD CONSTRAINT qcp4_others_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: qcp4 qcp4_packinglist_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4
    ADD CONSTRAINT qcp4_packinglist_id_fkey FOREIGN KEY (packinglist_id) REFERENCES public.packinglist(id);


--
-- Name: qcp4_products qcp4_products_product_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_products
    ADD CONSTRAINT qcp4_products_product_id_fkey FOREIGN KEY (product_id) REFERENCES public.crops(id);


--
-- Name: qcp4_products qcp4_products_qcp4_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_products
    ADD CONSTRAINT qcp4_products_qcp4_id_fkey FOREIGN KEY (qcp4_id) REFERENCES public.qcp4(id);


--
-- Name: qcp4_recommendations qcp4_recommendations_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_recommendations
    ADD CONSTRAINT qcp4_recommendations_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: qcp4_recommendations qcp4_recommendations_qcp4_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_recommendations
    ADD CONSTRAINT qcp4_recommendations_qcp4_id_fkey FOREIGN KEY (qcp4_id) REFERENCES public.qcp4(id);


--
-- Name: qcp4_recommendations qcp4_recommendations_qcp4_product_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_recommendations
    ADD CONSTRAINT qcp4_recommendations_qcp4_product_id_fkey FOREIGN KEY (qcp4_product_id) REFERENCES public.qcp4_products(id);


--
-- Name: qcp4_recommendations qcp4_recommendations_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4_recommendations
    ADD CONSTRAINT qcp4_recommendations_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: qcp4 qcp4_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp4
    ADD CONSTRAINT qcp4_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: qcp5_attributes qcp5_attributes_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_attributes
    ADD CONSTRAINT qcp5_attributes_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: qcp5_attributes qcp5_attributes_qcp5_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_attributes
    ADD CONSTRAINT qcp5_attributes_qcp5_id_fkey FOREIGN KEY (qcp5_id) REFERENCES public.qcp5(id);


--
-- Name: qcp5_attributes qcp5_attributes_qcp5_product_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_attributes
    ADD CONSTRAINT qcp5_attributes_qcp5_product_id_fkey FOREIGN KEY (qcp5_product_id) REFERENCES public.qcp5_products(id);


--
-- Name: qcp5_attributes qcp5_attributes_qualityattributes_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_attributes
    ADD CONSTRAINT qcp5_attributes_qualityattributes_id_fkey FOREIGN KEY (qualityattributes_id) REFERENCES public.qualityattributes(id);


--
-- Name: qcp5_attributes qcp5_attributes_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_attributes
    ADD CONSTRAINT qcp5_attributes_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: qcp5 qcp5_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5
    ADD CONSTRAINT qcp5_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: qcp5_other_attributes qcp5_other_attributes_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_other_attributes
    ADD CONSTRAINT qcp5_other_attributes_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: qcp5_other_attributes qcp5_other_attributes_qcp5_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_other_attributes
    ADD CONSTRAINT qcp5_other_attributes_qcp5_id_fkey FOREIGN KEY (qcp5_id) REFERENCES public.qcp5(id);


--
-- Name: qcp5_other_attributes qcp5_other_attributes_qcp5_other_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_other_attributes
    ADD CONSTRAINT qcp5_other_attributes_qcp5_other_id_fkey FOREIGN KEY (qcp5_other_id) REFERENCES public.qcp5_others(id);


--
-- Name: qcp5_other_attributes qcp5_other_attributes_qualityattributes_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_other_attributes
    ADD CONSTRAINT qcp5_other_attributes_qualityattributes_id_fkey FOREIGN KEY (qualityattributes_id) REFERENCES public.qualityattributes(id);


--
-- Name: qcp5_other_attributes qcp5_other_attributes_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_other_attributes
    ADD CONSTRAINT qcp5_other_attributes_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: qcp5_otherrecommendations qcp5_otherrecommendations_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_otherrecommendations
    ADD CONSTRAINT qcp5_otherrecommendations_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: qcp5_otherrecommendations qcp5_otherrecommendations_qcp5_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_otherrecommendations
    ADD CONSTRAINT qcp5_otherrecommendations_qcp5_id_fkey FOREIGN KEY (qcp5_id) REFERENCES public.qcp5(id);


--
-- Name: qcp5_otherrecommendations qcp5_otherrecommendations_qcp5_others_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_otherrecommendations
    ADD CONSTRAINT qcp5_otherrecommendations_qcp5_others_id_fkey FOREIGN KEY (qcp5_others_id) REFERENCES public.qcp5_others(id);


--
-- Name: qcp5_otherrecommendations qcp5_otherrecommendations_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_otherrecommendations
    ADD CONSTRAINT qcp5_otherrecommendations_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: qcp5_others qcp5_others_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_others
    ADD CONSTRAINT qcp5_others_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: qcp5_others qcp5_others_packinglist_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_others
    ADD CONSTRAINT qcp5_others_packinglist_id_fkey FOREIGN KEY (packinglist_id) REFERENCES public.packinglist(id);


--
-- Name: qcp5_others qcp5_others_qcp5_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_others
    ADD CONSTRAINT qcp5_others_qcp5_id_fkey FOREIGN KEY (qcp5_id) REFERENCES public.qcp5(id);


--
-- Name: qcp5_others qcp5_others_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_others
    ADD CONSTRAINT qcp5_others_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: qcp5 qcp5_packinglist_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5
    ADD CONSTRAINT qcp5_packinglist_id_fkey FOREIGN KEY (packinglist_id) REFERENCES public.packinglist(id);


--
-- Name: qcp5_products qcp5_products_product_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_products
    ADD CONSTRAINT qcp5_products_product_id_fkey FOREIGN KEY (product_id) REFERENCES public.crops(id);


--
-- Name: qcp5_products qcp5_products_qcp5_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_products
    ADD CONSTRAINT qcp5_products_qcp5_id_fkey FOREIGN KEY (qcp5_id) REFERENCES public.qcp5(id);


--
-- Name: qcp5_recommendations qcp5_recommendations_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_recommendations
    ADD CONSTRAINT qcp5_recommendations_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: qcp5_recommendations qcp5_recommendations_qcp5_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_recommendations
    ADD CONSTRAINT qcp5_recommendations_qcp5_id_fkey FOREIGN KEY (qcp5_id) REFERENCES public.qcp5(id);


--
-- Name: qcp5_recommendations qcp5_recommendations_qcp5_product_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_recommendations
    ADD CONSTRAINT qcp5_recommendations_qcp5_product_id_fkey FOREIGN KEY (qcp5_product_id) REFERENCES public.qcp5_products(id);


--
-- Name: qcp5_recommendations qcp5_recommendations_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5_recommendations
    ADD CONSTRAINT qcp5_recommendations_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: qcp5 qcp5_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5
    ADD CONSTRAINT qcp5_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: qcp5inspectionreportrecommendation qcp5inspectionreportrecommendation_consignment_no_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5inspectionreportrecommendation
    ADD CONSTRAINT qcp5inspectionreportrecommendation_consignment_no_fkey FOREIGN KEY (consignment_no) REFERENCES public.plannedconsignments(id);


--
-- Name: qcp5inspectionreportrecommendation qcp5inspectionreportrecommendation_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5inspectionreportrecommendation
    ADD CONSTRAINT qcp5inspectionreportrecommendation_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: qcp5inspectionreportrecommendation qcp5inspectionreportrecommendation_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.qcp5inspectionreportrecommendation
    ADD CONSTRAINT qcp5inspectionreportrecommendation_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: reception_attributes reception_attributes_qualityattribute_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.reception_attributes
    ADD CONSTRAINT reception_attributes_qualityattribute_id_fkey FOREIGN KEY (qualityattribute_id) REFERENCES public.qualityattributes(id);


--
-- Name: reception_attributes reception_attributes_receptionform_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.reception_attributes
    ADD CONSTRAINT reception_attributes_receptionform_id_fkey FOREIGN KEY (receptionform_id) REFERENCES public.receptionform(id);


--
-- Name: reception_documents reception_documents_receptionform_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.reception_documents
    ADD CONSTRAINT reception_documents_receptionform_id_fkey FOREIGN KEY (receptionform_id) REFERENCES public.receptionform(id);


--
-- Name: reception_otherdocuments reception_otherdocuments_receptionform_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.reception_otherdocuments
    ADD CONSTRAINT reception_otherdocuments_receptionform_id_fkey FOREIGN KEY (receptionform_id) REFERENCES public.receptionform(id);


--
-- Name: receptionform receptionform_crop_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.receptionform
    ADD CONSTRAINT receptionform_crop_id_fkey FOREIGN KEY (crop_id) REFERENCES public.crops(id);


--
-- Name: receptionform receptionform_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.receptionform
    ADD CONSTRAINT receptionform_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: receptionform receptionform_modeoftransport_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.receptionform
    ADD CONSTRAINT receptionform_modeoftransport_id_fkey FOREIGN KEY (modeoftransport_id) REFERENCES public.modesoftransport(id);


--
-- Name: receptionform receptionform_order_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.receptionform
    ADD CONSTRAINT receptionform_order_id_fkey FOREIGN KEY (order_id) REFERENCES public.orders(id);


--
-- Name: receptionform receptionform_packhouse_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.receptionform
    ADD CONSTRAINT receptionform_packhouse_id_fkey FOREIGN KEY (packhouse_id) REFERENCES public.packhouses(id);


--
-- Name: receptionform_qrcodes receptionform_qrcodes_receptionform_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.receptionform_qrcodes
    ADD CONSTRAINT receptionform_qrcodes_receptionform_id_fkey FOREIGN KEY (receptionform_id) REFERENCES public.receptionform(id);


--
-- Name: receptionform receptionform_supplier_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.receptionform
    ADD CONSTRAINT receptionform_supplier_id_fkey FOREIGN KEY (supplier_id) REFERENCES public.farmers(id);


--
-- Name: receptionform receptionform_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.receptionform
    ADD CONSTRAINT receptionform_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: redflags redflags_crop_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.redflags
    ADD CONSTRAINT redflags_crop_id_fkey FOREIGN KEY (crop_id) REFERENCES public.crops(id);


--
-- Name: redflags redflags_farmer_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.redflags
    ADD CONSTRAINT redflags_farmer_id_fkey FOREIGN KEY (farmer_id) REFERENCES public.farmers(id);


--
-- Name: redflags redflags_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.redflags
    ADD CONSTRAINT redflags_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: roastercount roastercount_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.roastercount
    ADD CONSTRAINT roastercount_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: role_permissions role_permissions_role_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.role_permissions
    ADD CONSTRAINT role_permissions_role_id_fkey FOREIGN KEY (role_id) REFERENCES public.roles(id);


--
-- Name: roles roles_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.roles
    ADD CONSTRAINT roles_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: sessions sessions_exitpoint_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sessions
    ADD CONSTRAINT sessions_exitpoint_id_fkey FOREIGN KEY (exitpoint_id) REFERENCES public.exitpoints(id);


--
-- Name: sessions sessions_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sessions
    ADD CONSTRAINT sessions_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: sessions sessions_packhouse_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sessions
    ADD CONSTRAINT sessions_packhouse_id_fkey FOREIGN KEY (packhouse_id) REFERENCES public.packhouses(id);


--
-- Name: sessions sessions_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.sessions
    ADD CONSTRAINT sessions_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: subcounties subcounties_district_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.subcounties
    ADD CONSTRAINT subcounties_district_id_fkey FOREIGN KEY (district_id) REFERENCES public.districts(id);


--
-- Name: suspensionreport suspensionreport_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.suspensionreport
    ADD CONSTRAINT suspensionreport_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: suspensionreport suspensionreport_packhouse_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.suspensionreport
    ADD CONSTRAINT suspensionreport_packhouse_id_fkey FOREIGN KEY (packhouse_id) REFERENCES public.packhouses(id);


--
-- Name: suspensionreport suspensionreport_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.suspensionreport
    ADD CONSTRAINT suspensionreport_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: trackhygienereport_checklist trackhygienereport_checklist_trackhygiene_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.trackhygienereport_checklist
    ADD CONSTRAINT trackhygienereport_checklist_trackhygiene_id_fkey FOREIGN KEY (trackhygiene_id) REFERENCES public.trackhygiene(id);


--
-- Name: trackhygienereport_checklist trackhygienereport_checklist_trackhygienereport_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.trackhygienereport_checklist
    ADD CONSTRAINT trackhygienereport_checklist_trackhygienereport_id_fkey FOREIGN KEY (trackhygienereport_id) REFERENCES public.trackhygienereport(id);


--
-- Name: trackhygienereport trackhygienereport_consignment_no_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.trackhygienereport
    ADD CONSTRAINT trackhygienereport_consignment_no_fkey FOREIGN KEY (consignment_no) REFERENCES public.plannedconsignments(id);


--
-- Name: user_exporter user_exporter_exportcompany_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.user_exporter
    ADD CONSTRAINT user_exporter_exportcompany_id_fkey FOREIGN KEY (exportcompany_id) REFERENCES public.exportcompanies(id);


--
-- Name: user_exporter user_exporter_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.user_exporter
    ADD CONSTRAINT user_exporter_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: user_packhouse user_packhouse_packhouse_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.user_packhouse
    ADD CONSTRAINT user_packhouse_packhouse_id_fkey FOREIGN KEY (packhouse_id) REFERENCES public.packhouses(id);


--
-- Name: user_packhouse user_packhouse_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.user_packhouse
    ADD CONSTRAINT user_packhouse_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: user_roles user_roles_role_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.user_roles
    ADD CONSTRAINT user_roles_role_id_fkey FOREIGN KEY (role_id) REFERENCES public.roles(id);


--
-- Name: user_roles user_roles_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.user_roles
    ADD CONSTRAINT user_roles_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: user_zones user_zones_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.user_zones
    ADD CONSTRAINT user_zones_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: user_zones user_zones_zone_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.user_zones
    ADD CONSTRAINT user_zones_zone_id_fkey FOREIGN KEY (zone_id) REFERENCES public.zones(id);


--
-- Name: userlogs userlogs_user_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.userlogs
    ADD CONSTRAINT userlogs_user_id_fkey FOREIGN KEY (user_id) REFERENCES public.users(id);


--
-- Name: villages villages_parish_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.villages
    ADD CONSTRAINT villages_parish_id_fkey FOREIGN KEY (parish_id) REFERENCES public.parishes(id);


--
-- Name: zone_district zone_district_district_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.zone_district
    ADD CONSTRAINT zone_district_district_id_fkey FOREIGN KEY (district_id) REFERENCES public.districts(id);


--
-- Name: zone_district zone_district_zone_id_fkey; Type: FK CONSTRAINT; Schema: public; Owner: -
--

ALTER TABLE ONLY public.zone_district
    ADD CONSTRAINT zone_district_zone_id_fkey FOREIGN KEY (zone_id) REFERENCES public.zones(id);


--
--

