表之间的菱形关系中的标识符

I have four tables (A,B,C,D) where A is the parent of one to many relationships with B and C. C and D are parents to a one to many relationship with table D. Conceptually, the primary keys of these tables could be:I have four tables (A,B,C,D) where A is the par