Maybe we can likewise record the dependencies for the type if it's beingused in other more scenarios besides as a column in some table?
pgsql-bugs by date:
Соглашаюсь с условиями обработки персональных данных