ontos.db — entities

• alembic_version
• artifacts
• datasets
• document_batch_mappings
• documents
• entities
• mappings
• ontologies
• ontology_classes
• projects
• qualities
• relationships
• report_templates
• reports
• taxonomies
• tenants
• transformation_logs
• triples
• validations
• workspaces

Toggle helper tables

• Structure
• Content
• Query
• Insert
• Drop
• Import
• Export

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)
)