--
-- PostgreSQL database dump
--

-- Dumped from database version 10.6 (Ubuntu 10.6-0ubuntu0.18.10.1)
-- Dumped by pg_dump version 10.6 (Ubuntu 10.6-0ubuntu0.18.10.1)

SET statement_timeout = 0;
SET lock_timeout = 0;
SET idle_in_transaction_session_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 client_min_messages = warning;
SET row_security = off;

--
-- Name: plpgsql; Type: EXTENSION; Schema: -; Owner:
--

CREATE EXTENSION IF NOT EXISTS plpgsql WITH SCHEMA pg_catalog;


--
-- Name: EXTENSION plpgsql; Type: COMMENT; Schema: -; Owner:
--

COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';


SET default_tablespace = '';

SET default_with_oids = false;

--
-- Name: autor; Type: TABLE; Schema: public; Owner: student1
--

CREATE TABLE public.autor (
    sifra character varying(10) NOT NULL,
    ime character varying(20) NOT NULL,
    prezime character varying(20) NOT NULL
);


ALTER TABLE public.autor OWNER TO student1;

--
-- Name: autor_knjige; Type: TABLE; Schema: public; Owner: student1
--

CREATE TABLE public.autor_knjige (
    knjiga character varying(10) NOT NULL,
    autor character varying(10) NOT NULL
);


ALTER TABLE public.autor_knjige OWNER TO student1;

--
-- Name: autor_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student1
--

CREATE SEQUENCE public.autor_sifra_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.autor_sifra_seq OWNER TO student1;

--
-- Name: autor_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student1
--

ALTER SEQUENCE public.autor_sifra_seq OWNED BY public.autor.sifra;


--
-- Name: brojac; Type: SEQUENCE; Schema: public; Owner: student1
--

CREATE SEQUENCE public.brojac
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.brojac OWNER TO student1;

--
-- Name: clan; Type: TABLE; Schema: public; Owner: student1
--

CREATE TABLE public.clan (
    sifra character varying(10) NOT NULL,
    ime character varying(20) NOT NULL,
    prezime character varying(20) NOT NULL,
    adresa character varying(50) NOT NULL
);


ALTER TABLE public.clan OWNER TO student1;

--
-- Name: clan_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student1
--

CREATE SEQUENCE public.clan_sifra_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.clan_sifra_seq OWNER TO student1;

--
-- Name: clan_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student1
--

ALTER SEQUENCE public.clan_sifra_seq OWNED BY public.clan.sifra;


--
-- Name: izdavac; Type: TABLE; Schema: public; Owner: student1
--

CREATE TABLE public.izdavac (
    sifra character varying(10) NOT NULL,
    naziv character varying(50) NOT NULL
);


ALTER TABLE public.izdavac OWNER TO student1;

--
-- Name: izdavac_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student1
--

CREATE SEQUENCE public.izdavac_sifra_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.izdavac_sifra_seq OWNER TO student1;

--
-- Name: izdavac_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student1
--

ALTER SEQUENCE public.izdavac_sifra_seq OWNED BY public.izdavac.sifra;


--
-- Name: knjiga; Type: TABLE; Schema: public; Owner: student1
--

CREATE TABLE public.knjiga (
    sifra character varying(50) NOT NULL,
    isbn character varying(15),
    naziv character varying(50) NOT NULL,
    godina smallint,
    izdavac character varying(10),
    CONSTRAINT knjiga_godina_check CHECK (((godina > 1970) AND (godina < 2050)))
);


ALTER TABLE public.knjiga OWNER TO student1;

--
-- Name: knjiga_sifra_seq; Type: SEQUENCE; Schema: public; Owner: student1
--

CREATE SEQUENCE public.knjiga_sifra_seq
    START WITH 1
    INCREMENT BY 1
    NO MINVALUE
    NO MAXVALUE
    CACHE 1;


ALTER TABLE public.knjiga_sifra_seq OWNER TO student1;

--
-- Name: knjiga_sifra_seq; Type: SEQUENCE OWNED BY; Schema: public; Owner: student1
--

ALTER SEQUENCE public.knjiga_sifra_seq OWNED BY public.knjiga.sifra;


--
-- Name: posudba; Type: TABLE; Schema: public; Owner: student1
--

CREATE TABLE public.posudba (
    clan character varying(10) NOT NULL,
    datum_posudbe date NOT NULL,
    datum_vracanja date,
    knjiga character varying(10) NOT NULL
);


ALTER TABLE public.posudba OWNER TO student1;

--
-- Name: autor sifra; Type: DEFAULT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.autor ALTER COLUMN sifra SET DEFAULT nextval('public.autor_sifra_seq'::regclass);


--
-- Name: clan sifra; Type: DEFAULT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.clan ALTER COLUMN sifra SET DEFAULT nextval('public.clan_sifra_seq'::regclass);


--
-- Name: izdavac sifra; Type: DEFAULT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.izdavac ALTER COLUMN sifra SET DEFAULT nextval('public.izdavac_sifra_seq'::regclass);


--
-- Name: knjiga sifra; Type: DEFAULT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.knjiga ALTER COLUMN sifra SET DEFAULT nextval('public.knjiga_sifra_seq'::regclass);


--
-- Data for Name: autor; Type: TABLE DATA; Schema: public; Owner: student1
--

COPY public.autor (sifra, ime, prezime) FROM stdin;
\.


--
-- Data for Name: autor_knjige; Type: TABLE DATA; Schema: public; Owner: student1
--

COPY public.autor_knjige (knjiga, autor) FROM stdin;
\.


--
-- Data for Name: clan; Type: TABLE DATA; Schema: public; Owner: student1
--

COPY public.clan (sifra, ime, prezime, adresa) FROM stdin;
\.


--
-- Data for Name: izdavac; Type: TABLE DATA; Schema: public; Owner: student1
--

COPY public.izdavac (sifra, naziv) FROM stdin;
\.


--
-- Data for Name: knjiga; Type: TABLE DATA; Schema: public; Owner: student1
--

COPY public.knjiga (sifra, isbn, naziv, godina, izdavac) FROM stdin;
\.


--
-- Data for Name: posudba; Type: TABLE DATA; Schema: public; Owner: student1
--

COPY public.posudba (clan, datum_posudbe, datum_vracanja, knjiga) FROM stdin;
\.


--
-- Name: autor_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student1
--

SELECT pg_catalog.setval('public.autor_sifra_seq', 1, false);


--
-- Name: brojac; Type: SEQUENCE SET; Schema: public; Owner: student1
--

SELECT pg_catalog.setval('public.brojac', 1, false);


--
-- Name: clan_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student1
--

SELECT pg_catalog.setval('public.clan_sifra_seq', 1, false);


--
-- Name: izdavac_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student1
--

SELECT pg_catalog.setval('public.izdavac_sifra_seq', 1, false);


--
-- Name: knjiga_sifra_seq; Type: SEQUENCE SET; Schema: public; Owner: student1
--

SELECT pg_catalog.setval('public.knjiga_sifra_seq', 1, false);


--
-- Name: autor autor_pkey; Type: CONSTRAINT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.autor
    ADD CONSTRAINT autor_pkey PRIMARY KEY (sifra);


--
-- Name: clan clan_pkey; Type: CONSTRAINT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.clan
    ADD CONSTRAINT clan_pkey PRIMARY KEY (sifra);


--
-- Name: izdavac izdavac_pkey; Type: CONSTRAINT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.izdavac
    ADD CONSTRAINT izdavac_pkey PRIMARY KEY (sifra);


--
-- Name: knjiga knjiga_pkey; Type: CONSTRAINT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.knjiga
    ADD CONSTRAINT knjiga_pkey PRIMARY KEY (sifra);


--
-- Name: autor_knjige pk1; Type: CONSTRAINT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.autor_knjige
    ADD CONSTRAINT pk1 PRIMARY KEY (knjiga, autor);


--
-- Name: posudba pk2; Type: CONSTRAINT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.posudba
    ADD CONSTRAINT pk2 PRIMARY KEY (clan, datum_posudbe, knjiga);


--
-- Name: autor_knjige autor_knjige_autor_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.autor_knjige
    ADD CONSTRAINT autor_knjige_autor_fkey FOREIGN KEY (autor) REFERENCES public.autor(sifra);


--
-- Name: autor_knjige autor_knjige_knjiga_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.autor_knjige
    ADD CONSTRAINT autor_knjige_knjiga_fkey FOREIGN KEY (knjiga) REFERENCES public.knjiga(sifra);


--
-- Name: knjiga knjiga_izdavac_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.knjiga
    ADD CONSTRAINT knjiga_izdavac_fkey FOREIGN KEY (izdavac) REFERENCES public.izdavac(sifra) ON UPDATE CASCADE ON DELETE RESTRICT;


--
-- Name: posudba posudba_clan_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.posudba
    ADD CONSTRAINT posudba_clan_fkey FOREIGN KEY (clan) REFERENCES public.clan(sifra);


--
-- Name: posudba posudba_knjiga_fkey; Type: FK CONSTRAINT; Schema: public; Owner: student1
--

ALTER TABLE ONLY public.posudba
    ADD CONSTRAINT posudba_knjiga_fkey FOREIGN KEY (knjiga) REFERENCES public.knjiga(sifra);


--
-- PostgreSQL database dump complete
--