Application vs Integration databases: https://martinfowler.com/bliki/IntegrationDatabase.html. If you're going to have one application writing to your database, having your constraints live in your application is definitely a viable option.