Thanks,

For example, user id is used as a linkage across multiple tables.

I am concerned about defining a key for the child tables as it requires 3- 9 columns to make the row unique. Will that be optimal?

Or defining a surrogate key will be of any use?