Is it okay to use dummy fields as 'headers' to organise tables ?
I have tables with dozens of fields, including raw data, calculations and summaries. To make such tables more organized and easier to understand, I am considering adding dummy fields to act like headers for a group of fields logically linked. For example, a table could look like:
=== Time fields
=== Descriptive fields
I wonder whether this idea makes sense or whether it will cause problems that I cannot yet foresee. Of course, the dummy fields will always remain empty, but even so will they affect the database’s efficiency? Should their type be text, number or something else? All comments will be most welcome. Thanks. W.