[ivan: Re: part_svc]
Ivan Kohler
ivan at sisd.com
Fri Nov 6 23:56:46 PST 1998
----- Forwarded message from Ivan Kohler <ivan> -----
Date: Sat, 7 Nov 1998 02:07:39 -0500
From: Ivan Kohler <ivan>
To: "Tom T. Thai" <tomthai at future.net>
Subject: Re: part_svc
On Fri, Oct 23, 1998 at 02:06:34PM -0500, Tom T. Thai wrote:
> 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.
Can you clarify what you're trying to say, specifically what do you mean
by `codes'?
What alternative do you suggest?
> Thomas T. Thai Infomedia Interactive Communications
>
> 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
> >
> >
>
--
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
----- End forwarded message -----
--
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
More information about the freeside-users
mailing list