Query

ontos.db — triples

SQL

CREATE TABLE triples  (
  id VARCHAR(50) NOT NULL,
  project_id VARCHAR(50),
  subject VARCHAR(255),
  predicate VARCHAR(255),
  object VARCHAR(255),
  subject_type VARCHAR(255),
  object_type VARCHAR(255),
  triple_type VARCHAR(255),
  confidence FLOAT,
  namespace VARCHAR(255),
  source_references JSON,
  properties JSON,
  source_entity_ids JSON,
  source_relationship_ids JSON,
  source_mapping_ids JSON,
  transformation_logs JSON,
  generation_method VARCHAR(255),
  created_at JSON NOT NULL,
  tenant_id VARCHAR(50) NOT NULL,
  license_tier JSON,
  ontology_ids JSON,
  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
subject VARCHAR(255) ✓ Rename | Drop
predicate VARCHAR(255) ✓ Rename | Drop
object VARCHAR(255) ✓ Rename | Drop
subject_type VARCHAR(255) ✓ Rename | Drop
object_type VARCHAR(255) ✓ Rename | Drop
triple_type VARCHAR(255) ✓ Rename | Drop
confidence FLOAT ✓ Rename | Drop
namespace VARCHAR(255) ✓ Rename | Drop
source_references JSON ✓ Rename | Drop
properties JSON ✓ Rename | Drop
source_entity_ids JSON ✓ Rename | Drop
source_relationship_ids JSON ✓ Rename | Drop
source_mapping_ids JSON ✓ Rename | Drop
transformation_logs JSON ✓ Rename | Drop
generation_method VARCHAR(255) ✓ Rename | Drop
created_at JSON Rename | Drop
tenant_id VARCHAR(50) Rename | Drop
license_tier JSON ✓ Rename | Drop
ontology_ids JSON ✓ Rename | Drop
deleted BOOLEAN ✓ Rename | Drop

+ Add index

Indexes

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