RE: [LANdb] schema changes

Regarding the last question, are you going to be ditching the
auto_increments in the jack and port tables, and going to a generated id, ie
p0001, j00001?  That makes the port table a bit easier, because we can
figure out if a port connects to a port or a jack via the connection column
without an extra column to say what's what.

Sean

-----Original Message-----
From: John Madden [mailto:weez@avenir.dhs.org]
Sent: Tuesday, January 18, 2000 12:34 PM
To: 'landb@avenir.dhs.org'
Subject: RE: [LANdb] schema changes


> - Jacks, bound to closet or building?  Building, I believe.

Building.

> - VLANS, subnets, ports and their relationship

Multiple subnets per vlan, multiple vlans per port, like subnets on
different vlans... anything else?

> - Were we going with the Cable, Connector, and Patch tables as suggested
by
> Teddy?

Ask Teddy, but as far as I know, if it connects two pieces of network
hardware (rather than a switch to a workstation), the port is considered
'trunking,' and we needn't go much further with it.

John




-------------------------------------
LANdb - The Network Management Database
To unsubscribe, send email to landb-request@avenir.dhs.org
	and put 'unsubscribe' in the subject line
Administrative contact: weez@avenir.dhs.org
-------------------------------------

-------------------------------------
LANdb - The Network Management Database
To unsubscribe, send email to landb-request@avenir.dhs.org
	and put 'unsubscribe' in the subject line
Administrative contact: weez@avenir.dhs.org
-------------------------------------