"""Initial PostgreSQL migration

Revision ID: 211b37bc596b
Revises: 
Create Date: 2026-05-14 09:45:11.774346

"""
from typing import Sequence, Union

from alembic import op
import sqlalchemy as sa
import sqlmodel


# revision identifiers, used by Alembic.
revision: str = '211b37bc596b'
down_revision: Union[str, Sequence[str], None] = None
branch_labels: Union[str, Sequence[str], None] = None
depends_on: Union[str, Sequence[str], None] = None


def upgrade() -> None:
    """Upgrade schema."""
    # ### commands auto generated by Alembic - please adjust! ###
    op.create_table('agriculture_insurance',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('quote_status', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('premium_amount', sa.Float(), nullable=True),
    sa.Column('created_at', sa.DateTime(), nullable=False),
    sa.Column('updated_at', sa.DateTime(), nullable=True),
    sa.Column('full_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('entity_type', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('email_address', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('phone_number', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('state', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('county', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('zip_code', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('farm_name', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('total_acres_owned', sa.Integer(), nullable=False),
    sa.Column('total_acres_leased', sa.Integer(), nullable=True),
    sa.Column('farm_type', sa.JSON(), nullable=True),
    sa.Column('annual_revenue', sa.Float(), nullable=True),
    sa.Column('crop_type', sa.JSON(), nullable=True),
    sa.Column('planted_acres', sa.Integer(), nullable=True),
    sa.Column('expected_yield_per_acre', sa.Float(), nullable=True),
    sa.Column('coverage_level', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('insurance_plan', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('irrigation_used', sa.Boolean(), nullable=True),
    sa.Column('gps_field_map_uploaded', sa.Boolean(), nullable=True),
    sa.Column('animal_type', sa.JSON(), nullable=True),
    sa.Column('number_of_head', sa.JSON(), nullable=True),
    sa.Column('average_weight_per_head', sa.JSON(), nullable=True),
    sa.Column('livestock_value_per_head', sa.JSON(), nullable=True),
    sa.Column('coverage_type', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('animal_housing', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('vet_records_uploaded', sa.Boolean(), nullable=True),
    sa.Column('barns_sheds_count', sa.Integer(), nullable=True),
    sa.Column('equipment_value', sa.Float(), nullable=True),
    sa.Column('storage_units', sa.Integer(), nullable=True),
    sa.Column('liability_coverage_needed', sa.Boolean(), nullable=True),
    sa.Column('business_interruption_insurance', sa.Boolean(), nullable=True),
    sa.Column('perils_to_cover', sa.JSON(), nullable=True),
    sa.Column('previous_insurance_carrier', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('total_number_of_claims', sa.Integer(), nullable=True),
    sa.Column('type_of_loss', sa.JSON(), nullable=True),
    sa.Column('year_of_most_recent_claim', sa.Integer(), nullable=True),
    sa.Column('preferred_contact_method', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('best_time_to_reach', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('agent_assistance_needed', sa.Boolean(), nullable=True),
    sa.Column('transaction_no', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('annuity_insurance',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('quote_status', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('premium_amount', sa.Float(), nullable=True),
    sa.Column('created_at', sa.DateTime(), nullable=False),
    sa.Column('updated_at', sa.DateTime(), nullable=True),
    sa.Column('first_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('last_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('date_of_birth', sa.Date(), nullable=False),
    sa.Column('gender', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('marital_status', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('citizenship_status', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('email', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('phone_number', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('address', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('city', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('state', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('zip_code', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('annual_income', sa.Float(), nullable=True),
    sa.Column('net_worth', sa.Float(), nullable=True),
    sa.Column('liquid_assets', sa.Float(), nullable=True),
    sa.Column('investment_objective', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('risk_tolerance', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('initial_investment', sa.Float(), nullable=False),
    sa.Column('payment_frequency', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('purchase_type', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('source_of_funds', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('premium_mode', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('payout_start_age', sa.Integer(), nullable=True),
    sa.Column('accumulation_period', sa.Integer(), nullable=True),
    sa.Column('payout_option', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('beneficiary_type', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('death_benefit_option', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('index_strategy', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('guaranteed_income_rider', sa.Boolean(), nullable=True),
    sa.Column('enhanced_withdrawal_benefit', sa.Boolean(), nullable=True),
    sa.Column('replacement_existing_annuity', sa.Boolean(), nullable=True),
    sa.Column('existing_annuity_company', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('replacement_value', sa.Float(), nullable=True),
    sa.Column('financial_objective_statement', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('transaction_no', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('e_sign_consent', sa.Boolean(), nullable=False),
    sa.Column('data_sharing_consent', sa.Boolean(), nullable=False),
    sa.Column('privacy_notice_acknowledged', sa.Boolean(), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('business_insurance',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('business_name', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=False),
    sa.Column('est_year', sqlmodel.sql.sqltypes.AutoString(length=4), nullable=False),
    sa.Column('tax_id', sqlmodel.sql.sqltypes.AutoString(length=20), nullable=False),
    sa.Column('business_type', sqlmodel.sql.sqltypes.AutoString(length=50), nullable=False),
    sa.Column('industry', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('employees', sqlmodel.sql.sqltypes.AutoString(length=50), nullable=False),
    sa.Column('annual_revenue', sqlmodel.sql.sqltypes.AutoString(length=50), nullable=False),
    sa.Column('street', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=False),
    sa.Column('city', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('state', sqlmodel.sql.sqltypes.AutoString(length=2), nullable=False),
    sa.Column('zip_code', sqlmodel.sql.sqltypes.AutoString(length=10), nullable=False),
    sa.Column('owner_name', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=False),
    sa.Column('title', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('owner_mobile', sqlmodel.sql.sqltypes.AutoString(length=20), nullable=False),
    sa.Column('owner_email', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=False),
    sa.Column('reason', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('has_insurance', sqlmodel.sql.sqltypes.AutoString(length=10), nullable=False),
    sa.Column('has_claims_5y', sqlmodel.sql.sqltypes.AutoString(length=10), nullable=False),
    sa.Column('current_provider', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=True),
    sa.Column('policy_expiry', sqlmodel.sql.sqltypes.AutoString(length=20), nullable=True),
    sa.Column('coverages', sa.Text(), nullable=True),
    sa.Column('coverage_types', sa.Text(), nullable=True),
    sa.Column('bop_data', sa.JSON(), nullable=True),
    sa.Column('auto_data', sa.JSON(), nullable=True),
    sa.Column('property_data', sa.JSON(), nullable=True),
    sa.Column('cyber_data', sa.JSON(), nullable=True),
    sa.Column('gl_data', sa.JSON(), nullable=True),
    sa.Column('group_health_data', sa.JSON(), nullable=True),
    sa.Column('group_life_data', sa.JSON(), nullable=True),
    sa.Column('ocean_data', sa.JSON(), nullable=True),
    sa.Column('eando_data', sa.JSON(), nullable=True),
    sa.Column('umbrella_data', sa.JSON(), nullable=True),
    sa.Column('workers_data', sa.JSON(), nullable=True),
    sa.Column('risk_factors', sa.JSON(), nullable=True),
    sa.Column('coverage_preferences', sa.JSON(), nullable=True),
    sa.Column('additional_info', sa.JSON(), nullable=True),
    sa.Column('consent_accepted', sa.Boolean(), nullable=False),
    sa.Column('hipaa_accepted', sa.Boolean(), nullable=False),
    sa.Column('transaction_no', sqlmodel.sql.sqltypes.AutoString(length=50), nullable=True),
    sa.Column('quote_status', sqlmodel.sql.sqltypes.AutoString(length=20), nullable=False),
    sa.Column('created_at', sa.DateTime(), nullable=False),
    sa.Column('updated_at', sa.DateTime(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('business_owner_policies',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('quote_status', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('premium_amount', sa.Float(), nullable=True),
    sa.Column('created_at', sa.DateTime(), nullable=False),
    sa.Column('updated_at', sa.DateTime(), nullable=True),
    sa.Column('business_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('contact_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('email_address', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('phone_number', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('business_address', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('type_of_business', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('business_entity_type', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('years_in_business', sa.Integer(), nullable=False),
    sa.Column('annual_revenue', sa.Float(), nullable=False),
    sa.Column('number_of_employees', sa.Integer(), nullable=False),
    sa.Column('property_owned_or_leased', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('property_addresses', sa.JSON(), nullable=True),
    sa.Column('square_footage', sa.Integer(), nullable=False),
    sa.Column('building_construction_type', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('year_built', sa.Integer(), nullable=False),
    sa.Column('business_personal_property_value', sa.Float(), nullable=False),
    sa.Column('building_value', sa.Float(), nullable=True),
    sa.Column('business_interruption_coverage', sa.Boolean(), nullable=True),
    sa.Column('cyber_liability_coverage', sa.Boolean(), nullable=True),
    sa.Column('hired_non_owned_auto_coverage', sa.Boolean(), nullable=True),
    sa.Column('crime_coverage', sa.Boolean(), nullable=True),
    sa.Column('past_insurance_coverage', sa.Boolean(), nullable=True),
    sa.Column('current_carrier', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('current_policy_expiration_date', sa.Date(), nullable=True),
    sa.Column('prior_claims_last_5_years', sa.Boolean(), nullable=False),
    sa.Column('description_of_past_claims', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('desired_coverage_start_date', sa.Date(), nullable=False),
    sa.Column('desired_property_coverage_limit', sa.Float(), nullable=False),
    sa.Column('desired_general_liability_coverage_limit', sa.Float(), nullable=False),
    sa.Column('deductible_preference', sa.Float(), nullable=True),
    sa.Column('security_safety_features', sa.JSON(), nullable=True),
    sa.Column('additional_insured_parties', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('special_coverage_needs', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('transaction_no', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('businessumbrella',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('business_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('contact_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('email_address', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('phone_number', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('business_address', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('type_of_business', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('business_entity_type', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('number_of_employees', sa.Integer(), nullable=False),
    sa.Column('years_in_operation', sa.Integer(), nullable=False),
    sa.Column('annual_revenue', sa.Float(), nullable=False),
    sa.Column('annual_payroll', sa.Float(), nullable=True),
    sa.Column('total_assets', sa.Float(), nullable=True),
    sa.Column('existing_liability_policies', sa.JSON(), nullable=False),
    sa.Column('total_liability_limits', sa.Float(), nullable=False),
    sa.Column('desired_umbrella_coverage', sa.Float(), nullable=False),
    sa.Column('high_risk_operations', sa.Boolean(), nullable=False),
    sa.Column('high_risk_details', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('prior_umbrella_coverage', sa.Boolean(), nullable=True),
    sa.Column('past_liability_claims', sa.Boolean(), nullable=False),
    sa.Column('past_claims_description', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('pending_lawsuits', sa.Boolean(), nullable=False),
    sa.Column('locations_of_operations', sa.JSON(), nullable=False),
    sa.Column('vehicles_owned', sa.Integer(), nullable=True),
    sa.Column('third_party_contracts', sa.Boolean(), nullable=True),
    sa.Column('desired_policy_start_date', sa.Date(), nullable=False),
    sa.Column('broker_agent_name', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('additional_insured_parties', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('special_coverage_needs', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('transaction_no', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('created_at', sa.DateTime(), nullable=False),
    sa.Column('updated_at', sa.DateTime(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_businessumbrella_business_name'), 'businessumbrella', ['business_name'], unique=False)
    op.create_index(op.f('ix_businessumbrella_email_address'), 'businessumbrella', ['email_address'], unique=False)
    op.create_table('commercial_auto_quotes',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('business_name', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('contact_name', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('email_address', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('phone_number', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('business_address', sqlmodel.sql.sqltypes.AutoString(length=1000), nullable=False),
    sa.Column('type_of_business', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=False),
    sa.Column('business_entity_type', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=True),
    sa.Column('years_in_business', sa.Integer(), nullable=False),
    sa.Column('annual_revenue', sa.Numeric(scale=2), nullable=False),
    sa.Column('number_of_vehicles', sa.Integer(), nullable=False),
    sa.Column('vehicle_list', sqlmodel.sql.sqltypes.AutoString(length=2000), nullable=False),
    sa.Column('vehicle_use_type', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('radius_of_operation', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('garaging_zip_codes', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('vehicles_cross_state_lines', sa.Boolean(), nullable=False),
    sa.Column('driver_list', sqlmodel.sql.sqltypes.AutoString(length=2000), nullable=False),
    sa.Column('driver_experience_years', sa.Integer(), nullable=True),
    sa.Column('drivers_under_25', sa.Boolean(), nullable=False),
    sa.Column('mvr_violations_past_3_years', sa.Boolean(), nullable=False),
    sa.Column('description_of_violations', sqlmodel.sql.sqltypes.AutoString(length=1000), nullable=True),
    sa.Column('accidents_claims_past_5_years', sa.Boolean(), nullable=False),
    sa.Column('description_of_accidents_claims', sqlmodel.sql.sqltypes.AutoString(length=1000), nullable=True),
    sa.Column('current_auto_insurance', sa.Boolean(), nullable=True),
    sa.Column('current_carrier', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=True),
    sa.Column('current_policy_expiration_date', sa.Date(), nullable=True),
    sa.Column('desired_coverage_types', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('desired_coverage_limits', sa.Numeric(scale=2), nullable=False),
    sa.Column('comprehensive_collision_deductibles', sa.Numeric(scale=2), nullable=True),
    sa.Column('hired_non_owned_coverage_needed', sa.Boolean(), nullable=True),
    sa.Column('special_equipment_on_vehicles', sa.Boolean(), nullable=True),
    sa.Column('description_of_equipment', sqlmodel.sql.sqltypes.AutoString(length=1000), nullable=True),
    sa.Column('desired_policy_start_date', sa.Date(), nullable=False),
    sa.Column('broker_agent_name', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=True),
    sa.Column('notes_special_requests', sqlmodel.sql.sqltypes.AutoString(length=1000), nullable=True),
    sa.Column('quote_status', sqlmodel.sql.sqltypes.AutoString(length=50), nullable=False),
    sa.Column('premium_amount', sa.Numeric(scale=2), nullable=True),
    sa.Column('created_at', sa.DateTime(), nullable=False),
    sa.Column('updated_at', sa.DateTime(), nullable=True),
    sa.Column('transaction_no', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('commercial_property_quotes',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('quote_status', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('premium_amount', sa.Float(), nullable=True),
    sa.Column('created_at', sa.DateTime(), nullable=False),
    sa.Column('updated_at', sa.DateTime(), nullable=True),
    sa.Column('business_name', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('contact_name', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('email_address', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('phone_number', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('business_address', sqlmodel.sql.sqltypes.AutoString(length=1000), nullable=False),
    sa.Column('type_of_business', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=False),
    sa.Column('business_entity_type', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=True),
    sa.Column('years_in_business', sa.Integer(), nullable=False),
    sa.Column('annual_revenue', sa.Numeric(scale=2), nullable=False),
    sa.Column('number_of_employees', sa.Integer(), nullable=False),
    sa.Column('number_of_locations', sa.Integer(), nullable=False),
    sa.Column('property_addresses', sqlmodel.sql.sqltypes.AutoString(length=2000), nullable=False),
    sa.Column('ownership_status', sqlmodel.sql.sqltypes.AutoString(length=50), nullable=False),
    sa.Column('building_use', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('building_construction_type', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('year_built', sa.Integer(), nullable=False),
    sa.Column('square_footage', sa.Integer(), nullable=False),
    sa.Column('building_replacement_value', sa.Numeric(scale=2), nullable=False),
    sa.Column('contents_inventory_value', sa.Numeric(scale=2), nullable=False),
    sa.Column('business_interruption_coverage_needed', sa.Boolean(), nullable=True),
    sa.Column('business_income_annual', sa.Numeric(scale=2), nullable=True),
    sa.Column('security_features', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=True),
    sa.Column('distance_to_fire_hydrant_ft', sa.Integer(), nullable=True),
    sa.Column('distance_to_fire_station_miles', sa.Float(), nullable=True),
    sa.Column('existing_property_insurance', sa.Boolean(), nullable=True),
    sa.Column('current_carrier', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=True),
    sa.Column('policy_expiration_date', sa.Date(), nullable=True),
    sa.Column('prior_claims_last_5_years', sa.Boolean(), nullable=False),
    sa.Column('description_of_past_claims', sqlmodel.sql.sqltypes.AutoString(length=2000), nullable=True),
    sa.Column('desired_coverage_start_date', sa.Date(), nullable=False),
    sa.Column('desired_deductible', sa.Numeric(scale=2), nullable=True),
    sa.Column('desired_coverage_limit', sa.Numeric(scale=2), nullable=False),
    sa.Column('special_requirements_notes', sqlmodel.sql.sqltypes.AutoString(length=2000), nullable=True),
    sa.Column('transaction_no', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('cyberliability',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('business_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('contact_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('email_address', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('phone_number', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('business_address', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('website_url', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('type_of_business', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('business_entity_type', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('years_in_business', sa.Integer(), nullable=False),
    sa.Column('annual_revenue', sa.Float(), nullable=False),
    sa.Column('number_of_employees', sa.Integer(), nullable=False),
    sa.Column('number_of_records_stored', sa.Integer(), nullable=False),
    sa.Column('types_of_sensitive_data', sa.JSON(), nullable=False),
    sa.Column('use_of_cloud_providers', sa.Boolean(), nullable=False),
    sa.Column('cloud_provider_details', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('percentage_business_online', sa.Float(), nullable=True),
    sa.Column('cybersecurity_frameworks', sa.JSON(), nullable=True),
    sa.Column('endpoint_protection', sa.Boolean(), nullable=True),
    sa.Column('mfa_used', sa.Boolean(), nullable=False),
    sa.Column('cybersecurity_training', sa.Boolean(), nullable=True),
    sa.Column('data_encryption', sa.Boolean(), nullable=False),
    sa.Column('prior_cyber_insurance', sa.Boolean(), nullable=True),
    sa.Column('previous_insurer', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('current_policy_expiration', sa.Date(), nullable=True),
    sa.Column('prior_cyber_incidents', sa.Boolean(), nullable=False),
    sa.Column('past_incidents_description', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('desired_coverage_limit', sa.Float(), nullable=False),
    sa.Column('desired_deductible', sa.Float(), nullable=True),
    sa.Column('compliance_requirements', sa.JSON(), nullable=True),
    sa.Column('third_party_vendors_access', sa.Boolean(), nullable=True),
    sa.Column('incident_response_plan', sa.Boolean(), nullable=True),
    sa.Column('desired_policy_start_date', sa.Date(), nullable=False),
    sa.Column('special_coverage_notes', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('transaction_no', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('created_at', sa.DateTime(), nullable=False),
    sa.Column('updated_at', sa.DateTime(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_cyberliability_business_name'), 'cyberliability', ['business_name'], unique=False)
    op.create_index(op.f('ix_cyberliability_email_address'), 'cyberliability', ['email_address'], unique=False)
    op.create_table('generalliability',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('business_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('contact_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('email_address', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('phone_number', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('business_address', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('type_of_business', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('business_entity_type', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('years_in_business', sa.Integer(), nullable=False),
    sa.Column('fein', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('number_of_employees', sa.Integer(), nullable=False),
    sa.Column('estimated_annual_revenue', sa.Float(), nullable=False),
    sa.Column('estimated_annual_payroll', sa.Float(), nullable=True),
    sa.Column('primary_business_activities', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('premises_owned_or_leased', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('square_footage', sa.Integer(), nullable=True),
    sa.Column('subcontractors_used', sa.Boolean(), nullable=False),
    sa.Column('percentage_subcontracted', sa.Float(), nullable=True),
    sa.Column('require_subcontractor_insurance', sa.Boolean(), nullable=True),
    sa.Column('collect_certificates', sa.Boolean(), nullable=True),
    sa.Column('states_of_operation', sa.JSON(), nullable=False),
    sa.Column('customers_visit_location', sa.Boolean(), nullable=False),
    sa.Column('high_risk_operations', sa.Boolean(), nullable=True),
    sa.Column('high_risk_description', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('prior_liability_coverage', sa.Boolean(), nullable=True),
    sa.Column('previous_carrier', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('policy_expiration_date', sa.Date(), nullable=True),
    sa.Column('past_liability_claims', sa.Boolean(), nullable=False),
    sa.Column('claims_description', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('desired_coverage_limit', sa.Float(), nullable=False),
    sa.Column('desired_deductible', sa.Float(), nullable=True),
    sa.Column('additional_insured_parties', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('certificate_needed', sa.Boolean(), nullable=True),
    sa.Column('desired_policy_start_date', sa.Date(), nullable=False),
    sa.Column('notes', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('transaction_no', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('created_at', sa.DateTime(), nullable=False),
    sa.Column('updated_at', sa.DateTime(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_generalliability_business_name'), 'generalliability', ['business_name'], unique=False)
    op.create_index(op.f('ix_generalliability_email_address'), 'generalliability', ['email_address'], unique=False)
    op.create_table('group_health_quotes',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('company_name', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('industry_sic_code', sqlmodel.sql.sqltypes.AutoString(length=50), nullable=False),
    sa.Column('company_address', sqlmodel.sql.sqltypes.AutoString(length=1000), nullable=False),
    sa.Column('city', sqlmodel.sql.sqltypes.AutoString(length=200), nullable=False),
    sa.Column('state', sqlmodel.sql.sqltypes.AutoString(length=10), nullable=False),
    sa.Column('zip_code', sqlmodel.sql.sqltypes.AutoString(length=50), nullable=False),
    sa.Column('federal_tax_id', sqlmodel.sql.sqltypes.AutoString(length=50), nullable=True),
    sa.Column('number_of_employees', sa.Integer(), nullable=False),
    sa.Column('number_of_employees_to_be_covered', sa.Integer(), nullable=False),
    sa.Column('average_age_of_employees', sa.Float(), nullable=True),
    sa.Column('employee_census_file_path', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=True),
    sa.Column('type_of_coverage_requested', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('desired_coverage_start_date', sa.Date(), nullable=False),
    sa.Column('current_insurance_carrier', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=True),
    sa.Column('current_plan_type', sqlmodel.sql.sqltypes.AutoString(length=50), nullable=True),
    sa.Column('monthly_premium_current_plan', sa.Numeric(scale=2), nullable=True),
    sa.Column('contribution_strategy', sqlmodel.sql.sqltypes.AutoString(length=50), nullable=True),
    sa.Column('waiting_period_new_employees', sqlmodel.sql.sqltypes.AutoString(length=20), nullable=True),
    sa.Column('broker_agent_involved', sa.Boolean(), nullable=False),
    sa.Column('broker_agent_name', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=True),
    sa.Column('contact_person_name', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('contact_email', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('contact_phone', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('preferred_contact_method', sqlmodel.sql.sqltypes.AutoString(length=20), nullable=True),
    sa.Column('notes_special_requirements', sqlmodel.sql.sqltypes.AutoString(length=2000), nullable=True),
    sa.Column('quote_status', sqlmodel.sql.sqltypes.AutoString(length=50), nullable=False),
    sa.Column('premium_amount', sa.Numeric(scale=2), nullable=True),
    sa.Column('created_at', sa.DateTime(), nullable=False),
    sa.Column('updated_at', sa.DateTime(), nullable=True),
    sa.Column('transaction_no', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('group_life_quotes',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('company_name', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('industry_type', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('federal_tax_id', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=False),
    sa.Column('company_address', sqlmodel.sql.sqltypes.AutoString(length=1000), nullable=False),
    sa.Column('contact_name', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('contact_email', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('contact_phone', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('type_of_group', sqlmodel.sql.sqltypes.AutoString(length=50), nullable=False),
    sa.Column('number_of_eligible_employees', sa.Integer(), nullable=False),
    sa.Column('number_of_employees_to_be_insured', sa.Integer(), nullable=False),
    sa.Column('employee_locations', sqlmodel.sql.sqltypes.AutoString(length=1000), nullable=False),
    sa.Column('coverage_type_requested', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('requested_effective_date', sa.Date(), nullable=False),
    sa.Column('current_group_life_carrier', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=True),
    sa.Column('current_monthly_premium', sa.Numeric(scale=2), nullable=True),
    sa.Column('current_benefit_design', sqlmodel.sql.sqltypes.AutoString(length=1000), nullable=True),
    sa.Column('desired_benefit_design', sqlmodel.sql.sqltypes.AutoString(length=1000), nullable=True),
    sa.Column('employer_contribution_percentage', sa.Float(), nullable=True),
    sa.Column('waiting_period_eligibility', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=False),
    sa.Column('class_structure', sqlmodel.sql.sqltypes.AutoString(length=1000), nullable=True),
    sa.Column('union_non_union_mix', sqlmodel.sql.sqltypes.AutoString(length=20), nullable=True),
    sa.Column('renewal_month', sqlmodel.sql.sqltypes.AutoString(length=20), nullable=True),
    sa.Column('broker_consultant_name', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=True),
    sa.Column('additional_notes', sqlmodel.sql.sqltypes.AutoString(length=1000), nullable=True),
    sa.Column('employee_census_file_path', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=True),
    sa.Column('quote_status', sqlmodel.sql.sqltypes.AutoString(length=50), nullable=False),
    sa.Column('premium_amount', sa.Numeric(scale=2), nullable=True),
    sa.Column('created_at', sa.DateTime(), nullable=False),
    sa.Column('updated_at', sa.DateTime(), nullable=True),
    sa.Column('transaction_no', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('grouplife',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('company_name', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('industry_type', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('federal_tax_id', sqlmodel.sql.sqltypes.AutoString(length=9), nullable=False),
    sa.Column('company_address', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=False),
    sa.Column('contact_name', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('contact_email', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('contact_phone', sqlmodel.sql.sqltypes.AutoString(length=20), nullable=False),
    sa.Column('group_type', sqlmodel.sql.sqltypes.AutoString(length=50), nullable=False),
    sa.Column('eligible_employees', sa.Integer(), nullable=False),
    sa.Column('insured_employees', sa.Integer(), nullable=False),
    sa.Column('employee_locations', sa.JSON(), nullable=False),
    sa.Column('coverage_types', sa.JSON(), nullable=False),
    sa.Column('effective_date', sa.Date(), nullable=False),
    sa.Column('current_carrier', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=True),
    sa.Column('current_premium', sa.Float(), nullable=True),
    sa.Column('current_benefit_design', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('desired_benefit_design', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('employer_contribution', sa.Float(), nullable=True),
    sa.Column('waiting_period', sqlmodel.sql.sqltypes.AutoString(length=50), nullable=False),
    sa.Column('class_structure', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('union_mix', sqlmodel.sql.sqltypes.AutoString(length=50), nullable=True),
    sa.Column('renewal_month', sqlmodel.sql.sqltypes.AutoString(length=20), nullable=True),
    sa.Column('broker_name', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=True),
    sa.Column('notes', sqlmodel.sql.sqltypes.AutoString(length=1000), nullable=True),
    sa.Column('census_file_path', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=False),
    sa.Column('transaction_no', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('created_at', sa.DateTime(), nullable=False),
    sa.Column('updated_at', sa.DateTime(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_grouplife_company_name'), 'grouplife', ['company_name'], unique=False)
    op.create_index(op.f('ix_grouplife_contact_email'), 'grouplife', ['contact_email'], unique=False)
    op.create_index(op.f('ix_grouplife_federal_tax_id'), 'grouplife', ['federal_tax_id'], unique=False)
    op.create_table('health_insurance',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('quote_status', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('premium_amount', sa.Float(), nullable=True),
    sa.Column('created_at', sa.DateTime(), nullable=False),
    sa.Column('updated_at', sa.DateTime(), nullable=True),
    sa.Column('full_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('date_of_birth', sa.Date(), nullable=False),
    sa.Column('gender', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('email', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('phone_number', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('residential_address', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('zip_code', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('tobacco_usage', sa.Boolean(), nullable=False),
    sa.Column('current_health_plan', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('takes_prescription_meds', sa.Boolean(), nullable=True),
    sa.Column('estimated_annual_income', sa.Float(), nullable=True),
    sa.Column('household_size', sa.Integer(), nullable=False),
    sa.Column('add_dependents', sa.Boolean(), nullable=False),
    sa.Column('dependent_info', sa.JSON(), nullable=True),
    sa.Column('coverage_start_date', sa.Date(), nullable=False),
    sa.Column('preferred_plan_type', sa.JSON(), nullable=True),
    sa.Column('preferred_insurance_carriers', sa.JSON(), nullable=True),
    sa.Column('primary_doctor_name', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('top_health_concerns', sa.JSON(), nullable=True),
    sa.Column('monthly_budget_premium', sa.Float(), nullable=True),
    sa.Column('consent_to_share', sa.Boolean(), nullable=False),
    sa.Column('transaction_no', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('homeinsurance',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('first_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('last_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('date_of_birth', sa.Date(), nullable=False),
    sa.Column('phone_number', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('email', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('property_address', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('city', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('state', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('zip_code', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('property_type', sa.Enum('single_family', 'condo', 'townhouse', 'rental', 'multi_family', name='propertytype'), nullable=False),
    sa.Column('year_built', sa.Integer(), nullable=False),
    sa.Column('square_footage', sa.Integer(), nullable=False),
    sa.Column('construction_type', sa.Enum('frame', 'masonry', 'brick', 'steel', 'other', name='constructiontype'), nullable=False),
    sa.Column('roof_type', sa.Enum('asphalt', 'metal', 'tile', 'flat', 'other', name='rooftype'), nullable=True),
    sa.Column('roof_year_replaced', sa.Integer(), nullable=True),
    sa.Column('number_of_stories', sa.Integer(), nullable=True),
    sa.Column('number_of_bedrooms', sa.Integer(), nullable=True),
    sa.Column('number_of_bathrooms', sa.Integer(), nullable=True),
    sa.Column('heating_type', sa.Enum('gas', 'electric', 'oil', 'propane', 'other', name='heatingtype'), nullable=True),
    sa.Column('primary_residence', sa.Boolean(), nullable=False),
    sa.Column('occupancy_type', sa.Enum('owner', 'tenant', 'seasonal', 'vacant', 'under_construction', name='occupancytype'), nullable=False),
    sa.Column('home_security_system', sa.Boolean(), nullable=True),
    sa.Column('fire_alarm_smoke_detector', sa.Boolean(), nullable=True),
    sa.Column('swimming_pool', sa.Boolean(), nullable=True),
    sa.Column('trampoline', sa.Boolean(), nullable=True),
    sa.Column('pets', sa.Boolean(), nullable=True),
    sa.Column('estimated_replacement_cost', sa.Numeric(), nullable=True),
    sa.Column('mortgage_lender_name', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('prior_claims_last_5_years', sa.Integer(), nullable=True),
    sa.Column('current_insurance_provider', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('desired_coverage_start_date', sa.Date(), nullable=False),
    sa.Column('preferred_coverage_level', sa.Enum('basic', 'standard', 'comprehensive', name='coveragelevel'), nullable=True),
    sa.Column('transaction_no', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('life_insurance',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('quote_status', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('premium_amount', sa.Float(), nullable=True),
    sa.Column('created_at', sa.DateTime(), nullable=False),
    sa.Column('updated_at', sa.DateTime(), nullable=True),
    sa.Column('full_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('date_of_birth', sa.Date(), nullable=False),
    sa.Column('gender', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('email_address', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('phone_number', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('state', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('zip_code', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('marital_status', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('ssn_last4', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('address_line1', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('address_line2', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('city', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('employment_status', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('occupation', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('annual_income', sa.Float(), nullable=True),
    sa.Column('height', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('weight', sa.Float(), nullable=False),
    sa.Column('tobacco_use', sa.Boolean(), nullable=False),
    sa.Column('alcohol_consumption', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('existing_conditions', sa.JSON(), nullable=True),
    sa.Column('medications', sa.JSON(), nullable=True),
    sa.Column('family_history', sa.JSON(), nullable=True),
    sa.Column('coverage_amount', sa.Float(), nullable=False),
    sa.Column('coverage_term', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('product_type', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('premium_budget', sa.Float(), nullable=True),
    sa.Column('payment_frequency', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('riders', sa.JSON(), nullable=True),
    sa.Column('primary_beneficiary_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('primary_beneficiary_relationship', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('beneficiary_percentage', sa.Float(), nullable=False),
    sa.Column('contingent_beneficiary_name', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('contingent_beneficiary_relationship', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('citizenship_status', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('country_of_citizenship', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('us_citizen', sa.Boolean(), nullable=False),
    sa.Column('criminal_record', sa.Boolean(), nullable=True),
    sa.Column('bankruptcy_history', sa.Boolean(), nullable=True),
    sa.Column('consent_to_contact', sa.Boolean(), nullable=False),
    sa.Column('consent_to_share_data', sa.Boolean(), nullable=False),
    sa.Column('signature', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('transaction_no', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('ocean_marine_quotes',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('quote_status', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('premium_amount', sa.Float(), nullable=True),
    sa.Column('created_at', sa.DateTime(), nullable=False),
    sa.Column('updated_at', sa.DateTime(), nullable=True),
    sa.Column('business_name', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('contact_name', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('email_address', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('phone_number', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('business_address', sqlmodel.sql.sqltypes.AutoString(length=1000), nullable=False),
    sa.Column('type_of_operation', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('description_of_goods', sqlmodel.sql.sqltypes.AutoString(length=2000), nullable=False),
    sa.Column('value_per_shipment', sa.Numeric(scale=2), nullable=False),
    sa.Column('annual_cargo_value', sa.Numeric(scale=2), nullable=False),
    sa.Column('shipping_methods', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('countries_of_origin', sqlmodel.sql.sqltypes.AutoString(length=1000), nullable=False),
    sa.Column('countries_of_destination', sqlmodel.sql.sqltypes.AutoString(length=1000), nullable=False),
    sa.Column('packaging_type', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=True),
    sa.Column('vessel_information', sqlmodel.sql.sqltypes.AutoString(length=1000), nullable=True),
    sa.Column('own_vessel', sa.Boolean(), nullable=False),
    sa.Column('number_of_shipments_per_year', sa.Integer(), nullable=False),
    sa.Column('max_value_single_shipment', sa.Numeric(scale=2), nullable=False),
    sa.Column('past_claims_history', sqlmodel.sql.sqltypes.AutoString(length=2000), nullable=True),
    sa.Column('desired_policy_start_date', sa.Date(), nullable=False),
    sa.Column('desired_coverage_types', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=True),
    sa.Column('deductible_preference', sa.Numeric(scale=2), nullable=True),
    sa.Column('certificate_insurance_needed', sa.Boolean(), nullable=True),
    sa.Column('additional_insured_parties', sqlmodel.sql.sqltypes.AutoString(length=1000), nullable=True),
    sa.Column('special_coverage_requirements', sqlmodel.sql.sqltypes.AutoString(length=2000), nullable=True),
    sa.Column('transaction_no', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('personalautoinsurance',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('quote_reference_id', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('submission_timestamp', sa.DateTime(), nullable=False),
    sa.Column('first_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('last_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('date_of_birth', sa.Date(), nullable=False),
    sa.Column('gender', sa.Enum('male', 'female', 'non_binary', 'prefer_not_say', name='genderenum'), nullable=True),
    sa.Column('marital_status', sa.Enum('single', 'married', 'divorced', 'widowed', name='maritalstatusenum'), nullable=True),
    sa.Column('driver_license_number', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('license_state', sqlmodel.sql.sqltypes.AutoString(length=2), nullable=False),
    sa.Column('years_licensed', sa.Integer(), nullable=False),
    sa.Column('email', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('phone_number', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('non_us_citizen', sa.Boolean(), nullable=True),
    sa.Column('street_address', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('city', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('state', sqlmodel.sql.sqltypes.AutoString(length=2), nullable=False),
    sa.Column('zip_code', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('county', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('residence_type', sa.Enum('own', 'rent', 'lease', 'other', name='residencetypeenum'), nullable=True),
    sa.Column('duration_at_address', sa.Integer(), nullable=True),
    sa.Column('vehicle_year', sa.Integer(), nullable=False),
    sa.Column('make', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('model', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('trim', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('vin', sqlmodel.sql.sqltypes.AutoString(length=17), nullable=True),
    sa.Column('ownership_type', sa.Enum('owned', 'financed', 'leased', name='ownershiptypeenum'), nullable=True),
    sa.Column('primary_use', sa.Enum('commute', 'pleasure', 'business', 'farm', name='primaryuseenum'), nullable=True),
    sa.Column('annual_mileage', sa.Integer(), nullable=False),
    sa.Column('days_driven_per_week', sa.Integer(), nullable=True),
    sa.Column('distance_to_work', sa.Integer(), nullable=True),
    sa.Column('garaging_zip', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('anti_theft_device', sa.Boolean(), nullable=True),
    sa.Column('safety_features', sa.JSON(), nullable=True),
    sa.Column('number_of_drivers', sa.Integer(), nullable=False),
    sa.Column('relationship_to_applicant', sa.Enum('self', 'spouse', 'child', 'parent', 'other', name='relationshipenum'), nullable=False),
    sa.Column('driver_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('driver_dob', sa.Date(), nullable=False),
    sa.Column('license_number', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('driver_years_licensed', sa.Integer(), nullable=False),
    sa.Column('accidents_last_5yrs', sa.Integer(), nullable=True),
    sa.Column('violations_last_5yrs', sa.Integer(), nullable=True),
    sa.Column('sr22_required', sa.Boolean(), nullable=True),
    sa.Column('education_level', sa.Enum('high_school', 'college', 'post_grad', 'other', name='educationlevelenum'), nullable=True),
    sa.Column('occupation', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('coverage_type', sa.Enum('liability_only', 'full_coverage', name='coveragetypeenum'), nullable=False),
    sa.Column('bodily_injury_liability', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('property_damage_liability', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('medical_payments', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('uninsured_motorist_coverage', sa.Boolean(), nullable=True),
    sa.Column('collision_deductible', sa.Integer(), nullable=True),
    sa.Column('comprehensive_deductible', sa.Integer(), nullable=True),
    sa.Column('rental_reimbursement', sa.Boolean(), nullable=True),
    sa.Column('roadside_assistance', sa.Boolean(), nullable=True),
    sa.Column('gap_coverage', sa.Boolean(), nullable=True),
    sa.Column('currently_insured', sa.Boolean(), nullable=False),
    sa.Column('current_carrier', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('policy_expiration_date', sa.Date(), nullable=True),
    sa.Column('years_continuously_insured', sa.Integer(), nullable=True),
    sa.Column('prior_lapse', sa.Boolean(), nullable=True),
    sa.Column('claims_past_5yrs', sa.Integer(), nullable=True),
    sa.Column('good_student_discount', sa.Boolean(), nullable=True),
    sa.Column('multi_car_discount', sa.Boolean(), nullable=True),
    sa.Column('multi_policy_discount', sa.Boolean(), nullable=True),
    sa.Column('safe_driver_discount', sa.Boolean(), nullable=True),
    sa.Column('defensive_driving_course', sa.Boolean(), nullable=True),
    sa.Column('paperless_preference', sa.Boolean(), nullable=True),
    sa.Column('payment_preference', sa.Enum('monthly', 'quarterly', 'annual', name='paymentpreferenceenum'), nullable=True),
    sa.Column('preferred_quote_delivery', sa.Enum('email', 'sms', 'call', name='preferredquotedeliveryenum'), nullable=True),
    sa.Column('agent_id', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('source_platform', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('transaction_no', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_personalautoinsurance_quote_reference_id'), 'personalautoinsurance', ['quote_reference_id'], unique=False)
    op.create_table('professionalliability',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('business_name', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=False),
    sa.Column('contact_name', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('email_address', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=False),
    sa.Column('phone_number', sqlmodel.sql.sqltypes.AutoString(length=20), nullable=False),
    sa.Column('business_address', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=False),
    sa.Column('business_type', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('description_of_services', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('number_of_employees', sa.Integer(), nullable=False),
    sa.Column('years_in_business', sa.Integer(), nullable=False),
    sa.Column('annual_revenue', sa.Float(), nullable=False),
    sa.Column('states_of_operation', sa.JSON(), nullable=True),
    sa.Column('current_insurance_carrier', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=True),
    sa.Column('current_policy_expiration', sa.Date(), nullable=True),
    sa.Column('requested_coverage_limit', sa.Float(), nullable=False),
    sa.Column('requested_deductible', sa.Float(), nullable=True),
    sa.Column('coverage_basis', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('retroactive_needed', sa.Boolean(), nullable=True),
    sa.Column('retroactive_date', sa.Date(), nullable=True),
    sa.Column('prior_claims', sa.Boolean(), nullable=False),
    sa.Column('prior_claims_details', sa.Text(), nullable=True),
    sa.Column('subcontracted_services', sa.Boolean(), nullable=False),
    sa.Column('subcontracted_percentage', sa.Float(), nullable=True),
    sa.Column('coverage_for_contractors', sa.Boolean(), nullable=True),
    sa.Column('contracts_reviewed_legal', sa.Boolean(), nullable=True),
    sa.Column('professional_licenses', sa.Text(), nullable=True),
    sa.Column('desired_policy_start', sa.Date(), nullable=False),
    sa.Column('additional_insured', sa.Text(), nullable=True),
    sa.Column('special_coverage_needs', sa.Text(), nullable=True),
    sa.Column('transaction_no', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('created_at', sa.DateTime(), nullable=False),
    sa.Column('updated_at', sa.DateTime(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('renters_insurance',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('quote_status', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('premium_amount', sa.Float(), nullable=True),
    sa.Column('created_at', sa.DateTime(), nullable=False),
    sa.Column('updated_at', sa.DateTime(), nullable=True),
    sa.Column('property_address', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('city', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('state', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('zip_code', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('property_type', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('year_built', sa.Integer(), nullable=True),
    sa.Column('number_of_units_in_building', sa.Integer(), nullable=True),
    sa.Column('first_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('last_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('date_of_birth', sa.Date(), nullable=False),
    sa.Column('email_address', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('phone_number', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('occupation', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('marital_status', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('number_of_occupants', sa.Integer(), nullable=True),
    sa.Column('personal_property_coverage', sa.Float(), nullable=False),
    sa.Column('liability_coverage', sa.Float(), nullable=False),
    sa.Column('medical_payments_coverage', sa.Float(), nullable=True),
    sa.Column('deductible', sa.Float(), nullable=False),
    sa.Column('loss_of_use_coverage', sa.Float(), nullable=True),
    sa.Column('replacement_cost_coverage', sa.Boolean(), nullable=True),
    sa.Column('scheduled_personal_property', sa.JSON(), nullable=True),
    sa.Column('policy_term', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('preferred_start_date', sa.Date(), nullable=False),
    sa.Column('payment_plan', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('payment_method', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('auto_pay_enrollment', sa.Boolean(), nullable=True),
    sa.Column('security_system_present', sa.Boolean(), nullable=True),
    sa.Column('sprinkler_system', sa.Boolean(), nullable=True),
    sa.Column('smoke_detectors', sa.Boolean(), nullable=True),
    sa.Column('claims_in_past_5_years', sa.Integer(), nullable=True),
    sa.Column('prior_carrier', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('prior_policy_expiration_date', sa.Date(), nullable=True),
    sa.Column('pet_ownership', sa.Boolean(), nullable=True),
    sa.Column('dog_breed', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('roommates_present', sa.Boolean(), nullable=True),
    sa.Column('landlord_information', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('additional_insured', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('transaction_no', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('umbrella_insurance',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('quote_status', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('premium_amount', sa.Float(), nullable=True),
    sa.Column('created_at', sa.DateTime(), nullable=False),
    sa.Column('updated_at', sa.DateTime(), nullable=True),
    sa.Column('full_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('date_of_birth', sa.Date(), nullable=False),
    sa.Column('email_address', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('mobile_phone', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('residential_address', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('state_of_residence', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('home_ownership', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('homeowner_renters_provider', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('owns_rental_property', sa.Boolean(), nullable=False),
    sa.Column('number_of_vehicles', sa.Integer(), nullable=False),
    sa.Column('auto_insurance_provider', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('owns_boat_atv_rv', sa.Boolean(), nullable=False),
    sa.Column('teen_drivers_in_home', sa.Boolean(), nullable=False),
    sa.Column('high_risk_pets', sa.Boolean(), nullable=False),
    sa.Column('liability_claims_last_5_years', sa.Boolean(), nullable=False),
    sa.Column('annual_household_income', sa.Float(), nullable=False),
    sa.Column('total_net_worth', sa.Float(), nullable=False),
    sa.Column('desired_coverage_amount', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('preferred_contact_method', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('additional_notes', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('transaction_no', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_table('unifiedcommercial',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('business_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('contact_name', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('email_address', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('phone_number', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('business_address', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('type_of_business', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('business_entity_type', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('years_in_business', sa.Integer(), nullable=False),
    sa.Column('annual_revenue', sa.Float(), nullable=False),
    sa.Column('number_of_employees', sa.Integer(), nullable=False),
    sa.Column('currently_insured', sa.Boolean(), nullable=True),
    sa.Column('current_carrier', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('policy_expiration_date', sa.Date(), nullable=True),
    sa.Column('past_claims', sa.Boolean(), nullable=False),
    sa.Column('past_claims_description', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('insurance_products_requested', sa.JSON(), nullable=False),
    sa.Column('desired_coverage_start_date', sa.Date(), nullable=False),
    sa.Column('desired_liability_coverage_limit', sa.Float(), nullable=True),
    sa.Column('desired_property_coverage_limit', sa.Float(), nullable=True),
    sa.Column('desired_deductible', sa.Float(), nullable=True),
    sa.Column('business_description', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('locations_of_operation', sa.JSON(), nullable=True),
    sa.Column('property_owned_or_leased', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('vehicles_owned', sa.Integer(), nullable=True),
    sa.Column('number_of_locations', sa.Integer(), nullable=True),
    sa.Column('cyber_liability_needed', sa.Boolean(), nullable=True),
    sa.Column('stores_sensitive_customer_data', sa.Boolean(), nullable=True),
    sa.Column('security_features', sa.JSON(), nullable=True),
    sa.Column('additional_insured_parties', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('special_notes', sqlmodel.sql.sqltypes.AutoString(), nullable=True),
    sa.Column('transaction_no', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('created_at', sa.DateTime(), nullable=False),
    sa.Column('updated_at', sa.DateTime(), nullable=True),
    sa.PrimaryKeyConstraint('id')
    )
    op.create_index(op.f('ix_unifiedcommercial_business_name'), 'unifiedcommercial', ['business_name'], unique=False)
    op.create_index(op.f('ix_unifiedcommercial_email_address'), 'unifiedcommercial', ['email_address'], unique=False)
    op.create_table('workers_compensation_quotes',
    sa.Column('id', sa.Integer(), nullable=False),
    sa.Column('quote_status', sqlmodel.sql.sqltypes.AutoString(), nullable=False),
    sa.Column('premium_amount', sa.Float(), nullable=True),
    sa.Column('created_at', sa.DateTime(), nullable=False),
    sa.Column('updated_at', sa.DateTime(), nullable=True),
    sa.Column('business_name', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('contact_name', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('email_address', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('phone_number', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.Column('business_address', sqlmodel.sql.sqltypes.AutoString(length=1000), nullable=False),
    sa.Column('type_of_business', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=False),
    sa.Column('business_entity_type', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=True),
    sa.Column('years_in_business', sa.Integer(), nullable=False),
    sa.Column('fein', sqlmodel.sql.sqltypes.AutoString(length=50), nullable=False),
    sa.Column('number_of_employees', sa.Integer(), nullable=False),
    sa.Column('employee_job_classifications', sqlmodel.sql.sqltypes.AutoString(length=2000), nullable=False),
    sa.Column('annual_payroll_by_classification', sqlmodel.sql.sqltypes.AutoString(length=2000), nullable=False),
    sa.Column('states_of_operation', sqlmodel.sql.sqltypes.AutoString(length=500), nullable=False),
    sa.Column('independent_contractors', sa.Boolean(), nullable=False),
    sa.Column('number_of_contractors', sa.Integer(), nullable=True),
    sa.Column('coverage_for_1099s', sa.Boolean(), nullable=True),
    sa.Column('temp_seasonal_volunteer_workers', sa.Boolean(), nullable=True),
    sa.Column('prior_policy', sa.Boolean(), nullable=True),
    sa.Column('prior_insurance_carrier', sqlmodel.sql.sqltypes.AutoString(length=255), nullable=True),
    sa.Column('current_policy_expiration_date', sa.Date(), nullable=True),
    sa.Column('past_workers_comp_claims', sa.Boolean(), nullable=False),
    sa.Column('description_of_prior_claims', sqlmodel.sql.sqltypes.AutoString(length=2000), nullable=True),
    sa.Column('osha_violations_past_3_years', sa.Boolean(), nullable=True),
    sa.Column('safety_program_in_place', sa.Boolean(), nullable=True),
    sa.Column('desired_effective_date', sa.Date(), nullable=False),
    sa.Column('additional_notes', sqlmodel.sql.sqltypes.AutoString(length=2000), nullable=True),
    sa.Column('transaction_no', sqlmodel.sql.sqltypes.AutoString(length=100), nullable=False),
    sa.PrimaryKeyConstraint('id')
    )
    # ### end Alembic commands ###


def downgrade() -> None:
    """Downgrade schema."""
    # ### commands auto generated by Alembic - please adjust! ###
    op.drop_table('workers_compensation_quotes')
    op.drop_index(op.f('ix_unifiedcommercial_email_address'), table_name='unifiedcommercial')
    op.drop_index(op.f('ix_unifiedcommercial_business_name'), table_name='unifiedcommercial')
    op.drop_table('unifiedcommercial')
    op.drop_table('umbrella_insurance')
    op.drop_table('renters_insurance')
    op.drop_table('professionalliability')
    op.drop_index(op.f('ix_personalautoinsurance_quote_reference_id'), table_name='personalautoinsurance')
    op.drop_table('personalautoinsurance')
    op.drop_table('ocean_marine_quotes')
    op.drop_table('life_insurance')
    op.drop_table('homeinsurance')
    op.drop_table('health_insurance')
    op.drop_index(op.f('ix_grouplife_federal_tax_id'), table_name='grouplife')
    op.drop_index(op.f('ix_grouplife_contact_email'), table_name='grouplife')
    op.drop_index(op.f('ix_grouplife_company_name'), table_name='grouplife')
    op.drop_table('grouplife')
    op.drop_table('group_life_quotes')
    op.drop_table('group_health_quotes')
    op.drop_index(op.f('ix_generalliability_email_address'), table_name='generalliability')
    op.drop_index(op.f('ix_generalliability_business_name'), table_name='generalliability')
    op.drop_table('generalliability')
    op.drop_index(op.f('ix_cyberliability_email_address'), table_name='cyberliability')
    op.drop_index(op.f('ix_cyberliability_business_name'), table_name='cyberliability')
    op.drop_table('cyberliability')
    op.drop_table('commercial_property_quotes')
    op.drop_table('commercial_auto_quotes')
    op.drop_index(op.f('ix_businessumbrella_email_address'), table_name='businessumbrella')
    op.drop_index(op.f('ix_businessumbrella_business_name'), table_name='businessumbrella')
    op.drop_table('businessumbrella')
    op.drop_table('business_owner_policies')
    op.drop_table('business_insurance')
    op.drop_table('annuity_insurance')
    op.drop_table('agriculture_insurance')
    # ### end Alembic commands ###
