[freeside-devel] svc_forward must die

[ivan]

I don't think I agree.  You want to add these fields to svc_forward:

>     * src - alias' local part
>     * srcdomsvc - alias' domain svcnum

Instead of just using srcsvc to link to equivalent fields in svc_acct:

    * username
    * domsvc

I think I need a clear, compelling _reason_ why you can't just use srcsvc
to link to svc_acct for this.  Aside from violating the "normal form" 
schema design rules[1], your suggestion makes duplicate username checking
more difficult. 

[1] while I don't hold "normal form" in such reverence that I wouldn't
break them when it makes sense, it does let you know when to
really think twice about something.  Besides, didn't you guys fix the
embarassing "owed" field?  :)

-- 
_ivan


On Thu, May 30, 2002 at 05:56:17PM -0700, Kristian Hoffmann wrote:
> A compromise.  What if svc_forward looked like this...
> 
> * svc_forward - Mail forwarding aliases
> 
>     * svcnum - primary key
>     * srcsvc - svcnum of the source of this forward
>     * src - alias' local part
>     * srcdomsvc - alias' domain svcnum
>     * dstsvc - svcnum of the destination of this forward
>     * dst - foreign destination (email address) - forward not local to freeside
> 
> Yeah, that looks horrible, but it lets you do it both ways for both the
> alias and destination addresses.
> 
> 
>