Query

ontos.db — taxonomies

SQL

CREATE TABLE taxonomies  (
  id VARCHAR(50) NOT NULL,
  project_id VARCHAR(50),
  name VARCHAR(255) NOT NULL,
  status JSON NOT NULL,
  workflow_id VARCHAR(50),
  tenant_id VARCHAR(50) NOT NULL,
  license_tier JSON,
  concepts JSON,
  relationships JSON,
  root_concepts JSON,
  metadata JSON,
  generation_metrics JSON,
  exported_formats JSON,
  created_at JSON NOT NULL,
  updated_at JSON NOT NULL,
  deleted BOOLEAN,
  PRIMARY KEY (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id VARCHAR(50) ✓ Rename | Drop
project_id VARCHAR(50) ✓ Rename | Drop
name VARCHAR(255) Rename | Drop
status JSON Rename | Drop
workflow_id VARCHAR(50) ✓ Rename | Drop
tenant_id VARCHAR(50) Rename | Drop
license_tier JSON ✓ Rename | Drop
concepts JSON ✓ Rename | Drop
relationships JSON ✓ Rename | Drop
root_concepts JSON ✓ Rename | Drop
metadata JSON ✓ Rename | Drop
generation_metrics JSON ✓ Rename | Drop
exported_formats JSON ✓ Rename | Drop
created_at JSON Rename | Drop
updated_at JSON Rename | Drop
deleted BOOLEAN ✓ Rename | Drop

+ Add index

Indexes

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