{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%
SUBSCRIPTION_BUNDLE
Col#
Column Name
Data Type
Field Length
Not Null?
Data Def.
Comments
1
ID
NUMBER
22
N
Primary key
2
KEY
VARCHAR2
200
Y
3
SUBSCRIPTION_ID
NUMBER
22
Y
Reference to SUBSCRIPTION (redundant from SUBSCRIPTION_CAMPAIGN_ID)
4
CAMPAIGN_ID
NUMBER
22
Y
Reference to CAMPAIGN (redundant from SUBSCRIPTION_CAMPAIGN_ID)
5
BUNDLE_ID
NUMBER
22
Y
Reference to BUNDLE
6
PERIOD
VARCHAR2
20
Y
7
STATUS_ID
NUMBER
22
Y
8
VALUE1
NUMBER
22
Y
9
VALUE2
NUMBER
22
Y
10
VALUE3
NUMBER
22
Y
11
VALUE4
NUMBER
22
Y
12
SUBSCRIPTION_CAMPAIGN_ID
NUMBER
22
Y
Reference to SUBSCRIPTION_CAMPAIGN
13
CHARGE_ITEM_ID
NUMBER
22
Y
Reference to CHARGE_ITEM
14
CONCURRENCY_KEY
NUMBER
22
Y
15
ALERT_GROUP_ID
NUMBER
22
Y
Deprecated
16
FROM_DATE
DATE
7
Y
17
TO_DATE
DATE
7
Y
18
CURRENCY_CODE
VARCHAR2
12
Y
Column
width
33%
Contains information on which bundles subscribe to which subscription at a given time