Query

ontos.db — mappings

SQL

CREATE TABLE mappings  (
  id VARCHAR(50) NOT NULL,
  source_id VARCHAR(255),
  source_kind JSON,
  source_iri VARCHAR(255),
  source_label VARCHAR(255),
  target_id VARCHAR(255),
  target_kind JSON,
  target_iri VARCHAR(255),
  target_label VARCHAR(255),
  predicate JSON,
  confidence FLOAT,
  bidirectional BOOLEAN,
  method VARCHAR(255),
  reasoning VARCHAR(255),
  evidence JSON,
  transformation_logs JSON,
  tenant_id VARCHAR(50) NOT NULL,
  license_tier JSON,
  created_at JSON NOT NULL,
  created_by VARCHAR(255),
  validated_by VARCHAR(255),
  validated_at JSON,
  is_validated BOOLEAN,
  is_active BOOLEAN,
  rejection_reason VARCHAR(255),
  annotations JSON,
  properties JSON,
  PRIMARY KEY (id)
)

+ Add column

Columns

Column Data type Allow null Primary key Actions
id VARCHAR(50) ✓ Rename | Drop
source_id VARCHAR(255) ✓ Rename | Drop
source_kind JSON ✓ Rename | Drop
source_iri VARCHAR(255) ✓ Rename | Drop
source_label VARCHAR(255) ✓ Rename | Drop
target_id VARCHAR(255) ✓ Rename | Drop
target_kind JSON ✓ Rename | Drop
target_iri VARCHAR(255) ✓ Rename | Drop
target_label VARCHAR(255) ✓ Rename | Drop
predicate JSON ✓ Rename | Drop
confidence FLOAT ✓ Rename | Drop
bidirectional BOOLEAN ✓ Rename | Drop
method VARCHAR(255) ✓ Rename | Drop
reasoning VARCHAR(255) ✓ Rename | Drop
evidence JSON ✓ Rename | Drop
transformation_logs JSON ✓ Rename | Drop
tenant_id VARCHAR(50) Rename | Drop
license_tier JSON ✓ Rename | Drop
created_at JSON Rename | Drop
created_by VARCHAR(255) ✓ Rename | Drop
validated_by VARCHAR(255) ✓ Rename | Drop
validated_at JSON ✓ Rename | Drop
is_validated BOOLEAN ✓ Rename | Drop
is_active BOOLEAN ✓ Rename | Drop
rejection_reason VARCHAR(255) ✓ Rename | Drop
annotations JSON ✓ Rename | Drop
properties JSON ✓ Rename | Drop

+ Add index

Indexes

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