conversational_agent_erd_v1_251222

Tables (8)

app_states

  • app_name — VARCHAR(128) — Primary key — NOT NULL
  • state — JSON — NOT NULL
  • update_time — TIMESTAMP — NOT NULL

chat_feedbacks

  • feedback_id — BIGINT — Primary key — NOT NULL
  • session_id — VARCHAR(128) — Foreign key → sessions.id — NOT NULL
  • turn_index — INTEGER — NOT NULL
  • is_positive — BOOLEAN — NOT NULL
  • feedback_code — VARCHAR(20)
  • feedback_text — TEXT
  • created_at — DATETIME — NOT NULL

events

  • id — VARCHAR(128) — Primary key — NOT NULL
  • app_name — VARCHAR(128) — Foreign key → sessions.app_name — NOT NULL
  • user_id — VARCHAR(128) — Foreign key → sessions.user_id — NOT NULL
  • session_id — VARCHAR(128) — Foreign key → sessions.id — NOT NULL
  • invocation_id — VARCHAR(128) — NOT NULL
  • author — VARCHAR(128) — NOT NULL
  • actions — TEXT — NOT NULL
  • long_running_tool_ids_json — TEXT
  • branch — VARCHAR(128)
  • timestamp — TIMESTAMP — NOT NULL
  • content — JSON
  • grounding_metadata — JSON
  • custom_metadata — JSON
  • usage_metadata — JSON
  • partial — BOOLEAN
  • turn_complete — BOOLEAN
  • error_code — VARCHAR(128)
  • error_message — VARCHAR(1024)
  • interrupted — BOOLEAN

session_chat_rooms

  • id — BIGINT — Primary key — NOT NULL
  • user_id — VARCHAR(128) — Foreign key → sessions.user_id — NOT NULL
  • session_id — VARCHAR(128) — Foreign key → sessions.id — NOT NULL
  • chat_room_id — VARCHAR(128) — NOT NULL
  • title — VARCHAR(255)
  • created_at — TIMESTAMP — NOT NULL

sessions

  • app_name — VARCHAR(128) — Primary key — NOT NULL
  • id — VARCHAR(128) — Primary key — NOT NULL
  • user_id — VARCHAR(128) — Foreign key → users.user_id — NOT NULL
  • state — JSON — NOT NULL
  • create_time — TIMESTAMP — NOT NULL
  • update_time — TIMESTAMP — NOT NULL

survey_responses

  • response_id — BIGINT — Primary key — NOT NULL
  • user_id — VARCHAR(128) — Foreign key → users.user_id — NOT NULL
  • satisfaction — INTEGER — NOT NULL
  • recommend — INTEGER — NOT NULL
  • productivity — INTEGER — NOT NULL
  • accuracy — INTEGER — NOT NULL
  • comments — TEXT
  • dont_show_again — BOOLEAN — NOT NULL
  • created_at — DATETIME — NOT NULL

user_states

  • app_name — VARCHAR(128) — Primary key — NOT NULL
  • user_id — VARCHAR(128) — Foreign key → users.user_id — NOT NULL
  • state — JSON — NOT NULL
  • update_time — TIMESTAMP — NOT NULL

users

  • user_id — VARCHAR(128) — Primary key — NOT NULL
  • subsidiary — VARCHAR(256)
  • region — VARCHAR(256)
  • country — VARCHAR(256)
  • division — VARCHAR(256)
  • group — VARCHAR(256)
  • is_active — BOOLEAN — NOT NULL
  • last_updated_at — TIMESTAMP — NOT NULL