Versions Compared

Version Old Version 2 New Version 3
Changes made by

Søren Duusgaard (Deactivated)

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%

MAIL_CAMPAIGN

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

ID

NUMBER

22

N

  2

STATUS_ID

NUMBER

22

Y

  
3

NAME

VARCHAR2

100

Y

  4

POP_SUBJECT

VARCHAR2

100

Y

  
5

MAIL_TEMPLATE_ID

NUMBER

22

Y

  6

TYPE_ID

NUMBER

22

Y

  7

FROM_NAME

VARCHAR2

100

Y

  8

FROM_EMAIL

VARCHAR2

100

Y

  9

NEXT_DATE

DATE

7

Y

  10

INTERVAL

NUMBER

22

Y

  
11

INTERVAL_TYPE

CHAR

1

Y

  12

IS_INTERNAL_MAIL

CHAR

1

Y

  
13

MAIL_CAMPAIGN_METHOD

VARCHAR2

50

Y

  
14

MAIL_CAMPAIGN_HANDLER

VARCHAR2

50

Y

  15

START_TIME

DATE

7

Y

  16

NEXT_DATE_SQL

VARCHAR2

1000

Y

  17

CODE

VARCHAR2

10

Y

  
18

AS_ATTACHMENT

CHAR

1

Y

  19

SAVE_ONLY

CHAR

1

Y

  
20

PUBLIC_ATTACHMENT

VARCHAR2

500

Y

  
21

BRANDED_CAMPAIGN

VARCHAR2

4

Y

  
22

MAIL_TEMPLATE_KEY

VARCHAR2

800

Y

  
CATEGORYVARCHAR2200Y  
Column
width33%