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