# What default fields do you use?

**URL:** https://the.fmsoup.org/t/what-default-fields-do-you-use/2204
**Category:** Bobino's
**Created:** [June 8, 2021, 2:31am UTC](https://the.fmsoup.org/t/what-default-fields-do-you-use/2204 "2021-06-08T02:31:07Z")
**Posts on this page:** 4
**Page:** 1

<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: [June 8, 2021, 2:31am UTC](https://the.fmsoup.org/t/what-default-fields-do-you-use/2204/1 "2021-06-08T02:31:07Z")

</div>

Hi everyone, I'm simply looking for tips about what fields to add by default to pretty much all tables. Please share how you call the fields, what you put in them and how you use them in your solutions.

I'm sure it's the kind of stuff that is fun to hear & lets us learn from other's habits.  
Please add your answer to this post (it is a Wiki)

Keep the obvious to yourself (primary key, creation/modification fields, etc.)

Please edit below this line:

* * *

Field Name:  
Contents:  
Usage:

Field Name:  
Contents:  
Usage:  
...

---

<div class="post-metadata">

### Author: ![Malcolm](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/malcolm/32/196_2.png) [@Malcolm](https://the.fmsoup.org/u/Malcolm)
#### Post date: [June 8, 2021, 5:20pm UTC](https://the.fmsoup.org/t/what-default-fields-do-you-use/2204/2 "2021-06-08T17:20:29Z")

</div>

Surely, the "obvious" fields are the ones that we are most likely to require by default?

---

<div class="post-metadata">

### Author: ![Markus](https://avatars.discourse-cdn.com/v4/letter/m/b782af/32.png) [@Markus](https://the.fmsoup.org/u/Markus)
#### Post date: [June 9, 2021, 5:56am UTC](https://the.fmsoup.org/t/what-default-fields-do-you-use/2204/3 "2021-06-09T05:56:32Z")

</div>

I do not use the 'default fields' option. That was matter of change, it is not so easy (fiddeling around with pref-files, some field types did not work properly in my tests, etc.)

I got a copy of 'Clip Manager' and I have sets of fields in there - that I can copy in a new fm-file

Besides of creation/mutation fields for date, time (separate..), user - I got a field 'ID\_OWN' that is a serial number. The reason for that serial number: Sooner or later, users will come and say that a record was deleted by somebody. In most cases, no record was deleted - the record was overwritten or one forgot to create that. With a hidden serial, it's easy to detect...

There is more in Clip Manager than just fields... There are some scripts and some interface-elements (for example for simulating the old 'zoom' part at the bottom, etc.)

---

<div class="post-metadata">

### Author: ![Torsten](https://yyz2.discourse-cdn.com/flex030/user_avatar/the.fmsoup.org/torsten/32/1574_2.png) [@Torsten](https://the.fmsoup.org/u/Torsten)
#### Post date: [June 9, 2021, 11:39am UTC](https://the.fmsoup.org/t/what-default-fields-do-you-use/2204/4 "2021-06-09T11:39:10Z")

</div>

It's the obvious ones in all tables:

Creation\_Account  
Creation\_Timestamp  
Modification\_Account  
Modification\_Timestamp  
UUID  
SID

I keep templates tables for specific purposes, which are copy-pasted when required. I.e. a value list table has different standard fields than any payload data table.
