Kustomer

Explore the interactive ERD

Table & Field Reference

customer_shared_phone

Column	Type	Keys
`index`	Int	PK
`customer_id`	String	PKFK
`phone`	String
`type`	String
`verified`	Boolean

business_schedule

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`modified_by`	String	FK
`created_at`	Instant
`default`	Boolean
`modified_at`	Instant
`name`	String
`org_id`	String
`timezone`	String
`updated_at`	Instant

message_created_by_team

Column	Type	Keys
`message_id`	String	PKFK
`team_id`	String	PKFK

work_session

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`modified_by`	String	FK
`queue_id`	String	FK
`team_id`	String	FK
`user_id`	String	FK
`capacity_remaining`	Long
`capacity_status`	String
`changed_team`	Boolean
`created_at`	Instant
`handled_conversation_count`	Long
`handled_item_count`	Long
`has_pending_item`	Boolean
`has_skills`	Boolean
`idle_since`	Instant
`last_assigned_item_at`	Instant
`modified_at`	Instant
`org_id`	String
`paused_work_item_count`	Long
`rev`	Int
`routable`	Boolean
`signed_in_at`	Instant
`signed_out_at`	Instant
`status_type`	String
`subsystem`	String
`total_available_at_capacity_business_time`	Long
`total_available_at_capacity_status_at`	Instant
`total_available_at_capacity_time`	Long
`total_available_business_time`	Long
`total_available_status_at`	Instant
`total_available_time`	Long
`total_capacity`	Long
`total_unavailable_at_capacity_business_time`	Long
`total_unavailable_at_capacity_status_at`	Instant
`total_unavailable_at_capacity_time`	Long
`total_unavailable_business_time`	Long
`total_unavailable_idle_capacity_business_time`	Long
`total_unavailable_idle_capacity_status_at`	Instant
`total_unavailable_idle_capacity_time`	Long
`total_unavailable_status_at`	Instant
`total_unavailable_time`	Long
`updated_at`	Instant
`user_name_keyword`	String
`work_item_count`	Long

customer_watcher

Column	Type	Keys
`customer_id`	String	PKFK
`user_id`	String	PKFK

team_queue

Column	Type	Keys
`queue_id`	String	PKFK
`team_id`	String	PKFK

work_item

Column	Type	Keys
`id`	String	PK
`accepted_by`	String	FK
`assigned_to`	String	FK
`queue_id`	String	FK
`team_id`	String	FK
`work_session_id`	String	FK
`channel`	String
`created_at`	Instant
`first_enter_queue_at`	Instant
`item_size`	Long
`last_revision_accepted_at`	Instant
`last_revision_entered_queue_at`	Instant
`last_revision_external_queue`	String
`last_revision_id`	String
`modified_at`	Instant
`org_id`	String
`paused`	Boolean
`priority`	Long
`queued_count`	Long
`resource_created_at`	Instant
`resource_direction`	String
`resource_id`	String
`resource_rev`	Int
`resource_type`	String
`rev`	Int
`status`	String
`updated_at`	Instant
`work_item_number`	Long

company_email

Column	Type	Keys
`index`	Int	PK
`company_id`	String	PKFK
`email`	String
`type`	String
`verified`	Boolean

company_location

Column	Type	Keys
`index`	Int	PK
`company_id`	String	PKFK
`address`	String
`address_2`	String
`address_3`	String
`area_code`	String
`city_name`	String
`country_code`	String
`country_name`	String
`latitude`	Double
`longitude`	Double
`name`	String
`region_code`	String
`region_name`	String
`type`	String
`zip_code`	String

conversation_history

Column	Type	Keys
`id`	String	PK
`assistant_id`	String	FK
`brand_id`	String	FK
`created_by`	String	FK
`customer_id`	String	FK
`deleted_by`	String	FK
`ended_by`	String	FK
`first_company_id`	String	FK
`first_message_in_id`	String	FK
`last_message_in_message_id`	String	FK
`last_message_out_message_id`	String	FK
`modified_by`	String	FK
`queue_id`	String	FK
`sla_id`	String	FK
`assistant_emulation`	Boolean
`assistant_status`	String
`assistant_transferred_at`	Instant
`assistant_type`	String
`created_at`	Instant
`default_lang`	String
`deleted`	Boolean
`deleted_at`	Instant
`direction`	String
`ended`	Boolean
`ended_at`	String
`ended_reason`	String
`external_id`	String
`first_company_name`	String
`first_done`	Json
`first_message_in_channel`	String
`first_message_in_created_at`	Instant
`first_message_in_meta_recipient_email`	String
`first_message_in_meta_recipient_mailbox_hash`	String
`first_message_in_meta_to`	String
`first_message_in_sent_at`	Instant
`first_response_created_at`	Instant
`first_response_created_by`	String
`first_response_id`	String
`first_response_response_time`	Long
`first_response_sent_at`	Instant
`first_response_time`	Long
`last_activity_at`	Instant
`last_done`	Json
`last_message_at`	Instant
`last_message_direction`	String
`last_message_in_created_at`	Instant
`last_message_in_sent_at`	Instant
`last_message_out_created_at`	Instant
`last_message_out_sent_at`	Instant
`message_count`	Int
`modified_at`	Instant
`name`	String
`note_count`	Int
`open_status_at`	Instant
`org_id`	String
`outbound_message_count`	Int
`priority`	Int
`reopen_count`	Int
`satisfaction`	Int
`satisfaction_level_channel`	String
`satisfaction_level_created_at`	Instant
`satisfaction_level_first_answer`	String
`satisfaction_level_form`	String
`satisfaction_level_form_response`	String
`satisfaction_level_rating`	Int
`satisfaction_level_scheduled_for`	Instant
`satisfaction_level_score`	Int
`satisfaction_level_sent_at`	Instant
`satisfaction_level_sent_by`	String
`satisfaction_level_sent_by_teams`	Json
`satisfaction_level_status`	String
`satisfaction_level_updated_at`	Instant
`sentiment_confidence`	Double
`sentiment_polarity`	Double
`sla_breach_at`	Instant
`sla_breach_metric`	String
`sla_breached`	Boolean
`sla_matched_at`	Instant
`sla_metrics_first_response_breach_at`	Instant
`sla_metrics_longest_unresponded_message_breach_at`	Instant
`sla_metrics_total_conversation_open_time_breach_at`	Instant
`sla_metrics_total_customer_wait_time_breach_at`	Instant
`sla_name`	String
`sla_status`	String
`sla_summary_first_breach_at`	Instant
`sla_version`	Int
`sla_version_id`	String
`snooze_count`	Int
`snooze_status`	String
`snooze_status_at`	Instant
`snooze_time`	Instant
`spam`	Boolean
`status`	String
`updated_at`	Instant

custom_attribute_metadata

Column	Type	Keys
`id`	String	PK
`resource`	String	PK

queue

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`modified_by`	String	FK
`created_at`	Instant
`description`	String
`display_name`	String
`item_size`	Int
`name`	String
`org_id`	String
`priority`	Int
`restrict_transfers_by_users`	Boolean
`system`	Boolean
`updated_at`	Instant

notification

Column	Type	Keys
`id`	String	PK
`user_id`	String	FK
`created_at`	Instant
`name`	String
`org_id`	String
`status`	String
`updated_at`	Instant

customer_email

Column	Type	Keys
`index`	Int	PK
`customer_id`	String	PKFK
`email`	String
`type`	String
`verified`	Boolean

sla_criteria

Column	Type	Keys
`_fivetran_id`	String	PK
`sla_id`	String	FK
`sla_version_id`	String	FK
`field`	String
`field_type`	String
`match_type`	String
`operator`	String
`value`	String

conversation_assigned_team_history

Column	Type	Keys
`conversation_id`	String	PKFK
`team_id`	String	PKFK

conversation_time_channel

Column	Type	Keys
`channel`	String	PKFK
`conversation_id`	String	PKFK
`conversation_time_id`	String	PKFK

conversation_assigned_team

Column	Type	Keys
`conversation_id`	String	PKFK
`team_id`	String	PKFK

brand

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`modified_by`	String	FK
`created_at`	Instant
`modified_at`	Instant
`name`	String
`org_id`	String
`updated_at`	Instant

shortcut_assigned_team

Column	Type	Keys
`shortcut_id`	String	PKFK
`team_id`	String	PKFK

customer_url

Column	Type	Keys
`index`	Int	PK
`customer_id`	String	PKFK
`type`	String
`url`	String

customer_location

Column	Type	Keys
`index`	Int	PK
`customer_id`	String	PKFK
`address`	String
`address_2`	String
`address_3`	String
`area_code`	String
`city_name`	String
`country_code`	String
`country_name`	String
`latitude`	Double
`longitude`	Double
`name`	String
`region_code`	String
`region_name`	String
`type`	String
`zip_code`	String

business_holiday

Column	Type	Keys
`id`	String	PK
`business_schedule_id`	String	PKFK
`created_by`	String	FK
`modified_by`	String	FK
`created_at`	Instant
`description`	String
`enabled`	Boolean
`end_date`	Instant
`modified_at`	Instant
`name`	String
`org_id`	String
`start_date`	Instant
`updated_at`	Instant

message_assigned_team

Column	Type	Keys
`message_id`	String	PKFK
`team_id`	String	PKFK

company_tag

Column	Type	Keys
`company_id`	String	PKFK
`tag_id`	String	PKFK

sla_version

Column	Type	Keys
`id`	String	PK
`sla_id`	String	PKFK
`created_by`	String	FK
`created_at`	Instant
`description`	String
`hours`	String
`name`	String
`org_id`	String
`version`	Int

sla

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`created_at`	Instant
`current_version`	Int
`org_id`	String

conversation_assigned_user

Column	Type	Keys
`conversation_id`	String	PKFK
`user_id`	String	PKFK

business_schedule_hour

Column	Type	Keys
`day`	String	PK
`index`	Int	PK
`business_schedule_id`	String	PKFK
`end_time`	Int
`start_time`	Int

company

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`modified_by`	String	FK
`created_at`	Instant
`external_id`	String
`modified_at`	Instant
`name`	String
`org_id`	String
`updated_at`	Instant

conversation_time_created_by_team

Column	Type	Keys
`conversation_id`	String	PKFK
`conversation_time_id`	String	PKFK
`team_id`	String	PKFK

user_role

Column	Type	Keys
`index`	Int	PK
`user_id`	String	PKFK
`name`	String

snooze

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`modified_by`	String	FK
`created_at`	Instant
`enabled`	Boolean
`name`	String
`org_id`	String
`time_day_type`	String
`time_day_value`	String
`time_relative`	Int
`time_value`	String
`updated_at`	Instant

message_assigned_user

Column	Type	Keys
`message_id`	String	PKFK
`user_id`	String	PKFK

team

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`deleted_by`	String	FK
`modified_by`	String	FK
`created_at`	Instant
`deleted`	Boolean
`deleted_at`	Instant
`display_name`	String
`modified_at`	Instant
`name`	String
`org_id`	String
`updated_at`	Instant

assistant

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`modified_by`	String	FK
`avatar_url`	String
`channel`	String
`created_at`	Instant
`description`	String
`modified_at`	Instant
`name`	String
`org_id`	String
`public_id`	String
`public_name`	String
`start`	String
`status`	String
`template`	String
`type`	String
`updated_at`	Instant
`version`	Long

tag

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`deleted_by`	String	FK
`modified_by`	String	FK
`color`	String
`created_at`	Instant
`deleted`	Boolean
`deleted_at`	Instant
`modified_at`	Instant
`name`	String
`org_id`	String
`updated_at`	Instant

customer_social

Column	Type	Keys
`index`	Int	PK
`customer_id`	String	PKFK
`type`	String
`url`	String
`userid`	String
`username`	String
`verified`	Boolean

conversation_suggested_tag

Column	Type	Keys
`conversation_id`	String	PKFK
`tag_id`	String	PKFK

customer_shared_whatsapp

Column	Type	Keys
`index`	Int	PK
`customer_id`	String	PKFK
`phone`	String
`type`	String
`verified`	Boolean

message_shortcut

Column	Type	Keys
`message_id`	String	PKFK
`shortcut_id`	String	PKFK

card_context

Column	Type	Keys
`index`	Int	PK
`card_id`	String	PKFK
`name`	String

work_session_channel

Column	Type	Keys
`_fivetran_id`	String	PK
`work_session_id`	String	PKFK
`capacity_max`	Long
`capacity_remaining`	Long
`name`	String

user

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`modified_by`	String	FK
`created_at`	Instant
`deleted`	Boolean
`deleted_at`	Instant
`display_name`	String
`email`	String
`email_signature`	String
`mobile`	String
`modified_at`	Instant
`name`	String
`org_id`	String
`updated_at`	Instant
`user_type`	String

customer_phone

Column	Type	Keys
`index`	Int	PK
`customer_id`	String	PKFK
`phone`	String
`type`	String
`verified`	Boolean

conversation_time

Column	Type	Keys
`id`	String	PK
`conversation_id`	String	PKFK
`created_by`	String	FK
`customer_id`	String	FK
`created_at`	Instant
`handle_at`	String
`handle_pause_at`	String
`handle_pause_by`	String
`handle_time`	String
`message_at`	String
`message_time`	String
`note_at`	String
`note_time`	String
`org_id`	String

customer_shared_external_link

Column	Type	Keys
`index`	Int	PK
`customer_id`	String	PKFK
`external_id`	String
`verified`	Boolean

customer_shared_email

Column	Type	Keys
`index`	Int	PK
`customer_id`	String	PKFK
`email`	String
`type`	String
`verified`	Boolean

customer_tag

Column	Type	Keys
`customer_id`	String	PKFK
`tag_id`	String	PKFK

conversation_tag

Column	Type	Keys
`conversation_id`	String	PKFK
`tag_id`	String	PKFK

customer_external_link

Column	Type	Keys
`index`	Int	PK
`customer_id`	String	PKFK
`external_id`	String
`verified`	Boolean

note_user_mention

Column	Type	Keys
`note_id`	String	PKFK
`user_id`	String	PKFK

message

Column	Type	Keys
`id`	String	PK
`conversation_id`	String	FK
`created_by`	String	FK
`customer_id`	String	FK
`first_company_id`	String	FK
`modified_by`	String	FK
`redacted_by`	String	FK
`app`	String
`auto`	Boolean
`channel`	String
`created_at`	Instant
`direction`	String
`direction_type`	String
`external_id`	String
`first_company_name`	String
`first_delivered_client_type`	String
`first_delivered_timestamp`	String
`modified_at`	Instant
`org_id`	String
`preview`	String
`redacted`	Boolean
`redacted_at`	Instant
`response_business_time`	Long
`response_time`	Long
`sent_at`	Instant
`size`	Int
`source`	String
`status`	String
`subject`	String
`updated_at`	Instant

kobject

Column	Type	Keys
`id`	String	PK
`customer_id`	String	FK
`assigned_team`	String
`assigned_user`	String
`created_at`	Instant
`external_id`	String
`name`	String
`org_id`	String
`status`	String
`title`	String
`updated_at`	Instant

assistant_dialog_node

Column	Type	Keys
`id`	String	PK
`assistant_dialog_id`	String	PKFK
`assistant_id`	String	PKFK
`type`	String

conversation_channel

Column	Type	Keys
`index`	Int	PK
`conversation_id`	String	PKFK
`name`	String

customer_shared_social

Column	Type	Keys
`index`	Int	PK
`customer_id`	String	PKFK
`type`	String
`url`	String
`userid`	String
`username`	String
`verified`	Boolean

shortcut_assigned_user

Column	Type	Keys
`shortcut_id`	String	PKFK
`user_id`	String	PKFK

conversation_suggested_tag_history

Column	Type	Keys
`conversation_id`	String	PKFK
`tag_id`	String	PKFK

conversation_tag_history

Column	Type	Keys
`conversation_id`	String	PKFK
`tag_id`	String	PKFK

shortcut

Column	Type	Keys
`id`	String	PK
`created_by`	String	FK
`deleted_by`	String	FK
`modified_by`	String	FK
`conversation_name`	String
`conversation_snooze_id`	String
`conversation_status`	String
`created_at`	Instant
`deleted`	Boolean
`deleted_at`	Instant
`is_private`	Boolean
`modified_at`	Instant
`name`	String
`org_id`	String
`updated_at`	Instant

conversation

Column	Type	Keys
`id`	String	PK
`assistant_id`	String	FK
`brand_id`	String	FK
`created_by`	String	FK
`customer_id`	String	FK
`deleted_by`	String	FK
`ended_by`	String	FK
`first_company_id`	String	FK
`first_message_in_id`	String	FK
`last_message_in_message_id`	String	FK
`last_message_out_message_id`	String	FK
`modified_by`	String	FK
`queue_id`	String	FK
`sla_id`	String	FK
`assistant_emulation`	Boolean
`assistant_status`	String
`assistant_transferred_at`	Instant
`assistant_type`	String
`created_at`	Instant
`default_lang`	String
`deleted`	Boolean
`deleted_at`	Instant
`direction`	String
`ended`	Boolean
`ended_at`	String
`ended_reason`	String
`external_id`	String
`first_company_name`	String
`first_done`	Json
`first_message_in_channel`	String
`first_message_in_created_at`	Instant
`first_message_in_meta_recipient_email`	String
`first_message_in_meta_recipient_mailbox_hash`	String
`first_message_in_meta_to`	String
`first_message_in_sent_at`	Instant
`first_response_created_at`	Instant
`first_response_created_by`	String
`first_response_id`	String
`first_response_response_time`	Long
`first_response_sent_at`	Instant
`first_response_time`	Long
`last_activity_at`	Instant
`last_done`	Json
`last_message_at`	Instant
`last_message_direction`	String
`last_message_in_created_at`	Instant
`last_message_in_sent_at`	Instant
`last_message_out_created_at`	Instant
`last_message_out_sent_at`	Instant
`message_count`	Int
`modified_at`	Instant
`name`	String
`note_count`	Int
`open_status_at`	Instant
`org_id`	String
`outbound_message_count`	Int
`priority`	Int
`reopen_count`	Int
`satisfaction`	Int
`satisfaction_level_channel`	String
`satisfaction_level_created_at`	Instant
`satisfaction_level_first_answer`	String
`satisfaction_level_form`	String
`satisfaction_level_form_response`	String
`satisfaction_level_rating`	Int
`satisfaction_level_scheduled_for`	Instant
`satisfaction_level_score`	Int
`satisfaction_level_sent_at`	Instant
`satisfaction_level_sent_by`	String
`satisfaction_level_sent_by_teams`	Json
`satisfaction_level_status`	String
`satisfaction_level_updated_at`	Instant
`sentiment_confidence`	Double
`sentiment_polarity`	Double
`sla_breach_at`	Instant
`sla_breach_metric`	String
`sla_breached`	Boolean
`sla_matched_at`	Instant
`sla_metrics_first_response_breach_at`	Instant
`sla_metrics_longest_unresponded_message_breach_at`	Instant
`sla_metrics_total_conversation_open_time_breach_at`	Instant
`sla_metrics_total_customer_wait_time_breach_at`	Instant
`sla_name`	String
`sla_status`	String
`sla_summary_first_breach_at`	Instant
`sla_version`	Int
`sla_version_id`	String
`snooze_count`	Int
`snooze_status`	String
`snooze_status_at`	Instant
`snooze_time`	Instant
`spam`	Boolean
`status`	String
`updated_at`	Instant

customer

Column	Type	Keys
`id`	String	PK
`company_id`	String	FK
`created_by`	String	FK
`deleted_by`	String	FK
`last_conversation_id`	String	FK
`modified_by`	String	FK
`conversation_counts_all`	Int
`conversation_counts_done`	Int
`conversation_counts_open`	Int
`conversation_counts_snoozed`	Int
`created_at`	Instant
`default_lang`	String
`deleted`	Boolean
`deleted_at`	Instant
`display_name`	String
`external_id`	String
`first_name`	String
`last_activity_at`	Instant
`last_message_at`	Instant
`last_message_out_sent_at`	Instant
`last_name`	String
`modified_at`	Instant
`name`	String
`org_id`	String
`progressive_status`	String
`sentiment_confidence`	Double
`sentiment_polarity`	Double
`updated_at`	Instant
`verified`	Boolean

note_team_mention

Column	Type	Keys
`note_id`	String	PKFK
`team_id`	String	PKFK

customer_last_conversation_tag

Column	Type	Keys
`customer_id`	String	PKFK
`tag_id`	String	PKFK

sla_metric

Column	Type	Keys
`_fivetran_id`	String	PK
`sla_id`	String	FK
`sla_version_id`	String	FK
`commitment`	Long
`enabled`	Boolean
`name`	String
`priority`	Int

company_social

Column	Type	Keys
`index`	Int	PK
`company_id`	String	PKFK
`type`	String
`url`	String
`userid`	String
`username`	String
`verified`	Boolean

conversation_assigned_user_history

Column	Type	Keys
`conversation_id`	String	PKFK
`user_id`	String	PKFK

team_member

Column	Type	Keys
`team_id`	String	PKFK
`user_id`	String	PKFK

company_phone

Column	Type	Keys
`index`	Int	PK
`company_id`	String	PKFK
`phone`	String
`type`	String
`verified`	Boolean

customer_active_user

Column	Type	Keys
`customer_id`	String	PKFK
`user_id`	String	PKFK

customer_whatsapp

Column	Type	Keys
`index`	Int	PK
`customer_id`	String	PKFK
`phone`	String
`type`	String
`verified`	Boolean

conversation_channel_history

Column	Type	Keys
`name`	String	PK
`conversation_id`	String	PKFK

note

Column	Type	Keys
`id`	String	PK
`conversation_id`	String	FK
`created_by`	String	FK
`customer_id`	String	FK
`deleted_by`	String	FK
`modified_by`	String	FK
`body`	String
`created_at`	Instant
`deleted`	Boolean
`deleted_at`	Instant
`external_id`	String
`modified_at`	Instant
`org_id`	String
`updated_at`	Instant

shortcut_tag

Column	Type	Keys
`shortcut_id`	String	PKFK
`tag_id`	String	PKFK

kobject_tag

Column	Type	Keys
`kobject_id`	String	PKFK
`tag_id`	String	PKFK

assistant_dialog

Column	Type	Keys
`id`	String	PK
`assistant_id`	String	PKFK
`name`	String

message_attachment

Column	Type	Keys
`id`	String	PK
`message_id`	String	FK
`content_length`	Int
`content_type`	String
`name`	String
`org_id`	String
`redacted`	Boolean
`related`	String
`self`	String

card

Column	Type	Keys
`id`	String	PK
`app_id`	String
`created_at`	Instant
`description`	String
`modified_at`	Instant
`name`	String
`org_id`	String
`updated_at`	Instant
`url`	String

work_session_capacity

Column	Type	Keys
`_fivetran_id`	String	PK
`work_session_id`	String	PKFK
`capacity_limit`	Long
`priority`	Long
`remaining`	Long

company_url

Column	Type	Keys
`index`	Int	PK
`company_id`	String	PKFK
`type`	String
`url`	String