💻 Codingadvanced6 variables

Design Database Schema

Create database schemas and data models.

databaseschemadata-modeling

Template

Design a {{database_type}} database schema for: {{application}} Entities and relationships: {{entities}} Requirements: - Consider normalization level: {{normalization}} - Index strategy for: {{query_patterns}} - {{additional_requirements}} Please provide: 1. Table/collection definitions 2. Relationships and constraints 3. Indexes 4. Example queries

Variables to Fill In

1
{{database_type}}

Database type

Example: PostgreSQL

2
{{application}}

Application type

Example: E-commerce platform

3
{{entities}}

Main entities

Example: Users, Products, Orders, Reviews

4
{{normalization}}

Normalization level

Example: 3NF

5
{{query_patterns}}

Common queries

Example: User orders, product searches

6
{{additional_requirements}}

Other requirements

Example: Soft deletes, audit trails

Example Usage

Variables Used:

database_type = MongoDB
application = Social media app
entities = Users, Posts, Comments
normalization = Embedded documents where appropriate
query_patterns = User feeds, post comments
additional_requirements = Real-time updates

Result:

Design a MongoDB schema for a social media app with Users, Posts, Comments and real-time update support.

Tips for Best Results

  • 1Be specific with your variables - the more detail you provide, the better the AI response.
  • 2Start with the example values if you're unsure, then customize based on your needs.
  • 3Iterate on the results - if the first response isn't perfect, refine your variables and try again.
  • 4Combine multiple templates for complex tasks that require different perspectives.