Hello and welcome. In answer to the question, NO, the city water connection only pressurizes the lines. The pump, on mine anyway, has a check valve that won't let line pressure back in to the tank. I think most trailers are this way. There is also a check valve at the city water connection, so when it isn't being used, line pressure will not be leaking out onto the street. Drawings will be hard to find.
tank - pump - cold line (various "T"' to fixtures & Water Heater) -check valve- city
Water Heater - (various "T" Fixtures)
2012 Ford F250 ext. Cab 4x4
2002 Jeep Wrangler Sahara
2008 Yamaha V-Star 650 Classic
2008 Work and Play 18LT