odbtools/odbctest/mql/aianswer/11class.mql

create class if not exists univ_demo : / ( )with autosearch=true , version=false , key=manu, alias='univ_demo' , namespace='univ_demo' ;
create class if not exists /univ_demo/agent_log ( 
		agent_name		varchar,
		answer			varchar,
		end_time		timestamp,
		finish_reason		varchar,
		id					varchar,
		input_token_count		int,
		original_end_time		timestamp,
		original_question		varchar,
		original_question_id		varchar,
		original_start_time		timestamp,
		output_token_count		int,
		question		varchar,
		session_id		varchar,
		start_time		timestamp,
		total_token_count		int,
		
		index( agent_name,answer,end_time,finish_reason,id,input_token_count,original_end_time,original_question,original_question_id,original_start_time,output_token_count,question,session_id,start_time,total_token_count) 


		)with autosearch=true , version=false , key=manu, alias='agent_log' , nickname='univ_demo_agent_log' ;
create class if not exists /univ_demo/mgn_duty ( 
		account			varchar	"工号",
		last_flag		varchar	"是否现行政职务",
		last_flag_code		varchar	"是否现行政职务代码",
		level				varchar	"行政职务级别",
		level_code		varchar	"行政职务级别代码",
		name				varchar	"姓名",
		title				varchar	"行政职务名称",
		title_code		varchar	"行政职务名称代码",
		unit				varchar	"行政职务任职部门",
		xzzw_sx			varchar	"行政职务任职属性",
		xzzw_sx_code		varchar	"行政职务任职属性代码",
		
		index( account,last_flag,last_flag_code,level,level_code,name,title,title_code,unit,xzzw_sx,xzzw_sx_code) 


		)with core=memory , autosearch=true , version=false , key=manu, alias='当前行政职务' , nickname='univ_demo_mgn_duty' ;
		
create class if not exists /univ_demo/org ( 
		code				varchar	"单位代码",
		dept_sort		varchar	"单位类别代码",
		dept_sort_name		varchar	"单位类别名",
		dwjb				varchar	"单位级别代码",
		dwjb_name		varchar	"单位级别名",
		name				varchar	"单位全称",
		up					varchar	"上级单位",
		
		index( code,dept_sort,dept_sort_name,dwjb,dwjb_name,name,up) 


		)with core=memory , autosearch=true , version=false , key=manu, alias='组织机构信息' , nickname='univ_demo_org' ;
		
create class if not exists /univ_demo/paper ( 
		abstract		text	"摘要",
		journals		varchar	"期刊",
		keywords		text	"关键字",
		level				varchar	"等级",
		paper_file		list<varchar>,
		type				varchar	"类型",
		title				text	"标题",
		
		index( abstract,journals,keywords,level,paper_file,type,title) 


		)with core=memory , autosearch=true , version=false , key=manu, alias='论文' , nickname='univ_demo_paper' ;
		
create class if not exists /univ_demo/person ( 
		account			varchar	"工号",
		actual_quit_date		timestamp	"真实离校日期(离校日期/人员离退休日期/人员去世日期 三个字段中最小的时间)",
		age					varchar	"年龄",
		birthday		varchar,
		deceased_date		timestamp	"人员去世日期",
		degree_level		varchar	"学位层次",
		degree_level_code		varchar	"学位层次代码",
		is_last_degree		varchar	"是否最高学位",
		is_last_degree_code		varchar	"是否最高学位代码",
		join_u_date		timestamp	"报到入职日期",
		lx_date			timestamp	"来校工作日期",
		main_dept		varchar	"人事所在单位",
		name				varchar	"姓名",
		nation			varchar	"民族",
		nation_code		varchar	"民族代码",
		person_sort		varchar	"编制类别",
		person_sort_code		varchar	"编制类别代码",
		photo_works		list<varchar>,
		polity			varchar	"政治面貌",
		polity_code		varchar	"政治面貌代码",
		quit_date		timestamp	"离校日期",
		retire_date		timestamp	"人员离退休日期",
		sex					varchar	"性别",
		sex_code		varchar	"性别代码",
		staff_from		varchar	"教职工来源",
		staff_from_code		varchar	"教职工来源代码",
		staff_type		varchar	"人员分类",
		staff_type_code		varchar	"人员分类代码",
		status			varchar	"人员状态",
		status_code		varchar	"人员状态代码",
		subject_first		varchar	"一级学科",
		subject_first_code		varchar	"一级学科代码",
		subject_second		varchar	"二级学科",
		subject_second_code		varchar	"二级学科代码",
		sz_g				varchar	"师资归属单位",
		xw_dept			varchar	"学位授予单位",
		
		index( account,actual_quit_date,age,birthday,deceased_date,degree_level,degree_level_code,is_last_degree,is_last_degree_code,join_u_date,lx_date,main_dept,name,nation,nation_code,person_sort,person_sort_code,photo_works,polity,polity_code,quit_date,retire_date,sex,sex_code,staff_from,staff_from_code,staff_type,staff_type_code,status,status_code,subject_first,subject_first_code,subject_second,subject_second_code,sz_g,xw_dept) 


		)with core=memory , autosearch=true , version=false , key=manu, alias='教职工基本信息' , nickname='univ_demo_person' ;
		
create class if not exists /univ_demo/student_master ( 
		account			varchar	"学号",
		
		index( account) 


		)with core=memory , autosearch=true , version=false , key=manu, alias='硕士研究生' , nickname='univ_demo_student_master' ;
		
create class if not exists /univ_demo/sys_agent_log ( 
		agent_name		varchar	"问题类型, 当前使用类名",
		answer			varchar	"当前与大模型交互的回答",
		end_time		timestamp	"大模型回答结束时间",
		finish_reason		varchar,
		id					varchar,
		input_token_count		int	"输入token数",
		original_end_time		timestamp	"原始问题结束时间",
		original_question		varchar	"原始问题",
		original_question_id		varchar	"原始问题ID",
		original_start_time		timestamp	"原始问题开始时间",
		output_token_count		int	"输出token数",
		question		varchar	"当前与大模型交互的问题",
		session_id		varchar	"当前与大模型交互的sessionID",
		start_time		timestamp	"大模型回答开始时间",
		total_token_count		int	"总数",
		
		index( agent_name,answer,end_time,finish_reason,id,input_token_count,original_end_time,original_question,original_question_id,original_start_time,output_token_count,question,session_id,start_time,total_token_count) 


		)with core=memory , autosearch=true , version=false , key=manu, alias='大模型调用日志' , nickname='univ_demo_sys_agent_log' ;
create class if not exists /univ_demo/sys_api_permission ( 
		api_name		varchar	"接口名称",
		create_time		timestamp	"创建时间",
		enabled			int	"是否启用：0-否 1-是",
		method			varchar	"请求方法",
		modify_time		timestamp	"修改时间",
		module			varchar	"所属模块",
		permission		varchar	"delete）",
		url_pattern		varchar	"请求路径",
		
		index( api_name,create_time,enabled,method,modify_time,module,permission,url_pattern) 


		)with core=memory , autosearch=true , version=false , key=manu, alias='系统接口权限' , nickname='univ_demo_sys_api_permission' ;
create class if not exists /univ_demo/sys_data_permission ( 
		class_name		varchar	"创建时间",
		create_time		timestamp	"创建时间",
		data_type		int	" field",
		modify_time		timestamp	"修改时间",
		permission		varchar	"0:没权限|1:可以看|2:仅分组}] ",
		post_id			varchar	"岗位ID",
		
		index( class_name,create_time,data_type,modify_time,permission,post_id) 


		)with core=memory , autosearch=true , version=false , key=manu, alias='系统数据权限' , nickname='univ_demo_sys_data_permission' ;
create class if not exists /univ_demo/sys_menu ( 
		component		varchar	"组件路径",
		create_time		timestamp	"创建时间",
		menu_name		varchar	"菜单名称",
		modify_time		timestamp	"修改时间",
		parent_id		varchar	"父菜单ID",
		path				varchar	"菜单路径（前端路由）",
		permission		varchar	"view）",
		sort				int	"排序值",
		status			int	"状态：0-禁用 1-启用",
		type				int	"菜单类型：0-目录 1-菜单 2-按钮",
		
		index( component,create_time,menu_name,modify_time,parent_id,path,permission,sort,status,type) 


		)with core=memory , autosearch=true , version=false , key=manu, alias='系统菜单权限' , nickname='univ_demo_sys_menu' ;
create class if not exists /univ_demo/sys_post ( 
		create_time		timestamp	"创建时间",
		modify_time		timestamp	"最后修改时间",
		parent_id		varchar	"父级岗位ID，顶级岗位为 null 或空字符串",
		post_desc		varchar	"岗位描述",
		post_name		varchar	"岗位名称",
		post_type		int	"菜单 3: 数据",
		sort				int	"排序值",
		
		index( create_time,modify_time,parent_id,post_desc,post_name,post_type,sort) 


		)with core=memory , autosearch=true , version=false , key=manu, alias='系统岗位' , nickname='univ_demo_sys_post' ;
create class if not exists /univ_demo/sys_post_api_rlt ( 
		api_id			varchar	"接口权限ID",
		permission		varchar	"delete）",
		post_id			varchar	"岗位ID",
		
		index( api_id,permission,post_id) 


		)with core=memory , autosearch=true , version=false , key=manu, alias='岗位与接口权限关联' , nickname='univ_demo_sys_post_api_rlt' ;
create class if not exists /univ_demo/sys_post_menu_rlt ( 
		menu_id			varchar	"菜单ID",
		permission		varchar	"delete） 这里做个冗余",
		post_id			varchar	"岗位ID",
		
		index( menu_id,permission,post_id) 


		)with core=memory , autosearch=true , version=false , key=manu, alias='岗位与菜单权限关联' , nickname='univ_demo_sys_post_menu_rlt' ;
create class if not exists /univ_demo/sys_role ( 
		create_time		timestamp	"创建时间",
		creator_id		varchar	"创建者ID",
		modifier_id		varchar	"修改者ID",
		modify_time		timestamp	"修改时间",
		role_desc		varchar	"角色描述",
		role_name		varchar	"角色名称",
		role_type		int	"角色类型 0=普通角色;1=管理员角色",
		
		index( create_time,creator_id,modifier_id,modify_time,role_desc,role_name,role_type) 


		)with core=memory , autosearch=true , version=false , key=manu, alias='角色实体类 Business Object' , nickname='univ_demo_sys_role' ;
create class if not exists /univ_demo/sys_role_post_rlt ( 
		create_time		timestamp	"创建时间",
		modify_time		timestamp	"修改时间",
		post_id			varchar	"岗位id",
		post_type		int	" 数据",
		role_id			varchar	"角色id",
		
		index( create_time,modify_time,post_id,post_type,role_id) 


		)with core=memory , autosearch=true , version=false , key=manu, alias='角色关联岗位实体' , nickname='univ_demo_sys_role_post_rlt' ;
create class if not exists /univ_demo/sys_role_user_rlt ( 
		create_time		timestamp	"创建时间",
		creator_id		varchar	"创建者id",
		modifier_id		varchar	"修改者id",
		modify_time		timestamp	"修改时间",
		role_id			varchar	"角色id",
		user_id			varchar	"用户id",
		
		index( create_time,creator_id,modifier_id,modify_time,role_id,user_id) 


		)with core=memory , autosearch=true , version=false , key=manu, alias='用户角色关联实体' , nickname='univ_demo_sys_role_user_rlt' ;
create class if not exists /univ_demo/sys_sa_token_kv ( 
		timeout			bigint	"超时时间",
		val					varchar	"值",
		
		index( timeout,val) 


		)with core=memory , autosearch=true , version=false , key=manu, alias='token缓存库' , nickname='univ_demo_sys_sa_token_kv' ;
create class if not exists /univ_demo/sys_user ( 
		active			int	"删除标识 0=已删除，1=未删除",
		create_time		timestamp	"创建时间",
		email				varchar	"电子邮件",
		enable			int	"禁用标识 0=禁用，1=启用",
		ims_adress		varchar	"即时通讯地址",
		login_code		varchar	"账号",
		login_passwd		varchar	"用户密码",
		mobile_number		varchar	"手机号码",
		modify_time		timestamp	"修改时间",
		notes				varchar	"备注",
		user_name		varchar	"姓名",
		user_origin		varchar	"用户来源",
		
		index( active,create_time,email,enable,ims_adress,login_code,login_passwd,mobile_number,modify_time,notes,user_name,user_origin) 


		)with core=memory , autosearch=true , version=false , key=manu, alias='用户信息' , nickname='univ_demo_sys_user' ;
create class if not exists /univ_demo/szxxsb ( 
		account			varchar	"工号",
		gccrc				varchar	"高层次人才项目分层等级",
		gccrc_code		varchar	"高层次人才项目分层等级代码",
		hjdc				varchar	"获奖等次",
		hjdc_code		varchar	"获奖等次代码",
		hpsj				timestamp	"获批时间",
		jx_yjdj			varchar	"教育教学业绩等级",
		jx_yjdj_code		varchar	"教育教学业绩等级代码",
		name				varchar	"姓名",
		sydw				varchar	"授予单位",
		szgsdw			varchar	"师资归属单位",
		xm_name			varchar	"项目名称",
		xm_name_code		varchar	"项目名称代码",
		xmpx				double	"排序",
		z_mc				varchar	"项目子名称",
		
		index( account,gccrc,gccrc_code,hjdc,hjdc_code,hpsj,jx_yjdj,jx_yjdj_code,name,sydw,szgsdw,xm_name,xm_name_code,xmpx,z_mc) 


		)with core=memory , autosearch=true , version=false , key=manu, alias='人才工程荣誉奖励业绩成果' , nickname='univ_demo_szxxsb' ;
		
create class if not exists /univ_demo/szxxsb_xh ( 
		account			varchar	"工号",
		name				varchar	"姓名",
		pq_jssj			timestamp	"聘期结束时间",
		pq_kssj			timestamp	"聘期开始时间",
		wcrpm				varchar	"担任学会职务",
		wcrpm_code		varchar	"担任学会职务代码",
		xm_name			varchar	"学会名称",
		xm_name_code		varchar	"学会名称代码",
		
		index( account,name,pq_jssj,pq_kssj,wcrpm,wcrpm_code,xm_name,xm_name_code) 


		)with core=memory , autosearch=true , version=false , key=manu, alias='学会职务' , nickname='univ_demo_szxxsb_xh' ;
		
create class if not exists /univ_demo/tech_duty ( 
		account			varchar	"工号",
		duty				varchar	"专业技术职务名称",
		duty_code		varchar	"专业技术职务名称代码",
		duty_level		varchar	"专业技术职务级别",
		duty_level_code		varchar	"专业技术职务级别代码",
		jj_time_end		timestamp	"职务结束时间",
		jj_time_start		timestamp	"职务开始时间",
		last_flag		varchar	"是否现任最高",
		name				varchar	"姓名",
		
		index( account,duty,duty_code,duty_level,duty_level_code,jj_time_end,jj_time_start,last_flag,name) 


		)with core=memory , autosearch=true , version=false , key=manu, alias='专业技术职务' , nickname='univ_demo_tech_duty' ;
		
create class if not exists /univ_demo/tech_gwdj ( 
		account			varchar	"工号",
		hj_dj				varchar	"专业技术岗位等级",
		jjtime_end		timestamp	"岗位等级结束时间",
		jjtime_start		timestamp	"岗位等级开始时间",
		last_flag		varchar	"是否现任最高",
		name				varchar	"姓名",
		
		index( account,hj_dj,jjtime_end,jjtime_start,last_flag,name) 


		)with core=memory , autosearch=true , version=false , key=manu, alias='专业技术岗位等级' , nickname='univ_demo_tech_gwdj' ;