RE: [LANdb] Suggested schema and app changes

 > Yeah, the schema will have to be modified for a more correct vlan
> implementation.  (Jacks currently don't store vlan info.)

I've included a .png of my current work on the schema for review.  Stuff
that still has to go in are support for subnets, and any extra information
each table is to hold.    See the bottom of the message for a couple of
small explanations.

I've got VLANS as a N-N relationship with port.  If we're looking into snmp
support, it'll work great for things like trunking where you say that this
port will carry vlans 1-1000, but only the vlans needed actually get set up.

> Support for terminals, routers, and PCs was requested by another user.
> I'd like your suggestions on what would be necessary to 
> implement this,
> as it seems to be a needed feature.

There are seperate jack and port entities in this schema.  The device could
possibly store what it is connected to.
 
> Yeah, my plan for install.pl was to have it create a 
> temporary database
> and copy tables over, then extract the data back into the new 
> 'nis' (or
> at least, create a '_temp' version of each table within nis 
> as a backup
> version.  Cake.

Perfect....  

A couple of things on the schema that aren't perfect, or perfectly apparent.

Port.Connection and Port.IsJack:  The former contains either a Jack.Jack_IDX
or Port.Port_IDX reference, and IsJack says which table to look in.  I
didn't think it was clean, but I'm told it's the best way to do it, unless
we make a Jack_IDX distinguishable from a Port_IDX.  The rationale behind
these fields is that a Port on a switch can connect to either a jack, or to
another switch.

Now that I think about this, how can/should we model a jack-jack connection,
as in a fibre patch panel?  Do we ignore this altogether, and say that the
device plugged into one end is plugged into the device on the other end?
For simplicity's sake, I'd venture a "yes".

How should subnets fit in?  Can a subnet span more than one VLAN?  (no?)
Can a VLAN contain multiple subnets (yes?).  To complicate things, you can
have a subnet without a vlan, and vice versa.

Sean

landb.png