CREATE TABLE public.Main (
                ID_man  INTEGER NOT NULL,
                Name VARCHAR NOT NULL,
                Surname VARCHAR NOT NULL,
                PRIMARY KEY (ID_man)

);


CREATE SEQUENCE public.uslov_id_udob_seq;

CREATE TABLE public.uslov (
                ID_udob VARCHAR NOT NULL DEFAULT NEXTVAL('public.uslov_id_udob_seq'),
                ID_man INTEGER NOT NULL,
                name_uslov VARCHAR NOT NULL,
                CONSTRAINT uslov_pk PRIMARY KEY (ID_udob)
);


ALTER SEQUENCE public.uslov_id_udob_seq OWNED BY public.uslov.ID_udob;

ALTER TABLE public.uslov ADD CONSTRAINT table___new_table_fk
FOREIGN KEY (ID_man)
REFERENCES public.Main (ID_man)
ON DELETE NO ACTION
ON UPDATE NO ACTION
NOT DEFERRABLE;