# -*- coding: utf-8 -*-
# Generated by Django 1.10 on 2016-09-20 15:30
from __future__ import unicode_literals

from django.db import migrations, models


class Migration(migrations.Migration):

    dependencies = [
        ('healthcare', '0037_delete_county_data'),
    ]

    operations = [
        migrations.CreateModel(
            name='County_Data',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('year', models.IntegerField()),
                ('fips', models.IntegerField()),
                ('state_name', models.CharField(max_length=20)),
                ('state', models.CharField(max_length=2)),
                ('county', models.CharField(max_length=40)),
                ('death_1', models.IntegerField(blank=True, null=True)),
                ('death_2', models.IntegerField(blank=True, null=True)),
                ('death_lo', models.IntegerField(blank=True, null=True)),
                ('death_hi', models.IntegerField(blank=True, null=True)),
                ('death_q', models.IntegerField(blank=True, null=True)),
                ('health_1', models.IntegerField(blank=True, null=True)),
                ('health_lo', models.IntegerField(blank=True, null=True)),
                ('health_hi', models.IntegerField(blank=True, null=True)),
                ('health_q', models.IntegerField(blank=True, null=True)),
                ('phealthdays_1', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)),
                ('phealthdays_lo', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)),
                ('phealthdays_hi', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)),
                ('phealthdays_q', models.IntegerField(blank=True, null=True)),
                ('mhealthdays_1', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)),
                ('mhealthdays_lo', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)),
                ('mhealthdays_hi', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)),
                ('mhealthdays_q', models.IntegerField(blank=True, null=True)),
                ('bweight_na', models.NullBooleanField()),
                ('bweight_1', models.IntegerField(blank=True, null=True)),
                ('bweight_2', models.IntegerField(blank=True, null=True)),
                ('bweight_e', models.IntegerField(blank=True, null=True)),
                ('bweight_lo', models.IntegerField(blank=True, null=True)),
                ('bweight_hi', models.IntegerField(blank=True, null=True)),
                ('bweight_q', models.IntegerField(blank=True, null=True)),
                ('smoke_1', models.IntegerField(blank=True, null=True)),
                ('smoke_lo', models.IntegerField(blank=True, null=True)),
                ('smoke_hi', models.IntegerField(blank=True, null=True)),
                ('smoke_q', models.IntegerField(blank=True, null=True)),
                ('obese_1', models.IntegerField(blank=True, null=True)),
                ('obese_lo', models.IntegerField(blank=True, null=True)),
                ('obese_hi', models.IntegerField(blank=True, null=True)),
                ('obese_q', models.IntegerField(blank=True, null=True)),
                ('food_1', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)),
                ('food_q', models.IntegerField(blank=True, null=True)),
                ('inact_1', models.IntegerField(blank=True, null=True)),
                ('inact_lo', models.IntegerField(blank=True, null=True)),
                ('inact_hi', models.IntegerField(blank=True, null=True)),
                ('inact_q', models.IntegerField(blank=True, null=True)),
                ('exopp_1', models.IntegerField(blank=True, null=True)),
                ('exopp_q', models.IntegerField(blank=True, null=True)),
                ('drink_1', models.IntegerField(blank=True, null=True)),
                ('drink_lo', models.IntegerField(blank=True, null=True)),
                ('drink_hi', models.IntegerField(blank=True, null=True)),
                ('drink_q', models.IntegerField(blank=True, null=True)),
                ('dwid_1', models.IntegerField(blank=True, null=True)),
                ('dwid_2', models.IntegerField(blank=True, null=True)),
                ('dwid_3', models.IntegerField(blank=True, null=True)),
                ('dwid_lo', models.IntegerField(blank=True, null=True)),
                ('dwid_hi', models.IntegerField(blank=True, null=True)),
                ('dwid_q', models.IntegerField(blank=True, null=True)),
                ('std_1', models.IntegerField(blank=True, null=True)),
                ('std_2', models.IntegerField(blank=True, null=True)),
                ('std_q', models.IntegerField(blank=True, null=True)),
                ('tbirth_1', models.IntegerField(blank=True, null=True)),
                ('tbirth_2', models.IntegerField(blank=True, null=True)),
                ('tbirth_3', models.IntegerField(blank=True, null=True)),
                ('tbirth_lo', models.IntegerField(blank=True, null=True)),
                ('tbirth_hi', models.IntegerField(blank=True, null=True)),
                ('tbirth_q', models.IntegerField(blank=True, null=True)),
                ('unins_1', models.IntegerField(blank=True, null=True)),
                ('unins_2', models.IntegerField(blank=True, null=True)),
                ('unins_lo', models.IntegerField(blank=True, null=True)),
                ('unins_hi', models.IntegerField(blank=True, null=True)),
                ('unins_q', models.IntegerField(blank=True, null=True)),
                ('pcp_1', models.IntegerField(blank=True, null=True)),
                ('pcp_2', models.IntegerField(blank=True, null=True)),
                ('pcp_3', models.CharField(blank=True, max_length=10, null=True)),
                ('pcp_q', models.IntegerField(blank=True, null=True)),
                ('dent_1', models.IntegerField(blank=True, null=True)),
                ('dent_2', models.IntegerField(blank=True, null=True)),
                ('dent_3', models.CharField(blank=True, max_length=10, null=True)),
                ('dent_q', models.IntegerField(blank=True, null=True)),
                ('mhp_1', models.IntegerField(blank=True, null=True)),
                ('mhp_2', models.IntegerField(blank=True, null=True)),
                ('mhp_3', models.CharField(blank=True, max_length=10, null=True)),
                ('mhp_q', models.IntegerField(blank=True, null=True)),
                ('phosp_1', models.IntegerField(blank=True, null=True)),
                ('phosp_2', models.IntegerField(blank=True, null=True)),
                ('phosp_lo', models.IntegerField(blank=True, null=True)),
                ('phosp_hi', models.IntegerField(blank=True, null=True)),
                ('phosp_q', models.IntegerField(blank=True, null=True)),
                ('diab_1', models.IntegerField(blank=True, null=True)),
                ('diab_2', models.IntegerField(blank=True, null=True)),
                ('diab_lo', models.IntegerField(blank=True, null=True)),
                ('diab_hi', models.IntegerField(blank=True, null=True)),
                ('diab_q', models.IntegerField(blank=True, null=True)),
                ('mamm_1', models.IntegerField(blank=True, null=True)),
                ('mamm_2', models.IntegerField(blank=True, null=True)),
                ('mamm_lo', models.IntegerField(blank=True, null=True)),
                ('mamm_hi', models.IntegerField(blank=True, null=True)),
                ('mamm_q', models.IntegerField(blank=True, null=True)),
                ('hs_1', models.IntegerField(blank=True, null=True)),
                ('hs_2', models.IntegerField(blank=True, null=True)),
                ('hs_q', models.IntegerField(blank=True, null=True)),
                ('coll_1', models.IntegerField(blank=True, null=True)),
                ('coll_2', models.IntegerField(blank=True, null=True)),
                ('coll_3', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)),
                ('coll_lo', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)),
                ('coll_hi', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)),
                ('coll_q', models.IntegerField(blank=True, null=True)),
                ('unem_1', models.IntegerField(blank=True, null=True)),
                ('unem_2', models.IntegerField(blank=True, null=True)),
                ('unem_3', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)),
                ('unem_q', models.IntegerField(blank=True, null=True)),
                ('cpov_1', models.IntegerField(blank=True, null=True)),
                ('cpov_2', models.IntegerField(blank=True, null=True)),
                ('cpov_lo', models.IntegerField(blank=True, null=True)),
                ('cpov_hi', models.IntegerField(blank=True, null=True)),
                ('cpov_q', models.IntegerField(blank=True, null=True)),
                ('ineq_1', models.IntegerField(blank=True, null=True)),
                ('ineq_2', models.IntegerField(blank=True, null=True)),
                ('ineq_3', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)),
                ('ineq_q', models.IntegerField(blank=True, null=True)),
                ('spar_1', models.IntegerField(blank=True, null=True)),
                ('spar_2', models.IntegerField(blank=True, null=True)),
                ('spar_3', models.IntegerField(blank=True, null=True)),
                ('spar_lo', models.IntegerField(blank=True, null=True)),
                ('spar_hi', models.IntegerField(blank=True, null=True)),
                ('spar_q', models.IntegerField(blank=True, null=True)),
                ('assoc_1', models.IntegerField(blank=True, null=True)),
                ('assoc_2', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)),
                ('assoc_q', models.IntegerField(blank=True, null=True)),
                ('vcrime_1', models.IntegerField(blank=True, null=True)),
                ('vcrime_2', models.IntegerField(blank=True, null=True)),
                ('vcrime_q', models.IntegerField(blank=True, null=True)),
                ('indeath_1', models.IntegerField(blank=True, null=True)),
                ('indeath_2', models.IntegerField(blank=True, null=True)),
                ('indeath_lo', models.IntegerField(blank=True, null=True)),
                ('indeath_hi', models.IntegerField(blank=True, null=True)),
                ('indeath_q', models.IntegerField(blank=True, null=True)),
                ('air_1', models.DecimalField(blank=True, decimal_places=2, max_digits=6, null=True)),
                ('air_q', models.IntegerField(blank=True, null=True)),
                ('water_1', models.NullBooleanField()),
                ('water_q', models.IntegerField(blank=True, null=True)),
                ('house_1', models.IntegerField(blank=True, null=True)),
                ('house_2', models.IntegerField(blank=True, null=True)),
                ('house_lo', models.IntegerField(blank=True, null=True)),
                ('house_hi', models.IntegerField(blank=True, null=True)),
                ('house_q', models.IntegerField(blank=True, null=True)),
                ('drive_1', models.IntegerField(blank=True, null=True)),
                ('drive_2', models.IntegerField(blank=True, null=True)),
                ('drive_3', models.IntegerField(blank=True, null=True)),
                ('drive_lo', models.IntegerField(blank=True, null=True)),
                ('drive_hi', models.IntegerField(blank=True, null=True)),
                ('drive_q', models.IntegerField(blank=True, null=True)),
                ('commute_1', models.IntegerField(blank=True, null=True)),
                ('commute_2', models.IntegerField(blank=True, null=True)),
                ('commute_lo', models.IntegerField(blank=True, null=True)),
                ('commute_hi', models.IntegerField(blank=True, null=True)),
                ('commute_q', models.IntegerField(blank=True, null=True)),
            ],
        ),
    ]
