Mariusz<p>Day 11<br>Well, technically it’s been a few days.</p><p>I just finished populating the entire partner-contracts layer in our system. That means hundreds of users, each linked to the correct unit, with the proper supervisor, job title, and contract type. All of it reflected in a single, consistent data model.</p><p>Every user has a contract pointing to their supervisor — with cascading relations:<br>- regional managers report directly to the admin,<br>- unit managers report to regional managers,<br>- team leads report to unit managers,<br>- and finally, operators, assigned in pairs to each lead.</p><p>I’ve also updated every partner’s supervisor field, so hierarchy is fully navigable.</p><p>It took some time and required pulling data from multiple sources:<br>users, organizational units, and memberships, regional and structural hierarchy, and even address assignments.</p><p>Numbers:<br>Total test users & contracts: 1,408<br>Regional Coordinators: 16<br>Managers: 160<br>Team Leads: 640<br>Operators: 592</p><p><a href="https://write.tyolabs.com/?p=36" rel="nofollow noopener" translate="no" target="_blank"><span class="invisible">https://</span><span class="">write.tyolabs.com/?p=36</span><span class="invisible"></span></a></p><p><a href="https://techhub.social/tags/programming" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>programming</span></a> <a href="https://techhub.social/tags/sql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>sql</span></a> <a href="https://techhub.social/tags/posgresql" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>posgresql</span></a> <a href="https://techhub.social/tags/testdata" class="mention hashtag" rel="nofollow noopener" target="_blank">#<span>testdata</span></a></p>