0001_initial.py
5.5 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
# Generated by Django 3.1.1 on 2020-11-03 08:15
from django.conf import settings
from django.db import migrations, models
import django.db.models.deletion
class Migration(migrations.Migration):
initial = True
dependencies = [
migrations.swappable_dependency(settings.AUTH_USER_MODEL),
]
operations = [
migrations.CreateModel(
name='Auditor',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('order', models.PositiveSmallIntegerField(blank=True, default=0, null=True, verbose_name='排序')),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='sku_aud', to=settings.AUTH_USER_MODEL, verbose_name='审批人员')),
],
options={
'ordering': ('order',),
},
),
migrations.CreateModel(
name='Flow',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('is_done', models.BooleanField(default=False, verbose_name='是否已结束')),
('create_time', models.DateTimeField(auto_now_add=True)),
('auditor', models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, to='sku.auditor', verbose_name='审核人员')),
('starter', models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, to=settings.AUTH_USER_MODEL, verbose_name='发起人')),
],
),
migrations.CreateModel(
name='SKU',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('supplier', models.CharField(default='', max_length=100, verbose_name='供应商')),
('sku', models.CharField(default='', max_length=100, verbose_name='SKU')),
('model', models.CharField(default='', max_length=100, verbose_name='型号')),
('title', models.CharField(default='', max_length=100, verbose_name='SKU名称')),
('is_new', models.CharField(default='', max_length=100, verbose_name='是否新品')),
('qty', models.CharField(default='', max_length=100, verbose_name='需求单数量')),
('price_with_tax', models.DecimalField(decimal_places=4, default=0, max_digits=9, verbose_name='含税单价')),
('amount_with_tax', models.DecimalField(decimal_places=4, default=0, max_digits=9, verbose_name='含税总金额')),
('sell_day', models.PositiveIntegerField(default=0, null=True, verbose_name='可售天数')),
('qty_within_30', models.PositiveIntegerField(default=0, null=True, verbose_name='30天销量')),
('inventory', models.PositiveIntegerField(default=0, null=True, verbose_name='库存')),
('coming_inventory', models.PositiveIntegerField(default=0, null=True, verbose_name='采购在途')),
('gross_profit_rate', models.FloatField(default=0, null=True, verbose_name='毛利率')),
('return_rate', models.FloatField(default=0, null=True, verbose_name='客退率')),
('memo', models.CharField(default='', max_length=255, null=True, verbose_name='备注')),
('create_time', models.DateTimeField(auto_now_add=True)),
('purchaser', models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, related_name='purchase_user', to=settings.AUTH_USER_MODEL, verbose_name='采购')),
],
),
migrations.CreateModel(
name='Result',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('is_accept', models.CharField(choices=[('accept', '通过'), ('reject', '否决')], max_length=10, null=True, verbose_name='审核项目')),
('memo', models.CharField(blank=True, default='', max_length=300, verbose_name='审核结果陈述')),
('create_time', models.DateTimeField(auto_now_add=True)),
('auditor', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='result_auditor', to='sku.auditor', verbose_name='审核人员')),
('flow', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='result_flow', to='sku.flow', verbose_name='审核项目')),
],
options={
'ordering': ('pk',),
},
),
migrations.CreateModel(
name='Leader',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('user', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, related_name='sku_leader', to=settings.AUTH_USER_MODEL, verbose_name='采购负责人')),
],
),
migrations.CreateModel(
name='FlowSKU',
fields=[
('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
('is_pass', models.BooleanField(default=False, verbose_name='是否通过，默认为否')),
('flow', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='sku.flow', verbose_name='对应的流程')),
('sku', models.ForeignKey(on_delete=django.db.models.deletion.CASCADE, to='sku.sku', verbose_name='流程中的的SKU')),
],
),
]