ALTER TABLE roms
ADD COLUMN parent_id INTEGER REFERENCES roms(id) ON DELETE CASCADE;