SQL

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
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
player_id TEXT ✓ Rename | Drop
game_category_id TEXT ✓ Rename | Drop
private_room_channel_id TEXT ✓ Rename | Drop
seat INTEGER Rename | Drop

Foreign Keys

Column Destination
player_id player.id
game_category_id player.game_category_id
private_room_channel_id private_room.channel_id

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_player_in_room_1
  • player_id
  • game_category_id
  • private_room_channel_id
 ✓ SQL
-- no sql found --
 Drop