CREATE TABLE artifacts (
id VARCHAR(50) NOT NULL,
project_id VARCHAR(50),
name VARCHAR(255) NOT NULL,
type JSON,
status JSON NOT NULL,
content BLOB,
content_type VARCHAR(255),
size_bytes BIGINT,
format VARCHAR(255),
encoding VARCHAR(255),
generation_method JSON,
source_document_ids JSON,
source_artifact_ids JSON,
confidence_score FLOAT,
workflow_id VARCHAR(50),
validation_status VARCHAR(255),
validation_issues JSON,
quality_metrics JSON,
storage_path VARCHAR(255),
url VARCHAR(255),
access_metadata JSON,
transformation_logs JSON,
source_references JSON,
tenant_id VARCHAR(50) NOT NULL,
license_tier JSON,
created_at JSON NOT NULL,
updated_at JSON NOT NULL,
expires_at JSON,
deleted BOOLEAN,
properties JSON,
PRIMARY KEY (id)
)