billmax documentation   BillMax Billing Solutions
  877.245.5629
  sales@billmax.com
 
auth table
Prev  Chapter 3. Database Schema  Next

Name

auth table — table for Permissions data

auth Field Definitions

Name

Description

Data Type BillMax Default
Name

Description

Data Type BillMax Default
access

The Permissions that the Authorized BillMax User will have. Please see the discussion on Permissions in glossary in "Auxiliary Material".

int(11) 0
email

The email address of the Authorized BillMax User.

char(100) BLANK
enddate

The date that the state of the Authorized BillMax User was changed to CLOSED

date 0000-00-00
descr

A more descriptive name for the Authorized BillMax User.

char(100) BLANK
lastip

The IP address from which the last access by the Authorized BillMax User was made.

char(16) BLANK
lastaccess

A timestamp of the last time BillMax was access by the Authorized BillMax User.

int(11) 0
ntries

The number of consecutive failed attempts to access the BillMax system. Counting ends when the systemstate list maxlogintries is reached.

tinyint(4) 0
number

System Identifier for a database row. In most cases automatically generated. Allowable range is 1-2147483647.

mediumint(8) Autogenerated. Generally next available integer.
password

The encrypted password for the Authorized BillMax User.

char(40) No default. User input required.
sessionid

The session ID for the current session.

char(255) BLANK
startdate

The date the Authorized BillMax User was created in BillMax.

date Date the Authorized BillMax User is created
state

Used to enable or disable access for an Authorized BillMax User. Valid values are:

  • 0 - Access Granted (OPEN)

  • 1 - Access Denied (CLOSED)

tinyint(4) 0
user

The username that is used by an Authorized BillMax User to access the Staff Interface.

char(60) No default. User input required.

SEE ALSO

Relevant Interfaces

  1. Library Routines - NONE

  2. Command Line Routines - NONE

  3. CGI Routines - NONE

  4. Web Forms - Permissions Forms

Prev  Up  Next
applylock table  Home  calltrack table
Document Revision A for BillMax 2.2.0   -   Copyright © 1997-2006 The iSpark Group, Inc.

All rights reserved. No part of this documentation may be reproduced or transmitted in any fashion without written permission by The iSpark Group, Inc. This documentation is for the sole use of licensees of the BillMax billing software created by The iSpark Group, Inc. Making the documentation available to a non-licensee of BillMax without written permission of The iSpark Group, Inc. is a violation of the use of this documentation.

While precautions have been taken in the preparation of this documentation, The iSpark Group, Inc. assumes neither liability nor responsibility for errors or omissions, or for damages resulting from the use of the information contained herein.

All terms mentioned that are known to be trademarks have been appropriately capitalized. Use of the a trademark does not affect the validity of any trademark or service mark.

Links to third-party Web sites are provided for convenience. The iSpark Group, Inc. is not responsible for any content contained in the third-party Web sites.

Comments about this documentation may be sent to doc@billmax.com