Query

ontos.db — ontologies

SQL

CREATE TABLE ontologies  (
  id VARCHAR(50) NOT NULL,
  name VARCHAR(255) NOT NULL,
  uri VARCHAR(255),
  description TEXT,
  ontology_id VARCHAR(50),
  created_at JSON NOT NULL,
  updated_at JSON NOT NULL,
  properties JSON,
  tenant_id VARCHAR(50) NOT NULL,
  license_tier JSON,
  parent_ontology VARCHAR(255),
  child_ontologies JSON,
  category JSON,
  version VARCHAR(255),
  namespace VARCHAR(255),
  status JSON NOT NULL,
  project_id VARCHAR(50),
  object_properties JSON,
  individuals JSON,
  axioms JSON,
  generation_source JSON,
  quality_score FLOAT,
  validation_status VARCHAR(255),
  content BLOB,
  format VARCHAR(255),
  size BIGINT,
  foundational_type JSON,
  authority VARCHAR(255),
  is_preloaded BOOLEAN,
  documentation_url VARCHAR(255),
  supported_formats JSON,
  compatibility_matrix JSON,
  metadata JSON,
  domain VARCHAR(255),
  deleted BOOLEAN,
  PRIMARY KEY (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id VARCHAR(50) ✓ Rename | Drop
name VARCHAR(255) Rename | Drop
uri VARCHAR(255) ✓ Rename | Drop
description TEXT ✓ Rename | Drop
ontology_id VARCHAR(50) ✓ Rename | Drop
created_at JSON Rename | Drop
updated_at JSON Rename | Drop
properties JSON ✓ Rename | Drop
tenant_id VARCHAR(50) Rename | Drop
license_tier JSON ✓ Rename | Drop
parent_ontology VARCHAR(255) ✓ Rename | Drop
child_ontologies JSON ✓ Rename | Drop
category JSON ✓ Rename | Drop
version VARCHAR(255) ✓ Rename | Drop
namespace VARCHAR(255) ✓ Rename | Drop
status JSON Rename | Drop
project_id VARCHAR(50) ✓ Rename | Drop
object_properties JSON ✓ Rename | Drop
individuals JSON ✓ Rename | Drop
axioms JSON ✓ Rename | Drop
generation_source JSON ✓ Rename | Drop
quality_score FLOAT ✓ Rename | Drop
validation_status VARCHAR(255) ✓ Rename | Drop
content BLOB ✓ Rename | Drop
format VARCHAR(255) ✓ Rename | Drop
size BIGINT ✓ Rename | Drop
foundational_type JSON ✓ Rename | Drop
authority VARCHAR(255) ✓ Rename | Drop
is_preloaded BOOLEAN ✓ Rename | Drop
documentation_url VARCHAR(255) ✓ Rename | Drop
supported_formats JSON ✓ Rename | Drop
compatibility_matrix JSON ✓ Rename | Drop
metadata JSON ✓ Rename | Drop
domain VARCHAR(255) ✓ Rename | Drop
deleted BOOLEAN ✓ Rename | Drop

+ Add index

Indexes

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