Storage of the contact information
If possible, can you please let me know why the customer contact data is designed to store in the following two tables.
PS_CUST_CONTACT
PS_CONTACT_CUST
I am little bit curious to know the usage perspective of this design.
When we insert the contact information through online via (Customers --> Contact Information)
Its inserts the data first into PS_CONTACT_CUST and through the peoplecode(i.e through compoent interface CUSTOMER_CONTACT) it inserts the data in PS_CUST_CONTACT table and vice versa.
Thanks,
Sudheer