def METHOD_NAME() -> None:
    op.drop_index(op.f('ix_user_notification_rollupid'), table_name='user_notification')
    op.drop_index(
        op.f('ix_user_notification_is_revoked'), table_name='user_notification'
    )
    op.drop_table('user_notification')
    op.drop_index(
        op.f('ix_notification_preferences_user_id'),
        table_name='notification_preferences',
    )
    op.drop_table('notification_preferences')
    op.drop_index(op.f('ix_notification_document_uuid'), table_name='notification')
    op.drop_table('notification')