1. Billing
  2. Customers
  3. Customer contacts

Customer contacts

customer_contacts
copy
Click to Copy
The customer_contacts table stores one row per contact linked to a customer. Each row represents a person or organization that may receive billing and account-related messages for that customer, as modeled in Chargebee’s contact data.

Columns

No match found
id string, not null
Unique identifier for this contact row. The value of this field is auto-generated by Chargebee and is not modifiable.
customer_id string, not null
Foreign Key customers.id
Every row in this table belongs to exactly one customer; together these rows are that customer’s contact list.
email string, not null
Email address stored on the contact row. When notification flags are set, messages of the corresponding types are directed to this address for the linked customer context.
enabled boolean, not null, default=false
When true, the contact row is active; when false, the contact is treated as disabled for notification and operational use.
first_name string, null
Given name stored on the contact row for this person or organization.
label string, null
Short label or tag on the row used to identify or group this contact among others for the same customer.
last_name string, null
Family or surname stored on the contact row for this person or organization.
phone string, null
Phone number stored on the contact row for reference or outreach.
send_account_email boolean, not null, default=false
When true, account-related emails may be sent to this contact’s email for the associated customer; when false, that channel is off for this row.
send_billing_email boolean, not null, default=false
When true, billing-related emails may be sent to this contact’s email for the associated customer; when false, that channel is off for this row.
record_extracted_at timestamp
The column represents the timestamp when the updated data became available in Chargebee's data lakehouse.
record_exported_at timestamp
The column represents the timestamp when the data was exported to the configured destination.
change_type string
The column indicates the type of change [create, update, delete, read] and can be used to load data into the warehouse accordingly.