Carol,

> Definately 1 tables needed to handle it at minimum. Pkey will be
> the issue to make it easier so you'd add to a full nodenumber
> (4d likely bet).

   That I'll be using... (zone:net/node.point, though I'm not really using the
point field for anything yet...)


>  Add a possible populated 5d {at}netname to the initial set and you
> have a generatable key set with the + that covers more than fidonet.

   That's being put in to the nodelist table, but I'm not certain how I'll use
it for the DNS table(s)...


> substrib(15,4) sounds right to hndle the INA

   Not yet certain how I'll be doing that, but more likely to use Perl rather
than SQL, because I'd likely be needing to process more than just the one
flag...  (get the set of flags, process them as an array or hash...)


> but you'd need to NVL or coalesce for null values?

   Not sure about that, but there shouldn't be any null values in the table; 
all fields are defined as 'NOT NULL" and have a default set...  



Jame

--- BBBS/LiI v4.01 Flag