I have been working on a web-based device management system for work, and I have ran into an issue with presenting the user the option of adding more fields as needed. For example, some devices will have say 4x drives, 6x ram modules, etc. My options so far are...
- Hard-code the MySQL Database to have X amount of each type of field.4 disk drive fields, 6 ram module fields, etc. However, most machineswill have less than this, and some may have considerably more.
- Create a table for each type that will possibly have more than one
value. Such as a device_drives table, device_memory table, etc.