Query

ontos.db — documents

SQL

CREATE TABLE documents  (
  id VARCHAR(50) NOT NULL,
  project_id VARCHAR(50),
  filename VARCHAR(255),
  content_type VARCHAR(255),
  size BIGINT,
  file_path VARCHAR(255),
  content TEXT,
  extracted_summary VARCHAR(255),
  page_count INTEGER,
  pages JSON,
  status JSON NOT NULL,
  uploaded_at JSON,
  processed_at JSON,
  tenant_id VARCHAR(50) NOT NULL,
  license_tier JSON,
  metadata JSON,
  entities JSON,
  checksum VARCHAR(255),
  source_id VARCHAR(255),
  artifact_id VARCHAR(255),
  dataset_id VARCHAR(255),
  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
filename VARCHAR(255) ✓ Rename | Drop
content_type VARCHAR(255) ✓ Rename | Drop
size BIGINT ✓ Rename | Drop
file_path VARCHAR(255) ✓ Rename | Drop
content TEXT ✓ Rename | Drop
extracted_summary VARCHAR(255) ✓ Rename | Drop
page_count INTEGER ✓ Rename | Drop
pages JSON ✓ Rename | Drop
status JSON Rename | Drop
uploaded_at JSON ✓ Rename | Drop
processed_at JSON ✓ Rename | Drop
tenant_id VARCHAR(50) Rename | Drop
license_tier JSON ✓ Rename | Drop
metadata JSON ✓ Rename | Drop
entities JSON ✓ Rename | Drop
checksum VARCHAR(255) ✓ Rename | Drop
source_id VARCHAR(255) ✓ Rename | Drop
artifact_id VARCHAR(255) ✓ Rename | Drop
dataset_id VARCHAR(255) ✓ Rename | Drop

+ Add index

Indexes

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