greater_wms/bin/migrations/0009_alloction_pre_allocation_history.py

# Generated by Django 4.1.2 on 2025-04-18 09:27

from django.db import migrations, models
import django.db.models.deletion


class Migration(migrations.Migration):

    dependencies = [
        ('container', '0001_initial'),
        ('bin', '0008_alter_locationmodel_current_quantity'),
    ]

    operations = [
        migrations.CreateModel(
            name='alloction_pre',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('batch_number', models.CharField(max_length=255, verbose_name='批次号')),
                ('layer1_pre', models.IntegerField(default=0, verbose_name='第一层预留')),
                ('layer2_pre', models.IntegerField(default=0, verbose_name='第二层预留')),
                ('layer3_pre', models.IntegerField(default=0, verbose_name='第三层预留')),
                ('layer1_pre_type', models.JSONField(default=list, verbose_name='第一层预留类型')),
                ('layer1_pre_type_number', models.JSONField(default=list, verbose_name='第一层预留数目')),
                ('layer2_pre_type', models.JSONField(default=list, verbose_name='第二层预留')),
                ('layer2_pre_type_number', models.JSONField(default=list, verbose_name='第二层预留数目')),
                ('layer3_pre_type', models.JSONField(default=list, verbose_name='第三层预留')),
                ('layer3_pre_type_number', models.JSONField(default=list, verbose_name='第三层预留数目')),
                ('layer1_pressure', models.IntegerField(default=0, verbose_name='第一层工作压力')),
                ('layer2_pressure', models.IntegerField(default=0, verbose_name='第二层工作压力')),
                ('layer3_pressure', models.IntegerField(default=0, verbose_name='第三层工作压力')),
                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
            ],
            options={
                'verbose_name': 'Allocation_pre',
                'verbose_name_plural': 'Allocation_pre',
                'db_table': 'allocation_pre',
                'ordering': ['-id'],
            },
        ),
        migrations.CreateModel(
            name='allocation_history',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('operation_type', models.CharField(max_length=10, verbose_name='操作类型')),
                ('timestamp', models.DateTimeField(auto_now_add=True, verbose_name='操作时间')),
                ('container', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='container.containerlistmodel', verbose_name='托盘')),
                ('location', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='bin.locationmodel', verbose_name='库位')),
                ('related_location', models.ForeignKey(null=True, on_delete=django.db.models.deletion.SET_NULL, related_name='related_logs_history', to='bin.locationmodel', verbose_name='关联库位')),
                ('task_detail', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='container.taskmodel', verbose_name='批次详情')),
                ('task_wcs', models.ForeignKey(blank=True, null=True, on_delete=django.db.models.deletion.CASCADE, to='container.containerwcsmodel', verbose_name='WCS任务')),
            ],
            options={
                'verbose_name': 'Allocation_history',
                'verbose_name_plural': 'Allocation_history',
                'db_table': 'allocation_history',
                'ordering': ['-id'],
            },
        ),
    ]