[HIGH] Missing foreign key constraints and indexes

[natcrypto]

Code Quality Finding

Severity: high
Category: Database Schema Design
Perspective: architect
File: shared/schema.ts

Description

Schema defines relationships through userId fields but lacks explicit foreign key constraints and indexes. This will cause performance issues and data integrity problems at scale.

Suggested Fix

Add foreign key references, indexes on userId columns, and consider composite indexes for common query patterns.

---

This issue was automatically created by Code Quality Agent