db_schema.sql

--
-- PostgreSQL database dump
--

-- Dumped from database version 16.9 (Ubuntu 16.9-1.pgdg24.04+1)
-- Dumped by pg_dump version 17.5 (Ubuntu 17.5-1.pgdg24.04+1)

-- Started on 2025-05-22 15:39:25 CEST

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_timeout = 0;
SET transaction_timeout = 0;
SET client_encoding = 'UTF8';
SET standard_conforming_strings = on;
SELECT pg_catalog.set_config('search_path', '', false);
SET check_function_bodies = false;
SET xmloption = content;
SET client_min_messages = warning;
SET row_security = off;

--
-- TOC entry 4 (class 2615 OID 2200)
-- Name: public; Type: SCHEMA; Schema: -; Owner: pg_database_owner
--

CREATE SCHEMA public;


ALTER SCHEMA public OWNER TO pg_database_owner;

--
-- TOC entry 3547 (class 0 OID 0)
-- Dependencies: 4
-- Name: SCHEMA public; Type: COMMENT; Schema: -; Owner: pg_database_owner
--

COMMENT ON SCHEMA public IS 'standard public schema';


--
-- TOC entry 251 (class 1255 OID 347013)
-- Name: provjeri_broj_recenzija_za_najam(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION public.provjeri_broj_recenzija_za_najam() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
DECLARE
  unajmljivac BIGINT;
  vlasnik BIGINT;
BEGIN
  IF (SELECT COUNT(*) FROM recenzija WHERE id_najam = NEW.id_najam) >= 2 THEN
    RAISE EXCEPTION 'Najam može imati najviše 2 recenzije.';
  END IF;
  
  IF
    EXISTS (
	  SELECT 1 FROM recenzija 
	  WHERE id_najam = NEW.id_najam AND id_ocjenjivac = NEW.id_ocjenjivac
	) THEN 
	  RAISE EXCEPTION 'Korisnik je već ocijenio ovaj najam.';
  END IF;

  -- provjera jesu li ocjenjivač i ocijenjeni oni koji su sudjelovali u najmu
  SELECT n.id_korisnik, a.id_korisnik
  INTO unajmljivac, vlasnik
  FROM najam n
  JOIN alat a ON n.id_alat = a.id_alat
  WHERE n.id_najam = NEW.id_najam;

  IF ((NEW.id_ocjenjivac != unajmljivac OR NEW.id_ocijenjeni != vlasnik) AND 
     (NEW.id_ocjenjivac != vlasnik OR NEW.id_ocijenjeni != unajmljivac)) THEN
    RAISE EXCEPTION 'Samo unajmljivač i vlasnik alata mogu sudjelovati u ocjenjivanju.';
  END IF;
  
  RETURN NEW;
END;
$$;


ALTER FUNCTION public.provjeri_broj_recenzija_za_najam() OWNER TO postgres;

--
-- TOC entry 239 (class 1255 OID 347011)
-- Name: provjeri_broj_slika_za_alat(); Type: FUNCTION; Schema: public; Owner: postgres
--

CREATE FUNCTION public.provjeri_broj_slika_za_alat() RETURNS trigger
    LANGUAGE plpgsql
    AS $$
BEGIN
  IF (SELECT COUNT(*) FROM slika_alat WHERE id_alat = NEW.id_alat) >= 5 THEN
    RAISE EXCEPTION 'Alat može imati najviše 5 slika.';
  END IF;
  RETURN NEW;
END;
$$;


ALTER FUNCTION public.provjeri_broj_slika_za_alat() OWNER TO postgres;

SET default_tablespace = '';

SET default_table_access_method = heap;

--
-- TOC entry 218 (class 1259 OID 346823)
-- Name: adresa; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.adresa (
    id_adresa bigint NOT NULL,
    id_naselje bigint NOT NULL,
    ulica character varying,
    broj character varying
);


ALTER TABLE public.adresa OWNER TO postgres;

--
-- TOC entry 238 (class 1259 OID 347026)
-- Name: adresa_id_adresa_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.adresa ALTER COLUMN id_adresa ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.adresa_id_adresa_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- TOC entry 224 (class 1259 OID 346926)
-- Name: alat; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.alat (
    id_alat bigint NOT NULL,
    id_kategorija bigint NOT NULL,
    id_korisnik bigint NOT NULL,
    id_adresa bigint NOT NULL,
    naziv character varying NOT NULL,
    opis text NOT NULL,
    cijena double precision NOT NULL,
    period_za_cijenu character varying NOT NULL,
    stanje character varying NOT NULL,
    CONSTRAINT check_period_za_cijenu CHECK (((period_za_cijenu)::text = ANY ((ARRAY['DAN'::character varying, 'TJEDAN'::character varying, 'MJESEC'::character varying, 'UKUPNO'::character varying])::text[]))),
    CONSTRAINT check_stanje CHECK (((stanje)::text = ANY ((ARRAY['DOSTUPAN'::character varying, 'IZNAJMLJEN'::character varying, 'ARHIVIRAN'::character varying])::text[])))
);


ALTER TABLE public.alat OWNER TO postgres;

--
-- TOC entry 237 (class 1259 OID 347025)
-- Name: alat_id_alat_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.alat ALTER COLUMN id_alat ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.alat_id_alat_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- TOC entry 220 (class 1259 OID 346858)
-- Name: blog_objava; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.blog_objava (
    id_blog_objava bigint NOT NULL,
    id_udruga bigint NOT NULL,
    naslov character varying NOT NULL,
    text text NOT NULL,
    slika bytea,
    datum_objave date NOT NULL
);


ALTER TABLE public.blog_objava OWNER TO postgres;

--
-- TOC entry 236 (class 1259 OID 347024)
-- Name: blog_objava_id_blog_objava_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.blog_objava ALTER COLUMN id_blog_objava ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.blog_objava_id_blog_objava_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- TOC entry 222 (class 1259 OID 346900)
-- Name: individualni_korisnik; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.individualni_korisnik (
    id_korisnik bigint NOT NULL,
    korisnicko_ime character varying NOT NULL,
    ime character varying NOT NULL,
    prezime character varying NOT NULL,
    kontakt_broj character varying
);


ALTER TABLE public.individualni_korisnik OWNER TO postgres;

--
-- TOC entry 223 (class 1259 OID 346914)
-- Name: kategorija; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.kategorija (
    id_kategorija bigint NOT NULL,
    id_nadkategorija bigint,
    naziv character varying NOT NULL
);


ALTER TABLE public.kategorija OWNER TO postgres;

--
-- TOC entry 235 (class 1259 OID 347023)
-- Name: kategorija_id_kategorija_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.kategorija ALTER COLUMN id_kategorija ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.kategorija_id_kategorija_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- TOC entry 219 (class 1259 OID 346835)
-- Name: korisnik; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.korisnik (
    id_korisnik bigint NOT NULL,
    id_adresa bigint NOT NULL,
    email character varying NOT NULL,
    lozinka character varying NOT NULL,
    uloga character varying NOT NULL,
    opis text,
    slika bytea,
    CONSTRAINT check_uloga CHECK (((uloga)::text = ANY ((ARRAY['ADMIN'::character varying, 'KORISNIK'::character varying])::text[])))
);


ALTER TABLE public.korisnik OWNER TO postgres;

--
-- TOC entry 234 (class 1259 OID 347022)
-- Name: korisnik_id_korisnik_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.korisnik ALTER COLUMN id_korisnik ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.korisnik_id_korisnik_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- TOC entry 226 (class 1259 OID 346963)
-- Name: najam; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.najam (
    id_najam bigint NOT NULL,
    id_alat bigint NOT NULL,
    id_korisnik bigint NOT NULL,
    datum_od date NOT NULL,
    datum_do date NOT NULL,
    cijena double precision NOT NULL,
    period_za_cijenu character varying NOT NULL,
    stanje character varying NOT NULL,
    CONSTRAINT check_period_za_cijenu CHECK (((period_za_cijenu)::text = ANY ((ARRAY['DAN'::character varying, 'TJEDAN'::character varying, 'MJESEC'::character varying, 'UKUPNO'::character varying])::text[]))),
    CONSTRAINT check_stanje CHECK (((stanje)::text = ANY ((ARRAY['ZATRAZEN'::character varying, 'POTVRDEN'::character varying, 'OTKAZAN'::character varying, 'AKTIVAN'::character varying, 'U_POVRATKU'::character varying, 'ZAVRSEN'::character varying, 'SPOR'::character varying])::text[])))
);


ALTER TABLE public.najam OWNER TO postgres;

--
-- TOC entry 233 (class 1259 OID 347021)
-- Name: najam_id_najam_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.najam ALTER COLUMN id_najam ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.najam_id_najam_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- TOC entry 217 (class 1259 OID 346811)
-- Name: naselje; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.naselje (
    id_naselje bigint NOT NULL,
    id_opcina_grad bigint NOT NULL,
    naziv character varying NOT NULL,
    pbr integer NOT NULL
);


ALTER TABLE public.naselje OWNER TO postgres;

--
-- TOC entry 232 (class 1259 OID 347020)
-- Name: naselje_id_naselje_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.naselje ALTER COLUMN id_naselje ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.naselje_id_naselje_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- TOC entry 216 (class 1259 OID 346797)
-- Name: opcina_grad; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.opcina_grad (
    id_opcina_grad bigint NOT NULL,
    id_zupanija bigint NOT NULL,
    naziv character varying NOT NULL
);


ALTER TABLE public.opcina_grad OWNER TO postgres;

--
-- TOC entry 231 (class 1259 OID 347019)
-- Name: opcina_grad_id_opcina_grad_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.opcina_grad ALTER COLUMN id_opcina_grad ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.opcina_grad_id_opcina_grad_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- TOC entry 227 (class 1259 OID 346982)
-- Name: recenzija; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.recenzija (
    id_recenzija bigint NOT NULL,
    id_najam bigint NOT NULL,
    id_ocjenjivac bigint NOT NULL,
    id_ocijenjeni bigint NOT NULL,
    ocjena smallint NOT NULL,
    komentar text,
    CONSTRAINT check_ocjena CHECK ((ocjena = ANY (ARRAY[1, 2, 3, 4, 5])))
);


ALTER TABLE public.recenzija OWNER TO postgres;

--
-- TOC entry 230 (class 1259 OID 347018)
-- Name: recenzija_id_recenzija_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.recenzija ALTER COLUMN id_recenzija ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.recenzija_id_recenzija_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- TOC entry 225 (class 1259 OID 346951)
-- Name: slika_alat; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.slika_alat (
    id_slika_alat bigint NOT NULL,
    id_alat bigint NOT NULL,
    slika bytea NOT NULL
);


ALTER TABLE public.slika_alat OWNER TO postgres;

--
-- TOC entry 229 (class 1259 OID 347017)
-- Name: slika_alat_id_slika_alat_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.slika_alat ALTER COLUMN id_slika_alat ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.slika_alat_id_slika_alat_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- TOC entry 221 (class 1259 OID 346883)
-- Name: udruga; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.udruga (
    id_korisnik bigint NOT NULL,
    naziv character varying NOT NULL,
    url character varying
);


ALTER TABLE public.udruga OWNER TO postgres;

--
-- TOC entry 215 (class 1259 OID 346790)
-- Name: zupanija; Type: TABLE; Schema: public; Owner: postgres
--

CREATE TABLE public.zupanija (
    id_zupanija bigint NOT NULL,
    naziv character varying NOT NULL
);


ALTER TABLE public.zupanija OWNER TO postgres;

--
-- TOC entry 228 (class 1259 OID 347015)
-- Name: zupanija_id_zupanija_seq; Type: SEQUENCE; Schema: public; Owner: postgres
--

ALTER TABLE public.zupanija ALTER COLUMN id_zupanija ADD GENERATED BY DEFAULT AS IDENTITY (
    SEQUENCE NAME public.zupanija_id_zupanija_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1
);


--
-- TOC entry 3357 (class 2606 OID 346829)
-- Name: adresa adresa_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.adresa
    ADD CONSTRAINT adresa_pkey PRIMARY KEY (id_adresa);


--
-- TOC entry 3373 (class 2606 OID 346934)
-- Name: alat alat_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.alat
    ADD CONSTRAINT alat_pkey PRIMARY KEY (id_alat);


--
-- TOC entry 3363 (class 2606 OID 346864)
-- Name: blog_objava blog_objava_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.blog_objava
    ADD CONSTRAINT blog_objava_pkey PRIMARY KEY (id_blog_objava);


--
-- TOC entry 3346 (class 2606 OID 347005)
-- Name: najam check_period; Type: CHECK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE public.najam
    ADD CONSTRAINT check_period CHECK ((datum_od <= datum_do)) NOT VALID;


--
-- TOC entry 3367 (class 2606 OID 346906)
-- Name: individualni_korisnik individualni_korisnik_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.individualni_korisnik
    ADD CONSTRAINT individualni_korisnik_pkey PRIMARY KEY (id_korisnik);


--
-- TOC entry 3371 (class 2606 OID 346920)
-- Name: kategorija kategorija_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.kategorija
    ADD CONSTRAINT kategorija_pkey PRIMARY KEY (id_kategorija);


--
-- TOC entry 3359 (class 2606 OID 346842)
-- Name: korisnik korisnik_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.korisnik
    ADD CONSTRAINT korisnik_pkey PRIMARY KEY (id_korisnik);


--
-- TOC entry 3377 (class 2606 OID 346971)
-- Name: najam najam_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.najam
    ADD CONSTRAINT najam_pkey PRIMARY KEY (id_najam);


--
-- TOC entry 3355 (class 2606 OID 346817)
-- Name: naselje naselje_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.naselje
    ADD CONSTRAINT naselje_pkey PRIMARY KEY (id_naselje);


--
-- TOC entry 3353 (class 2606 OID 346803)
-- Name: opcina_grad opcina_grad_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.opcina_grad
    ADD CONSTRAINT opcina_grad_pkey PRIMARY KEY (id_opcina_grad);


--
-- TOC entry 3379 (class 2606 OID 346989)
-- Name: recenzija recenzija_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.recenzija
    ADD CONSTRAINT recenzija_pkey PRIMARY KEY (id_recenzija);


--
-- TOC entry 3375 (class 2606 OID 346957)
-- Name: slika_alat slika_alat_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.slika_alat
    ADD CONSTRAINT slika_alat_pkey PRIMARY KEY (id_slika_alat);


--
-- TOC entry 3365 (class 2606 OID 346889)
-- Name: udruga udruga_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.udruga
    ADD CONSTRAINT udruga_pkey PRIMARY KEY (id_korisnik);


--
-- TOC entry 3361 (class 2606 OID 346844)
-- Name: korisnik unique_email; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.korisnik
    ADD CONSTRAINT unique_email UNIQUE (email);


--
-- TOC entry 3369 (class 2606 OID 347028)
-- Name: individualni_korisnik unique_korisnicko_ime; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.individualni_korisnik
    ADD CONSTRAINT unique_korisnicko_ime UNIQUE (korisnicko_ime);


--
-- TOC entry 3351 (class 2606 OID 346796)
-- Name: zupanija zupanija_pkey; Type: CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.zupanija
    ADD CONSTRAINT zupanija_pkey PRIMARY KEY (id_zupanija);


--
-- TOC entry 3397 (class 2620 OID 347012)
-- Name: slika_alat ogranici_broj_slika; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER ogranici_broj_slika BEFORE INSERT ON public.slika_alat FOR EACH ROW EXECUTE FUNCTION public.provjeri_broj_slika_za_alat();


--
-- TOC entry 3398 (class 2620 OID 347014)
-- Name: recenzija provjeri_recenziju; Type: TRIGGER; Schema: public; Owner: postgres
--

CREATE TRIGGER provjeri_recenziju BEFORE INSERT OR UPDATE ON public.recenzija FOR EACH ROW EXECUTE FUNCTION public.provjeri_broj_recenzija_za_najam();


--
-- TOC entry 3382 (class 2606 OID 346830)
-- Name: adresa fk_adresa__naselje; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.adresa
    ADD CONSTRAINT fk_adresa__naselje FOREIGN KEY (id_naselje) REFERENCES public.naselje(id_naselje);


--
-- TOC entry 3388 (class 2606 OID 346945)
-- Name: alat fk_alat__adresa; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.alat
    ADD CONSTRAINT fk_alat__adresa FOREIGN KEY (id_adresa) REFERENCES public.adresa(id_adresa);


--
-- TOC entry 3389 (class 2606 OID 346935)
-- Name: alat fk_alat__kategorija; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.alat
    ADD CONSTRAINT fk_alat__kategorija FOREIGN KEY (id_kategorija) REFERENCES public.kategorija(id_kategorija);


--
-- TOC entry 3390 (class 2606 OID 346940)
-- Name: alat fk_alat__korisnik; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.alat
    ADD CONSTRAINT fk_alat__korisnik FOREIGN KEY (id_korisnik) REFERENCES public.individualni_korisnik(id_korisnik);


--
-- TOC entry 3384 (class 2606 OID 346895)
-- Name: blog_objava fk_blog_objava__udruga; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.blog_objava
    ADD CONSTRAINT fk_blog_objava__udruga FOREIGN KEY (id_udruga) REFERENCES public.udruga(id_korisnik) NOT VALID;


--
-- TOC entry 3386 (class 2606 OID 346909)
-- Name: individualni_korisnik fk_individualni_korisnik__korisnik; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.individualni_korisnik
    ADD CONSTRAINT fk_individualni_korisnik__korisnik FOREIGN KEY (id_korisnik) REFERENCES public.korisnik(id_korisnik);


--
-- TOC entry 3387 (class 2606 OID 346921)
-- Name: kategorija fk_kategorija__nadkategorija; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.kategorija
    ADD CONSTRAINT fk_kategorija__nadkategorija FOREIGN KEY (id_nadkategorija) REFERENCES public.kategorija(id_kategorija) NOT VALID;


--
-- TOC entry 3383 (class 2606 OID 346845)
-- Name: korisnik fk_korisnik__adresa; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.korisnik
    ADD CONSTRAINT fk_korisnik__adresa FOREIGN KEY (id_adresa) REFERENCES public.adresa(id_adresa);


--
-- TOC entry 3392 (class 2606 OID 346972)
-- Name: najam fk_najam__anat; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.najam
    ADD CONSTRAINT fk_najam__anat FOREIGN KEY (id_alat) REFERENCES public.alat(id_alat);


--
-- TOC entry 3393 (class 2606 OID 346977)
-- Name: najam fk_najam__korisnik; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.najam
    ADD CONSTRAINT fk_najam__korisnik FOREIGN KEY (id_korisnik) REFERENCES public.individualni_korisnik(id_korisnik);


--
-- TOC entry 3381 (class 2606 OID 346818)
-- Name: naselje fk_naselje__opcina_grad; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.naselje
    ADD CONSTRAINT fk_naselje__opcina_grad FOREIGN KEY (id_opcina_grad) REFERENCES public.opcina_grad(id_opcina_grad);


--
-- TOC entry 3380 (class 2606 OID 346806)
-- Name: opcina_grad fk_opcina_grad__zupanija; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.opcina_grad
    ADD CONSTRAINT fk_opcina_grad__zupanija FOREIGN KEY (id_zupanija) REFERENCES public.zupanija(id_zupanija);


--
-- TOC entry 3394 (class 2606 OID 346990)
-- Name: recenzija fk_recenzija__najam; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.recenzija
    ADD CONSTRAINT fk_recenzija__najam FOREIGN KEY (id_najam) REFERENCES public.najam(id_najam);


--
-- TOC entry 3395 (class 2606 OID 347000)
-- Name: recenzija fk_recenzija__ocijenjeni; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.recenzija
    ADD CONSTRAINT fk_recenzija__ocijenjeni FOREIGN KEY (id_ocijenjeni) REFERENCES public.individualni_korisnik(id_korisnik);


--
-- TOC entry 3396 (class 2606 OID 346995)
-- Name: recenzija fk_recenzija__ocjenjivac; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.recenzija
    ADD CONSTRAINT fk_recenzija__ocjenjivac FOREIGN KEY (id_ocjenjivac) REFERENCES public.individualni_korisnik(id_korisnik);


--
-- TOC entry 3391 (class 2606 OID 346958)
-- Name: slika_alat fk_slika_alat__alat; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.slika_alat
    ADD CONSTRAINT fk_slika_alat__alat FOREIGN KEY (id_alat) REFERENCES public.alat(id_alat);


--
-- TOC entry 3385 (class 2606 OID 346890)
-- Name: udruga fk_udruga__korisnik; Type: FK CONSTRAINT; Schema: public; Owner: postgres
--

ALTER TABLE ONLY public.udruga
    ADD CONSTRAINT fk_udruga__korisnik FOREIGN KEY (id_korisnik) REFERENCES public.korisnik(id_korisnik);


-- Completed on 2025-05-22 15:39:25 CEST

--
-- PostgreSQL database dump complete
--