{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%
NP_FLOW
Col#
Column Name
Data Type
Field Length
Not Null?
Data Def.
Comments
1
ID
NUMBER
22
N
Primary key
2
SUBSCRIPTION_ID
NUMBER
22
Y
ID of subscription attached to number
3
WORKFLOW_ID
NUMBER
22
Y
Workflow handling the NP process
4
SIGNUP_DATE
DATE
7
Y
Date of number signup
5
PHONE_NUMBER
VARCHAR2
80
Y
Mobile number
6
PORT_DATE
DATE
7
Y
Date of importing/exporting number
7
ACTIVATION_DATE
DATE
7
Y
Date of activating number
8
SIMCARD_SENT_DATE
DATE
7
Y
Date of sending SIM card
9
CUSTOMER_NAME
VARCHAR2
400
Y
10
CUSTOMER_ID
NUMBER
22
Y
11
DSP_ID
NUMBER
22
Y
DSP (Donor Service Provider) offering the number
12
ODSP_ID
NUMBER
22
Y
13
RSP_ID
NUMBER
22
Y
14
NETWORK_ID
NUMBER
22
Y
15
STATUS_ID
NUMBER
22
Y
NP status: 0-pending, 1-completed, 2-waiting for donor, 6-cancelled, 7-waiting for activation, 8-waiting for cancel/confirm, 9-check reject, 10-waiting for npc ok