multica/server/migrations/017_comment_parent_id.up.sql

ALTER TABLE comment ADD COLUMN parent_id UUID REFERENCES comment(id) ON DELETE SET NULL;