Query

ontos.db — validations

SQL

CREATE TABLE validations  (
  id VARCHAR(50) NOT NULL,
  project_id VARCHAR(50),
  ontology_id VARCHAR(50),
  is_valid BOOLEAN,
  bfo_compliant BOOLEAN,
  cco_compliant BOOLEAN,
  consistency_score FLOAT,
  overall_score FLOAT,
  issues JSON,
  standard_scores JSON,
  detailed_results JSON,
  automated_fixes_applied JSON,
  validator_version VARCHAR(255),
  validated_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
is_valid BOOLEAN ✓ Rename | Drop
bfo_compliant BOOLEAN ✓ Rename | Drop
cco_compliant BOOLEAN ✓ Rename | Drop
consistency_score FLOAT ✓ Rename | Drop
overall_score FLOAT ✓ Rename | Drop
issues JSON ✓ Rename | Drop
standard_scores JSON ✓ Rename | Drop
detailed_results JSON ✓ Rename | Drop
automated_fixes_applied JSON ✓ Rename | Drop
validator_version VARCHAR(255) ✓ Rename | Drop
validated_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_validations_1 id ✓ SQL
-- no sql found --
 Drop