Versions Compared

Old Version 1

changes.mady.by.user Søren Duusgaard (Deactivated)

Saved on

compared with

New Version Current

changes.mady.by.user Søren Duusgaard (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width33%

Groups

Wiki Markup
{float:left|width=200px|background=lightgrey|border=solid blue 2px|margin=1px|padding=0px}
{children:page=Rator DB ER Diagram Navigator|depth=1|excerpt=trueindent=1px}
{float}
Column
width33%

SERVICE

Col #Column NameData TypeField LengthNot Null?Data Def.Comment
1

ID

NUMBER

22

N

 Primary key
2

SUBSCRIPTION_ID

NUMBER

22

Y

 

Foreign key referencing SUBSCRIPTION-table

3

CODE

VARCHAR2

10

Y

 

Refers to type of service, references SERVICE_CLASS.CODE

4

STATUS_ID

NUMBER

22

Y

 

Status of the service, references STATUS.ID

5

IMSI

VARCHAR2

50

Y

 

International Mobile Subscriber Identity

6

PHONE_NUMBER

VARCHAR2

20

Y

 

Phone number

7

MAILBOX_NUMBER

VARCHAR2

50

Y

 

Mailbox number

8

DATA_FAX_NUMBER

VARCHAR2

50

Y

 

Data fax number

9

PHONEBOOK_ENTRY

NUMBER

22

Y

  
10

FOREIGN_CALLS

NUMBER

22

Y

  
11

SIM_DELIVERED

NUMBER

22

Y

 

Indicates whether SIM card is delivered

12

FAX_NUMBER

VARCHAR2

50

Y

 

Fax number

13

DUAL_IMSI

VARCHAR2

50

Y

 

Second IMSI number if one exists

14

DUAL_PHONE_NUMBER

VARCHAR2

50

Y

 

Second phone number if one exists

15

NETWORK_ICC

VARCHAR2

100

Y

 

Network Integrated Circuit Card

16

NETWORK_PHONENUMBER

VARCHAR2

100

Y

 

Network phone number

17

ESN

VARCHAR2

50

Y

 

Electronic Serial Number

18

NETWORK_ESN

VARCHAR2

50

Y

 

Network ESN

19

SERVICE_CLASS_ID

NUMBER

22

Y

 

Foreign key referencing SERVICE_CLASS.ID

20

CDMAPHONE_GROUP_ID

NUMBER

22

Y

 

Foreign key referencing CDMA_PHONE_GROUP.ID

21

SHOP_PRODUCT_ID

NUMBER

22

Y

 Foreign key referencing SHOP_PRODUCT.ID
 
22

DIRECTORY_KEY

VARCHAR2

15

Y

  
23

BRAND_ID

NUMBER

22

Y

 Foreign key referencing BRAND_ID
24

IS_SUSPEND

NUMBER

22

N

 Indicates whether service is suspended25

NETWORK_SUB_ID

VARCHAR2

400

Y

  26

BLOCKED_FROM_DATE

DATE

7

Y

 Date of blocking
27

EXTERNAL_ACCOUNT_REFERENCE

VARCHAR2

32

Y

  
28

DISCONNECT_DATE

DATE

7

Y

 Date of disconnecting29

LAST_SPEED_CHANGE_DATE

DATE

7

Y

 Date of latest speed change30

INSTALLATION_ID

NUMBER

22

Y

  
31

USER_NO

VARCHAR2

200

Y

 User number
32

IP_NUMBER

VARCHAR2

50

Y

 IP-number
33

MAC_ADDRESS_NUMBER

VARCHAR2

50

Y

 Mac address number
34

NETWORK_USER_ID

NUMBER

22

Y

  
35

SERVICE_TAG

VARCHAR2

100

Y

  36

LAST_PROVISIONING_SYNC_DATE

DATE

7

Y

 Date of latest provisioning synchronization
37

CUSTOM_VALUE1

VARCHAR2

4000

Y

 Custom value
38

CUSTOM_VALUE2

VARCHAR2

4000

Y

 Custom value
39

CUSTOM_VALUE3

VARCHAR2

4000

Y

 Custom value
40

CSA_ZIP

VARCHAR2

200

Y

  41

CSA

VARCHAR2

400

Y

  
42

HEX_MEID

VARCHAR2

200

Y

 MEID in hex-format43

MEID

VARCHAR2

50

Y

 Mobile Equipment ID44

NETWORK_MEID

VARCHAR2

50

Y

 Network MEID
45

MIN

VARCHAR2

200

Y

 

Mobile Identification Number

46

CSA_NUMBER

VARCHAR2

400

Y

  
47

NETWORK_MIN

VARCHAR2

200

Y

 Network MIN48

FIRST_CDR_RATED_DATE

DATE

7

Y

 Date of first rating
Column
width33%

Contains all Service objects