part_svc

Ivan Kohler ivan at sisd.com
Fri Oct 23 11:50:35 PDT 1998


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




More information about the freeside-users mailing list