greater_wms/erp/migrations/0001_initial.py

# Generated by Django 4.1.2 on 2025-04-29 14:34

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


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='InboundBill',
            fields=[
                ('billId', models.IntegerField(primary_key=True, serialize=False, verbose_name='原始单据ID')),
                ('number', models.CharField(max_length=50, unique=True, verbose_name='单据编号')),
                ('type', models.IntegerField(choices=[(1, '订单'), (2, '其他')], verbose_name='绑定类型')),
                ('date', models.CharField(max_length=10, verbose_name='入库时间')),
                ('department', models.CharField(max_length=10, null=True, verbose_name='部门')),
                ('warehouse', models.CharField(default='W01', max_length=10, verbose_name='仓库')),
                ('creater', models.CharField(max_length=50, null=True, verbose_name='创建人')),
                ('note', models.TextField(blank=True, null=True, verbose_name='备注说明')),
                ('totalCount', models.IntegerField(verbose_name='总条目数')),
                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('is_delete', models.BooleanField(default=False, verbose_name='是否删除')),
            ],
            options={
                'verbose_name': '生产入库单',
                'verbose_name_plural': '生产入库单',
            },
        ),
        migrations.CreateModel(
            name='MaterialDetail',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('entryIds', models.IntegerField(verbose_name='分录ID')),
                ('production_batch', models.CharField(max_length=50, verbose_name='生产批次')),
                ('goods_code', models.CharField(max_length=20, verbose_name='商品编码')),
                ('goods_name', models.CharField(max_length=100, verbose_name='商品名称')),
                ('goods_std', models.CharField(max_length=50, verbose_name='商品规格')),
                ('goods_weight', models.DecimalField(decimal_places=2, default=1, max_digits=10, verbose_name='单件重量')),
                ('plan_qty', models.IntegerField(verbose_name='计划数量')),
                ('goods_total_weight', models.DecimalField(decimal_places=2, max_digits=10, null=True, verbose_name='总重量')),
                ('goods_unit', models.CharField(max_length=20, verbose_name='计量单位')),
                ('note', models.TextField(blank=True, verbose_name='备注')),
                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
                ('update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
                ('is_delete', models.BooleanField(default=False, verbose_name='是否删除')),
                ('bound_billId', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='bill_id', to='erp.inboundbill', verbose_name='所属入库单')),
            ],
            options={
                'verbose_name': '物料明细',
                'verbose_name_plural': '物料明细',
                'unique_together': {('bound_billId', 'entryIds')},
            },
        ),
    ]