Prompt 工具DeepSeek 使用概览输出结果概览一、表结构设计说明涉及的表BASE_MATERIAL_CATEGORY- 采购系统物料分类基础表已存在见Excel第145-156行BIZ_MATERIAL_CATEGORY_MAPPING- 物料分类映射关系表新增二、DDL语句DROP TABLE IF EXISTS BIZ_MATERIAL_CATEGORY_MAPPING; CREATE TABLE BIZ_MATERIAL_CATEGORY_MAPPING ( ID VARCHAR(64) NOT NULL, PURCHASE_CATEGORY_ID VARCHAR(64), PURCHASE_CATEGORY_CODE VARCHAR(64), PURCHASE_CATEGORY_NAME VARCHAR(516), PURCHASE_LEVEL_ONE_CODE VARCHAR(64), PURCHASE_LEVEL_ONE_NAME VARCHAR(516), PURCHASE_LEVEL_TWO_CODE VARCHAR(64), PURCHASE_LEVEL_TWO_NAME VARCHAR(516), PURCHASE_LEVEL_THREE_CODE VARCHAR(64), PURCHASE_LEVEL_THREE_NAME VARCHAR(516), PURCHASE_LEVEL_FOUR_CODE VARCHAR(64), PURCHASE_LEVEL_FOUR_NAME VARCHAR(516), MARKETING_LEVEL_ONE_CODE VARCHAR(64), MARKETING_LEVEL_ONE_NAME VARCHAR(516), MARKETING_LEVEL_TWO_CODE VARCHAR(64), MARKETING_LEVEL_TWO_NAME VARCHAR(516), MARKETING_LEVEL_THREE_CODE VARCHAR(64), MARKETING_LEVEL_THREE_NAME VARCHAR(516), MAPPING_STATUS TINYINT, BIND_TIME TIMESTAMP(6), UNBIND_TIME TIMESTAMP(6), BIND_BY VARCHAR(64), UNBIND_BY VARCHAR(64), ORG_CODE VARCHAR(64), ENTITY_NAME VARCHAR(64), ENTITY_CODE VARCHAR(64), APPLY_TIME TIMESTAMP(6), APPLICANT VARCHAR(64), APPLICANT_DEPT_ID VARCHAR(64), CREATE_TIME TIMESTAMP(6), CREATE_BY VARCHAR(64), UPDATE_TIME TIMESTAMP(6), UPDATE_BY VARCHAR(64), DEL_FLAG TINYINT DEFAULT 1 NOT NULL, NOT CLUSTER PRIMARY KEY(ID) ) STORAGE(CLUSTERBTR); COMMENT ON TABLE BIZ_MATERIAL_CATEGORY_MAPPING IS 物料分类映射关系表; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.ID IS 主键ID; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.PURCHASE_CATEGORY_ID IS 采购系统物料分类ID关联BASE_MATERIAL_CATEGORY.ID; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.PURCHASE_CATEGORY_CODE IS 采购系统物料分类编码; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.PURCHASE_CATEGORY_NAME IS 采购系统物料分类名称; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.PURCHASE_LEVEL_ONE_CODE IS 采购系统一级物料分类编码; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.PURCHASE_LEVEL_ONE_NAME IS 采购系统一级物料分类名称; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.PURCHASE_LEVEL_TWO_CODE IS 采购系统二级物料分类编码; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.PURCHASE_LEVEL_TWO_NAME IS 采购系统二级物料分类名称; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.PURCHASE_LEVEL_THREE_CODE IS 采购系统三级物料分类编码; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.PURCHASE_LEVEL_THREE_NAME IS 采购系统三级物料分类名称; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.PURCHASE_LEVEL_FOUR_CODE IS 采购系统四级物料分类编码; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.PURCHASE_LEVEL_FOUR_NAME IS 采购系统四级物料分类名称; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.MARKETING_LEVEL_ONE_CODE IS 新营销系统一级物料分类编码; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.MARKETING_LEVEL_ONE_NAME IS 新营销系统一级物料分类名称; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.MARKETING_LEVEL_TWO_CODE IS 新营销系统二级物料分类编码; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.MARKETING_LEVEL_TWO_NAME IS 新营销系统二级物料分类名称; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.MARKETING_LEVEL_THREE_CODE IS 新营销系统三级物料分类编码; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.MARKETING_LEVEL_THREE_NAME IS 新营销系统三级物料分类名称; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.MAPPING_STATUS IS 映射状态10-已绑定 20-已解绑; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.BIND_TIME IS 绑定时间; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.UNBIND_TIME IS 解绑时间; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.BIND_BY IS 绑定操作人; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.UNBIND_BY IS 解绑操作人; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.ORG_CODE IS 组织机构; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.ENTITY_NAME IS 申请人-店铺简称; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.ENTITY_CODE IS 申请人-店铺编码; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.APPLY_TIME IS 申请人-提报时间; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.APPLICANT IS 申请人; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.APPLICANT_DEPT_ID IS 申请人-申请部门; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.CREATE_TIME IS 创建时间; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.CREATE_BY IS 创建人; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.UPDATE_TIME IS 修改时间; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.UPDATE_BY IS 修改人; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.DEL_FLAG IS 删除标记0-已删除 1-未删除;三、辅助索引建议-- 采购分类编码索引 CREATE INDEX IDX_MAPPING_PURCHASE_CODE ON BIZ_MATERIAL_CATEGORY_MAPPING(PURCHASE_CATEGORY_CODE); -- 采购系统分类ID索引 CREATE INDEX IDX_MAPPING_PURCHASE_CATE_ID ON BIZ_MATERIAL_CATEGORY_MAPPING(PURCHASE_CATEGORY_ID); -- 映射状态索引用于查询已绑定/未绑定 CREATE INDEX IDX_MAPPING_STATUS ON BIZ_MATERIAL_CATEGORY_MAPPING(MAPPING_STATUS); -- 新营销三级分类编码索引 CREATE INDEX IDX_MAPPING_MARKETING_THREE ON BIZ_MATERIAL_CATEGORY_MAPPING(MARKETING_LEVEL_THREE_CODE); -- 组合索引采购四级分类编码 状态 CREATE INDEX IDX_MAPPING_PURCHASE_FOUR_STATUS ON BIZ_MATERIAL_CATEGORY_MAPPING(PURCHASE_LEVEL_FOUR_CODE, MAPPING_STATUS);Prompt 提示词工程建议一、概览 Xmind二、提示词 - 编写攻略高效提示词框架模板# 角色选填你是一名 [ 专家角色例如资深文案、数据分析师、编程导师 ]。# 任务必填请帮我 [ 清晰描述你需要完成的具体任务例如写一篇产品推广文案、解释某个概念、生成一段代码 ]。# 背景信息选填[ 提供与任务相关的背景或上下文例如目标受众是谁、产品特点、已有资料或数据、风格偏好等。背景越具体回复越贴合需求。]# 输出要求选填- 格式[ 例如Markdown、JSON、纯文本、表格、列表 ]- 长度[ 例如200字左右、3-5个要点、不超过500字 ]- 风格[ 例如正式、幽默、通俗易懂、专业 ]- 其他特殊要求[ 如分点阐述、包含数据引用、避免使用某些术语等 ]# 示例选填[ 提供一个你期望的输入输出示例帮助 AI 理解你的具体需求。]例如输入[...]输出[...]# 约束选填[ 任何需要避免的事项或必须遵守的规则例如不能包含政治敏感内容、必须基于给定的数据、不能编造事实等。]
数据库设计 Prompt 提示词 - 构建与迭代
Prompt 工具DeepSeek 使用概览输出结果概览一、表结构设计说明涉及的表BASE_MATERIAL_CATEGORY- 采购系统物料分类基础表已存在见Excel第145-156行BIZ_MATERIAL_CATEGORY_MAPPING- 物料分类映射关系表新增二、DDL语句DROP TABLE IF EXISTS BIZ_MATERIAL_CATEGORY_MAPPING; CREATE TABLE BIZ_MATERIAL_CATEGORY_MAPPING ( ID VARCHAR(64) NOT NULL, PURCHASE_CATEGORY_ID VARCHAR(64), PURCHASE_CATEGORY_CODE VARCHAR(64), PURCHASE_CATEGORY_NAME VARCHAR(516), PURCHASE_LEVEL_ONE_CODE VARCHAR(64), PURCHASE_LEVEL_ONE_NAME VARCHAR(516), PURCHASE_LEVEL_TWO_CODE VARCHAR(64), PURCHASE_LEVEL_TWO_NAME VARCHAR(516), PURCHASE_LEVEL_THREE_CODE VARCHAR(64), PURCHASE_LEVEL_THREE_NAME VARCHAR(516), PURCHASE_LEVEL_FOUR_CODE VARCHAR(64), PURCHASE_LEVEL_FOUR_NAME VARCHAR(516), MARKETING_LEVEL_ONE_CODE VARCHAR(64), MARKETING_LEVEL_ONE_NAME VARCHAR(516), MARKETING_LEVEL_TWO_CODE VARCHAR(64), MARKETING_LEVEL_TWO_NAME VARCHAR(516), MARKETING_LEVEL_THREE_CODE VARCHAR(64), MARKETING_LEVEL_THREE_NAME VARCHAR(516), MAPPING_STATUS TINYINT, BIND_TIME TIMESTAMP(6), UNBIND_TIME TIMESTAMP(6), BIND_BY VARCHAR(64), UNBIND_BY VARCHAR(64), ORG_CODE VARCHAR(64), ENTITY_NAME VARCHAR(64), ENTITY_CODE VARCHAR(64), APPLY_TIME TIMESTAMP(6), APPLICANT VARCHAR(64), APPLICANT_DEPT_ID VARCHAR(64), CREATE_TIME TIMESTAMP(6), CREATE_BY VARCHAR(64), UPDATE_TIME TIMESTAMP(6), UPDATE_BY VARCHAR(64), DEL_FLAG TINYINT DEFAULT 1 NOT NULL, NOT CLUSTER PRIMARY KEY(ID) ) STORAGE(CLUSTERBTR); COMMENT ON TABLE BIZ_MATERIAL_CATEGORY_MAPPING IS 物料分类映射关系表; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.ID IS 主键ID; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.PURCHASE_CATEGORY_ID IS 采购系统物料分类ID关联BASE_MATERIAL_CATEGORY.ID; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.PURCHASE_CATEGORY_CODE IS 采购系统物料分类编码; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.PURCHASE_CATEGORY_NAME IS 采购系统物料分类名称; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.PURCHASE_LEVEL_ONE_CODE IS 采购系统一级物料分类编码; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.PURCHASE_LEVEL_ONE_NAME IS 采购系统一级物料分类名称; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.PURCHASE_LEVEL_TWO_CODE IS 采购系统二级物料分类编码; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.PURCHASE_LEVEL_TWO_NAME IS 采购系统二级物料分类名称; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.PURCHASE_LEVEL_THREE_CODE IS 采购系统三级物料分类编码; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.PURCHASE_LEVEL_THREE_NAME IS 采购系统三级物料分类名称; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.PURCHASE_LEVEL_FOUR_CODE IS 采购系统四级物料分类编码; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.PURCHASE_LEVEL_FOUR_NAME IS 采购系统四级物料分类名称; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.MARKETING_LEVEL_ONE_CODE IS 新营销系统一级物料分类编码; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.MARKETING_LEVEL_ONE_NAME IS 新营销系统一级物料分类名称; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.MARKETING_LEVEL_TWO_CODE IS 新营销系统二级物料分类编码; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.MARKETING_LEVEL_TWO_NAME IS 新营销系统二级物料分类名称; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.MARKETING_LEVEL_THREE_CODE IS 新营销系统三级物料分类编码; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.MARKETING_LEVEL_THREE_NAME IS 新营销系统三级物料分类名称; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.MAPPING_STATUS IS 映射状态10-已绑定 20-已解绑; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.BIND_TIME IS 绑定时间; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.UNBIND_TIME IS 解绑时间; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.BIND_BY IS 绑定操作人; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.UNBIND_BY IS 解绑操作人; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.ORG_CODE IS 组织机构; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.ENTITY_NAME IS 申请人-店铺简称; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.ENTITY_CODE IS 申请人-店铺编码; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.APPLY_TIME IS 申请人-提报时间; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.APPLICANT IS 申请人; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.APPLICANT_DEPT_ID IS 申请人-申请部门; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.CREATE_TIME IS 创建时间; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.CREATE_BY IS 创建人; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.UPDATE_TIME IS 修改时间; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.UPDATE_BY IS 修改人; COMMENT ON COLUMN BIZ_MATERIAL_CATEGORY_MAPPING.DEL_FLAG IS 删除标记0-已删除 1-未删除;三、辅助索引建议-- 采购分类编码索引 CREATE INDEX IDX_MAPPING_PURCHASE_CODE ON BIZ_MATERIAL_CATEGORY_MAPPING(PURCHASE_CATEGORY_CODE); -- 采购系统分类ID索引 CREATE INDEX IDX_MAPPING_PURCHASE_CATE_ID ON BIZ_MATERIAL_CATEGORY_MAPPING(PURCHASE_CATEGORY_ID); -- 映射状态索引用于查询已绑定/未绑定 CREATE INDEX IDX_MAPPING_STATUS ON BIZ_MATERIAL_CATEGORY_MAPPING(MAPPING_STATUS); -- 新营销三级分类编码索引 CREATE INDEX IDX_MAPPING_MARKETING_THREE ON BIZ_MATERIAL_CATEGORY_MAPPING(MARKETING_LEVEL_THREE_CODE); -- 组合索引采购四级分类编码 状态 CREATE INDEX IDX_MAPPING_PURCHASE_FOUR_STATUS ON BIZ_MATERIAL_CATEGORY_MAPPING(PURCHASE_LEVEL_FOUR_CODE, MAPPING_STATUS);Prompt 提示词工程建议一、概览 Xmind二、提示词 - 编写攻略高效提示词框架模板# 角色选填你是一名 [ 专家角色例如资深文案、数据分析师、编程导师 ]。# 任务必填请帮我 [ 清晰描述你需要完成的具体任务例如写一篇产品推广文案、解释某个概念、生成一段代码 ]。# 背景信息选填[ 提供与任务相关的背景或上下文例如目标受众是谁、产品特点、已有资料或数据、风格偏好等。背景越具体回复越贴合需求。]# 输出要求选填- 格式[ 例如Markdown、JSON、纯文本、表格、列表 ]- 长度[ 例如200字左右、3-5个要点、不超过500字 ]- 风格[ 例如正式、幽默、通俗易懂、专业 ]- 其他特殊要求[ 如分点阐述、包含数据引用、避免使用某些术语等 ]# 示例选填[ 提供一个你期望的输入输出示例帮助 AI 理解你的具体需求。]例如输入[...]输出[...]# 约束选填[ 任何需要避免的事项或必须遵守的规则例如不能包含政治敏感内容、必须基于给定的数据、不能编造事实等。]
