tids: include constraints in database