greater_wms/container/migrations/0001_initial.py

# Generated by Django 4.1.2 on 2025-03-29 13:32

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
        ('bound', '0001_initial'),
    ]

    operations = [
        migrations.CreateModel(
            name='ContainerListModel',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('container_code', models.IntegerField(verbose_name='托盘编号')),
                ('current_location', models.CharField(default='N/A', max_length=50, verbose_name='当前库位')),
                ('status', models.IntegerField(choices=[(0, '空置'), (1, '入库中'), (2, '在库'), (3, '出库中'), (4, '已出库')], default=0, verbose_name='托盘状态')),
                ('last_operation', models.DateTimeField(auto_now=True, verbose_name='最后操作时间')),
            ],
            options={
                'verbose_name': 'ContainerList',
                'verbose_name_plural': 'ContainerList',
                'db_table': 'container_list',
                'ordering': ['-container_code'],
            },
        ),
        migrations.CreateModel(
            name='ContainerOperationModel',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('month', models.IntegerField(max_length=20, verbose_name='月份')),
                ('operation_type', models.CharField(choices=[('inbound', '入库'), ('outbound', '出库')], max_length=20, verbose_name='操作类型')),
                ('goods_code', models.CharField(max_length=50, verbose_name='货品编码')),
                ('goods_desc', models.CharField(max_length=100, verbose_name='货品描述')),
                ('goods_qty', models.IntegerField(verbose_name='数量')),
                ('goods_weight', models.DecimalField(decimal_places=3, max_digits=10, verbose_name='重量')),
                ('operator', models.CharField(max_length=50, verbose_name='操作人')),
                ('timestamp', models.DateTimeField(auto_now_add=True, verbose_name='操作时间')),
                ('from_location', models.CharField(max_length=50, null=True, verbose_name='原库位')),
                ('to_location', models.CharField(max_length=50, null=True, verbose_name='目标库位')),
                ('memo', models.TextField(null=True, verbose_name='备注')),
                ('batch', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='bound.boundbatchmodel', verbose_name='批次')),
                ('container', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='operations', to='container.containerlistmodel')),
            ],
            options={
                'verbose_name': 'ContainerOperation',
                'verbose_name_plural': 'ContainerOperation',
                'db_table': 'container_operation',
                'ordering': ['-timestamp'],
            },
        ),
        migrations.CreateModel(
            name='ContainerDetailModel',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('month', models.IntegerField(max_length=20, verbose_name='月份')),
                ('goods_code', models.CharField(max_length=50, verbose_name='货品编码')),
                ('goods_desc', models.CharField(max_length=100, verbose_name='货品描述')),
                ('goods_qty', models.IntegerField(verbose_name='数量')),
                ('goods_weight', models.DecimalField(decimal_places=3, max_digits=10, verbose_name='重量')),
                ('status', models.IntegerField(default=1, verbose_name='状态')),
                ('creater', models.CharField(max_length=50, verbose_name='创建人')),
                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('batch', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='bound.boundbatchmodel', verbose_name='批次')),
                ('container', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='details', to='container.containerlistmodel')),
            ],
            options={
                'verbose_name': 'ContainerDetail',
                'verbose_name_plural': 'ContainerDetail',
                'db_table': 'container_detail',
                'ordering': ['-id'],
            },
        ),
    ]