Good Day everybody,
i need a little bit Help with structuring my Database.
I want to create a customer/device Canvas App.
I already have a table with CustomerName and CustomerID and another table
with CustomerData (Contact, Adress etc), because one customer can have multiple Locations.
-------------------------------------------------------------------------------------------------------------
Now i want to create a second screen, where i see all the devices the customer bought.
(Switch, Firewall, Server, such thing). Therefore i need more tables.
I thought of an Table for Manufactor (like Microsoft), type (like Switch) and description (24Port Poe).
My Problem ist:
Each loction can have multiple devices, and these devices furthermore need different infos.
(Switch = Ip Adress, Wlan APs = SSID and Key and so on).
So i kinda need tables for each type. Table_Switchdata, Table_WLAN_Aps, Table_Server.
How would you create something like this with which relationship?
I'm happy and grateful for each help.
