Query

ontos.db — qualities

SQL

CREATE TABLE qualities  (
  id VARCHAR(50) NOT NULL,
  project_id VARCHAR(50),
  ontology_id VARCHAR(50),
  overall_score FLOAT,
  quality_level VARCHAR(255),
  completeness FLOAT,
  clarity FLOAT,
  coherence FLOAT,
  consistency FLOAT,
  coverage FLOAT,
  dimension_scores JSON,
  metrics JSON,
  recommendations JSON,
  assessor_version VARCHAR(255),
  assessed_at JSON,
  tenant_id VARCHAR(50) NOT NULL,
  license_tier 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
ontology_id VARCHAR(50) ✓ Rename | Drop
overall_score FLOAT ✓ Rename | Drop
quality_level VARCHAR(255) ✓ Rename | Drop
completeness FLOAT ✓ Rename | Drop
clarity FLOAT ✓ Rename | Drop
coherence FLOAT ✓ Rename | Drop
consistency FLOAT ✓ Rename | Drop
coverage FLOAT ✓ Rename | Drop
dimension_scores JSON ✓ Rename | Drop
metrics JSON ✓ Rename | Drop
recommendations JSON ✓ Rename | Drop
assessor_version VARCHAR(255) ✓ Rename | Drop
assessed_at JSON ✓ Rename | Drop
tenant_id VARCHAR(50) Rename | Drop
license_tier JSON ✓ Rename | Drop

+ Add index

Indexes

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