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