# RATERIGHT EVIDENCE ARCHIVE - MASTER INDEX
**Last Updated:** 2025-09-07 11:28:00 AEST  
**Total Files:** 192 files in Evidence Archive (412 total including legacy documentation)  
**Empty Directories:** 161 (scaffolding for future features)  
**Total Size:** ~2.5MB documentation  

---

## 🎯 QUICK ACCESS

### **Essential Starting Points**
- **README_Developer_Onboarding.md** - **NEW** - Prioritized onboarding guide for developers
- **HOW_TO_USE.md** - Evidence Archive usage guide
- **SYSTEM_MAP.md** - Complete system architecture overview (verified by testing)
- **DEPENDENCIES_MAP.md** - System dependencies mapping
- **ACTUAL_CURRENT_STATE.md** - Current platform state documentation

### **Critical Investigations**
- **CRITICAL_INVESTIGATIONS/** - High-priority system issues and resolutions
- **Cross_Feature_Issues/CROSS_FEATURE_INDEX.md** - Cross-system integration issues

---

## 📁 ROOT LEVEL FILES

| File Name | Path | Description |
|-----------|------|-------------|
| ACTUAL_CURRENT_STATE.md | `/3.7 Evidence Archive/ACTUAL_CURRENT_STATE.md` | Current platform state and feature status |
| DEPENDENCIES_MAP.md | `/3.7 Evidence Archive/DEPENDENCIES_MAP.md` | Complete system dependencies mapping |
| DETECTED_FEATURES.txt | `/3.7 Evidence Archive/DETECTED_FEATURES.txt` | Automated features detection report |
| HOW_TO_USE.md | `/3.7 Evidence Archive/HOW_TO_USE.md` | Evidence Archive navigation guide |
| MASTER_INDEX.md | `/3.7 Evidence Archive/MASTER_INDEX.md` | This comprehensive index file |
| README_Developer_Onboarding.md | `/3.7 Evidence Archive/README_Developer_Onboarding.md` | **NEW** - Prioritized developer onboarding guide with verified file recommendations |
| SYSTEM_MAP.md | `/3.7 Evidence Archive/SYSTEM_MAP.md` | System architecture and relationships overview |

---

## 🔥 CRITICAL_INVESTIGATIONS/

Critical system issues requiring immediate attention or recently resolved major problems.

### **INDEX.md**
- **Path:** `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/INDEX.md`
- **Description:** Master index of all critical investigations

### **Authentication_Flow/**
| File Name | Path | Description |
|-----------|------|-------------|
| AUTHENTICATION_404_FIX_COMPLETE_REPORT.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Authentication_Flow/` | 404 error resolution for auth routes |
| AUTHENTICATION_ARCHITECTURE_EXPLANATION.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Authentication_Flow/` | Complete authentication system architecture |
| AUTHENTICATION_FIX_COMPLETE.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Authentication_Flow/` | Authentication system repair completion report |
| WORKER_LOGIN_FIX_VERIFICATION_REPORT.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Authentication_Flow/` | Worker login functionality verification |
| WORKER_LOGIN_REPORT.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Authentication_Flow/` | Worker login issue investigation |

### **Database_Analysis/**
| File Name | Path | Description |
|-----------|------|-------------|
| COMPREHENSIVE_FORENSIC_INVESTIGATION_PHASES_3_TO_7.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Database_Analysis/` | Multi-phase database forensic analysis |
| DATABASE_CONNECTION_FAILURE_ANALYSIS.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Database_Analysis/` | Database connectivity issue root cause analysis |
| DATABASE_SCHEMA_GAP_ANALYSIS_REPORT.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Database_Analysis/` | Database schema discrepancy analysis |
| DATABASE_VERIFICATION_COMPLETE_REPORT.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Database_Analysis/` | Complete database verification results |
| FORENSIC_DATABASE_AUDIT_COMPLETE.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Database_Analysis/` | Comprehensive database forensic audit |

### **Nuclear_Migration/**
| File Name | Path | Description |
|-----------|------|-------------|
| CORRECTED_NUCLEAR_DATABASE_FIX.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Nuclear_Migration/` | Nuclear database deployment corrections |
| DATABASE_MIGRATION_DEPLOYMENT_ANALYSIS.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Nuclear_Migration/` | Migration deployment strategy analysis |
| MIGRATION_HEADS_INVESTIGATION_COMPLETE_REPORT.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Nuclear_Migration/` | Migration heads conflict resolution |
| MIGRATION_SAFETY_SYSTEM_GUIDE.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Nuclear_Migration/` | Migration safety protocols and procedures |
| MIGRATION_STATUS_EXPLANATION.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Nuclear_Migration/` | Migration status tracking explanation |
| MIGRATION_SYSTEM_COMPLETE_GUIDE.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Nuclear_Migration/` | Complete migration system documentation |
| NUCLEAR_DATABASE_RESET.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Nuclear_Migration/` | Nuclear database reset procedures |
| NUCLEAR_DEPLOYMENT_EXECUTION_GUIDE.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Nuclear_Migration/` | Step-by-step nuclear deployment instructions |
| NUCLEAR_RECOVERY_SUCCESS_20250822_175418.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Nuclear_Migration/` | Nuclear deployment success report |
| PHASE4_DEPLOYMENT_EXECUTION_GUIDE.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Nuclear_Migration/` | Phase 4 deployment execution guide |

### **Payment_Systems/**
| File Name | Path | Description |
|-----------|------|-------------|
| COMPLETE_PAYMENT_SYSTEM_ARCHITECTURE_REPORT.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Payment_Systems/` | Complete payment system architecture |
| LEGAL_DOCS_ROUTES_INVESTIGATION.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Payment_Systems/` | Legal documents routing investigation |
| LEGAL_DOCUMENTS_INTEGRATION_INVESTIGATION_REPORT.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Payment_Systems/` | Legal documents integration analysis |
| PLATFORM_FEE_STRUCTURE_ANALYSIS_REPORT.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Payment_Systems/` | Platform fee structure analysis |
| STRIPE_DEPLOYMENT_GUIDE.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Payment_Systems/` | Stripe integration deployment guide |

### **Performance_Issues/**
| File Name | Path | Description |
|-----------|------|-------------|
| APPLICATION_OPTIMIZATION_GUIDE.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Performance_Issues/` | Application performance optimization |
| COMPREHENSIVE_OPTIMIZATION_REPORT.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Performance_Issues/` | Complete system optimization report |
| DATABASE_COST_OPTIMIZATION_SUCCESS_REPORT.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Performance_Issues/` | Database cost optimization results |
| DATABASE_OPTIMIZATION_GUIDE.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Performance_Issues/` | Database performance optimization |
| EMERGENCY_FIX_REPORT.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Performance_Issues/` | Emergency performance fixes |

### **Trade_Categories_Current/**
| File Name | Path | Description |
|-----------|------|-------------|
| INVESTIGATION_SUMMARY.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Trade_Categories_Current/` | Trade categories investigation summary |
| LESSONS_LEARNED.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/Trade_Categories_Current/` | Lessons learned from trade categories issues |

### **UI_Architecture/**
| File Name | Path | Description |
|-----------|------|-------------|
| ACCURATE_UI_ISSUES_ASSESSMENT.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/UI_Architecture/` | Accurate UI issues assessment |
| COMPREHENSIVE_REGRESSION_ANALYSIS_REPORT.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/UI_Architecture/` | UI regression analysis report |
| ENTERPRISE_NAVIGATION_IMPLEMENTATION_COMPLETE.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/UI_Architecture/` | Enterprise navigation implementation |
| UI_FORENSIC_INVESTIGATION_COMPLETE_REPORT.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/UI_Architecture/` | Complete UI forensic investigation |
| UI_REBUILD_COMPREHENSIVE_FINAL_REPORT.md | `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/UI_Architecture/` | UI rebuild project final report |

---

## 🔗 Cross_Feature_Issues/

Cross-system integration issues and dependencies.

| File Name | Path | Description |
|-----------|------|-------------|
| CROSS_FEATURE_INDEX.md | `/3.7 Evidence Archive/Cross_Feature_Issues/CROSS_FEATURE_INDEX.md` | Index of cross-feature integration issues |

---

## 💾 DATABASE_ANALYSIS/

Database analysis tools and critical issues documentation.

| File Name | Path | Description |
|-----------|------|-------------|
| check_foreign_keys.py | `/3.7 Evidence Archive/DATABASE_ANALYSIS/check_foreign_keys.py` | Foreign key constraint verification script |
| check_local_tables.py | `/3.7 Evidence Archive/DATABASE_ANALYSIS/check_local_tables.py` | Local database table verification script |
| CRITICAL_ISSUES.md | `/3.7 Evidence Archive/DATABASE_ANALYSIS/CRITICAL_ISSUES.md` | Critical database issues documentation |

---

## 🎛️ Features/

Feature-specific evidence organized by individual platform features. Each feature follows a standardized structure.

### **Standard Feature Structure**
Each feature contains:
- **CURRENT_STATE.md** - Current implementation status
- **README.md** - Feature overview and documentation
- **ARCHIVED/** - Archived investigations
- **BUGS/** - Bug reports and fixes
- **ENHANCEMENTS/** - Enhancement requests and implementations
- **INVESTIGATIONS/** - Technical investigations
- **TESTING/** - Test reports and procedures

### **ABN_Validation/**
- **Path:** `/3.7 Evidence Archive/Features/ABN_Validation/`
- **Description:** Australian Business Number validation system
- **Sub-folders:** BUGS/, ENHANCEMENTS/, INVESTIGATIONS/, TESTING/

### **Admin_Panel/**
- **Path:** `/3.7 Evidence Archive/Features/Admin_Panel/`
- **Description:** Administrative panel functionality
- **Key Files:** CURRENT_STATE.md, README.md
- **Sub-folders:** ARCHIVED/, BUGS/, ENHANCEMENTS/, INVESTIGATIONS/, TESTING/

### **Analytics/**
- **Path:** `/3.7 Evidence Archive/Features/Analytics/`
- **Description:** Platform analytics and tracking
- **Key Files:** CURRENT_STATE.md, README.md
- **Sub-folders:** ARCHIVED/, BUGS/, ENHANCEMENTS/, INVESTIGATIONS/, TESTING/

### **Authentication/**
- **Path:** `/3.7 Evidence Archive/Features/Authentication/`
- **Description:** User authentication system
- **Key Files:** CURRENT_STATE.md, README.md
- **Sub-folders:** ARCHIVED/, BUGS/, ENHANCEMENTS/, INVESTIGATIONS/, TESTING/

### **Bookings/**
- **Path:** `/3.7 Evidence Archive/Features/Bookings/`
- **Description:** Job booking and scheduling system
- **Key Files:** CURRENT_STATE.md, README.md
- **Sub-folders:** ARCHIVED/, BUGS/, ENHANCEMENTS/, INVESTIGATIONS/, TESTING/

### **Calendar/**
- **Path:** `/3.7 Evidence Archive/Features/Calendar/`
- **Description:** Calendar integration functionality
- **Sub-folders:** BUGS/, ENHANCEMENTS/, INVESTIGATIONS/, TESTING/

### **Compliance/**
- **Path:** `/3.7 Evidence Archive/Features/Compliance/`
- **Description:** Legal and regulatory compliance features
- **Key Files:** CURRENT_STATE.md, README.md
- **Sub-folders:** ARCHIVED/, BUGS/, ENHANCEMENTS/, INVESTIGATIONS/, TESTING/

### **Contracts/**
- **Path:** `/3.7 Evidence Archive/Features/Contracts/`
- **Description:** Contract management system
- **Key Files:** CURRENT_STATE.md, README.md
- **Sub-folders:** ARCHIVED/, BUGS/, ENHANCEMENTS/, INVESTIGATIONS/, TESTING/

### **Dashboard/**
- **Path:** `/3.7 Evidence Archive/Features/Dashboard/`
- **Description:** User dashboard functionality
- **Key Files:** CURRENT_STATE.md, README.md
- **Sub-folders:** ARCHIVED/, BUGS/, ENHANCEMENTS/, INVESTIGATIONS/, TESTING/

### **Demo_Testing/**
- **Path:** `/3.7 Evidence Archive/Features/Demo_Testing/`
- **Description:** Demo environment testing procedures
- **Sub-folders:** BUGS/, ENHANCEMENTS/, INVESTIGATIONS/, TESTING/

### **Disputes/**
- **Path:** `/3.7 Evidence Archive/Features/Disputes/`
- **Description:** Dispute resolution system
- **Sub-folders:** BUGS/, ENHANCEMENTS/, INVESTIGATIONS/, TESTING/

### **Exports/**
- **Path:** `/3.7 Evidence Archive/Features/Exports/`
- **Description:** Data export functionality
- **Sub-folders:** BUGS/, ENHANCEMENTS/, INVESTIGATIONS/, TESTING/

### **Gamification/**
- **Path:** `/3.7 Evidence Archive/Features/Gamification/`
- **Description:** Gamification and rating systems
- **Key Files:** CURRENT_STATE.md, README.md
- **Sub-folders:** ARCHIVED/, BUGS/, ENHANCEMENTS/, INVESTIGATIONS/, TESTING/

### **Insurance/**
- **Path:** `/3.7 Evidence Archive/Features/Insurance/`
- **Description:** Insurance management features
- **Sub-folders:** BUGS/, ENHANCEMENTS/, INVESTIGATIONS/, TESTING/

### **Integrations/**
- **Path:** `/3.7 Evidence Archive/Features/Integrations/`
- **Description:** Third-party integrations
- **Sub-folders:** BUGS/, ENHANCEMENTS/, INVESTIGATIONS/, TESTING/

### **Job_Posting/**
- **Path:** `/3.7 Evidence Archive/Features/Job_Posting/`
- **Description:** Job posting and management system
- **Key Files:** CURRENT_STATE.md, README.md
- **Sub-folders:** ARCHIVED/, BUGS/, ENHANCEMENTS/, INVESTIGATIONS/, TESTING/

### **Legal_Compliance/**
- **Path:** `/3.7 Evidence Archive/Features/Legal_Compliance/`
- **Description:** Legal compliance and documentation
- **Sub-folders:** BUGS/, ENHANCEMENTS/, INVESTIGATIONS/, TESTING/

### **Messaging/**
- **Path:** `/3.7 Evidence Archive/Features/Messaging/`
- **Description:** Internal messaging system
- **Key Files:** CURRENT_STATE.md
- **Sub-folders:** ARCHIVED/, BUGS/

### **Navigation/**
- **Path:** `/3.7 Evidence Archive/Features/Navigation/`
- **Description:** Site navigation system

### **Notifications/**
- **Path:** `/3.7 Evidence Archive/Features/Notifications/`
- **Description:** Notification system
- **Key Files:** CURRENT_STATE.md

### **Payments/**
- **Path:** `/3.7 Evidence Archive/Features/Payments/`
- **Description:** Payment processing system

### **Payroll/**
- **Path:** `/3.7 Evidence Archive/Features/Payroll/`
- **Description:** Payroll management system

### **Ratings/**
- **Path:** `/3.7 Evidence Archive/Features/Ratings/`
- **Description:** Rating and review system

### **Search/**
- **Path:** `/3.7 Evidence Archive/Features/Search/`
- **Description:** Search functionality

### **Signature_Pad/**
- **Path:** `/3.7 Evidence Archive/Features/Signature_Pad/`
- **Description:** Digital signature functionality

### **Time_Tracking/**
- **Path:** `/3.7 Evidence Archive/Features/Time_Tracking/`
- **Description:** Time tracking and hours management

### **Trade_Categories/**
- **Path:** `/3.7 Evidence Archive/Features/Trade_Categories/`
- **Description:** Trade category management system
- **Key Files:** CURRENT_STATE.md (comprehensive database and API investigation completed)
- **Status:** Database verified with 96 categories, SQLAlchemy initialization issue identified

### **User_Profile/**
- **Path:** `/3.7 Evidence Archive/Features/User_Profile/`
- **Description:** User profile management
- **Key Files:** CURRENT_STATE.md

### **Webhooks/**
- **Path:** `/3.7 Evidence Archive/Features/Webhooks/`
- **Description:** Webhook management system

### **Worker_Management/**
- **Path:** `/3.7 Evidence Archive/Features/Worker_Management/`
- **Description:** Worker/contractor management system

---

## 📋 MDP_Protocol/

MDP (Master Development Protocol) documentation and feedback collection.

| File Name | Path | Description |
|-----------|------|-------------|
| FEEDBACK_COLLECTION.md | `/3.7 Evidence Archive/MDP_Protocol/FEEDBACK_COLLECTION.md` | Feedback collection procedures |
| MDP_v2.md | `/3.7 Evidence Archive/MDP_Protocol/MDP_v2.md` | Master Development Protocol version 2 |
| **FEEDBACK/** | `/3.7 Evidence Archive/MDP_Protocol/FEEDBACK/` | Feedback collection folder |

---

## 🏗️ System/

System-wide documentation, architecture, and infrastructure.

### **API_SPECS/**
- **Path:** `/3.7 Evidence Archive/System/API_SPECS/`
- **Description:** API specifications and documentation

### **ARCHITECTURE/**
- **Path:** `/3.7 Evidence Archive/System/ARCHITECTURE/`
- **Description:** System architecture documentation

### **AUDITS/**
- **Path:** `/3.7 Evidence Archive/System/AUDITS/`
- **Description:** System audits and compliance reports

### **DATABASE_MIGRATIONS/**
- **Path:** `/3.7 Evidence Archive/System/DATABASE_MIGRATIONS/`
- **Description:** Database migration scripts and documentation

### **DEPLOYMENTS/**
- **Path:** `/3.7 Evidence Archive/System/DEPLOYMENTS/`
- **Description:** Deployment procedures and scripts

### **ERROR_PATTERNS/**
- **Path:** `/3.7 Evidence Archive/System/ERROR_PATTERNS/`
- **Description:** Common error patterns and solutions

### **PERFORMANCE/**
- **Path:** `/3.7 Evidence Archive/System/PERFORMANCE/`
- **Description:** Performance monitoring and optimization

### **SECURITY/**
- **Path:** `/3.7 Evidence Archive/System/SECURITY/`
- **Description:** Security audits and procedures

### **SPRINTS/**
- **Path:** `/3.7 Evidence Archive/System/SPRINTS/`
- **Description:** Sprint planning and execution documentation

---

## 📊 AUDIT_LOGS/

Audit logging and historical records.

| File Name | Path | Description |
|-----------|------|-------------|
| AUDIT_2025-01-06_CONSERVATIVE.md | `/3.7 Evidence Archive/AUDIT_LOGS/AUDIT_2025-01-06_CONSERVATIVE.md` | Conservative audit log from January 6, 2025 |

---

## 📦 ARCHIVED_INVESTIGATIONS/

Templates and archived investigation procedures.

| File Name | Path | Description |
|-----------|------|-------------|
| INVESTIGATION_INDEX_TEMPLATE.md | `/3.7 Evidence Archive/ARCHIVED_INVESTIGATIONS/INVESTIGATION_INDEX_TEMPLATE.md` | Template for investigation documentation |

---

## 🎯 USAGE GUIDELINES

### **For New Developers/Claude Instances:**
1. **START HERE:** Read `README_Developer_Onboarding.md` - **ESSENTIAL FIRST READ**
2. **System overview:** Review `SYSTEM_MAP.md` (verified by endpoint testing)
3. **Navigation:** Read `HOW_TO_USE.md` for Evidence Archive guidance
4. **Current state:** Check `ACTUAL_CURRENT_STATE.md`
5. **Feature-specific work:** Navigate to `/3.7 Evidence Archive/Features/[Feature_Name]/CURRENT_STATE.md`

### **For Bug Investigations:**
1. **Check existing:** Look in `/3.7 Evidence Archive/Features/[Feature_Name]/BUGS/`
2. **Check critical:** Review `/3.7 Evidence Archive/CRITICAL_INVESTIGATIONS/`
3. **Cross-system issues:** Check `/3.7 Evidence Archive/Cross_Feature_Issues/`

### **For New Features:**
1. **Create structure:** Use standard feature folder structure
2. **Document state:** Create `CURRENT_STATE.md` and `README.md`
3. **Track progress:** Use `/3.7 Evidence Archive/Features/[Feature_Name]/ENHANCEMENTS/`

### **Naming Conventions:**
- **Files:** `[TYPE]_[description]_[YYYY-MM-DD].md`
- **Folders:** `[Feature_Name]/[CATEGORY]/`
- **Reports:** `[SYSTEM]_[ACTION]_[STATUS]_REPORT.md`

---

## 📈 STATISTICS

- **Total Features Tracked:** 25+
- **Critical Investigations:** 30+
- **Documentation Files:** 192 (Evidence Archive) + 220 (legacy files)
- **Empty Directories:** 161 (structure built for future use)
- **Database Analysis Tools:** 3
- **System Documentation Folders:** 9
- **Last Major Update:** 2025-09-07

**Note:** System folder shows 9 subfolders in index but contains 0 actual files

---

## 🔄 MAINTENANCE

**Quarterly Reviews:** Archive dead files, update current states
**Monthly Updates:** Refresh critical investigations status
**Weekly:** Update feature current states as needed

**Archive Criteria:** Files unused for 6+ months, superseded documentation
**Migration Rules:** Don't move old files, just link them; new items go in appropriate folders

---

*This index provides complete visibility into the Evidence Archive. Use the path information to navigate directly to relevant documentation. All investigations, current states, and system documentation is catalogued above.*

**END OF MASTER INDEX**