create table competitions (
  guid uuid not null,
  name text,
  status text references competition_statuses not null,
  start_at timestamptz not null,
  end_at timestamptz not null,
  created_at timestamptz not null,
  updated_at timestamptz not null
);
comment on table competitions is '
  A competition is a race game for the competitors to collect more vote points.
';

comment on column competitions.guid is '
  Internal unique identifier for this competition.
';