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

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

Auto Provisioning Administrator’s Guide
88 Appendix D Sample CRM Server Database Description
7 EMail Varchar(50) Yes NULL E-mail
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