Follow-up from "Add ability to query single Terraform State" - DB constraints for Terraform Name

The following discussion from !52102 (merged) should be addressed:

We should also open a follow up to enforce this (non-null name) with a database constraint.