+/- table definition

Query 

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
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update view : create view : drop