create table roles(
  id serial primary key,
  parent_id integer references roles(id),
  name text
)