Posted by Edward Z. Yang on 05/22/07 19:18

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Anibal Caixinha wrote:
> I'm trying to create a task manager , for accounting firm, they have a
> series of regular tasks they need to be able to control , research old
> records,etc... The problem is that all of these tasks have a common
> set of fields ,the problem is that some of them have some specific
> fiels (most of them just text fields). Has anyone developed a similar
> system and/or can give some hints on how I can alow the user to
> generate these fields on the fly ?

While it is possible for one to change the database schema dynamically,
it's not recommended. Do end-users actually create the fields, or is it
just certain tasks (developer defined) that have special fields? If it
is the former case, use nenegoro's solution. If it is the latter case,
look into the Single Table/Class Table and Concrete Table Inheritance
design patterns.

- --
Edward Z. Yang GnuPG: 0x869C48DA
HTML Purifier <htmlpurifier.org> Anti-XSS HTML Filter
[[ 3FA8 E9A9 7385 B691 A6FC B3CB A933 BE7D 869C 48DA ]]
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (MingW32)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFGU0H9qTO+fYacSNoRApfvAJ0UO/4HxSaP6MOXxh3AhoUcU7KzaACfeUFR
lR66iCnJkPdz07sR9g9TLfY=
=Uz5N
-----END PGP SIGNATURE-----

[Back to original message]