Good question ,
Yes I missed the product id.
The purpose of split tables is when the update frequency is very much different from basic table and the extension table .
So when updating one table ,the same id data row stored in another table will not be locked .
E.g when user update his address ,no point to lock columns (name, DOB, photo etc ) which could be stored in another table .