SQL

CREATE TABLE "player"  (
  "id" text not null,
  "seat" integer not null,
  "game_category_id" text not null references "game" ("category_id") on delete cascade,
  "dead_votes_remaining" integer not null,
  "active_room_channel_id" text references "private_room" ("channel_id") on delete set null,
  constraint "player_primary_key" primary key ("id", "game_category_id")
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ Rename | Drop
seat INTEGER Rename | Drop
game_category_id TEXT ✓ Rename | Drop
dead_votes_remaining INTEGER Rename | Drop
active_room_channel_id TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
active_room_channel_id private_room.channel_id
game_category_id game.category_id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_player_1
  • id
  • game_category_id
 ✓ SQL
-- no sql found --
 Drop