Auto Provisioning Administrator’s Guide
88
Appendix D Sample CRM Server Database Description
7
Varchar(50)
Yes
NULL
8
FirstName
Varchar(50)
Yes
NULL
First name
9
LastName
Varchar(50)
Yes
NULL
Last name
10 CurrentPhone
Varchar(50)
Yes
NULL
Current phone
11 Occupation
Varchar(50)
Yes
NULL
Occupation
12 StreetAddress
longtext
Yes
NULL
Street address
13 City
Varchar(50)
Yes
NULL
City
14 Province
Varchar(50)
Yes
NULL
Province
15 Country
Varchar(50)
Yes
NULL
Country
16 ZipCode
Varchar(50)
Yes
NULL
Zip code
17 PaymentMethod
Varchar(50)
Yes
NULL
Payment method
18 ResidentialPlan
Varchar(50)
Yes
NULL
Residential plan
19 PINCode
Varchar(50)
Yes
NULL
PIN code
20 CreateType
Varchar(50)
Yes
NULL
Account create type
1
: U
ser-registered
2
:
Created by administrator
(for reserve)
21 CreateDate
timestamp
Yes
CURRENT_TIME
STAMP
Account create date (for
reserve)
22 CreatePerson
Varchar(50)
Yes
NULL
Account create person (for
reserve)
23 ModifyDate
Datetime
Yes
0000-00-00
00:00:00
Last modified date (for
reserve)
24 ModifPerson
Varchar(50)
Yes
NULL
Last modified person (for
reserve)
25 State
char(1)
Yes
0
Status
1
:
Provisioned
2
:
Unprovisioned
26 BusinessPlan
Varchar(100) Yes
NULL
Business plan
Table 25
Unitdevice
ID COLUMN NAME DATATYPE
NULL KEY DEFAULT VALUE COMMENT
1
RowID
Int(6)
PRI
Subscriber device index
2
MACAddress
Varchar(50)
MAC address
3
ProductType
Varchar(100)
Product type
4
State
char(1)
1
Status
1: Unregistered
2: Registered
Table 24
Subscriber
ID COLUMN NAME DATATYPE
NULL KEY
DEFAULT
VALUE
COMMENT
Summary of Contents for APS 1.0
Page 1: ...Auto Provisioning For VoIP Devices Administrator s Guide Version 2 0 3 2006...
Page 2: ......
Page 6: ...Auto Provisioning Administrator s Guide 6 Customer Support...
Page 10: ...Auto Provisioning Administrator s Guide 10 Table of Contents...
Page 14: ...Auto Provisioning Administrator s Guide 14 List of Tables...
Page 42: ...Auto Provisioning Administrator s Guide 42 Chapter 3 Provisioning Utility...
Page 72: ...Auto Provisioning Administrator s Guide 72 Chapter 5 Using the Auto Provisioning Server...
Page 74: ...Auto Provisioning Administrator s Guide 74 Chapter 6 Using the Auto Provisioning Server...
Page 78: ...Auto Provisioning Administrator s Guide 78 Appendix A Auto Provisioning Service Flowchart...
