Values of Custom Fields and Referential Integrity

Maxwell Kanat-Alexander mkanat at bugzilla.org
Sat Apr 2 08:34:46 UTC 2005


	Myk pointed out to me that if we have one table that contains all the
values for each custom field, it will be impossible to have real
referential integrity in the database backend from columns in the bugs
table to the legal values for that column.

	So, at least for the field values, it could be a good idea to have the
values placed into a structured set of tables, that have a standardized
format and naming scheme.

	That is, one table per custom "select" field.

	Disclaimer: This implies no other position on how anything else for
custom fields should be done. :-) I'll have some idea of what to do
about that when I get there (or I'm sure somebody else will have an idea
when they get there).

	-Max





More information about the developers mailing list