{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
width
33%
SIMCARD
Col #
Column Name
Data Type
Field Length
Not 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 reserved6
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 code10
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
Comments14
USERCLIENT
VARCHAR2
100
Y
Operator name15
LOCATION
VARCHAR2
100
Y
Location16
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 For a situation when the SIM card
26
CA_DEBIT_CARD_NUMBER
VARCHAR2
400
Y
Debit card number regarding the SIM cardis loaded with some initial amount