I am, wondering if this would be possible?
have about 300 racks and have been asked with making a SVG out of em all
I noticed that all the racks either have 40,41,42,43,44,45 slots
and also not each rack has the same attributes
I think can us that and create a table
create table racks ( rack_id INT NOT NULL AUTO_INCREMENT, location VARCHAR(100) NOT NULL, elevation VARCHAR(100) NOT NULL, cabinet VARCHAR(100) NOT NULL, power_panel VARCHAR(100) NOT NULL, circuit_breaker VARCHAR(100) NOT NULL, number_of_slots INT NOT NULL, PRIMARY KEY ( rack_id ) );
to hold all my racks
Then because only certain spaces would be taken up on each rack, can I use his stable to hel the utilized spaces inside each rack?
create table rack_slots ( rack_slot_id INT NOT NULL AUTO_INCREMENT, rack_id VARCHAR(100) NOT NULL, slot_number_range INT NOT NULL, devic VARCHAR(100) NOT NULL, PRIMARY KEY ( rack_slot_id ), FOREIGN KEY ( rack_id ) ); then I can use INSERT statements to create the racks and fll the slots up Then should I us a SELECT query to display all he racks? I created a different template for the 6 different size of racks which would depend on the number_of_slots record for each record in the racks table.Am I setting this up right?