Query

mira.db — profiles

SQL

CREATE TABLE profiles  (
  id            TEXT PRIMARY KEY,
  user_id       TEXT UNIQUE REFERENCES users(id),
  first_name    TEXT NOT NULL,
  last_name     TEXT NOT NULL,
  country       TEXT NOT NULL,
  gender        TEXT NOT NULL,
  whatsapp      TEXT,
  email         TEXT,
  date_of_birth TEXT,
  plan          TEXT NOT NULL DEFAULT 'formation',
  created_at    INTEGER NOT NULL DEFAULT (unixepoch()),
  updated_at    INTEGER NOT NULL DEFAULT (unixepoch())
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id TEXT ✓ ✓ Rename | Drop
user_id TEXT ✓ Rename | Drop
first_name TEXT Rename | Drop
last_name TEXT Rename | Drop
country TEXT Rename | Drop
gender TEXT Rename | Drop
whatsapp TEXT ✓ Rename | Drop
email TEXT ✓ Rename | Drop
date_of_birth TEXT ✓ Rename | Drop
plan TEXT Rename | Drop
created_at INTEGER Rename | Drop
updated_at INTEGER Rename | Drop

Foreign Keys

Column Destination
user_id users.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_profiles_whatsapp whatsapp SQL 
CREATE INDEX idx_profiles_whatsapp
ON profiles(whatsapp)
Drop
sqlite_autoindex_profiles_1 id ✓ SQL
-- no sql found --
 Drop
sqlite_autoindex_profiles_2 user_id ✓ SQL
-- no sql found --
 Drop