# Acronyms, prefixes, suffixes commonly used

**URL:** <https://the.fmsoup.org/t/acronyms-prefixes-suffixes-commonly-used/762>\
**Category:** Wiki\
**Created:** [February 12, 2020, 9:42pm UTC](https://the.fmsoup.org/t/acronyms-prefixes-suffixes-commonly-used/762 "2020-02-12T21:42:56Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Cecile](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/cecile/32/98_2.png) [@Cecile](https://the.fmsoup.org/u/Cecile)\
**Post date:** [February 12, 2020, 9:42pm UTC](https://the.fmsoup.org/t/acronyms-prefixes-suffixes-commonly-used/762/1 "2020-02-12T21:42:56Z")

</div>

| String | Meaning |
| --- | --- |
| c | prefix or suffix developers put in field names to inform that it is a calculated field |
| CRUD | create, read, update, and delete: the four basic functions of persistent storage. |
| DRY | Don't Repeat Yourself : DRY coding |
| ERD | Entity Relationship Diagram |
| ESS integration | External SQL Source. Some Database Engines like Oracle and MS SQL are sources for FileMaker. One may even add a TO to tables in such a database. |
| ET | ~~a little alien~~ External Table (often viewed from another context through a portal) |
| FK | Foreign Key |
| g | prefix or suffix developers put in field names to inform that it is a global field |
| GTRR | go to related records |
| KISS | Keep it stupid and simple |
| MDI | |
| MVP | Minimum Viable Product |
| PK | Primary Key |
| PSOS | Perform Script On Server |
| RAD | Rapid Application Development |
| RG | Relationship Graph |
| SDI | |
| TO | Table Occurrence |
| TOG | Table Occurrence Group |

---

<div class="post-metadata">

**Author:** ![Bobino](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/bobino/32/194_2.png) [@Bobino](https://the.fmsoup.org/u/Bobino)\
**Post date:** [February 12, 2020, 10:33pm UTC](https://the.fmsoup.org/t/acronyms-prefixes-suffixes-commonly-used/762/2 "2020-02-12T22:33:12Z")

</div>

Suggestions:

- Remove 'c' and 'g' entries as they are more naming conventions (not too sure a single letter can be an acronym, but I may be wrong)
- If possible, use table markdown to make this easier to read

---

<div class="post-metadata">

**Author:** ![Cecile](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/cecile/32/98_2.png) [@Cecile](https://the.fmsoup.org/u/Cecile)\
**Post date:** [February 12, 2020, 11:15pm UTC](https://the.fmsoup.org/t/acronyms-prefixes-suffixes-commonly-used/762/3 "2020-02-12T23:15:23Z")

</div>

True. However naming convention are commonly used by chunks of people in the community, are often understood or easy to deduce by people in the know and experts but require to be explicit for newbies.