Are constraints at the database level necessary if they are set at the schema level?

Question

Python

Suppose I am describing a database schema for use with SQLAlchemy. In the schema, I specify that one of the columns is a foreign key to another table. But what if the database itself does not specify this restriction?
Will it work? If so, is it necessary to set restrictions at the database level at all if you plan to use ORM exclusively?