ontos.db — relationships

• 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 relationships  (
  id VARCHAR(50) NOT NULL,
  project_id VARCHAR(50),
  source_entity_id VARCHAR(255),
  target_entity_id VARCHAR(255),
  relationship_type VARCHAR(255),
  predicate VARCHAR(255),
  confidence FLOAT,
  evidence JSON,
  source_references JSON,
  domain VARCHAR(255),
  properties JSON,
  directional BOOLEAN,
  transformation_logs JSON,
  created_at JSON NOT NULL,
  tenant_id VARCHAR(50) NOT NULL,
  license_tier JSON,
  deleted BOOLEAN,
  PRIMARY KEY (id)
)