create table stakepools (
  id text not null,
  pool_id_bech32 text not null,
  metadata ,
  cost bigint not null,
  margin numeric not null,
  pledge bigint not null,
  active_stake bigint not null,
  saturation numeric not null,
  retiring_at_epoch bigint
);

comment on column stakepools.id is '
  the id of the pool
';
comment on column stakepools.pool_id_bech32 is '
  the id in bech32 format of the pool
';
comment on column stakepools.cost is '
  operational costs per epoch in lovelaces
';
comment on column stakepools.margin is '
  operator margin, percentage (from 0 to 1)
';
comment on column stakepools.pledge is '
  pledge amount, in lovelaces
';
comment on column stakepools.active_stake is '
  active stake for current epoch in lovelaces
';
comment on column stakepools.saturation is '
  pool saturation as percentage (0 to 1)
';
comment on column stakepools.retiring_at_epoch is '
  if defined, is the epoch at which the pool will retire
';