How could it be possible to insert same cid in second table if I create a primary key on this field.

As per my view I can put only single...