[freeside-devel] And now for something completely different (svc_* keys)

[ivan]

On Tue, Nov 27, 2001 at 01:09:23PM -0600, Dave Burgess wrote:
> Ivan,
> 
> I'm putting together a short novel on my efforts to implement FreeSide
> in an 'existing' environment and need to have one thing clarified before
> I tank this installation any worse than it already is.
> 
> Do the keys in the various 'svc_*' tables need to be unique amongst the
> family of tables?

Yes.  Each svcnum from cust_svc will have only one record among all the
svc_ tables. 

>  For example, can I have the same svcnum in the
> svc_domain table and the svc_www table?

No.  Very Bad.

>  I know from the database
> perspective there is no real restriction, but I want to double check and
> make sure I'm not going to hose anything up really badly.
> If it doesn't matter, but there is a 'desire' to have them be unique,
> I'd like to know that.
> 
> Finally, I'd like to know if anyone other than me is even reading the
> messages on this list?

ivan at cleanwhisker:~$ ezmlm-list ~/ezmlm-freeside-devel | wc -l
     73

:)

-- 
_ivan