part_svc

[Tom T. Thai]

yes this now makes sense.. I'm wondering if this is an effective way to
handle additional tables for svc_xxxx that an ISP might add.  I think
there should be a way for the isp to add additional svc_xxx tables with
out having to change the codes.


..............          ....................................
Thomas T. Thai          Infomedia Interactive Communications
tom at iic.net             TEL 612.376.9090 * FAX 612.376.9087


On Fri, 23 Oct 1998, Ivan Kohler wrote:

> On Fri, 23 Oct 1998, Tom T. Thai wrote:
> 
> > part_svc - Service definitions 
> >           svcpart - primary key 
> >           svc - name of this service 
> >           svcdb - table used for this service: svc_acct, svc_acct_sm,
> >                   svc_domain, svc_charge or svc_wo 
> >           table__field - Default or fixed value for field in table 
> >           table__field_flag - null, D or F 
> > 
> > Does the table_field above represent the VALUE that is to be in a
> > particular FIELD from a table represented by svcdb?
> 
> Yes.
> 
> >  If so, how do you know what the name of the field is for that
> > particular svcdb table? 
> 
> You're reading `table__field' abover *literally*.  There isn't a column in
> the table named `table__field', there are lots of columns in the database
> with `table' replaced by a table name, and `field' replace by a
> field/column name.  If you look at the database itself you will see
> columns like: 
> 
> svc_acct__slipip and svc_acct__slipip_flag
> ^^^^^^^^  ^^^^^^     ^^^^^^^^  ^^^^^^
> table     field      table     field
> 
> Does that clear things up?
> 
> > I don't know, it would seem logical to me that one would need
> > table_field_name up there.
> > ..............          ....................................
> > Thomas T. Thai          Infomedia Interactive Communications
> > tom at iic.net             TEL 612.376.9090 * FAX 612.376.9087
> > 
> > 
> > 
> 
> -- 
> Ivan Kohler <ivan at sisd.com> - finger for PGP key
> Silicon Interactive Software Design - http://www.sisd.com/ - 888-670-SISD
> Open-source billing and administration for ISPs - http://www.sisd.com/freeside
> 20 4,16 * * * saytime # please don't be surprised if you find me dreaming too
> 
>