ai_agent

AI智能Agent配置表

• Rows (estimated): 10
• Data size: 16.0 KB
• Engine: InnoDB
• Collation: utf8mb4_0900_ai_ci
• Created: 2026-04-27 18:51:51
• Updated: 2026-04-27 18:51:51

Columns

#	Name	Type	Null	Key	Default	Extra	Comment
1	iIncrement	int	NO	PRI		auto_increment	主键ID
2	sId	varchar(64)	NO	MUL			Agent唯一标识ID
3	iOrder	int	NO		0		排序号
4	tCreateDate	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED	创建时间
5	sMakePerson	varchar(255)	NO				创建人
6	sBrandsId	varchar(64)	NO				品牌ID
7	sSubsidiaryId	varchar(64)	NO				子公司ID
8	sBillNo	varchar(255)	NO				单号
9	sSceneNo	varchar(50)	YES	MUL			场景码（唯一标识业务场景）
10	sSceneName	varchar(50)	NO	MUL			场景名称（如：订单处理、售后咨询）
11	sNickName	varchar(200)	YES				Agent昵称（前端展示用）
12	sSceneContext	varchar(2000)	YES				场景内容（Agent对应的业务场景描述/指令）
13	sStatus	varchar(50)	NO		1		状态：1=启用，0=禁用
14	tUpdateDate	datetime	YES		CURRENT_TIMESTAMP	DEFAULT_GENERATED on update CURRENT_TIMESTAMP	修改时间
15	tMakeDate	datetime	NO		CURRENT_TIMESTAMP	DEFAULT_GENERATED	制单日期
16	bCheck	bit(1)	NO		b'0'		是否审核

Indexes

Name	Unique	Type	Columns
idx_sceneName		BTREE	sSceneName
idx_sId		BTREE	sId
PRIMARY	✓	BTREE	iIncrement
uk_scene_brands_subsidiary	✓	BTREE	sSceneNo, sBrandsId, sSubsidiaryId

Narrative

No human-written narrative yet — when this table is exercised by a vertical slice, link from there back to this page.