877.245.5629
sales@billmax.com
|
BillMax Billing Solutions 877.245.5629 sales@billmax.com |
| user table | ||
|---|---|---|
 |
Chapter 3. Database Schema | 
|
user table — table for User data
| Name | Description |
Data Type | BillMax Default |
|---|---|---|---|
| Name | Description |
Data Type | BillMax Default |
| account | A valid value from account.number denoting the Account to which this User belongs. |
int(11) | No default. User input required. |
| addr1 | Address field |
char(50) | Copied from Account |
| addr2 | Address field |
char(50) | Copied from Account |
| addr3 | Address field |
char(50) | Copied from Account |
| addr4 | Address field |
char(50) | Copied from Account |
| aphone | Placeholder for an alternative phone number. |
char(40) | BLANK |
| city | The city of the User. |
char(30) | Copied from Account |
| country | The country of the User. |
char(30) | Copied from Account |
| custsecret | Placeholder for phrase or word that a User may supply to validate their identification. Also may be used for validation when the User uses the Customer Interface. |
char(50) | BLANK |
| dataphone | Place holder for phone number from which modem may be calling. |
char(20) | Copied from Account |
| dlnumber | Place holder for driver's license number that a User may supply to validate their identification. Also may be used for validation when the User uses the Customer Interface. |
char(20) | BLANK |
| dlstate | Place holder for issuing state of the driver's license that a User may supply to validate their identification. Also may be used for validation when the User uses the Customer Interface. |
char(30) | BLANK |
| dob | Place holder for User's date of birth that a User may supply to validate their identification. Also may be used for validation when the User uses the Customer Interface. |
date | 0000-00-00 |
| dphone | The day phone number of the User. |
char(20) | Copied from Account |
The email address of the User. |
char(100) | Copied from Account | |
| empl | The Authorized BillMax User who created the entry. |
mediumint(8) | The Authorized BillMax User who created the entry. |
| enddate | If populated, the date this Account's state will be changed to Suspended State. |
date | 0000-00-00 |
| entdate | The date the entry was created. |
date | The date the entry was created. |
| enttime | The the time the entry was created. |
time | The the time the entry was created. |
| fname | The first name of the User. |
char(30) | Copied from Account |
| generation | A timestamp denoting the last time the record was modified. |
timestamp(14) | TIMESTAMP |
| lname | The last name of the User. |
char(30) | Copied from Account |
| maiden | Place holder for User's maiden name that a User may supply to validate their identification. Also may be used for validation when the User uses the Customer Interface. |
char(30) | BLANK |
| misc01 | A miscellaneous field to be used by the purchaser of BillMax. |
int(11) | 0 |
| misc02 | A miscellaneous field to be used by the purchaser of BillMax. |
int(11) | 0 |
| misc03 | A miscellaneous field to be used by the purchaser of BillMax. |
int(11) | 0 |
| misc04 | A miscellaneous field to be used by the purchaser of BillMax. |
int(11) | 0 |
| misc05 | A miscellaneous field to be used by the purchaser of BillMax. |
int(11) | 0 |
| misc06 | A miscellaneous field to be used by the purchaser of BillMax. |
char(50) | BLANK |
| misc07 | A miscellaneous field to be used by the purchaser of BillMax. |
char(50) | BLANK |
| misc08 | A miscellaneous field to be used by the purchaser of BillMax. |
char(50) | BLANK |
| misc09 | A miscellaneous field to be used by the purchaser of BillMax. |
char(50) | BLANK |
| misc10 | A miscellaneous field to be used by the purchaser of BillMax. |
char(50) | BLANK |
| misc11 | A miscellaneous field to be used by the purchaser of BillMax. |
date | 0000-00-00 |
| misc12 | A miscellaneous field to be used by the purchaser of BillMax. |
date | 0000-00-00 |
| misc13 | A miscellaneous field to be used by the purchaser of BillMax. |
date | 0000-00-00 |
| misc14 | A miscellaneous field to be used by the purchaser of BillMax. |
date | 0000-00-00 |
| misc15 | A miscellaneous field to be used by the purchaser of BillMax. |
date | 0000-00-00 |
| misc16 | A miscellaneous field to be used by the purchaser of BillMax. |
time | 00:00:00 |
| misc17 | A miscellaneous field to be used by the purchaser of BillMax. |
time | 00:00:00 |
| misc18 | A miscellaneous field to be used by the purchaser of BillMax. |
time | 00:00:00 |
| misc19 | A miscellaneous field to be used by the purchaser of BillMax. |
time | 00:00:00 |
| misc20 | A miscellaneous field to be used by the purchaser of BillMax. |
time | 00:00:00 |
| mname | The middle name of the User. |
char(30) | Copied from Account |
| modem | The modem the User is using. |
char(50) | BLANK |
| mspeed | The speed of the modem. A value from modems list. |
tinyint(4) | 0 |
| nphone | The night phone number of the User. |
char(20) | BLANK |
| number | System Identifier for a database row. In most cases automatically generated. Allowable range is 1-2147483647. |
int(11) | System Identifier for a database row. In most cases automatically generated. Allowable range is 1-2147483647. |
| os | The operating system that the User is using. A value from oss list. |
tinyint(4) | 0 |
| reason | The reason that the Account was changed to a State other than the Open State. A valid value from the reasons list. |
int(11) | 0 |
| ssn | Place holder for User's social security number that a User may supply to validate their identification. Also may be used for validation when the User uses the Customer Interface. |
char(12) | BLANK |
| startdate | The start date for the User. |
date | The date the entry was created. |
| state | tinyint(4) | 0 | |
| statename | The state/province of the User. |
char(30) | Copied from Account |
| suspdate | The date that the State of the User was change to Suspended State. |
date | 0000-00-00 |
| title | The salutation of the User. |
char(15) | Copied from Account |
| zip | The postal code of the User. |
char(30) | Copied from Account |
Relevant Interfaces
Library Routines
| BillMax_UserGet |
| BillMax_UserGetNext |
| BillMax_UserGetWhere |
| BillMax_UserPut |
| BillMax_UserPutIntoEnviron |
Command Line Routines - NONE
CGI Routines
| enter_user.cgi |
Web Forms - User Form
|
|
 |
|
| timetrack table |  |
Chapter 4. Various BillMax files |