# Data storage model — prompt for Gemma

Identify entities and relationships in a specific workflow before writing tables and queries.

Canonical URL: https://boswidget.ru/en/data-storage-model-prompt-for-gemma/

Model: Gemma

Category: Code

Tags: data, entities, relationships

![Data storage model](https://boswidget.ru/assets/images/text-preview-gm-model-hraneniya-rabochih-dannyh-1200.692828e76b9b.webp)

Data storage model

## Prompt

Propose a logical data model for this process: {process}. Example objects and rules: {rules}. List entities, fields, identifiers, relationships and integrity constraints. Distinguish facts from calculated values. Show history storage only if required. Do not add entities without a use case or invent personal-data fields. Give three example operations on the model and questions about ambiguous relationships. SQL and migrations are not needed yet.

## Template fields

- `{process}` — Process. Example input: Which actions participants perform and what must be retained
- `{rules}` — Objects and rules. Example input: Examples, uniqueness, lifecycle and history requirements

## Launch

[Open Gemma in YesAI](https://yesai.su/en/gemma)