CREATE TABLE public.motion_photo_additional( duration int8 NOT NULL, video_info json NOT NULL, audio_info json NOT NULL, id_unit integer, CONSTRAINT motion_photo_additional_uq UNIQUE (id_unit) ); ALTER TABLE public.motion_photo_additional ADD CONSTRAINT unit_fk FOREIGN KEY (id_unit) REFERENCES public.unit (id) MATCH FULL ON DELETE CASCADE ON UPDATE CASCADE;