SchemaSpy - Table ss650co.campaigns

Generated by
SchemaSpy

Legend:

Primary key columns

Columns with indexes

Implied relationships

Excluded column relationships

< n > number of related tables

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

id

char

36

accounts.campaign_id	Defined in XML R
campaign_log.campaign_id	Defined in XML R
campaign_trkrs.campaign_id	Defined in XML R
contacts.campaign_id	Defined in XML R
email_marketing.campaign_id	Defined in XML R
emailman.campaign_id	Defined in XML R
leads.campaign_id	Defined in XML R
opportunities.campaign_id	Defined in XML R
prospects.campaign_id	Defined in XML R

campaigns_audit.parent_id	Defined in XML R
prospect_list_campaigns.campaign_id	Defined in XML R

name

varchar

50

√

null

date_entered

datetime

19

√

null

date_modified

datetime

19

√

null

modified_user_id

char

36

√

null

users.id

Defined in XML R

created_by

char

36

√

null

users.id

Defined in XML R

deleted

bit

1

√

0

assigned_user_id

char

36

√

null

users.id

Defined in XML R

team_id

char

36

√

null

teams.id

Defined in XML R

team_set_id

char

36

√

null

team_sets_teams.team_set_id	Defined in XML R
team_sets.id	Defined in XML R

tracker_key

int

11

√

tracker_count

int

11

√

0

refer_url

varchar

255

√

http://

tracker_text

varchar

255

√

null

start_date

date

10

√

null

end_date

date

10

√

null

status

varchar

100

√

null

impressions

int

11

√

0

currency_id

char

36

√

null

budget

double

22

√

null

expected_cost

double

22

√

null

actual_cost

double

22

√

null

expected_revenue

double

22

√

null

campaign_type

varchar

100

√

null

objective

text

65535

√

null

content

text

65535

√

null

frequency

varchar

100

√

null

Analyzed at Wed Jun 06 17:36 PDT 2012

Indexes:

Column(s)	Type	Sort	Constraint Name
id	Primary key	Asc	PRIMARY
tracker_key	Performance	Asc	camp_auto_tracker_key
name	Performance	Asc	idx_campaign_name
team_set_id	Performance	Asc	idx_campaigns_tmst_id