32 lines
1.1 KiB
SQL
32 lines
1.1 KiB
SQL
-- Explicit additive migration. No business tables are changed and no historical records are purged.
|
|
CREATE TABLE IF NOT EXISTS bi_asset_ai_questions (
|
|
id CHAR(36) PRIMARY KEY,
|
|
actor_id VARCHAR(64) NOT NULL,
|
|
user_id VARCHAR(64) NOT NULL,
|
|
login_name VARCHAR(255) NOT NULL,
|
|
user_name VARCHAR(255) NOT NULL,
|
|
permission_level VARCHAR(24) NOT NULL,
|
|
is_preview TINYINT(1) NOT NULL DEFAULT 0,
|
|
preview_session_id VARCHAR(64) NULL,
|
|
session_id VARCHAR(64) NULL,
|
|
base_result_id VARCHAR(64) NULL,
|
|
result_id VARCHAR(64) NULL,
|
|
subject VARCHAR(150) NULL,
|
|
event_type VARCHAR(24) NOT NULL,
|
|
question TEXT NULL,
|
|
action_json JSON NULL,
|
|
outcome VARCHAR(24) NOT NULL,
|
|
reason VARCHAR(64) NULL,
|
|
business_types JSON NULL,
|
|
engine VARCHAR(24) NULL,
|
|
answer MEDIUMTEXT NULL,
|
|
started_at DATETIME(3) NOT NULL,
|
|
finished_at DATETIME(3) NULL,
|
|
duration_ms BIGINT UNSIGNED NULL,
|
|
KEY user_time (user_id, started_at),
|
|
KEY actor_time (actor_id, started_at),
|
|
KEY result_time (outcome, started_at),
|
|
KEY session_time (session_id, started_at),
|
|
KEY event_time (event_type, started_at)
|
|
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
|