Query

ontos.db — workspaces

SQL

CREATE TABLE workspaces  (
  id VARCHAR(50) NOT NULL,
  name VARCHAR(255) NOT NULL,
  project_id VARCHAR(50),
  windows JSON,
  window_layouts JSON,
  active BOOLEAN,
  created_at JSON NOT NULL,
  tenant_id VARCHAR(50) NOT NULL,
  license_tier JSON,
  description TEXT,
  updated_at JSON NOT NULL,
  last_accessed_at JSON,
  settings JSON,
  layout_config JSON,
  theme VARCHAR(255),
  ui_preferences JSON,
  active_workflows JSON,
  pinned_widgets JSON,
  PRIMARY KEY (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id VARCHAR(50) ✓ Rename | Drop
name VARCHAR(255) Rename | Drop
project_id VARCHAR(50) ✓ Rename | Drop
windows JSON ✓ Rename | Drop
window_layouts JSON ✓ Rename | Drop
active BOOLEAN ✓ Rename | Drop
created_at JSON Rename | Drop
tenant_id VARCHAR(50) Rename | Drop
license_tier JSON ✓ Rename | Drop
description TEXT ✓ Rename | Drop
updated_at JSON Rename | Drop
last_accessed_at JSON ✓ Rename | Drop
settings JSON ✓ Rename | Drop
layout_config JSON ✓ Rename | Drop
theme VARCHAR(255) ✓ Rename | Drop
ui_preferences JSON ✓ Rename | Drop
active_workflows JSON ✓ Rename | Drop
pinned_widgets JSON ✓ Rename | Drop

+ Add index

Indexes

Name Columns Unique SQL Drop?
sqlite_autoindex_workspaces_1 id ✓ SQL
-- no sql found --
 Drop