Hi all!
I would like to ask you guys a question regarding the design of one application I'm involved with.
We are preparing a basic software for some different clients. However the application needs to be changed by its owner.
This implies each end user may be able to add columns (or tables) to the system. However and to avoid communication issues, only the basic information should be
transferred.
Up to now, some ideas has come into my mind, like:
1. adding additional tables for the extra columns the user wants to add.
2. Add the extra columns to the existing tables and create a view with the common columns to everyone.
Do would you suggest? Any ideas?
Thank you very much in advance.
David.
I would like to ask you guys a question regarding the design of one application I'm involved with.
We are preparing a basic software for some different clients. However the application needs to be changed by its owner.
This implies each end user may be able to add columns (or tables) to the system. However and to avoid communication issues, only the basic information should be
transferred.
Up to now, some ideas has come into my mind, like:
1. adding additional tables for the extra columns the user wants to add.
2. Add the extra columns to the existing tables and create a view with the common columns to everyone.
Do would you suggest? Any ideas?
Thank you very much in advance.
David.