I am designing a database to keep track of our network equipment. My db has 2 tables:
sites & circuits
(circuit = cable) & (site = property location)
Each circuit runs between two sites, so it should relate to two sites, yes? The circuit table has the following columns:
ID_circuit (PK), circuit_number, site1, site2. I thought that I could relate my
ID_site field to both
site2, but I cannot. Would I be better off creating a whole other table to hold the locations of both cable ends?