AnsweredAssumed Answered

Is it okay to use dummy fields as 'headers' to organise tables ?

Question asked by wladdy on Oct 16, 2012
Latest reply on Mar 28, 2015 by FabianFuentes

Title

Is it okay to use dummy fields as 'headers' to organise tables ?

Post

      

     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
     d_Start
     d_End
     c_Duration
     === Descriptive fields
     d_EventName
     d_EventLocation

     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.

Outcomes