70929	Katengyeto	UG57310947	8079	2025-03-24 10:38:43.659029+00
70930	Katerananga	UG37649120	8079	2025-03-24 10:38:43.660939+00
70931	Rwakaterere	UG51901445	8079	2025-03-24 10:38:43.662878+00
70932	Rwendama	UG20912348	8079	2025-03-24 10:38:43.664819+00
70933	Rwenjeru North	UG41943739	8079	2025-03-24 10:38:43.666693+00
70934	Rwenjeru South	UG17432759	8079	2025-03-24 10:38:43.668645+00
70935	Bugashe	UG21221968	10704	2025-03-24 10:38:43.670926+00
70936	Kanyamurimi	UG27512460	10704	2025-03-24 10:38:43.673217+00
70937	Kibaya I	UG30880249	10704	2025-03-24 10:38:43.675497+00
70938	Kibaya Ii	UG27712458	10704	2025-03-24 10:38:43.677852+00
70939	Kibona	UG97913199	10704	2025-03-24 10:38:43.68025+00
70940	Nyakahanga	UG84424213	10704	2025-03-24 10:38:43.682561+00
70941	Rutooma	UG42005855	10704	2025-03-24 10:38:43.684849+00
70942	Kakoba Central	UG48582016	10705	2025-03-24 10:38:43.68716+00
70943	Kakoba Quarters	UG40946488	10705	2025-03-24 10:38:43.689483+00
70944	Kihindi	UG59183226	10705	2025-03-24 10:38:43.691874+00
70945	Kisenyi A	UG31492245	10705	2025-03-24 10:38:43.694485+00
70946	Kishwahili	UG5863952	10705	2025-03-24 10:38:43.697129+00
70947	Kyapotani	UG7664675	10705	2025-03-24 10:38:43.703034+00
70948	Lugazi	UG4424530	10705	2025-03-24 10:38:43.705503+00
70949	Mandela	UG37366616	10705	2025-03-24 10:38:43.707961+00
70950	N.T.C	UG18013357	10705	2025-03-24 10:38:43.710533+00
70951	Nyakaizi	UG41904462	10705	2025-03-24 10:38:43.712943+00
70952	Police/Prisons	UG50433850	10705	2025-03-24 10:38:43.715308+00
70953	Rwentondo	UG55671338	10705	2025-03-24 10:38:43.717635+00
70954	Bihunya	UG25473100	10706	2025-03-24 10:38:43.719938+00
70955	Karugangama	UG43957290	10706	2025-03-24 10:38:43.7222+00
70956	Katete Central	UG30096079	10706	2025-03-24 10:38:43.724494+00
70957	Kitebero	UG18815378	10706	2025-03-24 10:38:43.726796+00
70958	Nsiikye	UG78093348	10706	2025-03-24 10:38:43.729124+00
70959	Nyamitanga	UG6081842	10706	2025-03-24 10:38:43.731452+00
70960	Rwemirinzi	UG26360852	10706	2025-03-24 10:38:43.73373+00
70961	Rwizi	UG90944637	10706	2025-03-24 10:38:43.736076+00
70962	Karugyembe	UG69637926	8911	2025-03-24 10:38:43.738135+00
70963	Kibingo	UG13847130	8911	2025-03-24 10:38:43.740174+00
70964	Kitagata	UG25143195	8911	2025-03-24 10:38:43.742304+00
70965	Kitooma	UG59548341	8911	2025-03-24 10:38:43.744405+00
70966	Ngaara	UG89495530	8911	2025-03-24 10:38:43.746488+00
70967	Nyakashambya	UG33447802	8911	2025-03-24 10:38:43.748573+00
70968	Rwariire I	UG89957040	8911	2025-03-24 10:38:43.750561+00
70969	Rwariire Ii	UG4496421	8911	2025-03-24 10:38:43.752696+00
70970	Rwemigina	UG75033104	8911	2025-03-24 10:38:43.754711+00
70971	Rwentondo	UG43444673	8911	2025-03-24 10:38:43.756693+00
70972	Kambaba I	UG90245915	10708	2025-03-24 10:38:43.759016+00
70973	Kambaba Ii	UG88256052	10708	2025-03-24 10:38:43.761291+00
70974	Karengye	UG49368860	10708	2025-03-24 10:38:43.763606+00
70975	Katanda I	UG5336776	10708	2025-03-24 10:38:43.765882+00
70976	Katanda Ii	UG96370219	10708	2025-03-24 10:38:43.768168+00
70977	Keishazi	UG46400178	10708	2025-03-24 10:38:43.770389+00
70978	Kicwamba	UG84300510	10708	2025-03-24 10:38:43.772664+00
70979	Mutukura I	UG26231215	10708	2025-03-24 10:38:43.77493+00
70980	Mutukura Ii	UG99373689	10708	2025-03-24 10:38:43.77734+00
70981	Agip	UG87348448	10709	2025-03-24 10:38:43.779768+00
70982	Central	UG18404970	10709	2025-03-24 10:38:43.782039+00
70983	Kabateraine	UG68444444	10709	2025-03-24 10:38:43.784324+00
70984	Kilembe	UG64802372	10709	2025-03-24 10:38:43.786486+00
70985	Lower	UG7746853	10709	2025-03-24 10:38:43.788847+00
70986	Lubiri	UG18209656	10709	2025-03-24 10:38:43.791171+00
70987	Market	UG3126102	10709	2025-03-24 10:38:43.793517+00
70988	Muti	UG12153428	10709	2025-03-24 10:38:43.795844+00
70989	Survey	UG1303577	10709	2025-03-24 10:38:43.798115+00
70990	Upper	UG60874375	10709	2025-03-24 10:38:43.80039+00
70991	Ibaare	UG24024187	10710	2025-03-24 10:38:43.802661+00
70992	Kabingo	UG99901746	10710	2025-03-24 10:38:43.804924+00
70993	Karambi	UG89523201	10710	2025-03-24 10:38:43.807171+00
70994	Kashojwa	UG1423565	10710	2025-03-24 10:38:43.809512+00
70995	Katukuru	UG63365226	10710	2025-03-24 10:38:43.811782+00
70996	Keijengye	UG6435592	10710	2025-03-24 10:38:43.814113+00
70997	Kiboroga	UG66590080	10710	2025-03-24 10:38:43.816404+00
70998	Kinyaza	UG18929088	10710	2025-03-24 10:38:43.818698+00
70999	Kishenyi	UG38360499	10710	2025-03-24 10:38:43.821005+00
71000	Mabira	UG41814096	10710	2025-03-24 10:38:43.823277+00
71001	Macuro	UG46593860	10710	2025-03-24 10:38:43.825621+00
71002	Nyamatojo	UG32897586	10710	2025-03-24 10:38:43.827992+00
71003	Nyarubungo	UG18149792	10710	2025-03-24 10:38:43.830362+00
71004	Rwakwezi	UG95008849	10710	2025-03-24 10:38:43.83267+00
71005	Bwenkoma A	UG27914660	10711	2025-03-24 10:38:43.836634+00
71006	Bwenkoma B	UG28589102	10711	2025-03-24 10:38:43.838954+00
71007	Kagando A	UG3778104	10711	2025-03-24 10:38:43.841276+00
71008	Kagando B	UG69914614	10711	2025-03-24 10:38:43.843585+00
71009	Nyakakoni A	UG9232433	10711	2025-03-24 10:38:43.845862+00
71010	Nyakakoni B	UG12461631	10711	2025-03-24 10:38:43.84825+00
71011	Nyamiyaga	UG95116807	10711	2025-03-24 10:38:43.850573+00
71012	Rukindo	UG584316	10711	2025-03-24 10:38:43.8529+00
71013	Kafunda	UG13047241	10712	2025-03-24 10:38:43.855166+00
71014	Kateera	UG57467816	10712	2025-03-24 10:38:43.85744+00
71015	Kirehe	UG24180328	10712	2025-03-24 10:38:43.859871+00
71016	Market	UG10908991	10712	2025-03-24 10:38:43.862175+00
71017	Nsiikye	UG9031909	10712	2025-03-24 10:38:43.864543+00
71018	Nyamitanga	UG62761836	10712	2025-03-24 10:38:43.86683+00
71019	Rwizi	UG76712036	10712	2025-03-24 10:38:43.869206+00
71020	Tankhill	UG70910890	10712	2025-03-24 10:38:43.871477+00
71021	Bwigara	UG35165142	10713	2025-03-24 10:38:43.8737+00
71022	Kagasha	UG35127703	10713	2025-03-24 10:38:43.875954+00
71023	Karama I	UG92971795	10713	2025-03-24 10:38:43.878136+00
71024	Karama Ii	UG9138355	10713	2025-03-24 10:38:43.880415+00
71025	Kibingo	UG98855640	10713	2025-03-24 10:38:43.883176+00
71026	Kiyonza	UG39569014	10713	2025-03-24 10:38:43.885445+00
71027	Mistyamo	UG24148920	10713	2025-03-24 10:38:43.887788+00
71028	Nshungyezi	UG2120563	10713	2025-03-24 10:38:43.890094+00
71029	Nyakasa	UG49781107	10713	2025-03-24 10:38:43.892456+00
71030	Rucece	UG40910017	10713	2025-03-24 10:38:43.89475+00
71031	Rucence	UG7338747	10713	2025-03-24 10:38:43.897054+00
71032	Rwakishakizi I	UG12821319	10713	2025-03-24 10:38:43.899482+00
71033	Rwakishakizi Ii	UG19591078	10713	2025-03-24 10:38:43.901886+00
71034	Bulinda	UG85392874	10714	2025-03-24 10:38:43.904289+00
71035	Bwikya	UG78769128	10714	2025-03-24 10:38:43.906669+00
71036	Kakoora-Habitat	UG43290185	10714	2025-03-24 10:38:43.908934+00
71037	Kanenankumba	UG15867237	10714	2025-03-24 10:38:43.911256+00
71038	Kikwite	UG87894769	10714	2025-03-24 10:38:43.913558+00
71039	Kinuubi	UG7302295	10714	2025-03-24 10:38:43.915864+00
71040	Kyakabubi	UG5955537	10714	2025-03-24 10:38:43.918231+00
71041	Kyarwiru	UG61424048	10714	2025-03-24 10:38:43.920516+00
71042	Kyedikyo	UG33574814	10714	2025-03-24 10:38:43.922828+00
71043	Kyetunga	UG96261428	10714	2025-03-24 10:38:43.9251+00
71044	Mparo North	UG41762262	10714	2025-03-24 10:38:43.927532+00
71045	Mparo South	UG90117322	10714	2025-03-24 10:38:43.929939+00
71046	Bank Cell	UG41127282	598	2025-03-24 10:38:43.930938+00
71047	Hospital	UG76071554	598	2025-03-24 10:38:43.932114+00
71048	Isaka Lower	UG58769180	598	2025-03-24 10:38:43.933051+00
71049	Isaka Upper	UG96054297	598	2025-03-24 10:38:43.933994+00
71050	Kijungu	UG26724448	598	2025-03-24 10:38:43.934894+00
71051	Mosque Cell	UG13674228	598	2025-03-24 10:38:43.935775+00
71052	Park Cell	UG8372918	598	2025-03-24 10:38:43.936706+00
71053	Police Cell	UG68700638	598	2025-03-24 10:38:43.937612+00
71054	Public Cell	UG18065379	598	2025-03-24 10:38:43.938579+00
71055	Bucunga	UG74466505	10610	2025-03-24 10:38:43.940895+00
71056	Bwanya	UG66631806	10610	2025-03-24 10:38:43.943301+00
71057	Kiboni	UG14392648	10610	2025-03-24 10:38:43.94559+00
71058	Kicwamba I	UG23639766	10610	2025-03-24 10:38:43.947864+00
71059	Kicwamba Ii	UG89715618	10610	2025-03-24 10:38:43.950147+00
71060	Kidooti	UG16910694	10610	2025-03-24 10:38:43.952445+00
71061	Kihandagana	UG80477499	10610	2025-03-24 10:38:43.954841+00
71062	Kikwatamiigo	UG90359017	10610	2025-03-24 10:38:43.957186+00
71063	Kiryabaana	UG45602811	10610	2025-03-24 10:38:43.959516+00
71064	Kyakapeya	UG27776993	10610	2025-03-24 10:38:43.961772+00
71065	Bulera East	UG54739257	10717	2025-03-24 10:38:43.964104+00
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 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: 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: 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: 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);


--
--

