
This AI prompt is designed for gpt-3.5-turbo and can be used to generate high-quality results. It's compatible with multiple AI platforms including gpt-3.5-turbo, gpt-4, gpt-4-turbo, gpt-4o, gpt-4o-mini, claude-3-opus, claude-3-sonnet, claude-3.5-sonnet, claude-3-haiku, gemini-pro, gemini-ultra, gemini-1.5-pro, gemini-1.5-flash, llama-2, llama-3, llama-3.1, mistral-7b, mistral-large, mistral-8x7b, stable-diffusion-2.1, stable-diffusion-xl, stable-diffusion-3, dalle-2, dalle-3, midjourney-v4, midjourney-v5, midjourney-v6, grok, grok-2, leonardo-ai, runway-ml, pika-labs, suno-ai, udio, elevenlabs, perplexity, cohere, nano-banana-pro.
This prompt excels in sql scenarios, providing detailed and contextually relevant outputs for your specific needs.
This prompt excels in database design scenarios, providing detailed and contextually relevant outputs for your specific needs.
This prompt excels in postgresql scenarios, providing detailed and contextually relevant outputs for your specific needs.
This prompt excels in schema design scenarios, providing detailed and contextually relevant outputs for your specific needs.
When using this prompt, you can expect professional-grade outputs. This prompt has been viewed 11 times and has been tested by our community to ensure effectiveness. The prompt is designed to work seamlessly with gpt-3.5-turbo and provides consistent, reliable results when used correctly.
{
"role": "Senior Database Administrator",
"task": "Design a Scalable Database Schema",
"domain": "E-commerce Order Management System",
"entities": {
"users": "Customers and Admins",
"products": "Inventory items with variants (size/color)",
"orders": "Transactional data",
"reviews": "User feedback linked to products"
},
"design_rules": {
"normalization": "3rd Normal Form (3NF)",
"keys": "UUID for Primary Keys",
"relationships": "Define explicit Foreign Key constraints",
"indexing": "Add indexes for frequently queried columns (e.g., email, order_date)"
},
"output_format": "Write the raw SQL 'CREATE TABLE' statements compatible with PostgreSQL."
}Download this prompt in your preferred format for offline use or integration into your projects.
Downloads only the prompt content
Loading similar prompts...