Feat: Add comprehensive record history tracking for PATCH operations
Implements automatic versioning and audit trail for all record modifications:
• RecordHistory model with complete snapshots and field-level changes • RecordFieldHistory for granular change tracking • RecordVersion for lightweight version management • Smart change detection - only tracks actual field modifications • Enhanced PATCH endpoint with before/after state capture • History API endpoints for viewing changes and version comparison • Complete test coverage for history functionality • Performance optimized with JSONB storage and composite indexes
Permissions updated to allow any authenticated user to edit any record while maintaining complete audit trails with user attribution.