# Generated by Django 2.2.4 on 2020-04-27 02:28

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


class Migration(migrations.Migration):

    dependencies = [
        ('datasets', '0067_auto_20200426_1828'),
    ]

    operations = [
        migrations.CreateModel(
            name='AEDBuilding',
            fields=[
                ('id', models.TextField(primary_key=True, serialize=False)),
                ('buildingid', models.TextField(blank=True, default='', null=True)),
                ('borough', models.TextField(blank=True, default='', null=True)),
                ('number', models.TextField(blank=True, default='', null=True)),
                ('street', models.TextField(blank=True, default='', null=True)),
                ('totalunits', models.IntegerField(blank=True, null=True)),
                ('aepstartdate', models.DateField(blank=True, null=True)),
                ('ofbcviolationsatstart', models.IntegerField(blank=True, null=True)),
                ('currentstatus', models.TextField(blank=True, default='', null=True)),
                ('dischargedate', models.DateField(blank=True, null=True)),
                ('aepround', models.TextField(blank=True, default='', null=True)),
                ('latitude', models.DecimalField(blank=True, decimal_places=14, max_digits=16, null=True)),
                ('longitude', models.DecimalField(blank=True, decimal_places=14, max_digits=16, null=True)),
                ('censustract', models.IntegerField(blank=True, null=True)),
                ('nta', models.TextField(blank=True, default='', null=True)),
                ('bbl', models.ForeignKey(db_column='bbl', db_constraint=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to='datasets.Property')),
                ('bin', models.ForeignKey(blank=True, db_column='bin', db_constraint=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to='datasets.Building')),
                ('communityboard', models.ForeignKey(db_column='communityboard', db_constraint=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to='datasets.Community')),
                ('councildistrict', models.ForeignKey(db_column='councildistrict', db_constraint=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to='datasets.Council')),
                ('postcode', models.ForeignKey(db_column='postcode', db_constraint=False, null=True, on_delete=django.db.models.deletion.SET_NULL, to='datasets.ZipCode')),
            ],
            bases=(datasets.utils.BaseDatasetModel.BaseDatasetModel, models.Model),
        ),
    ]
