0001_initial.py 6.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103
  1. # Generated by Django 4.1.2 on 2025-03-30 13:24
  2. from django.db import migrations, models
  3. import django.db.models.deletion
  4. class Migration(migrations.Migration):
  5. initial = True
  6. dependencies = [
  7. ('bound', '0002_bounddetailmodel_status'),
  8. ]
  9. operations = [
  10. migrations.CreateModel(
  11. name='ContainerListModel',
  12. fields=[
  13. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  14. ('container_code', models.IntegerField(verbose_name='托盘编号')),
  15. ('current_location', models.CharField(default='N/A', max_length=50, verbose_name='当前库位')),
  16. ('target_location', models.CharField(default='N/A', max_length=50, verbose_name='目标库位')),
  17. ('status', models.IntegerField(choices=[(0, '空置'), (1, '入库中'), (2, '在库'), (3, '出库中'), (4, '已出库')], default=0, verbose_name='托盘状态')),
  18. ('last_operation', models.DateTimeField(auto_now=True, verbose_name='最后操作时间')),
  19. ],
  20. options={
  21. 'verbose_name': 'ContainerList',
  22. 'verbose_name_plural': 'ContainerList',
  23. 'db_table': 'container_list',
  24. 'ordering': ['-container_code'],
  25. },
  26. ),
  27. migrations.CreateModel(
  28. name='ContainerWCSModel',
  29. fields=[
  30. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  31. ('taskid', models.CharField(max_length=50, verbose_name='任务ID')),
  32. ('month', models.IntegerField(verbose_name='月份')),
  33. ('tasktype', models.CharField(max_length=50, verbose_name='任务类型')),
  34. ('container', models.CharField(max_length=50, verbose_name='托盘号')),
  35. ('current_location', models.CharField(max_length=50, verbose_name='当前库位')),
  36. ('target_location', models.CharField(max_length=50, verbose_name='目标库位')),
  37. ('message', models.TextField(verbose_name='消息')),
  38. ('status', models.IntegerField(verbose_name='状态')),
  39. ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
  40. ('is_delete', models.BooleanField(default=False, verbose_name='是否删除')),
  41. ],
  42. options={
  43. 'verbose_name': 'ContainerWCS',
  44. 'verbose_name_plural': 'ContainerWCS',
  45. 'db_table': 'container_wcs',
  46. 'ordering': ['-create_time'],
  47. },
  48. ),
  49. migrations.CreateModel(
  50. name='ContainerOperationModel',
  51. fields=[
  52. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  53. ('month', models.IntegerField(verbose_name='月份')),
  54. ('operation_type', models.CharField(choices=[('inbound', '入库'), ('outbound', '出库')], max_length=20, verbose_name='操作类型')),
  55. ('goods_code', models.CharField(max_length=50, verbose_name='货品编码')),
  56. ('goods_desc', models.CharField(max_length=100, verbose_name='货品描述')),
  57. ('goods_qty', models.IntegerField(verbose_name='数量')),
  58. ('goods_weight', models.DecimalField(decimal_places=3, max_digits=10, verbose_name='重量')),
  59. ('operator', models.CharField(max_length=50, verbose_name='操作人')),
  60. ('timestamp', models.DateTimeField(auto_now_add=True, verbose_name='操作时间')),
  61. ('from_location', models.CharField(max_length=50, null=True, verbose_name='原库位')),
  62. ('to_location', models.CharField(max_length=50, null=True, verbose_name='目标库位')),
  63. ('memo', models.TextField(null=True, verbose_name='备注')),
  64. ('batch', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='bound.boundbatchmodel', verbose_name='批次')),
  65. ('container', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='operations', to='container.containerlistmodel')),
  66. ],
  67. options={
  68. 'verbose_name': 'ContainerOperation',
  69. 'verbose_name_plural': 'ContainerOperation',
  70. 'db_table': 'container_operation',
  71. 'ordering': ['-timestamp'],
  72. },
  73. ),
  74. migrations.CreateModel(
  75. name='ContainerDetailModel',
  76. fields=[
  77. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  78. ('month', models.IntegerField(verbose_name='月份')),
  79. ('goods_code', models.CharField(max_length=50, verbose_name='货品编码')),
  80. ('goods_desc', models.CharField(max_length=100, verbose_name='货品描述')),
  81. ('goods_qty', models.IntegerField(verbose_name='数量')),
  82. ('goods_weight', models.DecimalField(decimal_places=3, max_digits=10, verbose_name='重量')),
  83. ('status', models.IntegerField(default=1, verbose_name='状态')),
  84. ('creater', models.CharField(max_length=50, verbose_name='创建人')),
  85. ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')),
  86. ('update_time', models.DateTimeField(auto_now=True, verbose_name='更新时间')),
  87. ('batch', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='bound.boundbatchmodel', verbose_name='批次')),
  88. ('container', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='details', to='container.containerlistmodel')),
  89. ],
  90. options={
  91. 'verbose_name': 'ContainerDetail',
  92. 'verbose_name_plural': 'ContainerDetail',
  93. 'db_table': 'container_detail',
  94. 'ordering': ['-id'],
  95. },
  96. ),
  97. ]