greater_wms/reportcenter/migrations/0003_goodssummarymodel.py

# Generated by Django 4.1.2 on 2025-07-25 18:15

from decimal import Decimal
from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ('reportcenter', '0002_alter_flowmodel_goods_in_alter_flowmodel_goods_out'),
    ]

    operations = [
        migrations.CreateModel(
            name='GoodsSummaryModel',
            fields=[
                ('goods_code', models.CharField(max_length=50, primary_key=True, serialize=False, verbose_name='货品编码')),
                ('goods_desc', models.CharField(max_length=100, verbose_name='货品描述')),
                ('total_in', models.DecimalField(decimal_places=3, default=Decimal('0'), max_digits=15, verbose_name='总入库量')),
                ('total_out', models.DecimalField(decimal_places=3, default=Decimal('0'), max_digits=15, verbose_name='总出库量')),
                ('net_change', models.DecimalField(decimal_places=3, default=Decimal('0'), max_digits=15, verbose_name='净变化量')),
                ('last_updated', models.DateTimeField(auto_now=True, verbose_name='最后更新时间')),
            ],
            options={
                'verbose_name': '货品汇总',
                'verbose_name_plural': '货品汇总',
                'db_table': 'goods_summary',
            },
        ),
    ]