ZyXEL Communications APS 1.0, Руководство администратора

Страница: 87 / 116

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