{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 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
INITIAL_AMOUNT
NUMBER
22
Y
For a situation when the SIM card is loaded with some initial amount