+/- table definition

Query 

CREATE TABLE "player_room_count"  (
  "seat" integer not null,
  "player_id" text not null,
  "game_category_id" text not null references "game" ("category_id") on delete cascade,
  "day" integer not null,
  "rooms_created" integer not null,
  "total_rooms_joined" integer not null,
  "group_rooms_created" integer not null,
  "total_group_rooms_joined" integer not null,
  constraint "player_room_count_primary_key" primary key ("seat", "player_id", "game_category_id", "day"),
  constraint "unique_seat_game_day" unique ("seat", "game_category_id", "day"),
  constraint "fk_player_room_count_player" foreign key ("player_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