INSERT INTO spatial.watercourse VALUES (6565, NULL, NULL, 0.00000000000, '[encoded data, 102132 characters]');
INSERT INTO spatial.watercourse VALUES (6566, NULL, NULL, 0.00000000000, '[encoded data, 105036 characters]');
INSERT INTO spatial.watercourse VALUES (6567, NULL, NULL, 0.00000000000, '[encoded data, 31870 characters]');
INSERT INTO spatial.watercourse VALUES (6568, NULL, NULL, 0.00000000000, '[encoded data, 40606 characters]');
INSERT INTO spatial.watercourse VALUES (6569, NULL, NULL, 0.00000000000, '0105000020110F000001000000010200000065000000FE4571B205C93941EDD4559F0480C840C4EC646EBCC839413912514A7259C840CA95B34F5AC83941A9ED3C960A64C840861F3E1EC7C739411E7B59E0F155C840587B5C0288C73941DB4105EDEA12C84011840FCED8C639415A340532CD40C840FAAC82A75AC6394115EB35EB8259C840896EDF9B1BC63941CBB7D66231AEC840C196D7748FC53941F63A05DBB6EDC8402AD6FA561FC53941C7B572833B2DC94027B74E7665C53941F2D9B8B75077C9405DA14F6718C53941E0A458180ED3C9406BD1214BA1C43941F2B8EBFE5332CA40B8002B4C7EC439415002E646B49FCA40CD3CEF3623C439410E025742CEE9CA4087491332F2C339415721EE441249CB40BCDFFA0D66C3394156760078C39DCB402DD3D3F911C339416CC160D947DDCB40DCD79CEFD9C239417C5590875220CC40B913D5F3D2C2394122E31FF83E55CC40AB7B10ECA8C2394140950F32A586CC40B9E94DD146C23941E49ACD1E86B4CC404372D7B2DDC13941A5B2619CD1D7CC40304066A7ACC139410233D18BA2FECC405CB0F1B8CFC13941568EE9237F2CCD4048CFCBA374C1394191B92E601273CD401E77218704C139411143C33D1FB6CD40FE070371B0C03941529AFBCFFFE3CD401A96CD4B2BC03941616A78C5771CCE404585055216C03941F9A809AE427FCE401A80F45701C039415E823F5D86DECE4043FEEA449FBF394149317B23DB44CF4082F36D281ABF394110BE46374EB9CF405CEF680795BE39417BB66E2A0007D04092F13791C6BC3941A15E32B5578BD04010958B50C3BB3941EB9B425EBFDAD040036F24FD72BA394130971252DB42D14080A2E1A2FFB839418F9E60F9D8BAD140531F288257B839418E29226F3F0AD240B81E315D9AB739414F92D9937862D2400EDA701997B63941685B82D087A5D240BC6668C89AB53941D24C46FEF4B8D240FF53B07EC1B439419C6B977144BED240AE1009117FB339416D7052561DC7D240440030CCACB2394138F289CC3ED5D240C67874A304B239413CACE21AF30BD340F6CBEF7D71B13941EDE99F984D36D340E138F660F3B0394195F201F22E64D340A6B10915DBAF3941C5808A6A3FA7D3405787E6AC60AE3941526C4547BAFDD34071978C582CAD3941F938B0BA1646D440D0BDCA3FAEAC39416B69D44B8E7ED4404831C5C12CAB3941C6F577791CA0D440A9B1F0D68BA839413051CEBE57B5D44091624C1154A63941DCF14E5454CCD440FDF79DBD50A539413779709658EAD440FDE7C96A54A439411320B365D504D540B450621B4AA33941BA92D44B4236D540B14BD2B607A239415C322294B067D540F153F444B7A03941C025674CF383D540EC9D84E4899F394133F694FF8EACD540AA90DAE05F9F3941E04D012E52CCD54099C8DF02759F3941384486FC2011D640921BC242919F3941923CA8F8BE9AD6409F3E7652289F39419DBA3F616024D7402844DA4DAA9E39416416EF847C8CD7407E3C5641F49D3941A561C5DC9812D840D7DD3B45459D3941C5A968C5B3B6D8406CC1CC0D2D9C3941E8B94FC96A29D940E84DEAD7539B39416A63F76FF568D940FA2EC2D2EA9A39415916A78C9AB6D940F9E8D0345B9B39415AC2844D1932DA4074F052D3189C3941566318EADDEEDA40930B25325F9C39410FCA2BDC897FDB40069D87D50E9D3941548ACB41A848DC403A31DE20329D394157AD0B96ECC5DC400A1D8C339F9C394123D230EE6258DD409D6E9B90D09C3941ABD4AF510FE9DD4079E2C0FAEC9C3941F61035C1C99EDE408CC88155179D39411FF47D452B2ADF40CA7541C0259D3941DC20EC7A6DE3DF4033748F33819D394155A1351B0C3AE0403F132DCF6F9E39419F5D36524174E040790B0558429F394175BA1F5D86A6E040A102C9E0969F3941001AA0738000E140DD77586523A03941B1520E938943E140FEDB2AF8E7A03941FE369BAF6480E14088205AA1C8A13941F4655A8611C6E14084C810D490A139417702B8196AFFE1409BC76DD4E1A03941F4DA260B7A33E240B3AA0497AD9F3941E25B918ED85DE2407698DD36BC9D3941D12D2FFE75A4E2404D1A0ACB099C394122E8A143B9CFE24001995073969A3941D58F8CD455F8E24058DE554EA89939410C706BB9EF20E3406DFECF30DD983941CB5197BE1F45E34009CFB6FDB6973941B7387F150673E3408087DFAA829639410A092927848DE34090708E4E1D953941FED77E2B12AFE3404BAAA614E993394167C4464817DCE340AF5C61C6F3923941511A719676E8E340');
INSERT INTO spatial.watercourse VALUES (6570, NULL, NULL, 0.00000000000, '[encoded data, 60436 characters]');
INSERT INTO spatial.watercourse VALUES (6571, NULL, NULL, 0.00000000000, '[encoded data, 49734 characters]');
INSERT INTO spatial.watercourse VALUES (6572, NULL, NULL, 0.00000000000, '0105000020110F0000010000000102000000430000006E513A7F49143C41721E69A49438FC40D1075DF605133C410FD48D2AC378FC409426CA26E5103C41B206ECAEBF98FC402F0113F1000E3C41B96DA0FAF2AEFC403857ADBA6A0B3C41957DA65E23C5FC40E428A1A7810A3C4120DC544DB7DDFC407A862ED6E7093C41084CFAD42F16FD40E50C067326093C41DE4DA75CF03FFD40910CB29564083C41F891DA906B5DFD4052A226D617083C41D032606D567DFD409424832FA4073C411BA37D30B79FFD40DE83A15609073C4189B6190131BDFD409CE193E020063C411967793C7FE4FD4080D53F9D11053C4137697FC8B710FE4017E766C606023C41271AA1C0BF30FE400A8D1621FBFE3B41CDE8E562253DFE400F1744C716FC3B41E94B357EE650FE4020DD848880F93B4135502FDC1867FE40275A65F14DF63B4142A98BBFF475FE40A2EA94FAB6F33B4130A5F8D4F87AFE407741FCFBD1F03B41E06536260080FE4096DF1C2B24EF3B410691FC31E36EFE4040E4CC0589EE3B41A9088E0A0185FE4067DF730EA0ED3B412BBC19ED0AA0FE40F1A312591BEC3B41E43E388878C2FE40A78BF297FAE93B41CB82D0CBECE4FE40FC1FCF4A64E73B4177EF181C20FBFE40980EE32132E43B41B8B4C5EF4216FF406A764C6FE9E13B41B024BE92A122FF40A6CD9FA169DE3B418FFA8BC39947FF40E361FBB3D3DB3B4163569B7B9F67FF4057E2900E1CD73B414233BDDF0294FF4067615D9474D33B41DABD8FD642AAFF40C2D7E14690D03B41BE40892DEFC2FF40DA447C2EE9CC3B41D6C1718201E3FF40F3F357D6DDC93B418828DBE7AFFBFF402F70E995D2C63B410B856280690B00410141F5C715C43B41E8C1248BE21D00415D0093AD7FC13B41B1A99A0EAC2C0041EC91673127BE3B41E34FD6D41144004184041B4FB8BB3B4145976A4B4F550041D7234E2323B93B41F4ED9DBC256F0041E6F403457CB53B412F243CE3DE820041C5664C74E6B23B41374337E857950041B1A4F5ED29B03B41B29676D380AB004167773B98AAAC3B415C238B2A5DC50041546BED69EDA93B4159802D8B28D400417A4D70AF57A73B411457136DDCE70041847A041E10A53B41EC62FB05C9FC0041697AB4D3B2A33B4122A961CDEA120141FBDBCCF292A13B41E58A46C0342F0141F1D02A84749F3B41E113B041755B014118D8B7FFEF9D3B41D01B4AA1236F014148604AB56B9C3B41C05754C546850141FDE232393C993B4198EBDD9DC8B201413EB08E6E69973B4160701A7904C40141DC841EFB96953B410AF4D37CEFD801416FF923B276933B41AA6FC42B51F001415F7DB6A0F1913B41DF5F4860DCFD01417AA7A4795C8F3B41F30FBFCBB5170241D56A367F44893B41BA71D65D972602418D769761C8833B416B12489D00330241A2AB940DF97F3B41B16A52C83B390241C772BEAB8D7B3B416B4D5F1AB540024137A700CDE5773B4138A2BB0ED94B02414BFCFB41C9733B416E59DA8DE95B0241F73956200B713B41A4FB9C6B1E620241');
INSERT INTO spatial.watercourse VALUES (6573, NULL, NULL, 0.00000000000, '[encoded data, 32300 characters]');


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

INSERT INTO tabular.documents VALUES ('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');
INSERT INTO tabular.documents VALUES ('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');
INSERT INTO tabular.documents VALUES ('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');


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

INSERT INTO tabular.organizations VALUES ('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');
INSERT INTO tabular.organizations VALUES ('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');
INSERT INTO tabular.organizations VALUES ('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');
INSERT INTO tabular.organizations VALUES ('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');
INSERT INTO tabular.organizations VALUES ('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');
INSERT INTO tabular.organizations VALUES ('335db174-a66a-4b46-aa86-ab79745d04c9', 'WWF', 'TEST DESCRIPTION', 'logos/335db174-a66a-4b46-aa86-ab79745d04c9.jpg', NULL, NULL);


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

INSERT INTO tabular.project_objectives VALUES ('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');
INSERT INTO tabular.project_objectives VALUES ('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');
INSERT INTO tabular.project_objectives VALUES ('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 6155 (class 0 OID 19472)
-- Dependencies: 244
-- Data for Name: project_results; Type: TABLE DATA; Schema: tabular; Owner: postgres
--



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

INSERT INTO tabular.project_thematics VALUES ('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');
INSERT INTO tabular.project_thematics VALUES ('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');
INSERT INTO tabular.project_thematics VALUES ('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 6154 (class 0 OID 19442)
-- Dependencies: 243
-- Data for Name: projects; Type: TABLE DATA; Schema: tabular; Owner: postgres
--

INSERT INTO tabular.projects VALUES ('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', NULL, 'SONE NKOKE', NULL, '+237699731856', 'DALIDA IKOUM', 'dalida.ikoum@traffic.org', NULL, NULL, '2025-06-26 20:12:26', '2025-06-26 20:12:26', NULL, NULL);
INSERT INTO tabular.projects VALUES ('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', NULL, NULL, '335db174-a66a-4b46-aa86-ab79745d04c9', '4ca1db3f-9e82-483a-b5eb-5507c9147ccf', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, '2025-07-15 16:13:52', '2025-07-15 16:13:52', NULL, NULL);
INSERT INTO tabular.projects VALUES ('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', NULL, 'Christian NGANWA', 'cnganwa@wwfcam.org', NULL, NULL, '2025-06-26 17:09:50', '2025-07-02 08:52:48', 'logos/9b20d3c9-304e-4c6f-9459-7f64d60ac38a.jpg', 'WWF, 2023');


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

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


--
-- TOC entry 5922 (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 5872 (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 5914 (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 5918 (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 5868 (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 5926 (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 5864 (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 5924 (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 5874 (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 5916 (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 5920 (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 5870 (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 5928 (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 5866 (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 5862 (class 2606 OID 18775)
-- Name: cache_locks cache_locks_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cache_locks
    ADD CONSTRAINT cache_locks_pkey PRIMARY KEY (key);


--
-- TOC entry 5860 (class 2606 OID 18768)
-- Name: cache cache_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.cache
    ADD CONSTRAINT cache_pkey PRIMARY KEY (key);


--
-- TOC entry 5856 (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 5858 (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 5854 (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 5851 (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 5844 (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 5890 (class 2606 OID 19432)
-- Name: password_reset_tokens password_reset_tokens_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.password_reset_tokens
    ADD CONSTRAINT password_reset_tokens_pkey PRIMARY KEY (email);


--
-- TOC entry 5893 (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 5946 (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 5941 (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 5967 (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 5955 (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 5958 (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 5949 (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 5961 (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 5943 (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 5939 (class 2606 OID 20981)
-- Name: tridom tridom_pkey; Type: CONSTRAINT; Schema: spatial; Owner: postgres
--

ALTER TABLE ONLY spatial.tridom
    ADD CONSTRAINT tridom_pkey PRIMARY KEY (id);


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

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


--
-- TOC entry 5952 (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 5932 (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 5880 (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 5904 (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 5900 (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 5930 (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 5896 (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 5934 (class 2606 OID 19659)
-- Name: documents tabular_documents_name_unique; Type: CONSTRAINT; Schema: tabular; Owner: postgres
--

ALTER TABLE ONLY tabular.documents
    ADD CONSTRAINT tabular_documents_name_unique UNIQUE (name);


--
-- TOC entry 5906 (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 5902 (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 5898 (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 5876 (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 5878 (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 5882 (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 5852 (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 5891 (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 5894 (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 5944 (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 5965 (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 5953 (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 5956 (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 5947 (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 5959 (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 5937 (class 1259 OID 20984)
-- Name: tridom_geom_idx; Type: INDEX; Schema: spatial; Owner: postgres
--

CREATE INDEX tridom_geom_idx ON spatial.tridom USING gist (geom);


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

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


--
-- TOC entry 5950 (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 5981 (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 5982 (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 5983 (class 2606 OID 19646)
-- 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 (user_id) REFERENCES public.users(user_id) ON DELETE CASCADE;


--
-- TOC entry 5976 (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 5975 (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 5978 (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 5979 (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 5980 (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 5971 (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 5972 (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 5973 (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 5974 (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 5968 (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-10-15 11:08:20

--
--

