# Generated by Django 3.0.6 on 2020-05-29 12:14

from django.db import migrations, models


class Migration(migrations.Migration):

    initial = True

    dependencies = [
    ]

    operations = [
        migrations.CreateModel(
            name='simi_data',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('role_id', models.CharField(max_length=100, null=True)),
                ('zone', models.CharField(max_length=100, null=True)),
                ('plant', models.FloatField(null=True)),
                ('type', models.CharField(max_length=100, null=True)),
                ('city_code', models.CharField(max_length=100, null=True)),
                ('city_desc', models.CharField(max_length=100, null=True)),
                ('simi_type', models.CharField(max_length=100, null=True)),
                ('simi_city_code', models.CharField(max_length=100, null=True)),
                ('simi_city_name', models.CharField(max_length=100, null=True)),
                ('truck_type', models.FloatField(null=True)),
                ('direct_sto', models.CharField(max_length=100, null=True)),
                ('mean_route_timetaken', models.FloatField(null=True)),
                ('mean_ele', models.FloatField(null=True)),
                ('sd_ele', models.FloatField(null=True)),
                ('nh_per', models.FloatField(null=True)),
                ('sh_per', models.FloatField(null=True)),
                ('other_per', models.FloatField(null=True)),
                ('lead', models.FloatField(null=True)),
                ('ptpk', models.FloatField(null=True)),
                ('plain_per', models.FloatField(null=True)),
                ('hilly_per', models.FloatField(null=True)),
                ('onward_travel', models.FloatField(null=True)),
                ('return_travel', models.FloatField(null=True)),
                ('idle_time_cust', models.FloatField(null=True)),
                ('slab', models.CharField(max_length=100, null=True)),
                ('city_no', models.CharField(max_length=100, null=True)),
                ('simi_coeff', models.FloatField(null=True)),
                ('ptpk_pred', models.FloatField(null=True)),
                ('path', models.CharField(max_length=100, null=True)),
                ('quantity', models.FloatField(null=True)),
                ('batch', models.FloatField(null=True)),
                ('source_lat', models.FloatField(null=True)),
                ('source_long', models.FloatField(null=True)),
                ('latitude', models.FloatField(null=True)),
                ('longitude', models.FloatField(null=True)),
                ('pred_base_freight', models.FloatField(null=True)),
                ('impact', models.FloatField(null=True)),
                ('base_freight', models.FloatField(null=True)),
                ('taluka', models.CharField(max_length=100, null=True)),
                ('i2_taluka_desc', models.CharField(max_length=100, null=True)),
                ('t_type', models.CharField(max_length=100, null=True)),
                ('full_plant_name', models.CharField(max_length=100, null=True)),
                ('simi_city', models.CharField(max_length=100, null=True)),
                ('full_city', models.CharField(max_length=100, null=True)),
                ('route_1', models.CharField(max_length=100, null=True)),
                ('route', models.CharField(max_length=100, null=True)),
                ('route_2', models.CharField(max_length=100, null=True)),
                ('PLANT_NAME', models.CharField(db_column='PLANT_NAME', max_length=100, null=True)),
                ('simi_route', models.CharField(max_length=100, null=True)),
                ('plant_name', models.CharField(db_column='PLANT.NAME', max_length=100, null=True)),
                ('clc_1', models.CharField(max_length=100, null=True)),
                ('clc_2', models.CharField(max_length=100, null=True)),
                ('clc_3', models.CharField(max_length=100, null=True)),
                ('clc_4', models.CharField(max_length=100, null=True)),
                ('clc_5', models.CharField(max_length=100, null=True)),
                ('clc_6', models.BigIntegerField(null=True)),
                ('clc_7', models.BigIntegerField(null=True)),
                ('clc_8', models.CharField(max_length=100, null=True)),
                ('clc_9', models.BigIntegerField(null=True)),
                ('clc_10', models.BigIntegerField(null=True)),
                ('zone_head_1', models.CharField(max_length=100, null=True)),
                ('zone_head_2', models.BigIntegerField(null=True)),
                ('zl_coordinator_1', models.CharField(max_length=100, null=True)),
                ('zl_coordinator_2', models.CharField(max_length=100, null=True)),
                ('zl_coordinator_3', models.BigIntegerField(null=True)),
                ('plant_head_1', models.CharField(max_length=100, null=True)),
                ('plant_head_2', models.BigIntegerField(null=True)),
            ],
            options={
                'verbose_name': 'Ultra Tech Similarity Data',
                'verbose_name_plural': 'Ultra Tech Similarity Data',
                'db_table': 'simi_data',
            },
        ),
    ]
