# Generated by Django 5.0.2 on 2024-08-14 07:43 import datetime import django.utils.timezone from django.db import migrations, models class Migration(migrations.Migration): initial = True dependencies = [ ] operations = [ migrations.CreateModel( name='Admin', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('username', models.CharField(max_length=60, unique=True, verbose_name='登录用户名')), ('password', models.CharField(max_length=255, verbose_name='登录密码')), ('mobile', models.CharField(max_length=20, verbose_name='手机号码')), ('email', models.CharField(max_length=60, verbose_name='邮件地址')), ('real_name', models.CharField(default='', max_length=255, verbose_name='真实姓名')), ('token', models.CharField(default='', max_length=120, verbose_name='登录授权码')), ('role_id', models.IntegerField(default=0, verbose_name='所属角色')), ('create_time', models.DateTimeField(default=datetime.datetime(2024, 8, 14, 15, 43, 16, 372756), verbose_name='创建日期')), ('last_login_time', models.DateTimeField(default=datetime.datetime(2024, 8, 14, 15, 43, 16, 372756), verbose_name='最后登录时间')), ('status', models.SmallIntegerField(choices=[(5, '使用中'), (6, '已停用'), (4, '已删除')], verbose_name='状态')), ('header', models.CharField(default='', max_length=255, verbose_name='头像')), ('code', models.CharField(default='', max_length=255, verbose_name='工号')), ('job', models.CharField(default='', max_length=255, verbose_name='职位')), ('contact', models.CharField(default='', max_length=255, verbose_name='联系方式')), ], options={ 'verbose_name': '管理员信息', 'verbose_name_plural': '管理员信息', 'db_table': 'dc_admin', }, ), migrations.CreateModel( name='AdminRole', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(max_length=60, unique=True, verbose_name='角色名称')), ('intro', models.CharField(max_length=255, verbose_name='角色介绍')), ('is_admin', models.SmallIntegerField(default=2, verbose_name='超管标识')), ('create_time', models.DateTimeField(default=datetime.datetime(2024, 8, 14, 15, 43, 16, 373756), verbose_name='创建日期')), ('status', models.SmallIntegerField(choices=[(5, '使用中'), (6, '已停用'), (4, '已删除')], verbose_name='状态')), ], options={ 'verbose_name': '管理员角色', 'verbose_name_plural': '管理员角色信息', 'db_table': 'dc_admin_role', }, ), migrations.CreateModel( name='Brand', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(max_length=255, unique=True, verbose_name='品牌名称')), ('intro', models.TextField(verbose_name='品牌介绍')), ('create_time', models.DateTimeField(default=datetime.datetime(2024, 8, 14, 15, 43, 16, 375757), verbose_name='创建日期')), ('status', models.SmallIntegerField(choices=[(5, '使用中'), (6, '已停用'), (4, '已删除')], verbose_name='状态')), ], options={ 'verbose_name': '品牌信息', 'verbose_name_plural': '品牌信息', 'db_table': 'dc_brand', }, ), migrations.CreateModel( name='Customer', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('code', models.CharField(max_length=60, unique=True, verbose_name='客户编码')), ('name', models.CharField(max_length=255, unique=True, verbose_name='客户名称')), ('en_name', models.CharField(max_length=255, verbose_name='英文名称')), ('mobile', models.CharField(max_length=255, verbose_name='手机号码')), ('contact', models.CharField(max_length=60, verbose_name='联系人')), ('address', models.CharField(max_length=255, verbose_name='联系地址')), ('other', models.CharField(max_length=255, verbose_name='其它信息')), ('create_time', models.DateTimeField(default=datetime.datetime(2024, 8, 14, 15, 43, 16, 373756), verbose_name='创建日期')), ('status', models.SmallIntegerField(choices=[(5, '使用中'), (6, '已停用'), (4, '已删除')], verbose_name='状态')), ], options={ 'verbose_name': '客户信息', 'verbose_name_plural': '客户信息', 'db_table': 'dc_customer', }, ), migrations.CreateModel( name='Document', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('title', models.CharField(max_length=255, verbose_name='文档标题')), ('data', models.TextField(verbose_name='文档内容')), ('user_id', models.IntegerField(default=0, verbose_name='用户id')), ('create_time', models.DateTimeField(default=datetime.datetime(2024, 8, 14, 15, 43, 16, 375757), verbose_name='创建日期')), ('update_time', models.DateTimeField(default=datetime.datetime(2024, 8, 14, 15, 43, 16, 375757), verbose_name='更新时间')), ('status', models.SmallIntegerField(choices=[(5, '使用中'), (6, '已停用'), (4, '已删除')], verbose_name='状态')), ('category_id', models.IntegerField(default=0, verbose_name='所属文档分类')), ], options={ 'verbose_name': '文档', 'verbose_name_plural': '文档', 'db_table': 'dc_document', }, ), migrations.CreateModel( name='DocumentCategory', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(max_length=255, unique=True, verbose_name='文档分类名称')), ('intro', models.TextField(verbose_name='文档分类介绍')), ('create_time', models.DateTimeField(default=datetime.datetime(2024, 8, 14, 15, 43, 16, 375757), verbose_name='创建日期')), ('status', models.SmallIntegerField(choices=[(5, '使用中'), (6, '已停用'), (4, '已删除')], verbose_name='状态')), ], options={ 'verbose_name': '文档分类', 'verbose_name_plural': '文档分类', 'db_table': 'dc_document_category', }, ), migrations.CreateModel( name='Formula', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(max_length=255, unique=True, verbose_name='公式名称')), ('formula', models.TextField(max_length=255, verbose_name='公式内容')), ('intro', models.CharField(max_length=255, verbose_name='公式介绍')), ('params', models.CharField(max_length=255, verbose_name='公式参数')), ('create_time', models.DateTimeField(default=datetime.datetime(2024, 8, 14, 15, 43, 16, 378267), verbose_name='创建日期')), ('use_status', models.SmallIntegerField(choices=[(5, '已用中'), (6, '未使用')], default=5, verbose_name='用户状态')), ('status', models.SmallIntegerField(choices=[(5, '使用中'), (6, '已停用'), (4, '已删除')], default=5, verbose_name='状态')), ], options={ 'verbose_name': '公式管理', 'verbose_name_plural': '公式管理', 'db_table': 'dc_formula', }, ), migrations.CreateModel( name='Image', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('category_id', models.IntegerField(verbose_name='图片分类')), ('name', models.CharField(max_length=255, unique=True, verbose_name='图片信息')), ('width', models.CharField(max_length=60, verbose_name='图片宽度')), ('height', models.CharField(max_length=255, verbose_name='图片高度')), ('path', models.CharField(max_length=255, verbose_name='图片路径')), ('create_time', models.DateTimeField(default=datetime.datetime(2024, 8, 14, 15, 43, 16, 377257), verbose_name='创建日期')), ('status', models.SmallIntegerField(choices=[(5, '使用中'), (6, '已停用'), (4, '已删除')], verbose_name='状态')), ], options={ 'verbose_name': '图片信息', 'verbose_name_plural': '图片信息', 'db_table': 'dc_image', }, ), migrations.CreateModel( name='ImageCategory', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(max_length=255, unique=True, verbose_name='图片分类名称')), ('intro', models.TextField(verbose_name='图片分类介绍')), ('create_time', models.DateTimeField(default=datetime.datetime(2024, 8, 14, 15, 43, 16, 377257), verbose_name='创建日期')), ('status', models.SmallIntegerField(choices=[(5, '使用中'), (6, '已停用'), (4, '已删除')], verbose_name='状态')), ], options={ 'verbose_name': '图片分类', 'verbose_name_plural': '图片分类', 'db_table': 'dc_image_category', }, ), migrations.CreateModel( name='Params', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('code', models.CharField(max_length=255, unique=True, verbose_name='参数代码')), ('name', models.CharField(max_length=255, unique=True, verbose_name='参数名称')), ('value', models.CharField(blank=True, max_length=255, null=True, verbose_name='参数值')), ('value_type', models.SmallIntegerField(choices=[(1, '文本'), (2, '选择')], default=1, verbose_name='变量类型')), ('value_item', models.CharField(blank=True, max_length=255, null=True, verbose_name='取值范围')), ('intro', models.CharField(max_length=255, verbose_name='参数介绍')), ('create_time', models.DateTimeField(default=datetime.datetime(2024, 8, 14, 15, 43, 16, 378267), verbose_name='创建日期')), ('type', models.SmallIntegerField(choices=[(1, '变量'), (2, '常量')], default=1, verbose_name='状态')), ('status', models.SmallIntegerField(choices=[(5, '使用中'), (6, '已停用'), (4, '已删除')], verbose_name='状态')), ], options={ 'verbose_name': '参数配置', 'verbose_name_plural': '参数配置', 'db_table': 'dc_params', }, ), migrations.CreateModel( name='Product', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('category_id', models.IntegerField(verbose_name='分类信息')), ('brand_id', models.IntegerField(verbose_name='所属品牌')), ('supplier_id', models.IntegerField(verbose_name='所属供应商')), ('name', models.CharField(max_length=255, verbose_name='产品名称')), ('intro', models.CharField(max_length=255, verbose_name='产品介绍')), ('price', models.CharField(max_length=255, verbose_name='价格')), ('product_area', models.CharField(max_length=255, verbose_name='产地')), ('is_safe', models.CharField(max_length=255, verbose_name='是否质保')), ('safe_time', models.CharField(default='', max_length=255, verbose_name='质保期限')), ('is_package', models.CharField(max_length=255, verbose_name='是否为套餐商品')), ('package_intro', models.CharField(default='', max_length=255, verbose_name='套餐说明')), ('qualifications', models.CharField(max_length=255, verbose_name='产品资质')), ('create_time', models.DateTimeField(default=datetime.datetime(2024, 8, 14, 15, 43, 16, 378267), verbose_name='创建日期')), ('status', models.SmallIntegerField(choices=[(5, '使用中'), (6, '已停用'), (4, '已删除')], default=5, verbose_name='状态')), ('attrs', models.TextField(default='', verbose_name='产品资质')), ], options={ 'verbose_name': '产品信息', 'verbose_name_plural': '产品信息', 'db_table': 'dc_product', }, ), migrations.CreateModel( name='ProductCategory', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('parent_id', models.IntegerField(verbose_name='所属父级')), ('name', models.CharField(max_length=255, unique=True, verbose_name='分类名称')), ('attrs', models.TextField(verbose_name='属性配置')), ('create_time', models.DateTimeField(default=datetime.datetime(2024, 8, 14, 15, 43, 16, 378267), verbose_name='创建日期')), ('status', models.SmallIntegerField(choices=[(5, '使用中'), (6, '已停用'), (4, '已删除')], verbose_name='状态')), ], options={ 'verbose_name': '产品分类', 'verbose_name_plural': '产品分类', 'db_table': 'dc_product_category', }, ), migrations.CreateModel( name='ProductDocument', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('product_id', models.IntegerField(verbose_name='相关产品')), ('document_id', models.IntegerField(verbose_name='文档id')), ('create_time', models.DateTimeField(default=django.utils.timezone.now, verbose_name='创建日期')), ('status', models.SmallIntegerField(choices=[(5, '使用中'), (6, '已停用'), (4, '已删除')], verbose_name='状态')), ], options={ 'verbose_name': '产品相关文档', 'verbose_name_plural': '产品相关文档', 'db_table': 'dc_product_document', }, ), migrations.CreateModel( name='Project', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(max_length=255, unique=True, verbose_name='客户名称')), ('intro', models.TextField(verbose_name='客户编码')), ('customer_id', models.IntegerField(verbose_name='客户id')), ('category_id', models.IntegerField(verbose_name='所属分类id')), ('create_time', models.DateTimeField(default=datetime.datetime(2024, 8, 14, 15, 43, 16, 375757), verbose_name='创建日期')), ('status', models.SmallIntegerField(choices=[(5, '使用中'), (6, '已停用'), (4, '已删除')], verbose_name='状态')), ], options={ 'verbose_name': '项目信息', 'verbose_name_plural': '项目信息', 'db_table': 'dc_project', }, ), migrations.CreateModel( name='ProjectCategory', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('code', models.CharField(max_length=60, verbose_name='客户编码')), ('name', models.CharField(max_length=255, verbose_name='客户名称')), ('create_time', models.DateTimeField(default=datetime.datetime(2024, 8, 14, 15, 43, 16, 373756), verbose_name='创建日期')), ('status', models.SmallIntegerField(choices=[(5, '使用中'), (6, '已停用'), (4, '已删除')], verbose_name='状态')), ], options={ 'verbose_name': '项目分类', 'verbose_name_plural': '项目分类', 'db_table': 'dc_project_category', }, ), migrations.CreateModel( name='ProjectDocument', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('project_id', models.IntegerField(verbose_name='项目id')), ('doc_id', models.IntegerField(verbose_name='文档id')), ('create_time', models.DateTimeField(default=datetime.datetime(2024, 8, 14, 15, 43, 16, 375757), verbose_name='创建日期')), ('status', models.SmallIntegerField(choices=[(5, '使用中'), (6, '已停用'), (4, '已删除')], verbose_name='状态')), ], options={ 'verbose_name': '项目相关文档', 'verbose_name_plural': '项目相关文档', 'db_table': 'dc_project_document', }, ), migrations.CreateModel( name='SourceCategory', fields=[ ('id', models.BigAutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')), ('name', models.CharField(max_length=100, verbose_name='分类名称')), ('status', models.CharField(choices=[('active', '启用'), ('inactive', '禁用')], default='active', max_length=20, verbose_name='分类状态')), ('created_at', models.DateTimeField(auto_now_add=True, verbose_name='创建时间')), ], options={ 'verbose_name': '原始数据分类', 'verbose_name_plural': '原始数据分类', 'db_table': 'dc_source_data_category', }, ), migrations.CreateModel( name='SourceData', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('code', models.CharField(max_length=60, unique=True, verbose_name='数据代码')), ('name', models.TextField(verbose_name='数据名称')), ('file_name', models.TextField(default='', verbose_name='文件名称')), ('source_data', models.TextField(default='', verbose_name='文件内容')), ('create_time', models.DateTimeField(default=django.utils.timezone.now, verbose_name='创建日期')), ('status', models.SmallIntegerField(choices=[(5, '使用中'), (6, '已停用'), (4, '已删除')], verbose_name='状态')), ], options={ 'verbose_name': '原始数据', 'verbose_name_plural': '原始数据', 'db_table': 'dc_source_data', }, ), migrations.CreateModel( name='Supplier', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('code', models.CharField(max_length=255, unique=True, verbose_name='供应商编码')), ('name', models.CharField(max_length=255, verbose_name='供应商名称')), ('intro', models.TextField(verbose_name='供应商介绍')), ('create_time', models.DateTimeField(default=datetime.datetime(2024, 8, 14, 15, 43, 16, 377257), verbose_name='创建日期')), ('status', models.SmallIntegerField(choices=[(5, '使用中'), (6, '已停用'), (4, '已删除')], verbose_name='状态')), ], options={ 'verbose_name': '供应商信息', 'verbose_name_plural': '供应商信息', 'db_table': 'dc_supplier', }, ), migrations.CreateModel( name='Template', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('code', models.CharField(max_length=255, unique=True, verbose_name='模板编码')), ('name', models.CharField(max_length=255, verbose_name='模板分类名称')), ('intro', models.TextField(default='', verbose_name='介绍')), ('lay_id', models.CharField(default='', max_length=100, verbose_name='图层id')), ('type', models.CharField(default='', max_length=100, verbose_name='类型')), ('content', models.TextField(default='', verbose_name='模板内容')), ('attrs', models.TextField(default='[]', verbose_name='属性')), ('category_id', models.IntegerField(verbose_name='所属分类')), ('admin_id', models.IntegerField(default=0, verbose_name='管理员id')), ('create_time', models.DateTimeField(default=datetime.datetime(2024, 8, 14, 15, 43, 16, 377257), verbose_name='创建日期')), ('status', models.SmallIntegerField(choices=[(5, '使用中'), (6, '已停用'), (4, '已删除')], verbose_name='状态')), ], options={ 'verbose_name': '模板信息', 'verbose_name_plural': '模板信息', 'db_table': 'dc_template', }, ), migrations.CreateModel( name='TemplateCategory', fields=[ ('id', models.AutoField(primary_key=True, serialize=False)), ('name', models.CharField(max_length=255, unique=True, verbose_name='文档分类名称')), ('intro', models.TextField(verbose_name='文档分类介绍')), ('create_time', models.DateTimeField(default=datetime.datetime(2024, 8, 14, 15, 43, 16, 377257), verbose_name='创建日期')), ('status', models.SmallIntegerField(choices=[(5, '使用中'), (6, '已停用'), (4, '已删除')], verbose_name='状态')), ], options={ 'verbose_name': '模板分类', 'verbose_name_plural': '模板分类', 'db_table': 'dc_template_category', }, ), ]