---

-- This script was generated by the ERD tool in pgAdmin 4.
-- Please log an issue at https://github.com/pgadmin-org/pgadmin4/issues/new/choose if you find any bugs, including reproduction steps.
BEGIN;


CREATE TABLE IF NOT EXISTS public.pv
(
    id serial NOT NULL,
    adres character varying COLLATE pg_catalog."default",
    CONSTRAINT pv_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.trr
(
    articul character varying COLLATE pg_catalog."default",
    name integer,
    r integer,
    post integer,
    proizv integer,
    categ character varying COLLATE pg_catalog."default",
    sale integer,
    sklad integer,
    opisan character varying COLLATE pg_catalog."default",
    photo character varying COLLATE pg_catalog."default"
);

CREATE TABLE IF NOT EXISTS public."user"
(
    "rol sotrud" serial NOT NULL,
    fio character varying COLLATE pg_catalog."default",
    login character varying COLLATE pg_catalog."default",
    password character varying COLLATE pg_catalog."default",
    CONSTRAINT user_pkey PRIMARY KEY ("rol sotrud")
);

CREATE TABLE IF NOT EXISTS public.zakaz
(
    nom integer NOT NULL,
    "date " date,
    date date,
    adres integer,
    fio character varying COLLATE pg_catalog."default",
    kod integer,
    status character varying COLLATE pg_catalog."default",
    CONSTRAINT zakaz_pkey PRIMARY KEY (nom)
);

CREATE TABLE IF NOT EXISTS public.tovar2
(
    proizvod character varying COLLATE pg_catalog."default",
    id serial NOT NULL,
    CONSTRAINT zakaz2_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.tovar2name
(
    "name tovara" character varying COLLATE pg_catalog."default",
    id serial NOT NULL,
    CONSTRAINT zakaz2name_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.tovar2post
(
    postavsh character varying COLLATE pg_catalog."default",
    id serial NOT NULL,
    CONSTRAINT zakaz2post_pkey PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.zakaz2
(
    status character varying,
    id serial,
    PRIMARY KEY (id)
);

CREATE TABLE IF NOT EXISTS public.user2
(
    sotrudnik character varying,
    id serial,
    PRIMARY KEY (id)
);

ALTER TABLE IF EXISTS public.trr
    ADD FOREIGN KEY (proizv)
    REFERENCES public.tovar2 (proizvod) MATCH SIMPLE
    ON UPDATE NO ACTION
    ON DELETE NO ACTION
    NOT VALID;


ALTER TABLE IF EXISTS public.trr
    ADD FOREIGN KEY (name)
    REFERENCES public.tovar2name (id) MATCH SIMPLE
    ON UPDATE NO ACTION
    ON DELETE NO ACTION
    NOT VALID;


ALTER TABLE IF EXISTS public.trr
    ADD FOREIGN KEY (post)
    REFERENCES public.tovar2post (id) MATCH SIMPLE
    ON UPDATE NO ACTION
    ON DELETE NO ACTION
    NOT VALID;


ALTER TABLE IF EXISTS public."user"
    ADD FOREIGN KEY ("rol sotrud")
    REFERENCES public.user2 (id) MATCH SIMPLE
    ON UPDATE NO ACTION
    ON DELETE NO ACTION
    NOT VALID;


ALTER TABLE IF EXISTS public.zakaz
    ADD FOREIGN KEY (status)
    REFERENCES public.zakaz2 (id) MATCH SIMPLE
    ON UPDATE NO ACTION
    ON DELETE NO ACTION
    NOT VALID;


ALTER TABLE IF EXISTS public.zakaz
    ADD FOREIGN KEY (adres)
    REFERENCES public.pv (id) MATCH SIMPLE
    ON UPDATE NO ACTION
    ON DELETE NO ACTION
    NOT VALID;

END;