6569	\N	\N	0.00000000000	[BLOB]
6570	\N	\N	0.00000000000	[BLOB]
6571	\N	\N	0.00000000000	[BLOB]
6572	\N	\N	0.00000000000	[BLOB]
6573	\N	\N	0.00000000000	[BLOB]
\.


--
-- TOC entry 6179 (class 0 OID 19635)
-- Dependencies: 253
-- Data for Name: documents; Type: TABLE DATA; Schema: tabular; Owner: postgres
--

COPY tabular.documents (id, name, type, description, size, publication_date, author, edition_year, path, project_id, user_id, role_id, created_at, updated_at, field, location_id, author_organization_id) FROM stdin;
cc86b1d9-585c-4e09-819b-8d218578243d	TDR de la Réunion avec les acteurs du paysage TRIDOM Cameroun	application/pdf	Cette réunion avait pour objectif de définir les clauses de partage de données entre le WWF et les  institutions/organisations contributrices après un examen critique des intérêts communs.	690950	2024-06-13 00:00:00	CIBEL TRIDOM	2024	documents/e054e854-946d-4780-8e61-593d03c8c3e7.pdf	aeb58d92-e483-4936-9fd7-6f9b2c6b7730	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	883112a8-fed4-4c25-8e8d-e4e77ed46e59	2025-07-04 10:58:40	2025-07-04 14:54:16	\N	\N	\N
d6ed5bb8-4563-4330-9a20-37b0d164f689	TDR de la Réunion avec les acteurs du paysage TRIDOM au Gabon	application/pdf	Cette réunion avait pour objectif de définir les clauses de partage de données entre le WWF et les  institutions/organisations contributrices après un examen critique des intérêts communs.	737911	2024-05-10 00:00:00	CIBEL TRIDOM	2024	documents/4f6a6d9b-ae9c-445c-8faa-66728fcd254b.pdf	aeb58d92-e483-4936-9fd7-6f9b2c6b7730	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-07-04 11:13:59	2025-07-04 11:13:59	\N	\N	\N
926af510-ba20-424d-9f47-35457bac82ad	TDR de la Réunion avec les acteurs du paysage TRIDOM au Congo (CG)	application/pdf	Cette réunion avait pour objectif de définir les clauses de partage de données entre le WWF et les  institutions/organisations contributrices après un examen critique des intérêts communs.	726362	2024-05-30 00:00:00	CIBEL TRIDOM	2024	documents/ab439149-8df0-4fd8-8464-9ce0c533c5d1.pdf	aeb58d92-e483-4936-9fd7-6f9b2c6b7730	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-07-04 11:11:47	2025-07-18 15:15:43	\N	\N	\N
f46c99ea-fd59-43cc-8b18-8eb49f8e2fd4	Business Plan 3 FC CIBEL	application/pdf	Document élaboration en vue de doter les entités juridiques gestionnaires des FC d'un matériel et équipement d'exploitation et de transformation	762855	2025-01-01 00:00:00	BINELI ATANGANA Steve	2025	documents/318f2a19-f471-492c-95ad-ff62d3541cb9.pdf	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	ca4e388b-b6c6-415a-9b47-3264d8257574	2025-10-16 14:49:18	2025-10-16 14:49:18	\N	\N	\N
cfd3527a-7bba-46a6-9895-f999ce99eeec	Manuel simplifié de gestion des entreprises	application/pdf	Manuel des procédures opérationnelles du projet d’exploitation, de transformation artisanale et de commercialisation du bois issus des Forêts communautaires ACODELEMIT, ACODENDO et ADILEM	270812	2025-01-01 00:00:00	BINELI ATANGANA Steve	2025	documents/a8b19013-98a1-44ff-a62c-8a305c57c9c6.pdf	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	ca4e388b-b6c6-415a-9b47-3264d8257574	2025-10-16 14:51:02	2025-10-16 14:51:02	\N	\N	\N
e23ca5dc-3433-4072-b365-2a6f53ffaf7f	Réquisition du matériel roulant	application/pdf	Facture d'acquisition du matériel roulant pour permettre le transport des différents produit issu des traveaux de la cacoyère communautaire	4273832	2025-01-01 00:00:00	Youssoufa NGNAGNE	2025	documents/80f6c305-ea97-4782-a446-39a5bea1e5da.pdf	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	883112a8-fed4-4c25-8e8d-e4e77ed46e59	2025-10-16 15:01:20	2025-10-16 15:01:20	\N	\N	\N
0afb0f88-2c5f-4e36-ba14-e91f03e60aa3	Rapport inventaire de faune TRIDOM	application/pdf	Document technique rédigé dans le but de soutenir la gestion de la biodiversité dans les parcs nationaux de Nki et de Boumba-Bek ainsi que dans leurs zones périphériques, en fournissant des données actualisées sur les grangs et moyens mammifèreainsi que l'ampleur des préssions anthropiques.	7138827	2025-06-01 00:00:00	BEUKOU C. Ghislain Brice, FONDJA Calvin, ETOGA Gilles, NZOOH Zacharie, AZANGUE Georges, BIDIMA Antoine, N’GORAN K. Paul	2025	documents/f98d8190-e1d5-4aae-979c-f8de450d65a7.pdf	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-16 15:04:46	2025-10-16 15:04:46	\N	\N	\N
9e390739-1057-4ee3-88bc-10b4ecb72536	Installation pépinière de Cacao	application/pdf	\N	322312	2025-01-01 00:00:00	Patrice ZEUFACK	2025	documents/27810467-d2ba-4696-8ad3-f450afe077e5.pdf	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	883112a8-fed4-4c25-8e8d-e4e77ed46e59	2025-10-16 15:09:06	2025-10-16 15:09:06	\N	\N	\N
8dc76b23-e954-49a1-8a5c-4d07d409c645	TDR enquête social plate forme multi acteurs Moloundou	application/pdf	\N	410106	2025-01-01 00:00:00	Moise NKOMO	2025	documents/5dd096eb-7345-41fa-9b34-f52f9e1abf0a.pdf	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	883112a8-fed4-4c25-8e8d-e4e77ed46e59	2025-10-16 15:10:46	2025-10-16 15:10:46	\N	\N	\N
04515d05-f04e-41e3-a098-39abb850f5cb	Mission de suivi-évaluation	image/jpeg	Plan rapproché: Plants d'Andok dans la pépinière	8280740	2025-05-22 00:00:00	Rowina Nguimbis	\N	documents/47b5c72a-b725-46ec-ba7c-a41b2abb0bfc.jpg	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-24 08:57:51	2025-10-24 08:57:51	Ebyeng	5197d1e6-6442-4bf9-8597-f43db3bb5b8c	335db174-a66a-4b46-aa86-ab79745d04c9
23555b50-254f-44ea-a157-bcfd9006a41d	Mission de suivi-évaluation	image/jpeg	Vue d'ensemble: Président de l'association Ebyeng Edzuameneniene (A2E) dans la pépinière communautaire.	9571953	2025-05-22 00:00:00	Rowina Nguimbis	\N	documents/2ec3b49d-f859-4270-a32b-46443255e005.jpg	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-24 08:55:54	2025-10-24 08:55:54	Ebyeng	5197d1e6-6442-4bf9-8597-f43db3bb5b8c	335db174-a66a-4b46-aa86-ab79745d04c9
363e751b-2063-4245-932f-e593c5435334	Mission de suivi-évaluation	image/jpeg	Plan rapproché: Plants d'Atangas dans la pépinière	7133983	2025-05-22 00:00:00	Rowina Nguimbis	\N	documents/07eb1d2b-330f-40ee-a0fe-3ddc8d8ddec5.jpg	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-24 08:56:45	2025-10-24 08:56:45	Ebyeng	5197d1e6-6442-4bf9-8597-f43db3bb5b8c	335db174-a66a-4b46-aa86-ab79745d04c9
42de8a91-4071-4236-9293-a34754937c50	Mission de suivi-évaluation	image/jpeg	Plantation de bananiers	14448700	2025-05-23 00:00:00	Rowina Nguimbis	\N	documents/cd105e7f-42ae-45f2-a033-15b01dae1462.jpg	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-24 09:03:55	2025-10-24 09:03:55	Nzé Vatican	5197d1e6-6442-4bf9-8597-f43db3bb5b8c	335db174-a66a-4b46-aa86-ab79745d04c9
021897d2-c2b0-4d5d-b796-d65ff895cfc0	Mission de suivi-évaluation	image/jpeg	Communautés locales recevant une formation en cacaoculture	118300	2025-06-16 00:00:00	Casimir Assama	\N	documents/e1608ddc-482f-4de3-a845-10d7463ba7d3.jpg	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-24 09:08:04	2025-10-24 09:08:04	Ndongo	f1ccfef1-2066-4c5b-903f-ed3212b16a28	335db174-a66a-4b46-aa86-ab79745d04c9
04f1f73d-c942-4cff-9f2b-02dece458d03	Mission de suivi-évaluation	image/jpeg	Les communautés locales à l'école de la cacaoculture	120741	2025-06-16 00:00:00	Casimir Assama	\N	documents/6e4bbeb6-7097-4e95-a7ce-1e8a97480616.jpg	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-24 09:11:13	2025-10-24 09:11:13	Ndongo	f1ccfef1-2066-4c5b-903f-ed3212b16a28	335db174-a66a-4b46-aa86-ab79745d04c9
544ef100-f7d1-42dd-b02c-fdb6b6a595a9	Mission de suivi-évaluation	image/jpeg	Jeunes plants de bananiers	11570202	2025-05-23 00:00:00	Rowina Nguimbis	\N	documents/24cce325-1357-4f67-afa8-d14af91b05cf.jpg	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-24 09:04:41	2025-10-24 09:04:41	Nzé Vatican	5197d1e6-6442-4bf9-8597-f43db3bb5b8c	335db174-a66a-4b46-aa86-ab79745d04c9
58e40648-5540-4698-99d5-9908942cb89f	Mission de suivi-évaluation	image/jpeg	Equipe de suivi évaluation ( WWF Gabon, CIBEL TRIDOM et WWF NL) visitant les plantations bénéficiaires de la clotûre électrique	12775627	2025-05-23 00:00:00	Rowina Nguimbis	\N	documents/b8587620-e4e7-493c-8b67-0d62b77c7070.jpg	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-24 09:03:34	2025-10-24 09:03:34	Nzé Vatican	5197d1e6-6442-4bf9-8597-f43db3bb5b8c	335db174-a66a-4b46-aa86-ab79745d04c9
5f706f52-b8c3-46f0-8cc0-390d74be98dd	Mission de suivi-évaluation	image/jpeg	Entrée des plantations entourées par une clôture éléctrique haute spécification installée par l'ANPN	11857658	2025-05-23 00:00:00	Rowina Nguimbis	\N	documents/43553b29-90fb-409b-813b-6dbe36ae6bed.jpg	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-24 09:02:07	2025-10-24 09:02:07	Nzé Vatican	5197d1e6-6442-4bf9-8597-f43db3bb5b8c	335db174-a66a-4b46-aa86-ab79745d04c9
62547324-4818-4cf0-81fe-3db9ff080527	Mission de suivi-évaluation	image/jpeg	Equipe de suivi évaluation visitant les plantations avec les membres des communautés bénéficiaires	14530561	2025-05-23 00:00:00	Rowina Nguimbis	\N	documents/50ee952a-e3c2-480c-aa0a-fe6c3bebdfc2.jpg	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-24 09:04:19	2025-10-24 09:04:19	Nzé Vatican	5197d1e6-6442-4bf9-8597-f43db3bb5b8c	335db174-a66a-4b46-aa86-ab79745d04c9
64bb889d-9e72-415b-ac31-89fcb90493f8	Mission de suivi-évaluation	image/jpeg	Un membre de la communauté donnant son point de vue	6975125	2025-05-23 00:00:00	Rowina Nguimbis	\N	documents/6de02ef3-bb8f-4b16-88ce-46579747e216.jpg	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-24 09:01:21	2025-10-24 09:01:21	Nzé Vatican	5197d1e6-6442-4bf9-8597-f43db3bb5b8c	335db174-a66a-4b46-aa86-ab79745d04c9
65d8a10c-cd25-43b6-9e85-2027c120aae7	Mission de suivi-évaluation	image/jpeg	Bureau de l'association A2E	11927619	2025-05-22 00:00:00	Rowina Nguimbis	\N	documents/cf9df392-1151-43cb-88e7-413a899b7d22.jpg	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-24 08:59:29	2025-10-24 08:59:29	Ebyeng	5197d1e6-6442-4bf9-8597-f43db3bb5b8c	335db174-a66a-4b46-aa86-ab79745d04c9
8e7f0744-395d-4132-8fb7-457f80ae1f39	Mission de suivi-évaluation	image/jpeg	Plan rapproché d'une partie de la clôture électrique	10352247	2025-05-23 00:00:00	Rowina Nguimbis	\N	documents/a2099dd4-d04d-44d4-b74c-a8c59dbb2697.jpg	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-24 09:02:30	2025-10-24 09:02:30	Nzé Vatican	5197d1e6-6442-4bf9-8597-f43db3bb5b8c	335db174-a66a-4b46-aa86-ab79745d04c9
9061609d-387c-405f-8abe-dc863d92d416	Mission de suivi-évaluation	image/jpeg	Vue d'ensemble d'une partie de la pépinière	12518932	2025-05-22 00:00:00	Rowina Nguimbis	\N	documents/4b96ea26-005b-4d70-97f4-664c04d38454.jpg	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-24 08:53:58	2025-10-24 08:53:58	Ebyeng	5197d1e6-6442-4bf9-8597-f43db3bb5b8c	335db174-a66a-4b46-aa86-ab79745d04c9
a33fa4fd-360b-4ea9-a185-ad37c6e4315e	Mission de suivi-évaluation	image/jpeg	Plan moyen: Président de l'association s'occupant des plants	9831010	2025-05-22 00:00:00	Rowina Nguimbis	\N	documents/0eb5a8a8-206f-4745-aad0-0f7765f5078a.jpg	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-24 08:58:45	2025-10-24 08:58:45	Ebyeng	5197d1e6-6442-4bf9-8597-f43db3bb5b8c	335db174-a66a-4b46-aa86-ab79745d04c9
a86ba235-d42d-465e-9772-b0b58d95e0ef	Mission de suivi-évaluation	image/jpeg	Plan rapproché taille: Président de l'association présentant un plan	8826089	2025-05-22 00:00:00	Rowina Nguimbis	\N	documents/860067fa-0c67-4fab-99ce-8bbced6b0eaf.jpg	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-24 08:59:05	2025-10-24 08:59:05	Ebyeng	5197d1e6-6442-4bf9-8597-f43db3bb5b8c	335db174-a66a-4b46-aa86-ab79745d04c9
ad280bb2-9b91-405e-b681-dfeefb66bddd	Mission de suivi-évaluation	image/jpeg	Discussion avec les populations locales sur l'entretien des barrières	11586243	2025-05-23 00:00:00	Rowina Nguimbis	\N	documents/3e40d55b-1019-4f5a-98fe-c5b8c1bedb1d.jpg	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-24 09:00:29	2025-10-24 09:00:29	Nzé Vatican	5197d1e6-6442-4bf9-8597-f43db3bb5b8c	335db174-a66a-4b46-aa86-ab79745d04c9
b692b172-42c8-472a-acc8-5c438c8fcd58	Mission de suivi-évaluation	image/jpeg	Vue d'ensemble: pots de pépinière	7383501	2025-05-22 00:00:00	Rowina Nguimbis	\N	documents/ecd665fb-2405-4401-9fd5-7be633d8aea4.jpg	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-24 08:57:19	2025-10-24 08:57:19	Ebyeng	5197d1e6-6442-4bf9-8597-f43db3bb5b8c	335db174-a66a-4b46-aa86-ab79745d04c9
cdc3decf-bcbb-40d9-a6aa-8de9afc5cf83	Mission de suivi-évaluation	image/jpeg	Plan moyen: Président de l'association observant la pépinière	10299229	2025-05-22 00:00:00	Rowina Nguimbis	\N	documents/141ea0c3-c87d-4462-ab3c-0c937d0a655d.jpg	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-24 08:58:21	2025-10-24 08:58:21	Ebyeng	5197d1e6-6442-4bf9-8597-f43db3bb5b8c	335db174-a66a-4b46-aa86-ab79745d04c9
de63456d-f47e-44c8-86bd-d305b1982ca3	Mission de suivi-évaluation	image/jpeg	Station de maintenance de la clotûre électrique	13605965	2025-05-23 00:00:00	Rowina Nguimbis	\N	documents/7be0e45e-3d24-42b3-b206-fcdd66ade200.jpg	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-24 09:02:54	2025-10-24 09:02:54	Nzé Vatican	5197d1e6-6442-4bf9-8597-f43db3bb5b8c	335db174-a66a-4b46-aa86-ab79745d04c9
e7991b46-b253-43a8-9e0d-70ec8d936a98	Mission de suivi-évaluation	image/jpeg	Plan d'ensemble montrant des villageois	12004221	2025-05-23 00:00:00	Rowina Nguimbis	\N	documents/ce8abfc8-8fac-4356-b59f-fc634e39e6ce.jpg	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-24 09:05:08	2025-10-24 09:05:08	Nzé Vatican	5197d1e6-6442-4bf9-8597-f43db3bb5b8c	335db174-a66a-4b46-aa86-ab79745d04c9
fdcaddfb-0d00-4deb-aafc-c3bb286cad3c	Mission de suivi-évaluation	image/jpeg	Plan moyen de branches d'arbre couvrant des jeunes plants de maïs	13467437	2025-05-23 00:00:00	Rowina Nguimbis	\N	documents/99e9831b-08fa-469e-9582-c96956236f42.jpg	02ca5547-2717-4970-8bb0-b6ddca521bb8	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	5b87e4e9-a7a2-4ad5-9218-403fb4b7fccf	2025-10-24 09:03:14	2025-10-24 09:03:14	Nzé Vatican	5197d1e6-6442-4bf9-8597-f43db3bb5b8c	335db174-a66a-4b46-aa86-ab79745d04c9
\.


--
-- TOC entry 6164 (class 0 OID 19213)
-- Dependencies: 238
-- Data for Name: organizations; Type: TABLE DATA; Schema: tabular; Owner: postgres
--

COPY tabular.organizations (id, name, description, logo, created_at, updated_at) FROM stdin;
645620c2-b9aa-41ca-87c2-dc4a1e8efbe9	TRAFFIC	Organization description	logos/beee2062-8848-44c5-b1f6-5c2f5221f26e.png	2025-06-26 12:08:44	2025-06-26 12:08:44
84f264dc-9cc4-494e-8a44-5571a341cb08	GIZ	GIZ	logos/8dca418d-a5cc-424a-8216-ac3677ae9d2f.png	2025-06-26 19:57:49	2025-06-26 19:57:49
bef8e6d5-90cd-4eda-9341-d55a40b6a6f4	OFAC	OFAC	logos/b041d4d0-e550-4df0-a906-069637842deb.png	2025-06-26 19:58:01	2025-06-26 19:58:01
c9a8a346-2f42-4d85-81bf-c1608d318419	Conservation Justice	Conservation Justice	logos/a178c5f5-c025-465d-961f-d8d56c2794f3.png	2025-06-26 19:59:25	2025-06-26 19:59:25
ecb030c5-2b1c-4b48-afcc-e9b73ef832be	ZSL	ZSL	logos/2aebbc44-1809-4a95-8aa4-8342866d3854.png	2025-06-26 19:57:13	2025-06-26 19:57:13
335db174-a66a-4b46-aa86-ab79745d04c9	WWF	World Wide Fund for Nature (Fonds mondial pour la nature)	logos/335db174-a66a-4b46-aa86-ab79745d04c9.jpg	\N	2025-10-30 01:23:47
\.


--
-- TOC entry 6171 (class 0 OID 19485)
-- Dependencies: 245
-- Data for Name: project_objectives; Type: TABLE DATA; Schema: tabular; Owner: postgres
--

COPY tabular.project_objectives (id, name, project_id, created_at, updated_at) FROM stdin;
0eb2532a-bedb-497e-8397-268f10b77636	Suivre et Evaluation des impact du Projet (Protocoles, Suivi, Analyses et Evaluation)	aeb58d92-e483-4936-9fd7-6f9b2c6b7730	2025-06-26 17:31:38	2025-06-26 17:31:38
5a2f010c-b572-474c-98fd-d9e3b50b66dc	Suivre de la qualité de mise en œuvre (Analyses, Contrôle et Orientations Adaptatives)	aeb58d92-e483-4936-9fd7-6f9b2c6b7730	2025-06-26 17:33:53	2025-06-26 17:33:53
2682e93e-2712-429e-bfe2-555538e56f75	Développer de plateforme Web (Compilation de données, Production de Résultats stratégiques, Création d’un Tableau de bord)	aeb58d92-e483-4936-9fd7-6f9b2c6b7730	2025-06-26 17:34:30	2025-06-26 17:34:30
\.


--
-- TOC entry 6170 (class 0 OID 19472)
-- Dependencies: 244
-- Data for Name: project_results; Type: TABLE DATA; Schema: tabular; Owner: postgres
--

COPY tabular.project_results (id, name, project_id, created_at, updated_at) FROM stdin;
\.


--
-- TOC entry 6178 (class 0 OID 19585)
-- Dependencies: 252
-- Data for Name: project_thematics; Type: TABLE DATA; Schema: tabular; Owner: postgres
--

COPY tabular.project_thematics (id, data_licence_id, collection_method_ids, data_format_ids, project_id, thematic_id, created_at, updated_at) FROM stdin;
0bda7708-80df-4fee-8e71-777add3d08b3	06b5188c-445b-46b1-a443-be4bfb67b899	["d3b299a4-2544-4eba-a433-cf110edcda81","e7b3e927-a8b0-4e74-a557-292d57dccc98"]	["0fb251de-3206-446d-a58b-7cb2cc6f4da9","23427270-a3c8-4dce-aef9-9ad6ca82f06a"]	aeb58d92-e483-4936-9fd7-6f9b2c6b7730	10a62626-2c45-41c1-8c79-563dd7488b32	2025-06-27 14:42:42	2025-06-27 14:42:42
0557ff8d-d6c5-4ca5-ad82-5bea5f32872f	06b5188c-445b-46b1-a443-be4bfb67b899	["d3b299a4-2544-4eba-a433-cf110edcda81","e7b3e927-a8b0-4e74-a557-292d57dccc98"]	["0fb251de-3206-446d-a58b-7cb2cc6f4da9","23427270-a3c8-4dce-aef9-9ad6ca82f06a"]	aeb58d92-e483-4936-9fd7-6f9b2c6b7730	6969efaf-e99b-43f3-9da1-c03c1bb331ca	2025-06-27 14:46:39	2025-06-27 14:46:39
c4529469-76ec-4c69-80a4-75cf37269e08	06b5188c-445b-46b1-a443-be4bfb67b899	["d3b299a4-2544-4eba-a433-cf110edcda81","e7b3e927-a8b0-4e74-a557-292d57dccc98"]	["23427270-a3c8-4dce-aef9-9ad6ca82f06a"]	aeb58d92-e483-4936-9fd7-6f9b2c6b7730	fb508fd1-da18-4c8d-94fa-010b5b15b7ac	2025-07-08 10:58:08	2025-07-08 10:58:08
\.


--
-- TOC entry 6169 (class 0 OID 19442)
-- Dependencies: 243
-- Data for Name: projects; Type: TABLE DATA; Schema: tabular; Owner: postgres
--

COPY tabular.projects (id, name, field, location_id, start_date, end_date, budget, currency_id, organization_id, user_id, website, manager_name, manager_email, manager_phone, focal_point_name, focal_point_email, focal_point_phone, main_objective, created_at, updated_at, logo, logo_copyright) FROM stdin;
90fe6c96-8df3-4d43-9e5b-11e615be2d2a	NIAP (National Ivory Action Plan)	Yaoundé	079fad94-17ca-4812-9cac-83d77855ae9c	2022-07-01 00:00:00	2024-06-30 00:00:00	104000	8f52a997-59c9-488b-b2cd-7c8dfa301bb4	645620c2-b9aa-41ca-87c2-dc4a1e8efbe9	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	\N	SONE NKOKE	\N	+237699731856	DALIDA IKOUM	dalida.ikoum@traffic.org	\N	\N	2025-06-26 20:12:26	2025-06-26 20:12:26	\N	\N
1cbcd82b-f23f-448e-b7bb-a5beb7ced26f	Achieving An Integrated Agribusiness-Conservation Agreement For Deforestation Free Palm Oil Or Cacao Production In Tridom Landscape Int/Practices Innovation Funds.	Yaoundé	079fad94-17ca-4812-9cac-83d77855ae9c	2019-05-01 00:00:00	2020-04-30 00:00:00	\N	\N	335db174-a66a-4b46-aa86-ab79745d04c9	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	\N	\N	\N	\N	\N	\N	\N	\N	2025-07-15 16:13:52	2025-07-15 16:13:52	\N	\N
aeb58d92-e483-4936-9fd7-6f9b2c6b7730	TRIDOM CIBEL	Yaoundé	079fad94-17ca-4812-9cac-83d77855ae9c	2023-07-01 00:00:00	2027-06-30 00:00:00	500000	8f52a997-59c9-488b-b2cd-7c8dfa301bb4	335db174-a66a-4b46-aa86-ab79745d04c9	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	https://wwf-congobasin-monitoring.org/	Paul N'Goran	pngoran@wwfcam.org	\N	Christian NGANWA	cnganwa@wwfcam.org	\N	\N	2025-06-26 17:09:50	2025-07-02 08:52:48	logos/9b20d3c9-304e-4c6f-9459-7f64d60ac38a.jpg	WWF, 2023
02ca5547-2717-4970-8bb0-b6ddca521bb8	CIBEL CAMEROUN	Ndongo	f1ccfef1-2066-4c5b-903f-ed3212b16a28	2023-07-01 00:00:00	2027-12-31 00:00:00	1500000	8f52a997-59c9-488b-b2cd-7c8dfa301bb4	335db174-a66a-4b46-aa86-ab79745d04c9	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	\N	Pierre Calvin FONDJA	string	string	Youssoufa NGANGNE MOUMBAGNA	string	string	string	2025-10-16 10:25:37	2025-10-16 10:25:37	\N	\N
e64a0b4e-9d1c-40b0-b907-5d2ffc3750dd	CIBEL CONGO	Sembé	1e4a6334-ea34-434c-a3bc-935c8038bed5	2023-07-01 00:00:00	2027-12-31 00:00:00	1500000	8f52a997-59c9-488b-b2cd-7c8dfa301bb4	335db174-a66a-4b46-aa86-ab79745d04c9	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	\N	Corneille MOUKSON	\N	\N	\N	\N	\N	\N	2025-10-16 11:49:07	2025-10-16 11:49:07	\N	\N
caccfc44-1bc5-4ecb-adb6-f991fdc206e4	CIBEL TRIDOM	Makokou	5197d1e6-6442-4bf9-8597-f43db3bb5b8c	2023-07-01 00:00:00	2027-12-31 00:00:00	1500000	8f52a997-59c9-488b-b2cd-7c8dfa301bb4	335db174-a66a-4b46-aa86-ab79745d04c9	4ca1db3f-9e82-483a-b5eb-5507c9147ccf	\N	Stéphane Le Duc Yeno	string	string	\N	string	string	string	2025-10-16 10:37:06	2025-10-30 00:58:19	\N	\N
\.


--
-- TOC entry 6163 (class 0 OID 19091)
-- Dependencies: 237
-- Data for Name: thematics; Type: TABLE DATA; Schema: tabular; Owner: postgres
--

COPY tabular.thematics (id, name, created_at, updated_at, definition, source, source_link, category_thematic_id) FROM stdin;
06abef34-cf0d-45f6-80f1-7200150573e1	Accords	2025-06-27 07:33:33	2025-06-27 07:33:33	\N	\N	\N	00466f04-9471-43fc-a3ee-63db5e4ba2d0
10a62626-2c45-41c1-8c79-563dd7488b32	Agriculture durable	2025-06-27 07:38:03	2025-06-27 07:38:03	\N	\N	\N	00466f04-9471-43fc-a3ee-63db5e4ba2d0
1d1369bd-c387-4215-84ad-dacb474855e5	Aires protégées	2025-06-27 07:38:21	2025-06-27 07:38:21	\N	\N	\N	00466f04-9471-43fc-a3ee-63db5e4ba2d0
2d19a548-1de0-4829-a275-fc2b73711e94	Bien-être des communautés	2025-06-27 07:38:31	2025-06-27 07:38:31	\N	\N	\N	c70981f9-44d7-48d3-ba6c-12623105aeae
6969efaf-e99b-43f3-9da1-c03c1bb331ca	Changements climatiques	2025-06-27 07:37:47	2025-06-27 07:37:47	\N	\N	\N	c70981f9-44d7-48d3-ba6c-12623105aeae
7fb7fadf-4c83-4771-9b17-db839a147dc5	Conflits homme-faune	2025-06-27 07:38:40	2025-06-27 07:38:40	\N	\N	\N	00466f04-9471-43fc-a3ee-63db5e4ba2d0
852c33dc-a69f-44dd-b570-96ffebc710f9	Conservation inclusive	2025-06-27 07:38:52	2025-06-27 07:38:52	\N	\N	\N	00466f04-9471-43fc-a3ee-63db5e4ba2d0
9cd5ae78-56dc-433a-9b9c-5930fe969dfc	Criminalité faunique	2025-06-27 07:37:32	2025-06-27 07:37:32	\N	\N	\N	00466f04-9471-43fc-a3ee-63db5e4ba2d0
e93c1ccf-e21b-4b9e-a92f-4eb6a5b22d08	Cross-cutting	2025-06-27 07:37:56	2025-06-27 07:37:56	\N	\N	\N	c70981f9-44d7-48d3-ba6c-12623105aeae
fb508fd1-da18-4c8d-94fa-010b5b15b7ac	Financement de la conservation	2025-06-27 07:37:39	2025-06-27 07:37:39	\N	\N	\N	8cc0cd04-3bef-416d-8a01-7698cbd61f11
85406479-ed53-4343-9dec-233e64abdcfb	Gouvernance	2025-09-17 13:06:34	2025-09-17 13:06:34	\N	\N	\N	\N
5da21baa-bb36-4577-99d4-eb590e098876	Zones clés de biodiversité	2025-09-17 13:06:52	2025-09-17 13:06:52	\N	\N	\N	\N
3d03a396-d812-4365-9bf9-829b2342ac5a	Législation et application de la loi	2025-09-17 13:07:06	2025-09-17 13:07:06	\N	\N	\N	\N
9c8d34b8-3007-46de-ab4a-390df055fb30	Planification et utilisation des terres	2025-09-17 13:07:22	2025-09-17 13:07:22	\N	\N	\N	\N
52839992-8e10-4217-a751-bf449d6dd92d	Protection de la biodiversité	2025-09-17 13:07:34	2025-09-17 13:07:34	\N	\N	\N	\N
9b32a11f-496c-483a-8bd1-c56449f350cd	Protection des écosystèmes	2025-09-17 13:07:47	2025-09-17 13:07:47	\N	\N	\N	\N
63a54e33-2845-4b79-b7b0-c2fad7c95fd4	Recherche et suivi écologique	2025-09-17 13:09:14	2025-09-17 13:09:14	\N	\N	\N	\N
3fe09f8f-df5e-42f7-b684-c78e3b1e4ade	Renforcement des capacités	2025-09-17 13:09:24	2025-09-17 13:09:24	\N	\N	\N	\N
e71b0911-d159-4174-aae5-95f8ad340663	Restauration des écosystèmes	2025-09-17 13:13:55	2025-09-17 13:13:55	\N	\N	\N	\N
4850b344-6889-485b-91ff-3c199b6367b3	Sauvegarde environnementale et sociale	2025-09-17 13:14:05	2025-09-17 13:14:05	\N	\N	\N	\N
9e219aed-90c9-44f3-ae53-b7cc59ad3bad	Suivi socio-économique	2025-09-17 13:14:39	2025-09-17 13:14:39	\N	\N	\N	\N
f5178792-f610-4f7f-b14c-d6a5a507649c	Suivi-écologique et recherche	2025-09-17 13:14:59	2025-09-17 13:14:59	\N	\N	\N	\N
593f821a-5dca-47a4-a94c-b11dc2cc3e5b	Systèmes d'information	2025-09-17 13:15:09	2025-09-17 13:15:09	\N	\N	\N	\N
\.



--
-- TOC entry 5934 (class 2606 OID 19545)
-- Name: collection_methods codelist_collection_methods_name_unique; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.collection_methods
    ADD CONSTRAINT codelist_collection_methods_name_unique UNIQUE (name);


--
-- TOC entry 5884 (class 2606 OID 19019)
-- Name: currency codelist_currency_name_unique; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.currency
    ADD CONSTRAINT codelist_currency_name_unique UNIQUE (name);


--
-- TOC entry 5926 (class 2606 OID 19527)
-- Name: data_formats codelist_data_formats_name_unique; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.data_formats
    ADD CONSTRAINT codelist_data_formats_name_unique UNIQUE (name);


--
-- TOC entry 5930 (class 2606 OID 19537)
-- Name: data_licences codelist_data_licences_name_unique; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.data_licences
    ADD CONSTRAINT codelist_data_licences_name_unique UNIQUE (name);


--
-- TOC entry 5880 (class 2606 OID 19011)
-- Name: project_locations codelist_project_locations_name_unique; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.project_locations
    ADD CONSTRAINT codelist_project_locations_name_unique UNIQUE (name);


--
-- TOC entry 5938 (class 2606 OID 19553)
-- Name: thematic_categories codelist_thematic_cathegories_name_unique; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.thematic_categories
    ADD CONSTRAINT codelist_thematic_cathegories_name_unique UNIQUE (name);


--
-- TOC entry 5876 (class 2606 OID 18828)
-- Name: user_roles codelist_user_roles_name_unique; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.user_roles
    ADD CONSTRAINT codelist_user_roles_name_unique UNIQUE (name);


--
-- TOC entry 5936 (class 2606 OID 19543)
-- Name: collection_methods collection_methods_pkey; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.collection_methods
    ADD CONSTRAINT collection_methods_pkey PRIMARY KEY (id);


--
-- TOC entry 5886 (class 2606 OID 19017)
-- Name: currency currency_pkey; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.currency
    ADD CONSTRAINT currency_pkey PRIMARY KEY (id);


--
-- TOC entry 5928 (class 2606 OID 19525)
-- Name: data_formats data_formats_pkey; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.data_formats
    ADD CONSTRAINT data_formats_pkey PRIMARY KEY (id);


--
-- TOC entry 5932 (class 2606 OID 19535)
-- Name: data_licences data_licences_pkey; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.data_licences
    ADD CONSTRAINT data_licences_pkey PRIMARY KEY (id);


--
-- TOC entry 5882 (class 2606 OID 19009)
-- Name: project_locations project_locations_pkey; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.project_locations
    ADD CONSTRAINT project_locations_pkey PRIMARY KEY (id);


--
-- TOC entry 5940 (class 2606 OID 19551)
-- Name: thematic_categories thematic_cathegories_pkey; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

ALTER TABLE ONLY codelist.thematic_categories
    ADD CONSTRAINT thematic_cathegories_pkey PRIMARY KEY (id);


--
-- TOC entry 5878 (class 2606 OID 18826)
-- Name: user_roles user_roles_pkey; Type: CONSTRAINT; Schema: codelist; Owner: postgres
--

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


--
-- TOC entry 5868 (class 2606 OID 18759)
-- Name: failed_jobs failed_jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_pkey PRIMARY KEY (id);


--
-- TOC entry 5870 (class 2606 OID 18761)
-- Name: failed_jobs failed_jobs_uuid_unique; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.failed_jobs
    ADD CONSTRAINT failed_jobs_uuid_unique UNIQUE (uuid);


--
-- TOC entry 5866 (class 2606 OID 18749)
-- Name: job_batches job_batches_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.job_batches
    ADD CONSTRAINT job_batches_pkey PRIMARY KEY (id);


--
-- TOC entry 5863 (class 2606 OID 18741)
-- Name: jobs jobs_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

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


--
-- TOC entry 5856 (class 2606 OID 17596)
-- Name: migrations migrations_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

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


--
-- TOC entry 5905 (class 2606 OID 19439)
-- Name: sessions sessions_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

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


--
-- TOC entry 5953 (class 2606 OID 21040)
-- Name: agro_industrial_concession agro-industrial concession_pkey; Type: CONSTRAINT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.agro_industrial_concession
    ADD CONSTRAINT "agro-industrial concession_pkey" PRIMARY KEY (id);


--
-- TOC entry 5977 (class 2606 OID 22975)
-- Name: country countries_pkey; Type: CONSTRAINT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.country
    ADD CONSTRAINT countries_pkey PRIMARY KEY (id);


--
-- TOC entry 5948 (class 2606 OID 21025)
-- Name: legend legend_pkey; Type: CONSTRAINT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.legend
    ADD CONSTRAINT legend_pkey PRIMARY KEY (id);


--
-- TOC entry 5974 (class 2606 OID 22822)
-- Name: mining_concession mining_concession_pkey; Type: CONSTRAINT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.mining_concession
    ADD CONSTRAINT mining_concession_pkey PRIMARY KEY (id);


--
-- TOC entry 5962 (class 2606 OID 22435)
-- Name: municipal_forest municipal_forest_pkey; Type: CONSTRAINT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.municipal_forest
    ADD CONSTRAINT municipal_forest_pkey PRIMARY KEY (id);


--
-- TOC entry 5965 (class 2606 OID 22534)
-- Name: planted_area planted_area_pkey; Type: CONSTRAINT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.planted_area
    ADD CONSTRAINT planted_area_pkey PRIMARY KEY (id);


--
-- TOC entry 5956 (class 2606 OID 21084)
-- Name: protected_area protected_area_pkey; Type: CONSTRAINT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.protected_area
    ADD CONSTRAINT protected_area_pkey PRIMARY KEY (id);


--
-- TOC entry 5968 (class 2606 OID 22644)
-- Name: road road_pkey; Type: CONSTRAINT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.road
    ADD CONSTRAINT road_pkey PRIMARY KEY (id);


--
-- TOC entry 5950 (class 2606 OID 21027)
-- Name: legend spatial_legend_name_unique; Type: CONSTRAINT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.legend
    ADD CONSTRAINT spatial_legend_name_unique UNIQUE (name);


--
-- TOC entry 5971 (class 2606 OID 22737)
-- Name: production_forest ufa_pkey; Type: CONSTRAINT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.production_forest
    ADD CONSTRAINT ufa_pkey PRIMARY KEY (id);


--
-- TOC entry 5980 (class 2606 OID 22990)
-- Name: village village_3857_pkey; Type: CONSTRAINT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.village
    ADD CONSTRAINT village_3857_pkey PRIMARY KEY (id);


--
-- TOC entry 5959 (class 2606 OID 21132)
-- Name: watercourse watercourse_pkey; Type: CONSTRAINT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.watercourse
    ADD CONSTRAINT watercourse_pkey PRIMARY KEY (id);


--
-- TOC entry 5944 (class 2606 OID 19657)
-- Name: documents documents_pkey; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

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


--
-- TOC entry 5892 (class 2606 OID 19220)
-- Name: organizations organizations_pkey; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.organizations
    ADD CONSTRAINT organizations_pkey PRIMARY KEY (id);


--
-- TOC entry 5916 (class 2606 OID 19495)
-- Name: project_objectives project_objectives_pkey; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.project_objectives
    ADD CONSTRAINT project_objectives_pkey PRIMARY KEY (id);


--
-- TOC entry 5912 (class 2606 OID 19482)
-- Name: project_results project_results_pkey; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.project_results
    ADD CONSTRAINT project_results_pkey PRIMARY KEY (id);


--
-- TOC entry 5942 (class 2606 OID 19607)
-- Name: project_thematics project_thematics_pkey; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.project_thematics
    ADD CONSTRAINT project_thematics_pkey PRIMARY KEY (id);


--
-- TOC entry 5908 (class 2606 OID 19469)
-- Name: projects projects_pkey; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.projects
    ADD CONSTRAINT projects_pkey PRIMARY KEY (id);


--
-- TOC entry 5918 (class 2606 OID 19497)
-- Name: project_objectives tabular_project_objectives_name_unique; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.project_objectives
    ADD CONSTRAINT tabular_project_objectives_name_unique UNIQUE (name);


--
-- TOC entry 5914 (class 2606 OID 19484)
-- Name: project_results tabular_project_results_name_unique; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.project_results
    ADD CONSTRAINT tabular_project_results_name_unique UNIQUE (name);


--
-- TOC entry 5910 (class 2606 OID 19471)
-- Name: projects tabular_projects_name_unique; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.projects
    ADD CONSTRAINT tabular_projects_name_unique UNIQUE (name);


--
-- TOC entry 5888 (class 2606 OID 19098)
-- Name: thematics tabular_thematics_name_unique; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.thematics
    ADD CONSTRAINT tabular_thematics_name_unique UNIQUE (name);


--
-- TOC entry 5890 (class 2606 OID 19096)
-- Name: thematics thematics_pkey; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.thematics
    ADD CONSTRAINT thematics_pkey PRIMARY KEY (id);


--
-- TOC entry 5894 (class 2606 OID 19516)
-- Name: organizations unique_column_name; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.organizations
    ADD CONSTRAINT unique_column_name UNIQUE (name);


--
-- TOC entry 5864 (class 1259 OID 18742)
-- Name: jobs_queue_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX jobs_queue_index ON public.jobs USING btree (queue);


--
-- TOC entry 5903 (class 1259 OID 19441)
-- Name: sessions_last_activity_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX sessions_last_activity_index ON public.sessions USING btree (last_activity);


--
-- TOC entry 5906 (class 1259 OID 19440)
-- Name: sessions_user_id_index; Type: INDEX; Schema: public; Owner: postgres
--

CREATE INDEX sessions_user_id_index ON public.sessions USING btree (user_id);


--
-- TOC entry 5951 (class 1259 OID 21052)
-- Name: agro-industrial concession_geom_idx; Type: INDEX; Schema: spatial; Owner: postgres
--

CREATE INDEX "agro-industrial concession_geom_idx" ON spatial.agro_industrial_concession USING gist (geom);


--
-- TOC entry 5975 (class 1259 OID 23006)
-- Name: countries_geom_idx; Type: INDEX; Schema: spatial; Owner: postgres
--

CREATE INDEX countries_geom_idx ON spatial.country USING gist (geom);


--
-- TOC entry 5972 (class 1259 OID 22841)
-- Name: mining_concession_geom_idx; Type: INDEX; Schema: spatial; Owner: postgres
--

CREATE INDEX mining_concession_geom_idx ON spatial.mining_concession USING gist (geom);


--
-- TOC entry 5960 (class 1259 OID 22483)
-- Name: municipal_forest_geom_idx; Type: INDEX; Schema: spatial; Owner: postgres
--

CREATE INDEX municipal_forest_geom_idx ON spatial.municipal_forest USING gist (geom);


--
-- TOC entry 5963 (class 1259 OID 22539)
-- Name: planted_area_geom_idx; Type: INDEX; Schema: spatial; Owner: postgres
--

CREATE INDEX planted_area_geom_idx ON spatial.planted_area USING gist (geom);


--
-- TOC entry 5954 (class 1259 OID 21114)
-- Name: protected_area_geom_idx; Type: INDEX; Schema: spatial; Owner: postgres
--

CREATE INDEX protected_area_geom_idx ON spatial.protected_area USING gist (geom);


--
-- TOC entry 5966 (class 1259 OID 22722)
-- Name: road_geom_idx; Type: INDEX; Schema: spatial; Owner: postgres
--

CREATE INDEX road_geom_idx ON spatial.road USING gist (geom);


--
-- TOC entry 5969 (class 1259 OID 22803)
-- Name: ufa_geom_idx; Type: INDEX; Schema: spatial; Owner: postgres
--

CREATE INDEX ufa_geom_idx ON spatial.production_forest USING gist (geom);


--
-- TOC entry 5978 (class 1259 OID 22991)
-- Name: village_3857_geom_idx; Type: INDEX; Schema: spatial; Owner: postgres
--

CREATE INDEX village_3857_geom_idx ON spatial.village USING gist (geom);


--
-- TOC entry 5957 (class 1259 OID 22417)
-- Name: watercourse_geom_idx; Type: INDEX; Schema: spatial; Owner: postgres
--

CREATE INDEX watercourse_geom_idx ON spatial.watercourse USING gist (geom);


--
-- TOC entry 5994 (class 2606 OID 22886)
-- Name: documents tabular_documents_location_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.documents
    ADD CONSTRAINT tabular_documents_location_id_foreign FOREIGN KEY (location_id) REFERENCES codelist.project_locations(id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;


--
-- TOC entry 5995 (class 2606 OID 22918)
-- Name: documents tabular_documents_organization_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.documents
    ADD CONSTRAINT tabular_documents_organization_id_foreign FOREIGN KEY (author_organization_id) REFERENCES tabular.organizations(id) NOT VALID;


--
-- TOC entry 5996 (class 2606 OID 19641)
-- Name: documents tabular_documents_project_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.documents
    ADD CONSTRAINT tabular_documents_project_id_foreign FOREIGN KEY (project_id) REFERENCES tabular.projects(id) ON DELETE CASCADE;


--
-- TOC entry 5997 (class 2606 OID 19651)
-- Name: documents tabular_documents_role_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.documents
    ADD CONSTRAINT tabular_documents_role_id_foreign FOREIGN KEY (role_id) REFERENCES codelist.user_roles(id) ON DELETE CASCADE;


--
-- TOC entry 5998 (class 2606 OID 22923)
-- Name: documents tabular_documents_user_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.documents
    ADD CONSTRAINT tabular_documents_user_id_foreign FOREIGN KEY (author_organization_id) REFERENCES tabular.organizations(id) ON UPDATE CASCADE ON DELETE CASCADE NOT VALID;


--
-- TOC entry 5989 (class 2606 OID 19489)
-- Name: project_objectives tabular_project_objectives_project_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.project_objectives
    ADD CONSTRAINT tabular_project_objectives_project_id_foreign FOREIGN KEY (project_id) REFERENCES tabular.projects(id) ON DELETE CASCADE;


--
-- TOC entry 5988 (class 2606 OID 19476)
-- Name: project_results tabular_project_results_project_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.project_results
    ADD CONSTRAINT tabular_project_results_project_id_foreign FOREIGN KEY (project_id) REFERENCES tabular.projects(id) ON DELETE CASCADE;


--
-- TOC entry 5991 (class 2606 OID 19591)
-- Name: project_thematics tabular_project_thematics_data_licence_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.project_thematics
    ADD CONSTRAINT tabular_project_thematics_data_licence_id_foreign FOREIGN KEY (data_licence_id) REFERENCES codelist.data_licences(id) ON DELETE CASCADE;


--
-- TOC entry 5992 (class 2606 OID 19596)
-- Name: project_thematics tabular_project_thematics_project_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.project_thematics
    ADD CONSTRAINT tabular_project_thematics_project_id_foreign FOREIGN KEY (project_id) REFERENCES tabular.projects(id) ON DELETE CASCADE;


--
-- TOC entry 5993 (class 2606 OID 19601)
-- Name: project_thematics tabular_project_thematics_thematic_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.project_thematics
    ADD CONSTRAINT tabular_project_thematics_thematic_id_foreign FOREIGN KEY (thematic_id) REFERENCES tabular.thematics(id) ON DELETE CASCADE;


--
-- TOC entry 5984 (class 2606 OID 19453)
-- Name: projects tabular_projects_currency_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.projects
    ADD CONSTRAINT tabular_projects_currency_id_foreign FOREIGN KEY (currency_id) REFERENCES codelist.currency(id) ON DELETE CASCADE;


--
-- TOC entry 5985 (class 2606 OID 19448)
-- Name: projects tabular_projects_location_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.projects
    ADD CONSTRAINT tabular_projects_location_id_foreign FOREIGN KEY (location_id) REFERENCES codelist.project_locations(id) ON DELETE CASCADE;


--
-- TOC entry 5986 (class 2606 OID 19458)
-- Name: projects tabular_projects_organization_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.projects
    ADD CONSTRAINT tabular_projects_organization_id_foreign FOREIGN KEY (organization_id) REFERENCES tabular.organizations(id) ON DELETE CASCADE;


--
-- TOC entry 5987 (class 2606 OID 19463)
-- Name: projects tabular_projects_user_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.projects
    ADD CONSTRAINT tabular_projects_user_id_foreign FOREIGN KEY (user_id) REFERENCES public.users(user_id) ON DELETE CASCADE;


--
-- TOC entry 5981 (class 2606 OID 19698)
-- Name: thematics tabular_thematics_codelist_thematic_categories_id_foreign; Type: FK CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.thematics
    ADD CONSTRAINT tabular_thematics_codelist_thematic_categories_id_foreign FOREIGN KEY (category_thematic_id) REFERENCES codelist.thematic_categories(id) ON DELETE CASCADE NOT VALID;


-- Completed on 2025-11-13 12:16:08

--
--

