Final answer:
When a consumer registers on a portal, records are typically created in tables that store user and contact information, such as Customer_contact, sys_user, Customer, Csm_consumer, and Csm_consumer_user. However, the exact tables depend on the specific system in use.
Step-by-step explanation:
When a consumer registers on a portal, the records are typically created in tables that handle user data and contact information. This would include tables such as:
- Customer_contact: Contains contact details for the customer such as email, phone number, address, etc.
- sys_user: This is usually the table where basic user information is stored for any system user, including customers, in a ServiceNow instance or similar systems. It includes usernames, passwords, and often more detailed personal identity information.
- Customer: May store general customer information such as name, customer ID, and other non-contact related details.
- Csm_consumer and Csm_consumer_user: These tables could be specific to certain Customer Service Management (CSM) platforms and might contain records that link customer contact information and user accounts.
Without specific context or understanding of the system in question, it's not possible to provide a definitive answer. Different systems may use different table names and structures. However, for many customer service management systems or consumer portals, one can expect that records related to the new consumer will be created in tables designated for storing user data and contact information.