HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials

HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials (http://www.howtoforge.com/forums/index.php)
-   Developers' Forum (http://www.howtoforge.com/forums/forumdisplay.php?f=18)
-   -   Index's (http://www.howtoforge.com/forums/showthread.php?t=36841)

afandino 20th June 2009 18:46

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

till 21st June 2009 13:09

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.


All times are GMT +2. The time now is 00:26.

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