Index's

Discussion in 'Developers' Forum' started by afandino, Jun 20, 2009.

  1. afandino

    afandino ISPConfig Developer

    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
     
  2. till

    till Super Moderator

    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.

    everything with isp_fakt_* is for the invoicing.

    no.
     

Share This Page