Versions Compared

Old Version 2

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

Saved on

compared with

New Version 3

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%

SIMCARD

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

ID

NUMBER

22

N

 Primary key
2

STATUS

NUMBER

22

Y

 

Status, i.e. 0-pre paid, 1-post paid, 2-pre paid card

3

ASSIGNED_TO_SERVICE_ID

NUMBER

22

Y

 Foreign key referencing SERVICE-table
4

CREATE_DATE

DATE

7

Y

 Date of creation
5

RESERV_TO_DATE

DATE

7

Y

 Date to which SIM card is reserved
6

IMSI

VARCHAR2

100

Y

 

International Mobile Subscriber Indentity

7

ICC

VARCHAR2

100

Y

 

Integrated Circuit Card

8

PIN1

VARCHAR2

100

Y

 PIN code
9

PIN2

VARCHAR2

100

Y

 Second PIN code
10

PUK1

VARCHAR2

100

Y

 

Personal unblocking code

11

PUK2

VARCHAR2

100

Y

 

Second personal unblocking code

12

TYPE

VARCHAR2

100

Y

 Status name
13

COMMENTS

VARCHAR2

1000

Y

 Comments
14

USERCLIENT

VARCHAR2

100

Y

 Operator name
15

LOCATION

VARCHAR2

100

Y

 Location
16

BLOCKED_FROM_DATE

DATE

7

Y

 Date on which SIM card is to be blocked
17

MARS_SYNC_DATE

DATE

7

Y

 

 

18

ASSIGNED_ANUMBER_ID

NUMBER

22

Y

 Foreign key referencing A_NUMBER.ID
19

NETWORK_ID

NUMBER

22

Y

 

Foreign key referencing NETWORK_OPERATOR.ID

20

KI

VARCHAR2

32

Y

  
21

CHANGE_PENDING

VARCHAR2

1

Y

  
22

SIM_TYPE_ID

NUMBER

22

Y

 SIM card type
23

NETWORK_STATUS

NUMBER

22

Y

  
24

BRAND_ID

NUMBER

22

Y

 Foreign key referencing BRAND.ID
25

CA_RICA_SERIAL_NUMBERINITIAL_AMOUNT

NUMBER

22

Y

 

RICA serial number regarding the SIM card

26

CA_DEBIT_CARD_NUMBER

VARCHAR2

400

 

Debit card number regarding the SIM card

Column
width33%

Contains all SIM cards