当前位置：首页 > news >正文

数据库设计 Prompt 提示词 - 构建与迭代

news 2026/6/13 3:08:56

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 理解你的具体需求。]
例如：
输入：[...]
输出：[...]
# 约束（选填）
[ 任何需要避免的事项或必须遵守的规则，例如：不能包含政治敏感内容、必须基于给定的数据、不能编造事实等。]