greater_wms/stock/migrations/0001_initial.py

# Generated by Django 4.1.2 on 2025-03-16 14:39

from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='StockshelfModel',
            fields=[
                ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('warehouse_code', models.CharField(max_length=255, verbose_name='Warehouse code')),
                ('warehouse_name', models.CharField(max_length=255, verbose_name='Warehouse Name')),
                ('shelf_name', models.CharField(max_length=255, verbose_name='Shelf Name')),
                ('shelf_type', models.CharField(default='storage', max_length=255, verbose_name='Shelf Type')),
                ('row', models.IntegerField(verbose_name='Row')),
                ('col', models.IntegerField(verbose_name='Column')),
                ('layer', models.IntegerField(verbose_name='Layer')),
                ('ip_address', models.CharField(default='127.0.0.1', max_length=255, verbose_name='IP Address')),
                ('port', models.IntegerField(default=8000, verbose_name='Port')),
                ('status', models.CharField(default='offline', max_length=255, verbose_name='Status')),
                ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='Create Time')),
                ('update_time', models.DateTimeField(auto_now=True, null=True, verbose_name='Update Time')),
                ('empty_label', models.BooleanField(default=True, verbose_name='Empty Flag')),
                ('shelf_department', models.CharField(default='货架部门', max_length=255, verbose_name='Shelf Department')),
                ('shelf_status', models.CharField(default='未满', max_length=255, verbose_name='Shelf Status')),
                ('goods_code', models.CharField(default='A010203', max_length=255, verbose_name='Goods Code')),
                ('goods_name', models.CharField(default='待填写', max_length=255, verbose_name='Goods Name')),
                ('goods_std', models.CharField(default='待填写', max_length=255, verbose_name='Goods Standard')),
                ('goods_desc', models.CharField(default='待填写', max_length=255, verbose_name='Goods Description')),
                ('goods_qty', models.BigIntegerField(default=0, verbose_name='Goods Quantity')),
                ('goods_unit', models.CharField(default='件', max_length=255, verbose_name='Goods Unit')),
                ('goods_price', models.DecimalField(decimal_places=2, default=0, max_digits=10, verbose_name='Goods Price')),
                ('goods_batch', models.CharField(default='待填写', max_length=255, verbose_name='Goods Batch')),
                ('goods_notes', models.CharField(default='待填写', max_length=255, verbose_name='Goods Notes')),
                ('goods_in', models.BigIntegerField(default=0, verbose_name='Goods In')),
                ('goods_out', models.BigIntegerField(default=0, verbose_name='Goods Out')),
            ],
            options={
                'verbose_name': 'Shelf List',
                'verbose_name_plural': 'Shelf List',
                'db_table': 'shelflist',
                'ordering': ['-id'],
                'unique_together': {('shelf_name', 'warehouse_code', 'row', 'col', 'layer')},
            },
        ),
    ]