foreign keys that are declared but not enforced (`NOT ENFORCED`). These are used when the application guarantees integrity and you want the optimizer to have the constraint information for query optimization without the overhead of enforcement. Use with extreme caution.