94b421f73a
- Move completed migration docs to docs/archive/ - Move session summaries to docs/archive/sessions/ - Rename API_ASP_DOCUMENTATION.md to docs/API.md - Archive redundant Claude reference files - Update docs/README.md as simplified index - Reduce active docs from 45+ files to 8 essential files Remaining docs: - CLAUDE.md (AI context) - TODO.md (task tracking) - docs/README.md, API.md, QUICK_REFERENCE.md - docs/ASP_DEVELOPMENT_GUIDE.md, STANDARDS.md 🤖 Generated with [Claude Code](https://claude.com/claude-code) Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
1.8 KiB
1.8 KiB
ShopDB Documentation
Last Updated: 2025-12-11 Current Status: Database Migration Complete
Quick Links
| Document | Purpose |
|---|---|
| CLAUDE.md | AI assistant context (start here) |
| QUICK_REFERENCE.md | Cheat sheets, common queries |
| ASP_DEVELOPMENT_GUIDE.md | Dev setup, VBScript patterns |
| STANDARDS.md | Coding standards, security |
| API.md | REST API documentation |
Current Architecture
machines table (unified)
├── Equipment (machinetypeid 1-15, pctypeid IS NULL)
├── PCs (machinetypeid 33-35, pctypeid IS NOT NULL)
└── Network Devices (machinetypeid 16-20)
printers table (separate)
communications table (all network interfaces)
machinerelationships table (PC↔equipment links)
Dev Environment
# Start dev environment
~/start-dev-env.sh
# Check status
~/status-dev-env.sh
# Access application
http://192.168.122.151:8080
# Connect to MySQL
docker exec -it dev-mysql mysql -u root -prootpassword shopdb
Database Views
All views are defined in sql/view_consolidation.sql:
| View | Purpose |
|---|---|
vw_equipment_list |
Equipment with details |
vw_pc_list |
PCs with OS/model info |
vw_printer_list |
Active printers |
vw_network_devices |
Network devices (APs, switches, etc.) |
vw_machine_detail |
Full machine info for detail pages |
vw_active_notifications |
Current notifications |
vw_warranty_status |
Warranty tracking |
Archive
Historical documentation from completed migrations is in archive/:
- Phase 1-4 migration plans and summaries
- Bug fix records
- Session summaries
Maintained By: Development Team