V2, Nishi #000 adding indexes and constraints on adherence tables and provider table