# -*- coding: utf-8 -*-
# Generated by Django 1.10.1 on 2016-09-20 14:08
from __future__ import unicode_literals

from django.db import migrations, models
import django.db.models.deletion


class Migration(migrations.Migration):

    dependencies = [
        ('references', '0001_initial'),
    ]

    operations = [
        migrations.CreateModel(
            name='Agency',
            fields=[
                ('agency_id', models.AutoField(primary_key=True, serialize=False)),
                ('agency_code_aac', models.CharField(blank=True, max_length=6, null=True)),
                ('agency_code_fpds', models.CharField(blank=True, max_length=4, null=True)),
                ('department_parent_id', models.IntegerField(blank=True, null=True)),
                ('sub_tier_parent_id', models.IntegerField(blank=True, null=True)),
                ('agency_name', models.CharField(blank=True, max_length=150, null=True)),
                ('valid_period_start', models.DateField(blank=True, null=True)),
                ('valid_period_end', models.DateField(blank=True, null=True)),
                ('create_date', models.DateTimeField(blank=True, null=True)),
                ('update_date', models.DateTimeField(blank=True, null=True)),
                ('create_user_id', models.CharField(blank=True, max_length=50, null=True)),
                ('update_user_id', models.CharField(blank=True, max_length=50, null=True)),
            ],
            options={
                'db_table': 'agency',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='LegalEntity',
            fields=[
                ('legal_entity_id', models.AutoField(primary_key=True, serialize=False)),
                ('ultimate_parent_legal_entity_id', models.IntegerField()),
                ('awardee_or_recipient_legal', models.CharField(blank=True, max_length=120, null=True)),
                ('vendor_doing_as_business_n', models.CharField(blank=True, max_length=400, null=True)),
                ('vendor_phone_number', models.CharField(blank=True, max_length=30, null=True)),
                ('vendor_fax_number', models.CharField(blank=True, max_length=30, null=True)),
                ('business_types', models.CharField(blank=True, max_length=3, null=True)),
                ('awardee_or_recipient_uniqu', models.CharField(blank=True, max_length=9, null=True)),
                ('limited_liability_corporat', models.CharField(blank=True, max_length=1, null=True)),
                ('sole_proprietorship', models.CharField(blank=True, max_length=1, null=True)),
                ('partnership_or_limited_lia', models.CharField(blank=True, max_length=1, null=True)),
                ('subchapter_s_corporation', models.CharField(blank=True, max_length=1, null=True)),
                ('foundation', models.CharField(blank=True, max_length=1, null=True)),
                ('for_profit_organization', models.CharField(blank=True, max_length=1, null=True)),
                ('nonprofit_organization', models.CharField(blank=True, max_length=1, null=True)),
                ('corporate_entity_tax_exemp', models.CharField(blank=True, max_length=1, null=True)),
                ('corporate_entity_not_tax_e', models.CharField(blank=True, max_length=1, null=True)),
                ('other_not_for_profit_organ', models.CharField(blank=True, max_length=1, null=True)),
                ('sam_exception', models.CharField(blank=True, max_length=1, null=True)),
                ('city_local_government', models.CharField(blank=True, max_length=1, null=True)),
                ('county_local_government', models.CharField(blank=True, max_length=1, null=True)),
                ('inter_municipal_local_gove', models.CharField(blank=True, max_length=1, null=True)),
                ('local_government_owned', models.CharField(blank=True, max_length=1, null=True)),
                ('municipality_local_governm', models.CharField(blank=True, max_length=1, null=True)),
                ('school_district_local_gove', models.CharField(blank=True, max_length=1, null=True)),
                ('township_local_government', models.CharField(blank=True, max_length=1, null=True)),
                ('us_state_government', models.CharField(blank=True, max_length=1, null=True)),
                ('us_federal_government', models.CharField(blank=True, max_length=1, null=True)),
                ('federal_agency', models.CharField(blank=True, max_length=1, null=True)),
                ('federally_funded_research', models.CharField(blank=True, max_length=1, null=True)),
                ('us_tribal_government', models.CharField(blank=True, max_length=1, null=True)),
                ('foreign_government', models.CharField(blank=True, max_length=1, null=True)),
                ('community_developed_corpor', models.CharField(blank=True, max_length=1, null=True)),
                ('labor_surplus_area_firm', models.CharField(blank=True, max_length=1, null=True)),
                ('small_agricultural_coopera', models.CharField(blank=True, max_length=1, null=True)),
                ('international_organization', models.CharField(blank=True, max_length=1, null=True)),
                ('us_government_entity', models.CharField(blank=True, max_length=1, null=True)),
                ('emerging_small_business', models.CharField(blank=True, max_length=1, null=True)),
                ('number_8a_program_participant', models.CharField(blank=True, db_column='8a_program_participant', max_length=1, null=True)),
                ('sba_certified_8_a_joint_ve', models.CharField(blank=True, max_length=1, null=True)),
                ('dot_certified_disadvantage', models.CharField(blank=True, max_length=1, null=True)),
                ('self_certified_small_disad', models.CharField(blank=True, max_length=1, null=True)),
                ('historically_underutilized', models.CharField(blank=True, max_length=1, null=True)),
                ('small_disadvantaged_busine', models.CharField(blank=True, max_length=1, null=True)),
                ('the_ability_one_program', models.CharField(blank=True, max_length=1, null=True)),
                ('historically_black_college', models.CharField(blank=True, max_length=1, null=True)),
                ('number_1862_land_grant_college', models.CharField(blank=True, db_column='1862_land_grant_college', max_length=1, null=True)),
                ('number_1890_land_grant_college', models.CharField(blank=True, db_column='1890_land_grant_college', max_length=1, null=True)),
                ('number_1994_land_grant_college', models.CharField(blank=True, db_column='1994_land_grant_college', max_length=1, null=True)),
                ('minority_institution', models.CharField(blank=True, max_length=1, null=True)),
                ('private_university_or_coll', models.CharField(blank=True, max_length=1, null=True)),
                ('school_of_forestry', models.CharField(blank=True, max_length=1, null=True)),
                ('state_controlled_instituti', models.CharField(blank=True, max_length=1, null=True)),
                ('tribal_college', models.CharField(blank=True, max_length=1, null=True)),
                ('veterinary_college', models.CharField(blank=True, max_length=1, null=True)),
                ('educational_institution', models.CharField(blank=True, max_length=1, null=True)),
                ('alaskan_native_servicing_i', models.CharField(blank=True, max_length=1, null=True)),
                ('community_development_corp', models.CharField(blank=True, max_length=1, null=True)),
                ('native_hawaiian_servicing', models.CharField(blank=True, max_length=1, null=True)),
                ('domestic_shelter', models.CharField(blank=True, max_length=1, null=True)),
                ('manufacturer_of_goods', models.CharField(blank=True, max_length=1, null=True)),
                ('hospital_flag', models.CharField(blank=True, max_length=1, null=True)),
                ('veterinary_hospital', models.CharField(blank=True, max_length=1, null=True)),
                ('hispanic_servicing_institu', models.CharField(blank=True, max_length=1, null=True)),
                ('woman_owned_business', models.CharField(blank=True, max_length=1, null=True)),
                ('minority_owned_business', models.CharField(blank=True, max_length=1, null=True)),
                ('women_owned_small_business', models.CharField(blank=True, max_length=1, null=True)),
                ('economically_disadvantaged', models.CharField(blank=True, max_length=1, null=True)),
                ('joint_venture_women_owned', models.CharField(blank=True, max_length=1, null=True)),
                ('joint_venture_economically', models.CharField(blank=True, max_length=1, null=True)),
                ('veteran_owned_business', models.CharField(blank=True, max_length=1, null=True)),
                ('service_disabled_veteran_o', models.CharField(blank=True, max_length=1, null=True)),
                ('contracts', models.CharField(blank=True, max_length=1, null=True)),
                ('grants', models.CharField(blank=True, max_length=1, null=True)),
                ('receives_contracts_and_gra', models.CharField(blank=True, max_length=1, null=True)),
                ('airport_authority', models.CharField(blank=True, max_length=1, null=True)),
                ('council_of_governments', models.CharField(blank=True, max_length=1, null=True)),
                ('housing_authorities_public', models.CharField(blank=True, max_length=1, null=True)),
                ('interstate_entity', models.CharField(blank=True, max_length=1, null=True)),
                ('planning_commission', models.CharField(blank=True, max_length=1, null=True)),
                ('port_authority', models.CharField(blank=True, max_length=1, null=True)),
                ('transit_authority', models.CharField(blank=True, max_length=1, null=True)),
                ('foreign_owned_and_located', models.CharField(blank=True, max_length=1, null=True)),
                ('american_indian_owned_busi', models.CharField(blank=True, max_length=1, null=True)),
                ('alaskan_native_owned_corpo', models.CharField(blank=True, max_length=1, null=True)),
                ('indian_tribe_federally_rec', models.CharField(blank=True, max_length=1, null=True)),
                ('native_hawaiian_owned_busi', models.CharField(blank=True, max_length=1, null=True)),
                ('tribally_owned_business', models.CharField(blank=True, max_length=1, null=True)),
                ('asian_pacific_american_own', models.CharField(blank=True, max_length=1, null=True)),
                ('black_american_owned_busin', models.CharField(blank=True, max_length=1, null=True)),
                ('hispanic_american_owned_bu', models.CharField(blank=True, max_length=1, null=True)),
                ('native_american_owned_busi', models.CharField(blank=True, max_length=1, null=True)),
                ('subcontinent_asian_asian_i', models.CharField(blank=True, max_length=1, null=True)),
                ('other_minority_owned_busin', models.CharField(blank=True, max_length=1, null=True)),
                ('us_local_government', models.CharField(blank=True, max_length=1, null=True)),
                ('undefinitized_action', models.CharField(blank=True, max_length=1, null=True)),
                ('domestic_or_foreign_entity', models.CharField(blank=True, max_length=1, null=True)),
                ('reporting_period_start', models.DateField(blank=True, null=True)),
                ('reporting_period_end', models.DateField(blank=True, null=True)),
                ('create_date', models.DateTimeField(blank=True, null=True)),
                ('update_date', models.DateTimeField(blank=True, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='Location',
            fields=[
                ('location_id', models.AutoField(primary_key=True, serialize=False)),
                ('location_country_name', models.CharField(blank=True, max_length=100, null=True)),
                ('location_state_code', models.CharField(blank=True, max_length=2, null=True)),
                ('location_state_name', models.CharField(blank=True, max_length=50, null=True)),
                ('location_state_text', models.CharField(blank=True, max_length=100, null=True)),
                ('location_city_name', models.CharField(blank=True, max_length=40, null=True)),
                ('location_city_code', models.CharField(blank=True, max_length=5, null=True)),
                ('location_county_name', models.CharField(blank=True, max_length=40, null=True)),
                ('location_county_code', models.CharField(blank=True, max_length=3, null=True)),
                ('location_address_line1', models.CharField(blank=True, max_length=150, null=True)),
                ('location_address_line2', models.CharField(blank=True, max_length=150, null=True)),
                ('location_address_line3', models.CharField(blank=True, max_length=55, null=True)),
                ('location_foreign_location_description', models.CharField(blank=True, max_length=100, null=True)),
                ('location_zip4', models.CharField(blank=True, max_length=10, null=True)),
                ('location_congressional_code', models.CharField(blank=True, max_length=2, null=True)),
                ('location_performance_code', models.CharField(blank=True, max_length=9, null=True)),
                ('location_zip_last4', models.CharField(blank=True, max_length=4, null=True)),
                ('location_zip5', models.CharField(blank=True, max_length=5, null=True)),
                ('location_foreign_postal_code', models.CharField(blank=True, max_length=50, null=True)),
                ('location_foreign_province', models.CharField(blank=True, max_length=25, null=True)),
                ('location_foreign_city_name', models.CharField(blank=True, max_length=40, null=True)),
                ('reporting_period_start', models.DateField(blank=True, null=True)),
                ('reporting_period_end', models.DateField(blank=True, null=True)),
                ('create_date', models.DateTimeField(blank=True, null=True)),
                ('create_user_id', models.CharField(blank=True, max_length=50, null=True)),
            ],
        ),
        migrations.CreateModel(
            name='RefCgacCode',
            fields=[
                ('agency_code_cgac', models.CharField(max_length=3, primary_key=True, serialize=False)),
                ('agency_name', models.CharField(blank=True, max_length=150, null=True)),
                ('valid_begin_date', models.DateTimeField(blank=True, null=True)),
                ('valid_end_date', models.DateTimeField(blank=True, null=True)),
                ('valid_code_indicator', models.CharField(blank=True, max_length=1, null=True)),
                ('create_date', models.DateTimeField(blank=True, null=True)),
                ('update_date', models.DateTimeField(blank=True, null=True)),
                ('create_user_id', models.CharField(blank=True, max_length=50, null=True)),
                ('update_user_id', models.CharField(blank=True, max_length=50, null=True)),
            ],
            options={
                'db_table': 'ref_cgac_code',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='RefCityCountyCode',
            fields=[
                ('city_county_code_id', models.AutoField(primary_key=True, serialize=False)),
                ('state_code', models.CharField(blank=True, max_length=2, null=True)),
                ('city_name', models.CharField(blank=True, max_length=50, null=True)),
                ('city_code', models.CharField(blank=True, max_length=5, null=True)),
                ('county_code', models.CharField(blank=True, max_length=3, null=True)),
                ('county_name', models.CharField(blank=True, max_length=100, null=True)),
                ('type_of_area', models.CharField(blank=True, max_length=20, null=True)),
                ('valid_begin_date', models.DateTimeField(blank=True, null=True)),
                ('valid_end_date', models.DateTimeField(blank=True, null=True)),
                ('valid_code_indicator', models.CharField(blank=True, max_length=1, null=True)),
                ('create_date', models.DateTimeField(blank=True, null=True)),
                ('update_date', models.DateTimeField(blank=True, null=True)),
                ('create_user_id', models.CharField(blank=True, max_length=50, null=True)),
                ('update_user_id', models.CharField(blank=True, max_length=50, null=True)),
            ],
            options={
                'db_table': 'ref_city_county_code',
                'managed': True,
            },
        ),
        migrations.CreateModel(
            name='RefCountryCode',
            fields=[
                ('country_code', models.CharField(max_length=3, primary_key=True, serialize=False)),
                ('country_name', models.CharField(blank=True, max_length=100, null=True)),
                ('valid_begin_date', models.DateTimeField(blank=True, null=True)),
                ('valid_end_date', models.DateTimeField(blank=True, null=True)),
                ('valid_code_indicator', models.CharField(blank=True, max_length=1, null=True)),
                ('create_date', models.DateTimeField(blank=True, null=True)),
                ('update_date', models.DateTimeField(blank=True, null=True)),
                ('create_user_id', models.CharField(blank=True, max_length=50, null=True)),
                ('update_user_id', models.CharField(blank=True, max_length=50, null=True)),
            ],
            options={
                'db_table': 'ref_country_code',
                'managed': True,
            },
        ),
        migrations.AddField(
            model_name='location',
            name='location_country_code',
            field=models.ForeignKey(blank=True, db_column='location_country_code', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='references.RefCountryCode'),
        ),
        migrations.AddField(
            model_name='legalentity',
            name='location',
            field=models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, to='references.Location'),
        ),
        migrations.AddField(
            model_name='agency',
            name='agency_code_cgac',
            field=models.ForeignKey(blank=True, db_column='agency_code_cgac', null=True, on_delete=django.db.models.deletion.DO_NOTHING, to='references.RefCgacCode'),
        ),
        migrations.AddField(
            model_name='agency',
            name='location',
            field=models.ForeignKey(on_delete=django.db.models.deletion.DO_NOTHING, to='references.Location'),
        ),
    ]
