ERROR: type "public.geometry" does not exist - Postgres

I have connected my postgres database from render on dbeaver and I want to create a new table. I run the following query :

CREATE TABLE draft_ilias.parcels_2 (
parcel_id serial4 NOT NULL,
user_id int4 NOT NULL,
name_area text NULL,
crop_type varchar(100) NULL,
area_m2 numeric(10, 2) NULL,
geom_4326 public.geometry(polygon, 4326) NULL,
created_at timestamp NULL DEFAULT CURRENT_TIMESTAMP,
irrigation bool NOT NULL DEFAULT false,
traps bool NOT NULL DEFAULT false,
station bool NOT NULL DEFAULT false,
bio bool NOT NULL DEFAULT false,
CONSTRAINT parcels_2_pkey PRIMARY KEY (parcel_id)
); -

SQL Error [42704]: ERROR: type “public.geometry” does not exist
Position: 192 - how to fix it??

Does geometry type actually exist in public schema (or at all)? Is it in draft_ilias? Maybe try removing the schema (“public.”) if you’re already in the correct context?

EDIT: Seems like maybe you’re using PostGIS. Not familiar with it, but you need to run a command to install it CREATE EXTENSION POSTGIS, and then geometry type should just be accessible globally according to their docs, don’t have to qualify it with a schema. Would need more info on what geometry type is, where it lives, etc.