One Resume, Two Data Models

One Resume, Two Data Models An architecture diagram generated by Archify. Profile Page (SQL) · fetch full resume · Architecture component Profile Page (SQL) fetch full resume users table · id, name, region_id · Architecture component users table id, name, region_id positions table · job_title, user_id · Architecture component positions table job_title, user_id education table · school, user_id · Architecture component education table school, user_id regions table · id to name · Architecture component · normalized regions table id to name normalized Profile Page (JSON) · fetch full resume · Architecture component Profile Page (JSON) fetch full resume Profile Document · positions + education inside · Architecture component · one read Profile Document positions + education inside one read regions collection · referenced by id · Architecture component regions collection referenced by id query + join join on user_id join on user_id resolve ID single read by region_id Legend Backend Database