Auto Provisioning Administrator’s Guide
Appendix D Sample CRM Server Database Description
87
A
P P E N D I X
D
Sample CRM Server Database
Description
These tables describe the database structure of the VoIP Subscribing System (VSS) sample
CRM server software.
Table 22
Creditcard
ID COLUMN NAME DATATYPE NULL KEY DEFAULT VALUE COMMENT
1
UserID
varchar(50)
No
PRI
2
CardType
varchar(50)
No
Credit card type
3
CardNumber
varchar(50)
No
Credit card number
4
ExpirationDate
varchar(20)
No
Credit card expiration date
5
HolderName
varchar(50)
No
Credit card holder’s name
6
SecurityID
varchar(50)
No
Security code of credit card
Table 23
Itspphone
ID COLUMN NAME DATATYPE
NULL KEY DEFAULT VALUE COMMENT
1
PhoneNumber
Varchar(50)
No
PRI
SIP phone number
2
Price
Decimal(19,4) Yes
Null
Price
3
State
char(1)
No
Status
1: unused
2: used
4
Comment
Varchar(50)
Yes
Null
Comment
Table 24
Subscriber
ID COLUMN NAME DATATYPE
NULL KEY
DEFAULT
VALUE
COMMENT
1
SubscriberID
Int(11)
No
PRI
Subscriber index
2
UserID
Varchar(100) No
User’s account name
3
MACAddress
Varchar(50)
No
MAC address
4
PhoneNumber
Varchar(50)
No
U
Phone number
5
SIPOrder
Int(11)
NO
1
SIP order (CPE Port#)
6
Password
Varchar(50)
Yes
NULL
Password
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...
