# Issue #183: Create locations table migration

## Goal
Create migration for locations table with: name, code (unique), location_type (warehouse/area/site/boat/vehicle/container), parent_id (self-reference), address, is_active. Add timestamps.

## Requirements (To-Do)
- [ ] Create migration file with all required columns
- [ ] Add unique index on code column
- [ ] Add self-referencing foreign key for parent_id
- [ ] Add enum/constraint for location_type values

## Acceptance Criteria
- Migration runs without errors
- Hierarchical location structure is supported
- location_type accepts all defined values



## Implementation Status
**Status:** ✅ COMPLETED
**Note:** Using `sitios_embarcaciones` + `cargos` tables


## Implementation Status
**✅ COMPLETED**
**Note:** Implemented
## Labels
- type:database
- priority:high

## Milestone
M1-Foundation
