# Generated by Django 3.1.3 on 2020-11-24 10:04

from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='omBackOrder',
            fields=[
                ('backOrderId', models.CharField(db_column='back_order_id', max_length=32, primary_key=True, serialize=False)),
                ('orderId', models.CharField(db_column='order_id', max_length=32, verbose_name='订单主键(外键)')),
                ('signer', models.CharField(db_column='signer', max_length=20, null=True, verbose_name='签收人')),
                ('signerTime', models.DateTimeField(db_column='signer_time', null=True, verbose_name='签收时间')),
                ('signerOpinion', models.CharField(db_column='signer_opinion', max_length=320, null=True, verbose_name='签收意见')),
                ('backOrderStatus', models.IntegerField(db_column='back_order_status', null=True, verbose_name='签收状态：1-完成，2-未回单')),
                ('backOrderImagePath1', models.CharField(db_column='back_order_Image_path1', max_length=32, null=True, verbose_name='照片1')),
                ('backOrderImagePath2', models.CharField(db_column='back_order_Image_path2', max_length=32, null=True, verbose_name='照片2')),
                ('backOrderImagePath3', models.CharField(db_column='back_order_Image_path3', max_length=32, null=True, verbose_name='照片3')),
                ('companyId', models.CharField(db_column='company_id', max_length=32, null=True, verbose_name='公司ID')),
                ('deptId', models.CharField(db_column='dept_id', max_length=32, null=True, verbose_name='机构ID')),
                ('createUserId', models.CharField(db_column='create_user_id', max_length=32, null=True, verbose_name='创建人ID')),
                ('createTime', models.DateTimeField(db_column='create_time', null=True, verbose_name='创建时间')),
                ('updateUserId', models.CharField(db_column='update_user_id', max_length=32, null=True, verbose_name='更新人ID')),
                ('updateTime', models.DateTimeField(db_column='update_time', null=True, verbose_name='更新时间')),
                ('delFlag', models.IntegerField(db_column='del_flag', null=True, verbose_name='是否删除：1已删除，2未删除')),
            ],
            options={
                'db_table': 't_om_back_order',
            },
        ),
        migrations.CreateModel(
            name='omBl',
            fields=[
                ('blId', models.CharField(db_column='bl_id', max_length=32, primary_key=True, serialize=False)),
                ('orderId', models.CharField(db_column='order_id', max_length=32, verbose_name='订单主键(外键)')),
                ('blPerson', models.CharField(db_column='bl_person', max_length=32, verbose_name='提货人')),
                ('blTime', models.DateTimeField(db_column='bl_time', verbose_name='提货时间')),
                ('blStatus', models.IntegerField(db_column='bl_status', verbose_name='状态：1-完成，2-否')),
                ('companyId', models.CharField(db_column='company_id', max_length=32, null=True, verbose_name='公司ID')),
                ('deptId', models.CharField(db_column='dept_id', max_length=32, null=True, verbose_name='机构ID')),
                ('createUserId', models.CharField(db_column='create_user_id', max_length=32, null=True, verbose_name='创建人ID')),
                ('createTime', models.DateTimeField(db_column='create_time', null=True, verbose_name='创建时间')),
                ('updateUserId', models.CharField(db_column='update_user_id', max_length=32, null=True, verbose_name='更新人ID')),
                ('updateTime', models.DateTimeField(db_column='update_time', null=True, verbose_name='更新时间')),
                ('delFlag', models.IntegerField(db_column='del_flag', null=True, verbose_name='是否删除：1已删除，2未删除')),
            ],
            options={
                'db_table': 't_om_bl',
            },
        ),
        migrations.CreateModel(
            name='omConcract',
            fields=[
                ('contractId', models.CharField(db_column='contract_id', max_length=32, primary_key=True, serialize=False)),
                ('contractNum', models.CharField(db_column='contract_num', max_length=32, verbose_name='合同编号')),
                ('contractName', models.CharField(db_column='contract_name', max_length=100, verbose_name='合同名称')),
                ('signTime', models.DateTimeField(db_column='sign_time', verbose_name='签订时间')),
                ('contractStartTime', models.DateTimeField(db_column='contract_start_time', null=True, verbose_name='合同生效时间')),
                ('contractEndTime', models.DateTimeField(db_column='contract_end_time', null=True, verbose_name='合同结束时间')),
                ('contractAddr', models.CharField(db_column='contract_addr', max_length=280, verbose_name='合同签订地点')),
                ('firstCompanyName', models.CharField(db_column='first_company_name', max_length=50, verbose_name='甲方单位名称')),
                ('firstPersonName', models.CharField(db_column='first_person_name', max_length=20, verbose_name='甲方联系人')),
                ('firstPersonTel', models.CharField(db_column='first_person_tel', max_length=20, verbose_name='甲方联系人电话')),
                ('secondCompanyName', models.CharField(db_column='second_company_name', max_length=50, verbose_name='乙方单位名称')),
                ('secondPersonName', models.CharField(db_column='second_person_name', max_length=20, verbose_name='乙方联系人')),
                ('secondPersonTel', models.CharField(db_column='second_person_tel', max_length=20, verbose_name='乙方联系人电话')),
                ('contractAttachment', models.CharField(db_column='contract_attachment', max_length=30, null=True, verbose_name='合同附件')),
                ('companyId', models.CharField(db_column='company_id', max_length=32, null=True, verbose_name='公司ID')),
                ('deptId', models.CharField(db_column='dept_id', max_length=32, null=True, verbose_name='机构ID')),
                ('createUserId', models.CharField(db_column='create_user_id', max_length=32, null=True, verbose_name='创建人ID')),
                ('createTime', models.DateTimeField(db_column='create_time', null=True, verbose_name='创建时间')),
                ('updateUserId', models.CharField(db_column='update_user_id', max_length=32, null=True, verbose_name='更新人ID')),
                ('updateTime', models.DateTimeField(db_column='update_time', null=True, verbose_name='更新时间')),
                ('delFlag', models.IntegerField(db_column='del_flag', null=True, verbose_name='是否删除：1已删除，2未删除')),
            ],
            options={
                'db_table': 't_om_concract',
            },
        ),
        migrations.CreateModel(
            name='omDetail',
            fields=[
                ('detailId', models.CharField(db_column='detail_id', max_length=32, primary_key=True, serialize=False)),
                ('orderId', models.CharField(db_column='order_id', max_length=32, verbose_name='订单主键(外键)')),
                ('goodsNum', models.CharField(db_column='goods_num', max_length=12, verbose_name='货物编号')),
                ('goodsName', models.CharField(db_column='goods_name', max_length=50, verbose_name='货物名称')),
                ('goodsType', models.CharField(db_column='goods_type', max_length=20, verbose_name='货物种类')),
                ('goodsWeight', models.FloatField(db_column='goods_weight', null=True, verbose_name='货物重量')),
                ('goodsVolume', models.FloatField(db_column='goods_volume', null=True, verbose_name='货物体积')),
                ('goodsQuantity', models.IntegerField(db_column='goods_quantity', verbose_name='货物数量')),
                ('goodsPrice', models.FloatField(db_column='goods_price', verbose_name='货物价格')),
                ('goodsTotalPrice', models.FloatField(db_column='goods_total_price', verbose_name='货物总价')),
                ('companyId', models.CharField(db_column='company_id', max_length=32, null=True, verbose_name='公司ID')),
                ('deptId', models.CharField(db_column='dept_id', max_length=32, null=True, verbose_name='机构ID')),
                ('createUserId', models.CharField(db_column='create_user_id', max_length=32, null=True, verbose_name='创建人ID')),
                ('createTime', models.DateTimeField(db_column='create_time', null=True, verbose_name='创建时间')),
                ('updateUserId', models.CharField(db_column='update_user_id', max_length=32, null=True, verbose_name='更新人ID')),
                ('updateTime', models.DateTimeField(db_column='update_time', null=True, verbose_name='更新时间')),
                ('delFlag', models.IntegerField(db_column='del_flag', null=True, verbose_name='是否删除：1已删除，2未删除')),
            ],
            options={
                'db_table': 't_om_detail',
            },
        ),
        migrations.CreateModel(
            name='omDetailWarehouse',
            fields=[
                ('warehouseId', models.CharField(db_column='warehouse_id', max_length=32, primary_key=True, serialize=False)),
                ('time', models.DateTimeField(db_column='time', verbose_name='当前系统时间')),
                ('detailId', models.CharField(db_column='detail_id', max_length=32, verbose_name='订单货物信息主键(外键)')),
                ('warehouseLocal', models.CharField(db_column='warehouse_local', max_length=32, verbose_name='仓库系统中位置主键(外键)')),
                ('companyId', models.CharField(db_column='company_id', max_length=32, null=True, verbose_name='公司ID')),
                ('deptId', models.CharField(db_column='dept_id', max_length=32, null=True, verbose_name='机构ID')),
                ('createUserId', models.CharField(db_column='create_user_id', max_length=32, null=True, verbose_name='创建人ID')),
                ('createTime', models.DateTimeField(db_column='create_time', null=True, verbose_name='创建时间')),
                ('updateUserId', models.CharField(db_column='update_user_id', max_length=32, null=True, verbose_name='更新人ID')),
                ('updateTime', models.DateTimeField(db_column='update_time', null=True, verbose_name='更新时间')),
                ('delFlag', models.IntegerField(db_column='del_flag', null=True, verbose_name='是否删除：1已删除，2未删除')),
            ],
            options={
                'db_table': 't_om_detail_warehouse',
            },
        ),
        migrations.CreateModel(
            name='omOrder',
            fields=[
                ('orderId', models.CharField(db_column='order_id', max_length=32, primary_key=True, serialize=False)),
                ('transporterId', models.CharField(db_column='transporter_id', max_length=32, verbose_name='托运人主键(外键)')),
                ('contractId', models.CharField(db_column='contract_id', max_length=32, verbose_name='电子合同主键(外键)')),
                ('transporter', models.CharField(db_column='transporter', max_length=20, verbose_name='托运人')),
                ('transporterTel', models.CharField(db_column='transporter_tel', max_length=30, verbose_name='托运人电话')),
                ('getAddr', models.CharField(db_column='get_addr', max_length=150, verbose_name='取货地址')),
                ('receiver', models.CharField(db_column='receiver', max_length=20, verbose_name='收货人')),
                ('receiverTel', models.CharField(db_column='receiver_tel', max_length=30, verbose_name='收货人电话')),
                ('unloadAddr', models.CharField(db_column='unload_addr', max_length=150, verbose_name='卸货地址')),
                ('transporterMethod', models.IntegerField(db_column='transporter_method', verbose_name='运输方式：1-汽运，2-火车，3-海运')),
                ('getGoodsTime', models.DateTimeField(db_column='get_goods_time', null=True, verbose_name='取货时间')),
                ('carStartTime', models.DateTimeField(db_column='car_start_time', null=True, verbose_name='发车时间')),
                ('arriveGoodsTime', models.DateTimeField(null=True, verbose_name='到货时间')),
                ('transform', models.IntegerField(db_column='transform', null=True, verbose_name='是否中转运输：1-是，2-否')),
                ('ordinaryTicket', models.IntegerField(db_column='ordinary_ticket', null=True, verbose_name='是否开票：1-是，2-否')),
                ('specialTicket', models.IntegerField(db_column='special_ticket', null=True, verbose_name='是否专票：1-是，2-否')),
                ('taxpayerName', models.CharField(db_column='taxpayer_name', max_length=50, null=True, verbose_name='纳税人名称')),
                ('taxpayerNum', models.CharField(db_column='taxpayer_num', max_length=30, null=True, verbose_name='纳税人识别号')),
                ('taxpayerAddr', models.CharField(db_column='taxpayer_addr', max_length=280, null=True, verbose_name='纳税人地址')),
                ('taxpayerTel', models.CharField(db_column='taxpayer_tel', max_length=20, null=True, verbose_name='纳税人电话')),
                ('taxpayerBank', models.CharField(db_column='taxpayer_bank', max_length=280, null=True, verbose_name='纳税人开户行')),
                ('taxpayerBannkNum', models.CharField(db_column='taxpayer_bannk_num', max_length=24, null=True, verbose_name='纳税人识账号')),
                ('sendOrder', models.IntegerField(db_column='send_order', null=True, verbose_name='是否发货单：1-是，2-否')),
                ('transportOrder', models.IntegerField(db_column='transport_order', null=True, verbose_name='是否托运单：1-是，2-否')),
                ('backOrder', models.IntegerField(db_column='back_order', null=True, verbose_name='是否回单：1-是，2-否')),
                ('orderAmount', models.FloatField(db_column='order_amount', null=True, verbose_name='订单金额')),
                ('evaluateMethod', models.IntegerField(db_column='evaluate_method', null=True, verbose_name='结算方式：1-是，2-否')),
                ('payMethod', models.IntegerField(db_column='pay_method', null=True, verbose_name='付款方式：1-是，2-否')),
                ('payStatus', models.IntegerField(db_column='pay_status', null=True, verbose_name='付款状态：1-是，2-否')),
                ('orderStatus', models.IntegerField(db_column='order_status', null=True, verbose_name='订单状态：0-订单成功未付款，1-用户已付，2-已派单，3-已完成')),
                ('carDemand', models.CharField(db_column='car_demand', max_length=280, null=True, verbose_name='车辆要求')),
                ('goodsDemand', models.CharField(db_column='goods_demand', max_length=280, null=True, verbose_name='货物要求')),
                ('otherDemand', models.CharField(db_column='other_demand', max_length=280, null=True, verbose_name='其他要求')),
                ('companyId', models.CharField(db_column='company_id', max_length=32, null=True, verbose_name='公司ID')),
                ('deptId', models.CharField(db_column='dept_id', max_length=32, null=True, verbose_name='机构ID')),
                ('createUserId', models.CharField(db_column='create_user_id', max_length=32, null=True, verbose_name='创建人ID')),
                ('createTime', models.DateTimeField(db_column='create_time', null=True, verbose_name='创建时间')),
                ('updateUserId', models.CharField(db_column='update_user_id', max_length=32, null=True, verbose_name='更新人ID')),
                ('updateTime', models.DateTimeField(db_column='update_time', null=True, verbose_name='更新时间')),
                ('delFlag', models.IntegerField(db_column='del_flag', null=True, verbose_name='是否删除：1已删除，2未删除')),
            ],
            options={
                'db_table': 't_om_order',
            },
        ),
    ]
