def METHOD_NAME() -> None:
    op.drop_index(
        op.f('ix_proposal_membership_active'), table_name='proposal_membership'
    )
    op.drop_index(
        op.f('ix_proposal_membership_user_id'), table_name='proposal_membership'
    )
    op.drop_table('proposal_membership')
    op.drop_index(
        op.f('ix_project_crew_membership_active'), table_name='project_crew_membership'
    )
    op.drop_index(
        op.f('ix_project_crew_membership_user_id'), table_name='project_crew_membership'
    )
    op.drop_table('project_crew_membership')
    op.drop_index(
        op.f('ix_organization_membership_active'), table_name='organization_membership'
    )
    op.drop_index(
        op.f('ix_organization_membership_user_id'), table_name='organization_membership'
    )
    op.drop_table('organization_membership')