CREATE TABLE "player_in_room"  (
  "player_id" text not null,
  "game_category_id" text not null,
  "private_room_channel_id" text not null references "private_room" ("channel_id") on delete cascade,
  "seat" integer not null,
  constraint "player_in_room_primary_key" primary key ("player_id", "game_category_id", "private_room_channel_id"),
  constraint "fk_player_in_room_player" foreign key ("player_id", "game_category_id") references "player" ("id", "game_category_id") on delete cascade
)