CREATE TABLE "nomination"  (
  "message_id" text primary key,
  "game_category_id" text not null references "game" ("category_id") on delete cascade,
  "channel_id" text not null,
  "nominee_id" text not null,
  "nominator_id" text not null,
  "day" integer not null,
  "time_of_nomination" text not null,
  "voting_window" real not null,
  "majority" integer not null,
  constraint "fk_nomination_nominee" foreign key ("nominee_id", "game_category_id") references "player" ("id", "game_category_id") on delete cascade,
  constraint "fk_nomination_nominator" foreign key ("nominator_id", "game_category_id") references "player" ("id", "game_category_id") on delete cascade
)