123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384 |
- # 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',
- },
- ),
- ]
|