---
sourceDocument: Brazil Customer Service Management
sourceDocumentLink: https://www.servicenow.com/docs/r/customer-service-management

 Release :

    - brazil

ft:locale :

    - en-US

ft:publication_title :

    - Brazil Customer Service Management

ft:clusterId :

    - csm

bundleId :

    - csm

workflow :

    - Customer and Industry


---

# B2C - Customer and household data model

# B2C - Customer and household data model {#ariaid-title1}

Release version: Brazil  
Updated September 10, 2026  
![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read  
Reference the tables and relationships that store business-to-consumer (B2C) consumers, consumer profiles, households, household members, and the relationships that connect them.

## Overview of B2C data model {#b2c-customer-and-household-data-model__section_c3d_vwx_zjc}

The B2C consumer and household data model captures the structures used when the customer is an individual or a household.

Consumer is the core person entity. Consumer Profile lets a single consumer maintain multiple contexts, and household groups consumers who share an address or service arrangement. A family of relationship entities, such as consumer
relationships, household member relationships, consumer team members, and household team members supports multi-party patterns across consumers and households.

The model supports scenarios such as a bank serving account holders, a healthcare provider serving patients, a telecommunications carrier serving residential subscribers, and a utility serving households.

## B2C - Consumer and household data model diagram {#b2c-customer-and-household-data-model__section_oq2_g5x_zjc}

In the B2C consumer and household data model diagram, consumer and household are the core entities. Consumer profile, consumer profile location, household member, and the relationship and team entities govern multi-party
access. Consumer can be extended for patients, constituents, and similar roles. Each entity refers to shared reference data and transaction data.

## Tables in the B2C Consumer and Household data model {#b2c-customer-and-household-data-model__section_qlj_ycy_zjc}

{#b2c-customer-and-household-data-model__table_aby_1dy_zjc__entry__3}

| Label | Table name | Description |
|-|-|-|
| Consumer | csm_consumer | Individual B2C customer. Extends `sys_user`. Can be extended for patients, constituents, and similar roles. |
| Consumer User (linked) | sys_user | Platform user account associated with a consumer for login and self-service access. |
| Consumer Profile |   | A distinct context (role, relationship, or product line) under a single consumer. A consumer can have multiple profiles. |
| Consumer Profile Location |   | Many-to-many link from Consumer Profile to Location, classified by Address Type. |
| Consumer Relationship |   | Bi-directional link between two consumers. Types include Authorized Representative, Attorney, Guarantor, Power of Attorney, Beneficiary. |
| Consumer Team Member | sn_customer_rel_consumer_to_user | Internal employee assigned to a consumer in a named role, such as relationship manager, care coordinator, or financial planner. |
| Household | csm_household | B2C customers grouped under a shared address or service arrangement. Extends `core_company`. |
| Household Member | csm_consumer | Individual member of a household. Uses the same table as Consumer. |
| Household Member Relationship |   | Relationship between two members of the same household. Types include Parent, Spouse, Child, Dependent, Guardian. |
| Household Team Member |   | Internal employee assigned to a household in a named role. |
[ ]

{#b2c-customer-and-household-data-model__table_aby_1dy_zjc}
**Related concepts**   

* [Configuring households](https://www.servicenow.com/docs/Mtcfro3eeH0ZSp9Ldw2_6Q "The household entity represents a group of consumers that usually share a common address and use services as a group.")
* [Creating multiple consumer profiles for a user](https://www.servicenow.com/docs/MAsaOq2OPwrguo9HTMem_w "The concept of consumer profiles refers to the idea that an individual can have multiple profiles associated with them. For example, a consumer might have a patient profile in Healthcare and Life Sciences and simultaneously have a constituent profile in Public Sector Digital Services.")
* [Configuring a Unified User](https://www.servicenow.com/docs/7zHJO14tdmL47WgF2zf2UQ "By unifying multiple profiles for a single user in the Customer Service Management (CSM) application, you don't need to create and manage multiple user accounts for that user.")  
**Related tasks**   

* [Configure consumers](https://www.servicenow.com/docs/0gAUkXPBZN9BEXSl0UGU2A "A consumer is a customer in the business-to-consumer (B2C) business model.")