sales_assistant
Tables
agent_event
event_id, conversation_id, seller_id, agent_type, event_type, payload, created_at
8 rows
appointment
appointment_id, seller_id, customer_id, conversation_id, service_id, title, scheduled_at, duration_minutes, status, notes, created_at, updated_at
0 rows
conversation
conversation_id, seller_id, customer_id, status, state, escalation_level, source_channel, agent_type_active, context_summary, metadata, started_at, last_activity, closed_at
3 rows
customer
customer_id, telegram_id, phone, full_name, username, first_seen, last_seen, total_conversations, lifetime_value_cents, tags, metadata, created_at, updated_at
1 row
customer_persona
persona_id, customer_id, tone_preference, preferred_name, channel_pref, recurring_topic, objection_style, callback_context, summary_snippet, last_updated, created_at
0 rows
customer_session
session_id, customer_id, conversation_id, fsm_state, context_data, turn_count, last_llm_response, created_at, updated_at
0 rows
message
message_id, conversation_id, sender_type, sender_id, telegram_message_id, content, content_type, metadata, intent_label, created_at
12 rows
order
order_id, proposal_id, conversation_id, seller_id, customer_id, status, total_cents, payment_method, payment_status, shipping_address, tracking_info, notes, created_at, updated_at, closed_at
0 rows
product
product_id, seller_id, name, description, price_cents, category, stock_quantity, unit, is_active, image_urls, variations, created_at, updated_at
101 rows
proposal
proposal_id, conversation_id, seller_id, customer_id, status, total_cents, discount_cents, shipping_cents, payment_terms, notes, valid_until, sent_at, responded_at, created_at, updated_at
0 rows
proposal_line_item
line_item_id, proposal_id, product_id, product_snapshot, quantity, unit_price_cents, total_cents, created_at
0 rows
seller
seller_id, telegram_id, business_name, display_name, language_pref, timezone, dnd_start_hour, dnd_end_hour, is_active, vacation_until, config_json, created_at, updated_at, business_type, essential_persona, seller_essential_persona, tool_tier
4 rows
seller_nudge
nudge_id, seller_id, conversation_id, nudge_type, priority, summary, suggested_action, dismissed, dismissed_at, responded_at, sent_at, created_at, expires_at
0 rows
service
service_id, seller_id, name, description, price_cents, duration_minutes, category, is_active, image_urls, created_at, updated_at
0 rows