Query

ontos.db — ontology_classes

SQL

CREATE TABLE ontology_classes  (
  id VARCHAR(50) NOT NULL,
  iri VARCHAR(255),
  label VARCHAR(255),
  curie VARCHAR(255),
  description TEXT,
  annotations JSON,
  axioms JSON,
  ontology_id VARCHAR(50),
  entity_id VARCHAR(255),
  transformation_logs JSON,
  properties JSON,
  PRIMARY KEY (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id VARCHAR(50) ✓ Rename | Drop
iri VARCHAR(255) ✓ Rename | Drop
label VARCHAR(255) ✓ Rename | Drop
curie VARCHAR(255) ✓ Rename | Drop
description TEXT ✓ Rename | Drop
annotations JSON ✓ Rename | Drop
axioms JSON ✓ Rename | Drop
ontology_id VARCHAR(50) ✓ Rename | Drop
entity_id VARCHAR(255) ✓ Rename | Drop
transformation_logs JSON ✓ Rename | Drop
properties JSON ✓ Rename | Drop

+ Add index

Indexes

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