Foreign keys are not enforced unless you enable it but only for that connection.