执行python manage.py migrate时遭遇django.db.utils.IntegrityError的问题咨询

各位好，我在执行python manage.py migrate命令的时候碰到了一个完整性错误，具体报错信息如下：

django.db.utils.IntegrityError: The row in table 'flights_flight' with
primary key '1' has an invalid foreign key: flights_flight.origin_id
contains a value 'New York' that does not have a corresponding value
in flights_airport.id.

我的项目入口代码是这样的：

def main():
    """Run administrative tasks."""
    os.environ.setdefault('DJANGO_SETTINGS_MODULE', 'airline.settings')
    try:
        from django.core.management import execute_from_command_line
    except ImportError as exc:
        raise ImportError(
            "Couldn't import Django. Are you sure it's installed and "
            "available on your PYTHONPATH environment variable? Did you "
            "forget to activate a virtual environment?"
        ) from exc
    execute_from_command_line(sys.argv)


if __name__ == '__main__':
    main()

我尝试过把New York换成其他值，但问题依然存在。下面是错误日志的截图：

备注：内容来源于stack exchange，提问作者user28239646