Survey with many columns
From: Philipp Lenssen <philipp.lenssen_at_bb-k.com>
Date: Fri, 15 Aug 2003 18:16:14 +0200
Message-ID: <MPG.19a725bec39f6efe98968e_at_News.Individual.DE>
My colleague is working on a project which should store data from a long survey. His single table now has many, many columns (labelled "a_1_1" and so on), with different data types (some boolean, some integers, some text, and so on).
E.g. what would be if the next survey comes along, one which has different fields. Would everything need to be redone from scratch? Received on Fri Aug 15 2003 - 18:16:14 CEST
Date: Fri, 15 Aug 2003 18:16:14 +0200
Message-ID: <MPG.19a725bec39f6efe98968e_at_News.Individual.DE>
My colleague is working on a project which should store data from a long survey. His single table now has many, many columns (labelled "a_1_1" and so on), with different data types (some boolean, some integers, some text, and so on).
Is there a way to optimize this?
E.g. what would be if the next survey comes along, one which has different fields. Would everything need to be redone from scratch? Received on Fri Aug 15 2003 - 18:16:14 CEST