Query

ontos.db — transformation_logs

SQL

CREATE TABLE transformation_logs  (
  id VARCHAR(50) NOT NULL,
  stage JSON,
  method JSON,
  from_state VARCHAR(255),
  to_state VARCHAR(255),
  initial_confidence FLOAT,
  final_confidence FLOAT,
  confidence_degradation FLOAT,
  reasoning VARCHAR(255),
  rules_applied JSON,
  inputs_considered JSON,
  alternatives JSON,
  model_name VARCHAR(255),
  model_version VARCHAR(255),
  temperature FLOAT,
  max_tokens INTEGER,
  hyperparameters JSON,
  was_validated BOOLEAN,
  human_reviewed BOOLEAN,
  reviewer_id VARCHAR(255),
  quality_notes VARCHAR(255),
  source_entity_ids JSON,
  dependency_log_ids JSON,
  correlation_id VARCHAR(255),
  processing_time_ms BIGINT,
  memory_usage_bytes BIGINT,
  cost_estimate FLOAT,
  had_errors BOOLEAN,
  error_messages JSON,
  warning_messages JSON,
  started_at JSON,
  completed_at JSON,
  tenant_id VARCHAR(50) NOT NULL,
  metadata JSON,
  PRIMARY KEY (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id VARCHAR(50) ✓ Rename | Drop
stage JSON ✓ Rename | Drop
method JSON ✓ Rename | Drop
from_state VARCHAR(255) ✓ Rename | Drop
to_state VARCHAR(255) ✓ Rename | Drop
initial_confidence FLOAT ✓ Rename | Drop
final_confidence FLOAT ✓ Rename | Drop
confidence_degradation FLOAT ✓ Rename | Drop
reasoning VARCHAR(255) ✓ Rename | Drop
rules_applied JSON ✓ Rename | Drop
inputs_considered JSON ✓ Rename | Drop
alternatives JSON ✓ Rename | Drop
model_name VARCHAR(255) ✓ Rename | Drop
model_version VARCHAR(255) ✓ Rename | Drop
temperature FLOAT ✓ Rename | Drop
max_tokens INTEGER ✓ Rename | Drop
hyperparameters JSON ✓ Rename | Drop
was_validated BOOLEAN ✓ Rename | Drop
human_reviewed BOOLEAN ✓ Rename | Drop
reviewer_id VARCHAR(255) ✓ Rename | Drop
quality_notes VARCHAR(255) ✓ Rename | Drop
source_entity_ids JSON ✓ Rename | Drop
dependency_log_ids JSON ✓ Rename | Drop
correlation_id VARCHAR(255) ✓ Rename | Drop
processing_time_ms BIGINT ✓ Rename | Drop
memory_usage_bytes BIGINT ✓ Rename | Drop
cost_estimate FLOAT ✓ Rename | Drop
had_errors BOOLEAN ✓ Rename | Drop
error_messages JSON ✓ Rename | Drop
warning_messages JSON ✓ Rename | Drop
started_at JSON ✓ Rename | Drop
completed_at JSON ✓ Rename | Drop
tenant_id VARCHAR(50) Rename | Drop
metadata JSON ✓ Rename | Drop

+ Add index

Indexes

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