13. PostgreSQL Schema：基礎會員與交易 (Prisma)

What problem does it solve?

This Skill helps you bootstrap a clean Prisma data layer for a trading app by defining the PostgreSQL schema models needed to persist core concepts like users (members) and their trades.

Core Features & Use Cases

• Create Prisma schema structure: Adds the foundational Prisma schema.prisma content for member and trade persistence.
• Define relational fields: Models are designed to support linking trades to users (members) and tracking trade attributes over time.
• Use Case: When you move from JSON storage to Neon PostgreSQL, you can generate the Prisma schema first, run migrations, and then implement repository code for /api trade workflows.

Quick Start

Use the Skill to generate the complete Prisma schema for member and trade tables, then run Prisma migrate to apply it to your Neon PostgreSQL database.