Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Section
Column
width33%

Groups

Wiki Markup
{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
width33%

SUBSCRIPTION_CAMPAIGN

Col #

Column NameData TypeField LengthNot Null?Data Def.Comments
1

ID

NUMBER

22

N

 Primary key
2

SUBSCRIPTION_ID

NUMBER

22

Y

 Reference to SUBSCRIPTION
3

CAMPAIGN_ID

NUMBER

22

Y

 Reference to CAMPAIGN
4

STATUS_ID

NUMBER

22

Y

  
5

FROM_DATE

DATE

7

Y

  
6

TO_DATE

DATE

7

Y

  
7

FEE_ID

NUMBER

22

Y

  
8

OBJECT_ID

NUMBER

22

Y

  
9

OBJECT_CODE

VARCHAR2

20

Y

  
10

PARAMETER_STRING

VARCHAR2

4000

Y

  
11

AUTO_EXTEND

VARCHAR2

4

Y

  
12

EXPIRED_ON_DATE

DATE

7

Y

  
Column
width33%

Contains information about which subscription a campaign subscribes to at a given time