create table foo (
  id   serial,
  name varchar(60) not null,
  constraint foo_pk primary key(id),
  constraint foo_name unique(name)
);

create table bar (
  id serial,
  foo_id integer not null references foo (id),
  name varchar(500) not null,
  constraint bar_pk primary key(id)
);