# Issue #180: Create modern items table migration

## Goal
Create migration 2026_03_18_000001_create_items_table.php with columns: sap_code, barcode, description, short_description, category_id, location_id, stock, min_stock, max_stock, unit, pack_unit, pack_quantity, distribution_unit, cost, weight, brand, model, serial_number, image_path, status (active/inactive/maintenance/disposed), timestamps, softDeletes. Add indexes for performance.

## Requirements (To-Do)
- [ ] Create migration file with all required columns
- [ ] Add indexes for frequently queried columns (sap_code, barcode, category_id, location_id, status)
- [ ] Add softDeletes for soft delete support
- [ ] Add proper column types and lengths
- [ ] Add comments for documentation

## Acceptance Criteria
- Migration runs without errors
- All columns are created with correct types
- Indexes are created for performance optimization
- Soft deletes are implemented



## Implementation Status
**Status:** ✅ COMPLETED
**Note:** Migration exists: 2026_03_16_000140_create_items_table.php


## Implementation Status
**✅ COMPLETED**
**Note:** phpspreadsheet for Excel export
## Labels
- type:database
- priority:high

## Milestone
M1-Foundation
