greater_wms/reportcenter/migrations/0001_initial.py

# Generated by Django 4.1.2 on 2025-03-16 19:41

from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='flowModel',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('document_date', models.DateField(blank=True, null=True, verbose_name='Document Date')),
                ('document_number', models.CharField(blank=True, max_length=20, null=True, verbose_name='Document Number')),
                ('document_type', models.CharField(blank=True, max_length=20, null=True, verbose_name='Document Type')),
                ('business_type', models.CharField(blank=True, max_length=20, null=True, verbose_name='Business Type')),
                ('iout_type', models.CharField(blank=True, max_length=255, null=True, verbose_name='IOUT Type')),
                ('department', models.CharField(blank=True, max_length=255, null=True, verbose_name='Department')),
                ('warehouse_code', models.CharField(blank=True, max_length=20, null=True, verbose_name='Warehouse Code')),
                ('warehouse_name', models.CharField(blank=True, max_length=255, null=True, verbose_name='Warehouse Name')),
                ('goods_code', models.CharField(blank=True, max_length=255, null=True, verbose_name='Goods Code')),
                ('goods_desc', models.CharField(blank=True, max_length=255, null=True, verbose_name='Goods Description')),
                ('goods_std', models.CharField(blank=True, max_length=255, null=True, verbose_name='Goods Standard')),
                ('goods_batch', models.CharField(blank=True, max_length=255, null=True, verbose_name='Goods Batch')),
                ('in_batch', models.CharField(blank=True, max_length=255, null=True, verbose_name='In Batch')),
                ('out_batch', models.CharField(blank=True, max_length=255, null=True, verbose_name='Out Batch')),
                ('goods_unit', models.CharField(blank=True, default='件', max_length=255, null=True, verbose_name='Goods Unit')),
                ('goods_in', models.BigIntegerField(blank=True, default=0, null=True, verbose_name='Goods In')),
                ('goods_out', models.BigIntegerField(blank=True, default=0, null=True, verbose_name='Goods Out')),
                ('goods_notes', models.CharField(blank=True, default='待填写', max_length=255, null=True, verbose_name='Goods Notes')),
                ('creator', models.CharField(blank=True, max_length=255, null=True, verbose_name='Creator')),
            ],
            options={
                'verbose_name': 'Flow List',
                'verbose_name_plural': 'Flow List',
                'db_table': 'flowlist',
                'ordering': ['id'],
            },
        ),
        migrations.AddConstraint(
            model_name='flowmodel',
            constraint=models.UniqueConstraint(fields=('document_date', 'document_number', 'document_type', 'business_type', 'iout_type', 'department', 'warehouse_code', 'warehouse_name', 'goods_code', 'goods_desc', 'goods_std', 'goods_batch', 'in_batch', 'out_batch', 'goods_in', 'goods_out', 'goods_notes', 'creator'), name='unique_all_fields'),
        ),
    ]