And because I have a thing for parallel grammar (I believe that it reduces cognitive load), I call the timestamp fields “z_CreatedOn” and “z_ModifiedOn” to match “z_CreatedBy” and “z_ModifiedBy”. I prepend a “z_” to them to group them together as utility fields. I’ve found that requiring these fields to have a value has gotten me into hot water, so I also remove that requirement from all of them.Īlso, while I rely heavily on the standard metadata fields such as Creation Timestamp, CreatedBy, ModificationTimestamp, and ModifiedBy, I make some tweaks to them: Now that the FileMaker Migration Tool helps to coordinate serial numbers during data migrations, I find that I prefer serial numbers to UUIDs, so I make that auto-enter change too. The resulting table should include only those fields that you want as your defaults.įor example, I like my primary key to start with “_pk_TableName” so that’s what I call the field (substituting the actual table name later).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |