DHL Express CS — Data Schema
13 tables · click a table for details · reads live from schema/tables/*.yaml
conversation
1 row per run_id
run_id
uuid
session_id
uuid
channel
text
country
text
started_at
timestamptz
+23 more — click to expand
conversation_survey
1 row per run_id, 0..1 (only if the survey sub-flow ran)
run_id
FK
uuid
survey_session_id
uuid
survey_completed
bool
survey_resolution
text
survey_csat_score
int4
+4 more — click to expand
conversation_telephony
1 row per run_id, only present for voice conversations
run_id
FK
uuid
from_number
text
to_number
text
transfer_routing_key
text
transfer_extension_provided
bool
+14 more — click to expand
request
1 row per request_pk, many per run_id
request_pk
uuid
run_id
FK
uuid
session_id
uuid
country
text
channel
text
+8 more — click to expand
request_faq_detail
1 row per request_pk, 0..1, present only when intent = faq
request_pk
FK
uuid
faq_queried
bool
faq_category
text
faq_missing
bool
faq_answer_provided
bool
+3 more — click to expand
request_odd_detail
1 row per request_pk, 0..1, present only when intent starts with odd_
request_pk
FK
uuid
odd_shipment_found
bool
odd_options_available
bool
odd_sd_available
bool
odd_vh_available
bool
+21 more — click to expand
request_odd_otp_verification
1 row per request_pk, 0..1, present only when OTP verification was attempted for this request
request_pk
FK
uuid
otp_contact_options_available
bool
otp_contact_email_available
bool
otp_contact_sms_available
bool
otp_contact_method_selected
text
+7 more — click to expand
request_odd_sd_detail
1 row per request_pk, 0..1, present only when request_odd_detail.odd_final_intent ∈ {sd, vh}
request_pk
FK
uuid
sd_procedure_type
text
sd_requested_date
date
sd_confirmed_date
date
available_dates
date[]
+5 more — click to expand
request_odd_sp_detail
1 row per request_pk, 0..1, present only when request_odd_detail.odd_final_intent = sp
request_pk
FK
uuid
sp_service_points_attempts
int4
returned_service_points
jsonb
sp_selected_service_point_id
text
sp_near_delivery_address
bool
+1 more — click to expand
request_odd_sx_detail
1 row per request_pk, 0..1, present only when request_odd_detail.odd_final_intent = sx
request_pk
FK
uuid
sx_locations_available
bool
available_location_types
text[]
offered_locations
jsonb
sx_location_selected
text
+9 more — click to expand
request_sherloc_lookup
1 row per request_pk, 0..1, present only when request_tracking_detail.sherloc_called = true
request_pk
FK
uuid
sherloc_follow_up_queries
int4
sherloc_found
bool
sherloc_declared_pieces
int4
sherloc_pieces_delivered
int4
+13 more — click to expand
request_tracking_detail
1 row per request_pk, 0..1, present only when intent = tracking
request_pk
FK
uuid
air_waybill_provided
bool
air_waybill
text
air_waybill_capture_attempts
int4
valid_air_waybill
bool
+8 more — click to expand
signal
0..N rows per run_id, optionally attributable to a specific request_pk
id
uuid
run_id
FK
uuid
request_pk
FK
uuid
category
text
signal_type_code
text
+2 more — click to expand
Mini Map
Press enter or space to select a node. You can then use the arrow keys to move the node around. Press delete to remove it and escape to cancel.
Press enter or space to select an edge. You can then press delete to remove it or escape to cancel.