{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%
PRODUCT_OPTION
Col#
Column Name
Data Type
Field Length
Not Null?
Data Def.
Comments
1
ID
NUMBER
22
N
Primary key
2
NAME
VARCHAR2
256
Y
3
DESCRIPTION
VARCHAR2
256
Y
4
LABEL
VARCHAR2
256
Y
5
PARENT_ID
NUMBER
22
Y
Reference to PRODUCT_OPTION (parent)
6
SUB_OPTIONS_EXCLUSIVE
CHAR
1
Y
7
CODE
VARCHAR2
20
Y
8
TAG
VARCHAR2
20
Y
9
HANDLER_TAG
VARCHAR2
20
Y
10
PROVISIONING_TAG
VARCHAR2
25
Y
11
PRICE_CODE
VARCHAR2
40
Y
12
OPTION_KEY
VARCHAR2
50
Y
13
WEB_DESCRIPTION
VARCHAR2
4000
Y
14
HAS_LICENSE_AGREEMENT
CHAR
1
Y
15
LICENSE_AGREEMENT
VARCHAR2
4000
Y
16
ON_SELECT_METHOD
VARCHAR2
100
Y
17
COMPLETE_IT_METHOD
VARCHAR2
100
Y
18
ON_UNSUBSCRIBE_METHOD
VARCHAR2
100
Y
19
DEFAULT_SUBSCRIBE_STATUS_ID
NUMBER
22
Y
20
DEFAULT_UNSUBSCRIBE_STATUS_ID
NUMBER
22
Y
21
TYPE_ID
NUMBER
22
Y
22
CATEGORY
VARCHAR2
30
Y
23
PRODUCT_OPTION_CATEGORY_ID
NUMBER
22
Y
Reference to PRODUCT_OPTION_CATEGORY
24
SUB_LOCKIN_TYPE_ID
NUMBER
22
Y
Reference to SUBSCRIPTION_LOCKIN_TYPE
25
CAMPAIGN_ID
NUMBER
22
Y
Reference to CAMPAIGN
26
CAN_MODIFY_METHOD
VARCHAR2
100
Y
27
IS_EXCLUSIVE
CHAR
4
Y
28
GROUP_NAME
VARCHAR2
400
Y
Column
width
33%
Definition of all Products to which a Subscription/SIM can subscribe