File: /volume1/@appstore/SynologyPhotos/etc/sql/21.sql
ALTER TABLE public.unit ADD CONSTRAINT unit_uk UNIQUE (id, id_user);
ALTER TABLE public.filter ADD CONSTRAINT composite_unit_fk FOREIGN KEY (id_unit, id_user) REFERENCES unit (id, id_user) MATCH FULL ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE public.face ADD CONSTRAINT composite_unit_fk FOREIGN KEY (ref_id_unit, id_user) REFERENCES unit (id, id_user) MATCH FULL ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE public.address ADD CONSTRAINT composite_unit_fk FOREIGN KEY (id_unit, id_user) REFERENCES unit (id, id_user) MATCH FULL ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE public.one_filter_has_many_unit ADD CONSTRAINT composite_unit_fk FOREIGN KEY (id_unit, id_user) REFERENCES unit (id, id_user) MATCH FULL ON UPDATE CASCADE ON DELETE CASCADE;
ALTER TABLE public.many_unit_has_many_person ADD CONSTRAINT composite_unit_fk FOREIGN KEY (id_unit, id_user) REFERENCES unit (id, id_user) MATCH FULL ON UPDATE CASCADE ON DELETE CASCADE;