# Issue #185: Create transactions table migration

## Goal
Create migration for transactions table with: type (loan/provision/transfer), status (pending/approved/rejected/dispatched/completed/cancelled), operation_number (unique), requester_id, authorizer_id, dispatcher_id, source_location_id, destination_location_id, notes, timestamps for requested_at, approved_at, dispatched_at, completed_at.

## Requirements (To-Do)
- [ ] Create migration with all transaction fields
- [ ] Add unique index on operation_number
- [ ] Add nullable foreign keys for user references
- [ ] Add nullable timestamps for workflow stages
- [ ] Add enum constraints for type and status

## Acceptance Criteria
- Migration runs without errors
- Operation numbers are unique
- All workflow timestamps are supported
- Foreign key relationships are properly defined



## Implementation Status
**Status:** ✅ COMPLETED
**Note:** Using `operaciones` + `numoperaciones` tables


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

## Milestone
M1-Foundation
