#1  
Old 20th June 2009, 18:46
afandino afandino is offline
Member
 
Join Date: May 2009
Posts: 35
Thanks: 1
Thanked 3 Times in 3 Posts
Default Index's

till,

I need a little guidance here.
Can i have the index definitions for the following fields from the database.

userid

groupid

doctype_id

tree_id

type

doc_id


this is from the isp_nodes table.

Are the Isp_fakt_nodes and isp_fakt_artikel the only tables used for the invoiceing ?

Do you have any documentation how your billing system functions ? Flow charts ? anythin ?

tony
Reply With Quote
Sponsored Links
  #2  
Old 21st June 2009, 13:09
till till is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 35,421
Thanks: 812
Thanked 5,205 Times in 4,081 Posts
 
Default

userid = id of the users, see sys_user table.
groupid = The groupid if the user, see group table.
doctype_id = doctype ID, see doctpye table
tree_id = primary ID of the *_nodes table
type = type of the node. There are two types, one for nodes and one for folders.
doc_id = the doc_id of the object were this node is for, see isp_isp_web, isp_isp_domain etc.

Quote:
Are the Isp_fakt_nodes and isp_fakt_artikel the only tables used for the invoiceing ?
everything with isp_fakt_* is for the invoicing.

Quote:
Do you have any documentation how your billing system functions ? Flow charts ? anythin ?
no.
__________________
Till Brehm
--
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote
Reply

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT +2. The time now is 02:33.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.