SQL

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
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
seat INTEGER ✓ Rename | Drop
player_id TEXT ✓ Rename | Drop
game_category_id TEXT ✓ Rename | Drop
day INTEGER ✓ Rename | Drop
rooms_created INTEGER Rename | Drop
total_rooms_joined INTEGER Rename | Drop
group_rooms_created INTEGER Rename | Drop
total_group_rooms_joined INTEGER Rename | Drop

Foreign Keys

Column Destination
player_id player.id
game_category_id player.game_category_id
game_category_id game.category_id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_player_room_count_1
  • seat
  • player_id
  • game_category_id
  • day
 ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_player_room_count_2
  • seat
  • game_category_id
  • day
 ✓ SQL
-- no sql found --
 Drop