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

猫猫聚会Ing

253人浏览 · 2026-06-12 12:13:50

猫猫聚会Ing · 2026-06-12 12:13:50 发布

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 理解你的具体需求。]
例如：
输入：[...]
输出：[...]

# 约束（选填）
[ 任何需要避免的事项或必须遵守的规则，例如：不能包含政治敏感内容、必须基于给定的数据、不能编造事实等。]