Frames Modems Help Home Page Chipsets Search No Frames
Diary Entries See also Site Info & Diary.
2 October 2001 Still completing the first section of tables...

(the previous links table was altered to be totally generic)
  Modems above will almost certainly need changing. I'm also getting in a bit of a tizz whilst trying to get my head around the relationships involved in the child tables. There are multiple Links for manufacturers, and also for modems. Since the format is pretty much the same for both it makes sense to have a single table, but then a means is needed to easily & quickly extract the correct ones.

I've clearly reached the 'Hard Work' state of this work. Having created so much I'm now beginning to lose track of everything. The first flush of excitement of getting started has faded & now things are beginning to be a grind. Hah! Just wait until I have to enter all the details into the tables - that will be a grind. Still, I need to finish these last child tables & then draw up a relationships chart to make sure that it works on paper. Then construct the PHP scripts to start filling the tables & discover it all needs changing...
 
  1. Links Look-up - this is how the links for a modem are found: 
      CREATE TABLE linkDLU (
  DID INT UNSIGNED NOT NULL,
  LID INT UNSIGNED NOT NULL,
  TID TINYINT UNSIGNED NOT NULL, /* Types of Links */
  OID TINYINT UNSIGNED, /* Types of OS */
  PID TINYINT UNSIGNED, /* Types of protocol */
  Description TINYTEXT,
  PRIMARY KEY(DID, LID, TID)
  );
    (this is unfinished - a means needs finding of allowing same-type links at multiple sites)
    (14 Jan - all tables continued now at 14 Jan)
  So - 21 tables in this first section (the main section) of modem manufacturers & chipset manufacturers, and certainly not finished. It needs now some PHP pages to create web forms to allow the tables to be filled, and some PHP pages to allow the results to be used. Phew.