Example flow is on the image. Here I want to accomplish if playlist removed, make it delete image too.

I know I should’ve put FK on image table but Image is generic and its used more than once.

What are my options? Triggers and application-side comes to mind, but I’m not sure. Maybe there is a better way.

UPDATE: I guess I’ve found what I was looking for, rules:

CREATE RULE playlist_delete AS ON DELETE TO playlist WHERE (SELECT id FROM image WHERE image.id = OLD.image_id) IS NOT NULL DO INSTEAD NOTHING;