AgentSkillsCN

prisma-data-modeling

设计 Prisma Schema、关系与索引的指导原则。在修改 schema.prisma 或讨论数据库结构时使用。

SKILL.md
--- frontmatter
name: prisma-data-modeling
description: Guidelines for designing Prisma schema, relationships, and indexes. Use when modifying schema.prisma or discussing database structure.

Prisma Data Modeling Skill

This skill ensures the database scales well and maintains data integrity for the Midas Web Concept.

🏗️ Modeling Standards

1. Naming Conventions

  • •Models: PascalCase (e.g., LimitOrder, PortfolioItem).
  • •Fields: camelCase (e.g., createdAt, userId).
  • •Foreign Keys: Use userId pointing to User.

2. Monetary Fields

ALWAYS use the following definition for price/balance fields:

prisma
amount Decimal @db.Decimal(19, 4)