# ShopDB

Manufacturing shop floor infrastructure management system for GE Aerospace. Tracks machines, PCs, printers, and network devices.

## Tech Stack

- **Backend:** Classic ASP (VBScript)
- **Database:** MySQL 5.6
- **Frontend:** Bootstrap 4.6, jQuery, DataTables
- **Server:** IIS on Windows

## Features

- Equipment inventory (CNC machines, lathes, mills, etc.)
- PC asset tracking with warranty monitoring
- Printer management with Zabbix integration
- Network device tracking (switches, access points, cameras)
- Knowledge base for troubleshooting
- Interactive floor maps
- REST API for PowerShell data collection

## Quick Start

```bash
# Start dev environment
~/start-dev-env.sh

# Access application
http://192.168.122.151:8080

# Run tests
./tests/test_forms.sh

# Connect to MySQL
docker exec -it dev-mysql mysql -u root -prootpassword shopdb
```

## Documentation

| Document | Purpose |
|----------|---------|
| [CLAUDE.md](CLAUDE.md) | AI assistant context |
| [docs/QUICK_REFERENCE.md](docs/QUICK_REFERENCE.md) | Cheat sheets, common queries |
| [docs/API.md](docs/API.md) | REST API documentation |
| [docs/STANDARDS.md](docs/STANDARDS.md) | Coding standards |

## Database Schema

```
machines table (unified)
  ├── Equipment (machinetypeid 1-15)
  ├── PCs (pctypeid IS NOT NULL)
  └── Network Devices (machinetypeid 16-20)

printers table (separate)
communications table (network interfaces)
machinerelationships table (PC↔equipment links)
```

## Testing

```bash
./tests/test_forms.sh    # 41 endpoint tests
```

Tests page loads, form submissions, and API endpoints.

## License

Internal use - GE Aerospace