Query

mira.db — profiles

+/- table definition

Query 

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())
)
Use Shift + Up/Down to navigate recently-executed queries
delete expression index : create index : drop insert select : advanced select table : alter table : create table : drop trigger : create trigger : drop update upsert view : create view : drop