CREATE TABLE IF NOT EXISTS public.thumbnail_version ( id_user integer NOT NULL, id_unit integer NOT NULL, version bigint NOT NULL, sm_size_hash text NOT NULL DEFAULT '', PRIMARY KEY (id_unit) ); ALTER TABLE public.thumbnail_version ADD CONSTRAINT composite_unit_fk FOREIGN KEY (id_unit, id_user) REFERENCES unit (id, id_user) MATCH FULL ON DELETE CASCADE ON UPDATE CASCADE;