---
title: Best Practices for Database Naming Conventions | ESHA Research
description: Defining naming conventions for your database can help keep your database organized and allow you to quickly filter and identify your Ingredients and Recipes. This post walks through best practices and tips for creating your own naming convention.
image: https://blog.trustwell.com/hubfs/Imported_Blog_Media/database-naming-oct-30.jpg
---

[Skip to content](https://blog.trustwell.com/best-practices-database-naming-conventions#main-content)

- Login
- Support
- Search

[![Trustwelll_logo_2col_pos_RGB](https://blog.trustwell.com/hs-fs/hubfs/Trustwell%20Logos/Trustwelll_logo_2col_pos_RGB.png?width=250&name=Trustwelll_logo_2col_pos_RGB.png)](https://blog.trustwell.com/?hsLang=en)

- [Platform](https://www.trustwell.com/platform/) 
    - Use Cases 
          - [Make Compliant Labels](https://www.trustwell.com/platform/make-compliant-labels/)
          - [Formulate Products](https://www.trustwell.com/platform/formulate-products/)
          - [Comply with Regulations](https://www.trustwell.com/platform/comply-with-regulations/)
          - [Track My Products](https://www.trustwell.com/platform/track-my-products/)
          - [Expedite Recalls](https://www.trustwell.com/platform/expedite-recalls/)
          - [Monitor Supply Chains](https://www.trustwell.com/platform/monitor-supply-chains/)
          - [Manage Quality](https://www.trustwell.com/platform/manage-quality/)
    - Industries 
          - [Restaurants](https://www.trustwell.com/platform/restaurants/)
          - [Grocers + Retailers](https://www.trustwell.com/platform/grocers-retailers/)
          - [Food Manufacturers + CPG](https://www.trustwell.com/platform/food-manufacturers-cpg/)
          - [Wholesale Food Distributors](https://www.trustwell.com/platform/wholesale-food-distributors/)
          - [Supplement Manufacturers](https://www.trustwell.com/platform/supplement-manufacturers/)
          - [Growers, Packers + Shippers](https://www.trustwell.com/platform/growers-packers-shippers/)
- [Products](https://www.trustwell.com/products/) 
    - [Genesis](https://www.trustwell.com/products/genesis/) 
          - [Food Formulation and Labeling](https://www.trustwell.com/products/genesis/food-formulation-and-labeling/)
          - [Supplement Formulation and Labeling](https://www.trustwell.com/products/genesis/supplement-formulation-and-labeling/)
          - [Request a Demo of Genesis](https://www.trustwell.com/products/genesis/request-genesis-demo/)
    - [FoodLogiQ](https://www.trustwell.com/products/foodlogiq/) 
          - [Compliance](https://www.trustwell.com/products/foodlogiq/compliance/)
          - [Quality Management](https://www.trustwell.com/products/foodlogiq/quality-management/)
          - [Traceability](https://www.trustwell.com/products/foodlogiq/traceability/)
          - [Recall](https://www.trustwell.com/products/foodlogiq/recall/)
          - [Request a Demo of FoodLogiQ](https://www.trustwell.com/products/foodlogiq/request-foodlogiq-demo/)
- [Services](https://www.trustwell.com/services/) 
    - Consulting Services 
          - [Food Nutrition Label Consulting](https://www.trustwell.com/services/food-nutrition-label-consulting/)
          - [Supplement Label Consulting](https://www.trustwell.com/services/supplement-nutrition-label-consulting/)
          - [Menu Label Consulting](https://www.trustwell.com/services/menu-consulting-services/)
          - [FSMA 204 Consulting](https://www.trustwell.com/services/fsma-204-consulting/)
    - Software Support 
          - [Training](https://www.trustwell.com/services/training/)
          - [Application Managed Services](https://www.trustwell.com/services/application-managed-services/)
          - [Implementation](https://www.trustwell.com/services/implementation/)
- [Resources](https://www.trustwell.com/resources/) 
    - [Blog](https://blog.trustwell.com)
    - [eBooks](https://www.trustwell.com/ebooks/)
    - [Infographics](https://www.trustwell.com/infographics/)
    - [Podcast](https://www.trustwell.com/podcasts/)
    - [Webinars](https://www.trustwell.com/webinars/)
- [Why Trustwell](https://www.trustwell.com/why-trustwell/) 
    - [Careers](https://www.trustwell.com/why-trustwell/careers/)
    - [Partners](https://www.trustwell.com/why-trustwell/partners/)
    - [Customer Stories](https://www.trustwell.com/why-trustwell/customer-stories/)
    - [News & Press](https://www.trustwell.com/why-trustwell/news-press/)
    - [Our Team](https://www.trustwell.com/why-trustwell/our-team/)

[![Get Started](https://no-cache.hubspot.com/cta/default/21653883/a490ce5f-57c2-483a-b8d1-0e4994f1c2f3.png)](https://cta-redirect.hubspot.com/cta/redirect/21653883/a490ce5f-57c2-483a-b8d1-0e4994f1c2f3)

- [Platform](https://www.trustwell.com/platform/) 
    - Use Cases 
          - [Make Compliant Labels](https://www.trustwell.com/platform/make-compliant-labels/)
          - [Formulate Products](https://www.trustwell.com/platform/formulate-products/)
          - [Comply with Regulations](https://www.trustwell.com/platform/comply-with-regulations/)
          - [Track My Products](https://www.trustwell.com/platform/track-my-products/)
          - [Expedite Recalls](https://www.trustwell.com/platform/expedite-recalls/)
          - [Monitor Supply Chains](https://www.trustwell.com/platform/monitor-supply-chains/)
          - [Manage Quality](https://www.trustwell.com/platform/manage-quality/)
    - Industries 
          - [Restaurants](https://www.trustwell.com/platform/restaurants/)
          - [Grocers + Retailers](https://www.trustwell.com/platform/grocers-retailers/)
          - [Food Manufacturers + CPG](https://www.trustwell.com/platform/food-manufacturers-cpg/)
          - [Wholesale Food Distributors](https://www.trustwell.com/platform/wholesale-food-distributors/)
          - [Supplement Manufacturers](https://www.trustwell.com/platform/supplement-manufacturers/)
          - [Growers, Packers + Shippers](https://www.trustwell.com/platform/growers-packers-shippers/)
- [Products](https://www.trustwell.com/products/) 
    - [Genesis](https://www.trustwell.com/products/genesis/) 
          - [Food Formulation and Labeling](https://www.trustwell.com/products/genesis/food-formulation-and-labeling/)
          - [Supplement Formulation and Labeling](https://www.trustwell.com/products/genesis/supplement-formulation-and-labeling/)
          - [Request a Demo of Genesis](https://www.trustwell.com/products/genesis/request-genesis-demo/)
    - [FoodLogiQ](https://www.trustwell.com/products/foodlogiq/) 
          - [Compliance](https://www.trustwell.com/products/foodlogiq/compliance/)
          - [Quality Management](https://www.trustwell.com/products/foodlogiq/quality-management/)
          - [Traceability](https://www.trustwell.com/products/foodlogiq/traceability/)
          - [Recall](https://www.trustwell.com/products/foodlogiq/recall/)
          - [Request a Demo of FoodLogiQ](https://www.trustwell.com/products/foodlogiq/request-foodlogiq-demo/)
- [Services](https://www.trustwell.com/services/) 
    - Consulting Services 
          - [Food Nutrition Label Consulting](https://www.trustwell.com/services/food-nutrition-label-consulting/)
          - [Supplement Label Consulting](https://www.trustwell.com/services/supplement-nutrition-label-consulting/)
          - [Menu Label Consulting](https://www.trustwell.com/services/menu-consulting-services/)
          - [FSMA 204 Consulting](https://www.trustwell.com/services/fsma-204-consulting/)
    - Software Support 
          - [Training](https://www.trustwell.com/services/training/)
          - [Application Managed Services](https://www.trustwell.com/services/application-managed-services/)
          - [Implementation](https://www.trustwell.com/services/implementation/)
- [Resources](https://www.trustwell.com/resources/) 
    - [Blog](https://blog.trustwell.com)
    - [eBooks](https://www.trustwell.com/ebooks/)
    - [Infographics](https://www.trustwell.com/infographics/)
    - [Podcast](https://www.trustwell.com/podcasts/)
    - [Webinars](https://www.trustwell.com/webinars/)
- [Why Trustwell](https://www.trustwell.com/why-trustwell/) 
    - [Careers](https://www.trustwell.com/why-trustwell/careers/)
    - [Partners](https://www.trustwell.com/why-trustwell/partners/)
    - [Customer Stories](https://www.trustwell.com/why-trustwell/customer-stories/)
    - [News & Press](https://www.trustwell.com/why-trustwell/news-press/)
    - [Our Team](https://www.trustwell.com/why-trustwell/our-team/)

[![Get Started](https://no-cache.hubspot.com/cta/default/21653883/a490ce5f-57c2-483a-b8d1-0e4994f1c2f3.png)](https://cta-redirect.hubspot.com/cta/redirect/21653883/a490ce5f-57c2-483a-b8d1-0e4994f1c2f3)

May 4, 2020

# Best Practices for Database Naming Conventions

Share <http://www.facebook.com/share.php?u=https://blog.trustwell.com/best-practices-database-naming-conventions> <https://twitter.com/intent/tweet?original_referer=https://blog.trustwell.com/best-practices-database-naming-conventions&url=https://blog.trustwell.com/best-practices-database-naming-conventions&source=tweetbutton> <http://www.linkedin.com/shareArticle?mini=true&url=https://blog.trustwell.com/best-practices-database-naming-conventions> [mailto:?subject=Check%20out%20https://blog.trustwell.com/best-practices-database-naming-conventions](mailto:?subject=Check%20out%20https://blog.trustwell.com/best-practices-database-naming-conventions)

The importance of establishing rigorous naming conventions for your Recipes and Ingredients cannot be overstated, especially when working with a large database. A solid naming convention will simplify data organization and allow you to narrow and sort search results to more easily identify your items.

This post walks through best practices and tips for defining your own naming conventions.

## Getting Started

Before delving into specifics, start with a few ground rules:

- Keep it simple. Your naming conventions should be easily understood by everyone in your organization and should follow a logical format.
- Archive older data first. Avoid a huge overhaul by moving your older, unused Recipes and Ingredients out of the naming project. We suggest [creating Groups](https://blog.trustwell.com/blog/organizing-recipes-ingredients-tags/?hsLang=en) called “Archived Ingredients” and “Archived Recipes.” Groups can then be [hidden from search results](https://esha.zendesk.com/hc/en-us/articles/205089655-Is-there-any-way-to-retire-or-hide-user-created-items-Groups-to-Exclude-).
- Consider using a unique identifier in the User Code field. If you generally use unique codes in the Ingredient or Recipe names, you can simplify the database name by putting that identifier in the User Code field. Later, you can search by User Code.
- Stay consistent. Pick a naming convention, document it, and stick to it! Address specifics in your documentation, like capitalization, and make sure to define each naming field.

## Naming Convention Dos

**Naturally Ordered**: Order elements from general (category, family, etc.) to specific (type, flavor, size, etc.) as much as possible, i.e. Latte Nonfat Vanilla (Small 12 oz). This simplifies naming and allows for inferences for naming scenarios that fall outside documented parameters.

**Location: **If your Ingredient or Recipe is intended for a specific geographic region, be sure to include a region code or abbreviation in your naming convention.

**Numbering**: When including numbers in a file name always use at least two digits rather than one in order to maintain a correctly sorted numeric order. Specifically, it is important to include the zero for numbers 0-9 (01, 02, 03, etc.) so you don’t end up with 1, 10, 11, 12 … 19, 2, 20, 21 when you want 01, 02, 03 … 19, 20, 21.

**Version Control:** Some records go through many versions before being finalized and it is important to be able to differentiate between drafts and the final version by giving them each their own designation. (Examples: RecipeA-v01, RecipeA-v02, RecipeA-v03).

**Dates**: If your Ingredient/Recipe is season- or date-specific, you can list the date in the name or product field. As a best practice, state the date “back to front” with the year first. Examples: YYYYMMDD, YYYYMM, or YYYYQ1.

## Naming Convention Don’ts

**Abbreviations**: Avoid using abbreviations, acronyms, initials, and codes *that are not commonly understood* whenever possible.

**Special Characters/Punctuation**: Use of special characters (such as \* : \\ / < > | ” ? ! \[ \] ; = + & £ $) is discouraged.

## Take it Up a Notch

For further organization, we suggest assigning ingredients and recipes to specific groups.  Check out our blog post: [*Using Groups for Organization, Exporting, and Access Control*](https://blog.trustwell.com/blog/using-groups-organization-exporting-access-control/?hsLang=en).

Tag(s): [Trustwell Software](https://blog.trustwell.com/tag/trustwell-software)

## Other posts you might be interested in

View All Posts

## [![ESHA Software Searching Tips & Tricks Featured Image](https://blog.trustwell.com/hs-fs/hubfs/Imported_Blog_Media/search-2.jpg?length=360&name=search-2.jpg) Trustwell Software 4 min read | June 12, 2019 ESHA Software Searching Tips & Tricks Read More](https://blog.trustwell.com/using-our-programs-searching-tips?hsLang=en)

## [![Yield Options in the ESHA Database: Choosing Cooked vs Raw Featured Image](https://blog.trustwell.com/hs-fs/hubfs/Imported_Blog_Media/yield-options-aug-11.jpg?length=360&name=yield-options-aug-11.jpg) Product Formulation 6 min read | August 11, 2017 Yield Options in the ESHA Database: Choosing Cooked vs Raw Read More](https://blog.trustwell.com/yield-options-esha-database-choosing-cooked-vs-raw?hsLang=en)

## [![Using a Nutrition Database for Menu Analysis & Menu Labeling Compliance Featured Image](https://blog.trustwell.com/hs-fs/hubfs/Imported_Blog_Media/blog-database.png?length=360&name=blog-database.png) Product Formulation 5 min read | June 13, 2016 Using a Nutrition Database for Menu Analysis & Menu Labeling Compliance Read More](https://blog.trustwell.com/using-nutrition-database-recipe-analysis?hsLang=en)

## Subscribe to blog updates

![Trustwell Logo](https://blog.trustwell.com/hs-fs/hubfs/Trustwell_2023/Trustwelll_logo_2col_rev_RGB%20(1).png?width=500&name=Trustwelll_logo_2col_rev_RGB%20(1).png)

- [Platform](https://www.trustwell.com/platform/) 
    - [Make Compliant Labels](https://www.trustwell.com/platform/make-compliant-labels/)
    - [Formulate Products](https://www.trustwell.com/platform/formulate-products/)
    - [Comply with Regulations](https://www.trustwell.com/platform/comply-with-regulations/)
    - [Track My Products](https://www.trustwell.com/platform/track-my-products/)
    - [Expedite Recalls](https://www.trustwell.com/platform/expedite-recalls/)
    - [Manage Quality](https://www.trustwell.com/platform/manage-quality/)
    - [Monitor Supply Chains](https://www.trustwell.com/platform/monitor-supply-chains/)
- [Products](https://www.trustwell.com/products/) 
    - [FoodLogiQ](https://www.trustwell.com/products/foodlogiq/) 
          - [Compliance](https://www.trustwell.com/products/foodlogiq/compliance/)
          - [Quality Management](https://www.trustwell.com/products/foodlogiq/quality-management/)
          - [Traceability](https://www.trustwell.com/products/foodlogiq/traceability/)
          - [Recall](https://www.trustwell.com/products/foodlogiq/recall/)
    - [Genesis](https://www.trustwell.com/products/genesis/) 
          - [Food Formulation & Labeling](https://www.trustwell.com/products/genesis/food-formulation-and-labeling/)
          - [Supplement Formulation & Labeling](https://www.trustwell.com/products/genesis/supplement-formulation-and-labeling/)
- [Consulting](https://www.trustwell.com/services/) 
    - [Food Nutrition Label Consulting](https://www.trustwell.com/services/food-nutrition-label-consulting/)
    - [Supplement Label Consulting](https://www.trustwell.com/services/supplement-nutrition-label-consulting/)
    - [Menu Label Consulting](https://www.trustwell.com/services/menu-consulting-services/)
    - [FSMA 204 Consulting](https://www.trustwell.com/services/fsma-204-consulting/)
- [About Trustwell](https://www.trustwell.com/why-trustwell/) 
    - [Careers](https://www.trustwell.com/careers)
    - [Partners](https://www.trustwell.com/why-trustwell/partners/)
    - [Customer Stories](https://www.trustwell.com/why-trustwell/customer-stories/)
    - [News & Press](https://www.trustwell.com/why-trustwell/news-press/)
    - [Team](https://www.trustwell.com/why-trustwell/our-team/)
- [Resources](https://www.trustwell.com/news) 
    - Blog
    - Podcast
- [Contact](https://www.trustwell.com/get-started/) 
    - [Training](https://www.trustwell.com/services/training/trustwell-training-center/)
    - [Support](https://www.trustwell.com/support/)

© 2026 Trustwell

- [Sitemap](https://www.trustwell.com/sitemap/)
- [Accessibility Statement](https://www.trustwell.com/accessibility-statement/)
- [Privacy Policy](https://www.trustwell.com/privacy-policy/)

<https://twitter.com/trustwell_llc> <https://www.linkedin.com/company/trustwell-llc>

```json
{
  "@context" : "https://schema.org",
  "@type" : "BlogPosting",
  "author" : {
    "@type" : "Person",
    "name" : "Admin",
    "url" : "https://blog.trustwell.com/author/admin"
  },
  "dateModified" : "2023-07-17T16:37:20.999Z",
  "datePublished" : "2020-05-04T07:00:00.000Z",
  "headline" : "Best Practices for Database Naming Conventions | ESHA Research",
  "image" : [ "https://blog.trustwell.com/hubfs/Imported_Blog_Media/database-naming-oct-30.jpg" ],
  "mainEntityOfPage" : {
    "@id" : "https://blog.trustwell.com/best-practices-database-naming-conventions",
    "@type" : "WebPage"
  },
  "publisher" : {
    "@type" : "Organization",
    "logo" : {
      "@type" : "ImageObject",
      "url" : "https://blog.trustwell.com/hubfs/Trustwell%20Logos/Trustwelll_logo_2col_pos_RGB.png"
    },
    "name" : "Trustwell"
  }
}
```