Field;Type;Description
cdr_id;uuid;Primary key, unique identifier for the CDR
call_history_id;uuid;Associated call history ID
source_participant_id;uuid;ID of the source participant
source_entity_type;varchar;Type of the source entity
source_dn_number;varchar;Dialed number of the source
source_dn_type;varchar;Type of the source number
source_dn_name;varchar;Name of the source dialed number
source_participant_name;varchar;Name of the source participant
source_participant_phone_number;varchar;Phone number of the source participant
source_participant_trunk_did;varchar;Trunk DID for the source participant
source_participant_is_incoming;boolean;Indicates if the call to source was incoming
source_participant_is_already_connected;boolean;Indicates if the source was already connected
source_participant_group_name;varchar;Group name of the source participant
source_participant_billing_suffix;varchar;Billing suffix of the source participant
destination_participant_id;uuid;ID of the destination participant
destination_entity_type;varchar;Type of the destination entity
destination_dn_number;varchar;Dialed number of the destination
destination_dn_type;varchar;Type of the destination number
destination_dn_name;varchar;Name of the destination DN
destination_participant_name;varchar;Name of the destination participant
destination_participant_phone_number;varchar;Phone number of the destination participant
destination_participant_trunk_did;varchar;Trunk DID for the destination participant
destination_participant_is_incoming;boolean;Indicates if the call to destination was incoming
destination_participant_is_already_connected;boolean;Indicates if the destination was already connected
destination_participant_group_name;varchar;Group name of the destination participant
destination_participant_billing_suffix;varchar;Billing suffix of the destination participant
base_cdr_id;uuid;Base CDR identifier
originating_cdr_id;uuid;Originating CDR identifier
creation_method;varchar;Method used to create the CDR
creation_forward_reason;varchar;Reason for call forwarding
termination_reason;varchar;Call termination reason
terminated_by_participant_id;uuid;Participant ID who ended the call
continued_in_cdr_id;uuid;ID of the next CDR where the call continued
cdr_started_at;timestamp with time zone;Start time of the CDR
cdr_ended_at;timestamp with time zone;End time of the CDR
cdr_answered_at;timestamp with time zone;Time the call was answered
termination_reason_details;varchar;Details about the call termination
processed;boolean;Whether the record was processed
migrated;boolean;Whether the record was migrated
main_call_history_id;uuid;Main call history identifier
source_presentation;varchar;Caller ID presentation for the source
offload_id;bigint;Identifier for the offload/archive operation