{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%
SERVICE_OPTION
Col #
Column Name
Data Type
Field Length
Not Null?
Data Def.
Comments
1
ID
NUMBER
22
N
Primary key
2
SERVICE_ID
NUMBER
22
Y
Reference to SERVICE (main relation)
3
START_DATE
DATE
7
Y
4
END_DATE
DATE
7
Y
5
STATUS_ID
NUMBER
22
Y
6
PRODUCT_OPTION_ID
NUMBER
22
Y
Reference to PRODUCT_OPTION
7
LAST_CHANGED_BY
VARCHAR2
40
Y
8
RECURRENT_FEE_ID
NUMBER
22
Y
Reference to SUBSCRIPTION_FEES
9
NETWORK_STATUS_ID
VARCHAR2
50
Y
10
SUBSCRIPTION_CAMPAIGN_ID
NUMBER
22
Y
Reference to SUBSCRIPTION_CAMPAIGN
11
PROVISIONING_TASK_ID
NUMBER
22
Y
Reference to PROVISIONING_TASK
12
OBJECT_ID
NUMBER
22
Y
Not used in application
13
CODE
VARCHAR2
50
Y
14
SOURCE_OBJECT_ID
NUMBER
22
Y
Reference to SERVICE (for now - available for extension to other tables)