# Generated by Django 5.2.17 on 2026-09-27 19:17 import django.core.validators import django.db.models.deletion import django.utils.timezone import uuid from django.conf import settings from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ ('organization', '0002_userorganizationassignment'), ('parts', '0001_initial'), migrations.swappable_dependency(settings.AUTH_USER_MODEL), ] operations = [ migrations.CreateModel( name='InventoryLocation', fields=[ ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('code', models.CharField(max_length=64, validators=[django.core.validators.RegexValidator('^[A-Z0-9][A-Z0-9_-]*$')])), ('name', models.CharField(max_length=200)), ('location_type', models.CharField(choices=[('WAREHOUSE', 'Warehouse'), ('STORE', 'Service-center store'), ('QUARANTINE', 'Quarantine'), ('DEFECTIVE', 'Defective')], max_length=16)), ('is_active', models.BooleanField(default=True)), ('company', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='organization.company')), ('service_center', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, to='organization.servicecenter')), ], options={ 'ordering': ['company_id', 'code'], 'permissions': [('manage_inventory', 'Manage inventory locations'), ('view_stock', 'View scoped inventory and history'), ('receive_stock', 'Receive inventory'), ('transfer_stock', 'Move inventory within a company')], }, ), migrations.CreateModel( name='StockMovement', fields=[ ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('kind', models.CharField(choices=[('RECEIPT', 'Receipt'), ('MOVE', 'Location movement')], max_length=16)), ('quantity', models.PositiveIntegerField()), ('posted_at', models.DateTimeField(default=django.utils.timezone.now, editable=False)), ('reference', models.CharField(max_length=128)), ('note', models.TextField(blank=True, validators=[django.core.validators.MaxLengthValidator(2000)])), ('idempotency_key', models.UUIDField()), ('actor', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to=settings.AUTH_USER_MODEL)), ('company', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='organization.company')), ('destination', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='incoming_movements', to='inventory.inventorylocation')), ('source', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name='outgoing_movements', to='inventory.inventorylocation')), ('spare_part', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='parts.sparepart')), ], options={ 'ordering': ['posted_at', 'id'], }, ), migrations.CreateModel( name='StockLedgerEntry', fields=[ ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('quantity_delta', models.BigIntegerField()), ('company', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='organization.company')), ('location', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='ledger_entries', to='inventory.inventorylocation')), ('spare_part', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='parts.sparepart')), ('movement', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='entries', to='inventory.stockmovement')), ], ), migrations.CreateModel( name='SerializedStockUnit', fields=[ ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('identifier', models.CharField(max_length=128)), ('state', models.CharField(choices=[('REGISTERED', 'Registered, not yet received'), ('IN_STOCK', 'In stock')], default='REGISTERED', max_length=16)), ('company', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='organization.company')), ('current_location', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, to='inventory.inventorylocation')), ('registered_by', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to=settings.AUTH_USER_MODEL)), ('spare_part', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='parts.sparepart')), ('current_movement', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.PROTECT, related_name='current_units', to='inventory.stockmovement')), ], ), migrations.CreateModel( name='StockMovementUnit', fields=[ ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('movement', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='unit_links', to='inventory.stockmovement')), ('unit', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='movement_links', to='inventory.serializedstockunit')), ], ), migrations.CreateModel( name='StockPosition', fields=[ ('created_at', models.DateTimeField(auto_now_add=True)), ('updated_at', models.DateTimeField(auto_now=True)), ('id', models.UUIDField(default=uuid.uuid4, editable=False, primary_key=True, serialize=False)), ('location', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='inventory.inventorylocation')), ('spare_part', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, to='parts.sparepart')), ], ), migrations.AddConstraint( model_name='inventorylocation', constraint=models.UniqueConstraint(fields=('company', 'code'), name='inventory_location_code_uniq'), ), migrations.AddConstraint( model_name='inventorylocation', constraint=models.UniqueConstraint(fields=('id', 'company'), name='inventory_location_owner_uniq'), ), migrations.AddConstraint( model_name='inventorylocation', constraint=models.CheckConstraint(condition=models.Q(('code__regex', '^[A-Z0-9][A-Z0-9_-]*$')), name='inventory_location_code_valid'), ), migrations.AddConstraint( model_name='inventorylocation', constraint=models.CheckConstraint(condition=models.Q(('name', ''), _negated=True), name='inventory_location_name_nonempty'), ), migrations.AddConstraint( model_name='inventorylocation', constraint=models.CheckConstraint(condition=models.Q(('location_type__in', ['WAREHOUSE', 'STORE', 'QUARANTINE', 'DEFECTIVE'])), name='inventory_location_type_valid'), ), migrations.AddConstraint( model_name='inventorylocation', constraint=models.CheckConstraint(condition=models.Q(models.Q(('location_type', 'STORE'), _negated=True), ('service_center__isnull', False), _connector='OR'), name='inventory_store_requires_center'), ), migrations.AddConstraint( model_name='stockmovement', constraint=models.UniqueConstraint(fields=('company', 'idempotency_key'), name='inventory_movement_command_unique'), ), migrations.AddConstraint( model_name='stockmovement', constraint=models.UniqueConstraint(fields=('id', 'company', 'spare_part'), name='inventory_movement_owner_part_unique'), ), migrations.AddConstraint( model_name='stockmovement', constraint=models.CheckConstraint(condition=models.Q(('quantity__gte', 1), ('quantity__lte', 1000000000)), name='inventory_movement_quantity_positive'), ), migrations.AddConstraint( model_name='stockmovement', constraint=models.CheckConstraint(condition=models.Q(models.Q(('kind', 'RECEIPT'), ('source__isnull', True)), models.Q(('kind', 'MOVE'), ('source__isnull', False)), _connector='OR'), name='inventory_movement_kind_endpoints'), ), migrations.AddConstraint( model_name='stockmovement', constraint=models.CheckConstraint(condition=models.Q(('source', models.F('destination')), _negated=True), name='inventory_movement_distinct_locations'), ), migrations.AddConstraint( model_name='stockmovement', constraint=models.CheckConstraint(condition=models.Q(('reference', ''), _negated=True), name='inventory_movement_reference_required'), ), migrations.AddConstraint( model_name='stockledgerentry', constraint=models.UniqueConstraint(fields=('movement', 'location'), name='inventory_entry_movement_location_unique'), ), migrations.AddConstraint( model_name='stockledgerentry', constraint=models.CheckConstraint(condition=models.Q(('quantity_delta', 0), _negated=True), name='inventory_entry_nonzero'), ), migrations.AddConstraint( model_name='serializedstockunit', constraint=models.UniqueConstraint(fields=('spare_part', 'identifier'), name='inventory_unit_identity_permanent'), ), migrations.AddConstraint( model_name='serializedstockunit', constraint=models.UniqueConstraint(fields=('id', 'company', 'spare_part'), name='inventory_unit_owner_part_unique'), ), migrations.AddConstraint( model_name='serializedstockunit', constraint=models.CheckConstraint(condition=models.Q(('identifier', ''), _negated=True), name='inventory_unit_identifier_nonempty'), ), migrations.AddConstraint( model_name='serializedstockunit', constraint=models.CheckConstraint(condition=models.Q(models.Q(('current_location__isnull', True), ('current_movement__isnull', True), ('state', 'REGISTERED')), models.Q(('current_location__isnull', False), ('current_movement__isnull', False), ('state', 'IN_STOCK')), _connector='OR'), name='inventory_unit_state_location'), ), migrations.AddConstraint( model_name='stockmovementunit', constraint=models.UniqueConstraint(fields=('movement', 'unit'), name='inventory_movement_unit_unique'), ), migrations.AddConstraint( model_name='stockposition', constraint=models.UniqueConstraint(fields=('location', 'spare_part'), name='inventory_position_unique'), ), ]