Query
CREATE TABLE projects (
id VARCHAR(50) NOT NULL,
name VARCHAR(255) NOT NULL,
description TEXT,
ontologies JSON,
workspaces JSON,
created_at JSON NOT NULL,
updated_at JSON NOT NULL,
tenant_id VARCHAR(50) NOT NULL,
license_tier JSON,
category JSON,
tags JSON,
owner VARCHAR(255),
collaborators JSON,
active_pipelines JSON,
settings JSON,
deleted BOOLEAN,
PRIMARY KEY (id)
)