create table user_roles (
  id bigint generated by default as identity primary key,
  user_id uuid references auth.users not null,
  role_definition_id bigint references role_definitions (id)
);

Why does auth.users correctly reference a foreign key but if I do role_definitions.id it says schema permissions doesn't exist?