What are the pros and cons, performance-wise about using the primary key of the parent table as part of the primary key in the child tables v.s. just having it as a foreign key in the child tables ?? And if the keys are all surrogate keys, how many levels down can I migrate that first primary key ??