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