Query

db.sqlite3 — user_accounts

SQL

CREATE TABLE "user_accounts"  (
  "id" integer NOT NULL PRIMARY KEY AUTOINCREMENT,
  "platform" varchar(20) NOT NULL,
  "account_identifier" varchar(255) NOT NULL,
  "is_active" bool NOT NULL,
  "created_at" datetime NOT NULL,
  "updated_at" datetime NOT NULL,
  "user_id" bigint NOT NULL REFERENCES "core_users" ("id") DEFERRABLE INITIALLY DEFERRED
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ Rename | Drop
platform varchar(20) Rename | Drop
account_identifier varchar(255) Rename | Drop
is_active bool Rename | Drop
created_at datetime Rename | Drop
updated_at datetime Rename | Drop
user_id bigint Rename | Drop

Foreign Keys

Column Destination
user_id core_users.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
user_accounts_platform_account_identifier_6ce265aa_uniq
  • platform
  • account_identifier
 ✓ SQL 
CREATE UNIQUE INDEX "user_accounts_platform_account_identifier_6ce265aa_uniq"
ON "user_accounts" ("platform", "account_identifier")
Drop
user_accounts_user_id_8a31d4ed user_id SQL 
CREATE INDEX "user_accounts_user_id_8a31d4ed"
ON "user_accounts" ("user_id")
Drop
user_acct_identifier_idx account_identifier SQL 
CREATE INDEX "user_acct_identifier_idx"
ON "user_accounts" ("account_identifier")
Drop
user_acct_platform_idx
  • platform
  • account_identifier
 SQL 
CREATE INDEX "user_acct_platform_idx"
ON "user_accounts" ("platform", "account_identifier")
Drop
user_acct_user_platform_idx
  • user_id
  • platform
 SQL 
CREATE INDEX "user_acct_user_platform_idx"
ON "user_accounts" ("user_id", "platform")
Drop