1 year ago

how to handle database tables with similar fields

Posted 1 year ago by Sabonzy

i have database tables Applicants, Batteries,Inverters and Solar Panels. the table fields on Batteries,Inverters and Solar Panels are the same,

Total number Capacity Voltage and they are related to the Applicants table. So my questions is should i seperate Batteries,Inverters and Solar Panels into individual tables or use one table and add a field to differentiate them like this Type (battery,inverter,solar panel) Total number Capacity Voltage

Please sign in or create an account to participate in this conversation.