Prompt Details
Model
Chat - (gpt-5.6)
Token size
213
Example input
[System/Application Name]: E-Commerce Marketplace Platform
[Core Business Logic/Data Volume, e.g., 10 million daily transactions]: 50 million products and 2 million daily orders
[Database Engine, e.g., PostgreSQL / MySQL]: PostgreSQL 15
Example output
**1. Normalized Relational Schema (DDL)**
- Tables: `users`, `products`, `orders`, `order_items`, `inventory`.
- Foreign keys properly mapped with cascading rules and 3NF constraints.
**2. Indexing & Performance Strategy**
- B-Tree index on `orders(customer_id, created_at)` for fast order history retrieval.
- GIN index on `products(metadata jsonb)` for flexible attribute searching.
**3. Critical Query Optimization**
- Window function query to calculate monthly rolling user GMV and retention ranking.
**4. Scalability & Maintenance Plan**
- Partitioning the `orders` table monthly by range on `created_at`.
Instant access
Commercial use
Money‑backBy purchasing this prompt, you agree to our terms of service
1
Views
GPT-5.6
Designs normalized enterprise relational database schemas, indexing strategies, CTE query optimizations, and scalable partitioning architectures.
...more
Added 4 days ago
