0001_initial.py 5.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687
  1. # Generated by Django 4.1.2 on 2025-03-27 20:26
  2. from django.db import migrations, models
  3. import django.db.models.deletion
  4. class Migration(migrations.Migration):
  5. initial = True
  6. dependencies = [
  7. ]
  8. operations = [
  9. migrations.CreateModel(
  10. name='BoundBatchModel',
  11. fields=[
  12. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  13. ('bound_number', models.CharField(max_length=255, verbose_name='入库批次号')),
  14. ('bound_month', models.CharField(max_length=255, verbose_name='月份')),
  15. ('warehouse_code', models.CharField(max_length=255, verbose_name='仓库编码')),
  16. ('warehouse_name', models.CharField(max_length=255, verbose_name='仓库名称')),
  17. ('goods_code', models.CharField(max_length=255, verbose_name='商品编码')),
  18. ('goods_desc', models.CharField(max_length=255, verbose_name='商品描述')),
  19. ('goods_qty', models.BigIntegerField(default=0, verbose_name='商品数量')),
  20. ('goods_weight', models.FloatField(default=0, verbose_name='商品单重')),
  21. ('goods_total_weight', models.FloatField(default=0, verbose_name='商品总重')),
  22. ('creater', models.CharField(default='uesr', max_length=255, verbose_name='Who Created')),
  23. ('openid', models.CharField(max_length=255, verbose_name='Openid')),
  24. ('is_delete', models.BooleanField(default=False, verbose_name='Delete Label')),
  25. ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='Create Time')),
  26. ('update_time', models.DateTimeField(auto_now=True, null=True, verbose_name='Update Time')),
  27. ],
  28. options={
  29. 'verbose_name': 'Bound Batch',
  30. 'verbose_name_plural': 'Bound Batch',
  31. 'db_table': 'boundbatch',
  32. 'ordering': ['-id'],
  33. },
  34. ),
  35. migrations.CreateModel(
  36. name='BoundListModel',
  37. fields=[
  38. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  39. ('bound_month', models.CharField(max_length=255, verbose_name='月份')),
  40. ('bound_date', models.DateField(verbose_name='单据日期')),
  41. ('bound_code', models.CharField(max_length=255, unique=True, verbose_name='出入库编号')),
  42. ('bound_code_type', models.CharField(max_length=255, verbose_name='单据类型')),
  43. ('bound_bs_type', models.CharField(max_length=255, verbose_name='业务类型')),
  44. ('bound_type', models.CharField(max_length=255, verbose_name='出入库类型')),
  45. ('bound_desc', models.CharField(default='', max_length=255, verbose_name='出入库描述')),
  46. ('bound_department', models.CharField(max_length=255, verbose_name='部门')),
  47. ('bound_status', models.CharField(max_length=255, verbose_name='单据状态')),
  48. ('creater', models.CharField(default='uesr', max_length=255, verbose_name='Who Created')),
  49. ('openid', models.CharField(max_length=255, verbose_name='Openid')),
  50. ('is_delete', models.BooleanField(default=False, verbose_name='Delete Label')),
  51. ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='Create Time')),
  52. ('update_time', models.DateTimeField(auto_now=True, null=True, verbose_name='Update Time')),
  53. ],
  54. options={
  55. 'verbose_name': 'Bound List',
  56. 'verbose_name_plural': 'Bound List',
  57. 'db_table': 'boundlist',
  58. 'ordering': ['-id'],
  59. },
  60. ),
  61. migrations.CreateModel(
  62. name='BoundDetailModel',
  63. fields=[
  64. ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
  65. ('detail_code', models.CharField(max_length=255, unique=True, verbose_name='明细编号')),
  66. ('creater', models.CharField(default='uesr', max_length=255, verbose_name='Who Created')),
  67. ('openid', models.CharField(max_length=255, verbose_name='Openid')),
  68. ('is_delete', models.BooleanField(default=False, verbose_name='Delete Label')),
  69. ('create_time', models.DateTimeField(auto_now_add=True, verbose_name='Create Time')),
  70. ('update_time', models.DateTimeField(auto_now=True, null=True, verbose_name='Update Time')),
  71. ('bound_batch', models.ForeignKey(on_delete=django.db.models.deletion.PROTECT, related_name='bound_batch_detail', to='bound.boundbatchmodel', verbose_name='Bound Batch')),
  72. ('bound_list', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='bound_detail', to='bound.boundlistmodel', verbose_name='Bound List')),
  73. ],
  74. options={
  75. 'verbose_name': 'Bound Detail',
  76. 'verbose_name_plural': 'Bound Detail',
  77. 'db_table': 'bounddetail',
  78. 'ordering': ['-id'],
  79. },
  80. ),
  81. ]