Query

ontos.db — entities

SQL

CREATE TABLE entities  (
  id VARCHAR(50) NOT NULL,
  project_id VARCHAR(50),
  name VARCHAR(255) NOT NULL,
  domain VARCHAR(255),
  source_references JSON,
  properties JSON,
  frequency INTEGER,
  created_at JSON NOT NULL,
  last_seen_at JSON,
  transformation_logs JSON,
  tenant_id VARCHAR(50) NOT NULL,
  taxonomy_ids JSON,
  foundational_ontology_type JSON,
  bfo_class VARCHAR(255),
  bfo_uri VARCHAR(255),
  cco_class VARCHAR(255),
  cco_uri VARCHAR(255),
  foundational_confidence FLOAT,
  foundational_reasoning VARCHAR(255),
  semantic_category JSON,
  definition VARCHAR(255),
  deleted BOOLEAN,
  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
domain VARCHAR(255) ✓ Rename | Drop
source_references JSON ✓ Rename | Drop
properties JSON ✓ Rename | Drop
frequency INTEGER ✓ Rename | Drop
created_at JSON Rename | Drop
last_seen_at JSON ✓ Rename | Drop
transformation_logs JSON ✓ Rename | Drop
tenant_id VARCHAR(50) Rename | Drop
taxonomy_ids JSON ✓ Rename | Drop
foundational_ontology_type JSON ✓ Rename | Drop
bfo_class VARCHAR(255) ✓ Rename | Drop
bfo_uri VARCHAR(255) ✓ Rename | Drop
cco_class VARCHAR(255) ✓ Rename | Drop
cco_uri VARCHAR(255) ✓ Rename | Drop
foundational_confidence FLOAT ✓ Rename | Drop
foundational_reasoning VARCHAR(255) ✓ Rename | Drop
semantic_category JSON ✓ Rename | Drop
definition VARCHAR(255) ✓ Rename | Drop
deleted BOOLEAN ✓ Rename | Drop

+ Add index

Indexes

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