added erd. also updated subscription schema