# Generated by Django 2.2 on 2019-04-23 21:20

import datasets.utils.BaseDatasetModel
from django.db import migrations, models
import django.db.models.deletion


class Migration(migrations.Migration):

    dependencies = [
        ('datasets', '0026_auto_20190410_1025'),
    ]

    operations = [
        migrations.CreateModel(
            name='PropertyAnnotation',
            fields=[
                ('id', models.AutoField(auto_created=True, primary_key=True, serialize=False, verbose_name='ID')),
                ('unitsrentstabilized', models.IntegerField(blank=True, null=True)),
                ('latestsaleprice', models.BigIntegerField(blank=True, db_index=True, null=True)),
                ('hpdviolations_last30', models.IntegerField(blank=True, null=True)),
                ('hpdviolations_lastyear', models.IntegerField(blank=True, null=True)),
                ('hpdviolations_last3years', models.IntegerField(blank=True, null=True)),
                ('hpdcomplaints_last30', models.IntegerField(blank=True, null=True)),
                ('hpdcomplaints_lastyear', models.IntegerField(blank=True, null=True)),
                ('hpdcomplaints_last3years', models.IntegerField(blank=True, null=True)),
                ('dobviolations_last30', models.IntegerField(blank=True, null=True)),
                ('dobviolations_lastyear', models.IntegerField(blank=True, null=True)),
                ('dobviolations_last3years', models.IntegerField(blank=True, null=True)),
                ('dobcomplaints_last30', models.IntegerField(blank=True, null=True)),
                ('dobcomplaints_lastyear', models.IntegerField(blank=True, null=True)),
                ('dobcomplaints_last3years', models.IntegerField(blank=True, null=True)),
                ('ecbviolations_last30', models.IntegerField(blank=True, null=True)),
                ('ecbviolations_lastyear', models.IntegerField(blank=True, null=True)),
                ('ecbviolations_last3years', models.IntegerField(blank=True, null=True)),
                ('housinglitigations_last30', models.IntegerField(blank=True, null=True)),
                ('housinglitigations_lastyear', models.IntegerField(blank=True, null=True)),
                ('housinglitigations_last3years', models.IntegerField(blank=True, null=True)),
                ('dobfiledpermits_last30', models.IntegerField(blank=True, null=True)),
                ('dobfiledpermits_lastyear', models.IntegerField(blank=True, null=True)),
                ('dobfiledpermits_last3years', models.IntegerField(blank=True, null=True)),
                ('dobissuedpermits_last30', models.IntegerField(blank=True, null=True)),
                ('dobissuedpermits_lastyear', models.IntegerField(blank=True, null=True)),
                ('dobissuedpermits_last3years', models.IntegerField(blank=True, null=True)),
                ('evictions_last30', models.IntegerField(blank=True, null=True)),
                ('evictions_lastyear', models.IntegerField(blank=True, null=True)),
                ('evictions_last3years', models.IntegerField(blank=True, null=True)),
                ('acrisrealmasters_last30', models.IntegerField(blank=True, null=True)),
                ('acrisrealmasters_lastyear', models.IntegerField(blank=True, null=True)),
                ('acrisrealmasters_last3years', models.IntegerField(blank=True, null=True)),
                ('lispendens_last30', models.IntegerField(blank=True, null=True)),
                ('lispendens_lastyear', models.IntegerField(blank=True, null=True)),
                ('lispendens_last3years', models.IntegerField(blank=True, null=True)),
                ('taxlien', models.BooleanField(blank=True, null=True)),
                ('conhrecord', models.BooleanField(blank=True, null=True)),
                ('nycha', models.BooleanField(blank=True, null=True)),
                ('subsidyj51', models.BooleanField(blank=True, null=True)),
                ('subsidy421a', models.BooleanField(blank=True, null=True)),
                ('subsidyprograms', models.TextField(blank=True, null=True)),
                ('bbl', models.OneToOneField(blank=True, db_column='bbl', db_constraint=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to='datasets.Property')),
            ],
            bases=(datasets.utils.BaseDatasetModel.BaseDatasetModel, models.Model),
        ),
    ]
