Versions Compared

Old Version 1

changes.mady.by.user Søren Duusgaard (Deactivated)

Saved on

compared with

New Version Current

changes.mady.by.user Søren Duusgaard (Deactivated)

Saved on

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%

CAMPAIGN

Col #Column NameData TypeField LengthNot Null?Data Def.Comments
1

ID

NUMBER

22

Y

 Primary key
2

CODE

VARCHAR2

80

Y

  
3

NAME

VARCHAR2

80

Y

  
4

STATUS_ID

NUMBER

22

Y

  
5

FROM_DATE

DATE

7

Y

  
6

TO_DATE

DATE

7

Y

  
7

ON_ASSIGN_METHOD

VARCHAR2

200

Y

  
8

ON_ACTIVATE_METHOD

VARCHAR2

200

Y

  
9

ON_EXPIRE_METHOD

VARCHAR2

200

Y

  
10

ON_TERMINATE_METHOD

VARCHAR2

200

Y

  
11

PRICE_CODE

VARCHAR2

100

Y

  
12

ACTIVATION_TYPE_ID

NUMBER

22

Y

  
13

VALIDITY_PERIOD

NUMBER

22

Y

  
14

VALIDITY_PERIOD_TYPE_ID

NUMBER

22

Y

  
15

EXCLUSIVE_GROUP

VARCHAR2

256

Y

  
16

EXCLUSIVE_GROUP_PRIORITY

NUMBER

22

Y

  
17

SHORT_DESCRIPTION

VARCHAR2

500

Y

  
18

LONG_DESCRIPTION

VARCHAR2

4000

Y

  
19

CAMPAIGN_KEY

VARCHAR2

64

Y

  
20

VALIDITY_PERIOD_END_DATE

DATE  

7

Y

  
21

DISPLAY_PRIORITY

NUMBER

22

Y

  
22

CAN_AUTO_EXTEND

VARCHAR2

4

Y

  
23

MULTIPLE_ALLOWED

NUMBER

22

N

  
Column
width33%

Definition of all Campaigns