Query

ontos.db — artifacts

SQL

CREATE TABLE artifacts  (
  id VARCHAR(50) NOT NULL,
  project_id VARCHAR(50),
  name VARCHAR(255) NOT NULL,
  type JSON,
  status JSON NOT NULL,
  content BLOB,
  content_type VARCHAR(255),
  size_bytes BIGINT,
  format VARCHAR(255),
  encoding VARCHAR(255),
  generation_method JSON,
  source_document_ids JSON,
  source_artifact_ids JSON,
  confidence_score FLOAT,
  workflow_id VARCHAR(50),
  validation_status VARCHAR(255),
  validation_issues JSON,
  quality_metrics JSON,
  storage_path VARCHAR(255),
  url VARCHAR(255),
  access_metadata JSON,
  transformation_logs JSON,
  source_references JSON,
  tenant_id VARCHAR(50) NOT NULL,
  license_tier JSON,
  created_at JSON NOT NULL,
  updated_at JSON NOT NULL,
  expires_at JSON,
  deleted BOOLEAN,
  properties JSON,
  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
type JSON ✓ Rename | Drop
status JSON Rename | Drop
content BLOB ✓ Rename | Drop
content_type VARCHAR(255) ✓ Rename | Drop
size_bytes BIGINT ✓ Rename | Drop
format VARCHAR(255) ✓ Rename | Drop
encoding VARCHAR(255) ✓ Rename | Drop
generation_method JSON ✓ Rename | Drop
source_document_ids JSON ✓ Rename | Drop
source_artifact_ids JSON ✓ Rename | Drop
confidence_score FLOAT ✓ Rename | Drop
workflow_id VARCHAR(50) ✓ Rename | Drop
validation_status VARCHAR(255) ✓ Rename | Drop
validation_issues JSON ✓ Rename | Drop
quality_metrics JSON ✓ Rename | Drop
storage_path VARCHAR(255) ✓ Rename | Drop
url VARCHAR(255) ✓ Rename | Drop
access_metadata JSON ✓ Rename | Drop
transformation_logs JSON ✓ Rename | Drop
source_references JSON ✓ Rename | Drop
tenant_id VARCHAR(50) Rename | Drop
license_tier JSON ✓ Rename | Drop
created_at JSON Rename | Drop
updated_at JSON Rename | Drop
expires_at JSON ✓ Rename | Drop
deleted BOOLEAN ✓ Rename | Drop
properties JSON ✓ Rename | Drop

+ Add index

Indexes

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