Query

app.db — smile_preview_jobs

SQL

CREATE TABLE smile_preview_jobs  (
  id INTEGER PRIMARY KEY AUTOINCREMENT,
  chatbot_id INTEGER NOT NULL,
  requester_user_id INTEGER,
  treatment_type TEXT NOT NULL,
  orthodontic_color TEXT,
  before_media_id INTEGER NOT NULL,
  after_media_id INTEGER,
  status TEXT NOT NULL DEFAULT 'pending',
  prompt_version TEXT NOT NULL DEFAULT 'v1',
  error_message TEXT,
  credits_charged INTEGER NOT NULL DEFAULT 0,
  generation_attempt INTEGER NOT NULL DEFAULT 1,
  source TEXT NOT NULL DEFAULT 'admin',
  reference_id TEXT UNIQUE,
  created_at TEXT NOT NULL,
  updated_at TEXT NOT NULL,
  teeth_mask_media_id INTEGER,
  adjusted_after_media_id INTEGER,
  shade_level INTEGER NOT NULL DEFAULT 0,
  embed_visitor_key TEXT,
  source_page_url TEXT,
  FOREIGN KEY (chatbot_id) REFERENCES chatbots(id) ON DELETE CASCADE,
  FOREIGN KEY (requester_user_id) REFERENCES users(id) ON DELETE SET NULL,
  FOREIGN KEY (before_media_id) REFERENCES media_files(id) ON DELETE SET NULL,
  FOREIGN KEY (after_media_id) REFERENCES media_files(id) ON DELETE SET NULL
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id INTEGER ✓ ✓ Rename | Drop
chatbot_id INTEGER Rename | Drop
requester_user_id INTEGER ✓ Rename | Drop
treatment_type TEXT Rename | Drop
orthodontic_color TEXT ✓ Rename | Drop
before_media_id INTEGER Rename | Drop
after_media_id INTEGER ✓ Rename | Drop
status TEXT Rename | Drop
prompt_version TEXT Rename | Drop
error_message TEXT ✓ Rename | Drop
credits_charged INTEGER Rename | Drop
generation_attempt INTEGER Rename | Drop
source TEXT Rename | Drop
reference_id TEXT ✓ Rename | Drop
created_at TEXT Rename | Drop
updated_at TEXT Rename | Drop
teeth_mask_media_id INTEGER ✓ Rename | Drop
adjusted_after_media_id INTEGER ✓ Rename | Drop
shade_level INTEGER Rename | Drop
embed_visitor_key TEXT ✓ Rename | Drop
source_page_url TEXT ✓ Rename | Drop

Foreign Keys

Column Destination
after_media_id media_files.id
before_media_id media_files.id
requester_user_id users.id
chatbot_id chatbots.id

+ Add index

Indexes

Name Columns Unique SQL Drop?
idx_smile_preview_jobs_chatbot
  • chatbot_id
  • created_at
 SQL 
CREATE INDEX idx_smile_preview_jobs_chatbot
ON smile_preview_jobs(chatbot_id, created_at DESC)
Drop
idx_smile_preview_jobs_status status SQL 
CREATE INDEX idx_smile_preview_jobs_status
ON smile_preview_jobs(status)
Drop
sqlite_autoindex_smile_preview_jobs_1 reference_id ✓ SQL
-- no sql found --
 Drop