CREATE TABLE IF NOT EXISTS t_todo ( todo_id BIGINT AUTO_INCREMENT PRIMARY KEY, content VARCHAR(200) NOT NULL, owner_id BIGINT NOT NULL, owner_name VARCHAR(100) NOT NULL, creator_id BIGINT NOT NULL, creator_name VARCHAR(100) NOT NULL, status VARCHAR(20) NOT NULL DEFAULT '待处理', created_at_utc DATETIME(3) NOT NULL, operated_at_utc DATETIME(3) NOT NULL, handle_remark VARCHAR(500) NULL, INDEX idx_todo_owner_status (owner_id, status), INDEX idx_todo_operated (operated_at_utc) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='用户待办事项';