3 ms·
Please don't do this! Entity-Attribute-Value tables are a nightmare waiting to happen about 98% of the time. If there's something wrong with your DBMS where th
by bcoates 14y ago
Please don't do this! Entity-Attribute-Value tables are a nightmare waiting to happen about 98% of the time.
If there's something wrong with your DBMS where the alter table to add a row is an expensive or dangerous operation, just add a new table for every attribute, having lots of tables in a database is no worse than having lots of variables in a program.
If your DBA gets angry at you for adding new tables all the time, get a new DBA.