CRM model documentation

CRM

Tables 10	Columns 45		Triggers 0	Sequences 0
Tables 10	Relationships 11	Views 0	Procedures 0	Domains 0

Diagram

All Items

Tables

#	Caption	Name
1	Campaign	CAMPAIGN
2	CampaignMember	CAMPAIGNMEMBER
3	Lead	LEAD
4	Contact	CONTACT
5	OpportunityContactRole	OPPORTUNITYCONTACTROLE
6	AccountContactRole	ACCOUNTCONTACTROLE
7	Account	ACCOUNT
8	Case	CASE
9	Opportunity	OPPORTUNITY
10	Contract	CONTRACT

Tables : CAMPAIGN

Columns 7	Keys 1	Triggers 0	Comment: Description:
Indexes 0	Contraints 0

Columns :

Name	Caption	Primary Key	type
CAMPAIGN_ID	Campaign_ID	true	INT(10)
CAMPAIGN_NAME	Campaign_name		VARCHAR(40)
CAMPAIGN_OBJECTIVES	Campaign_objectives		VARCHAR(40)
CAMPAIGN_SPONSOR	Campaign_sponsor		VARCHAR(40)
CAMPAIGN_START_DATE	Campaign_start_date		DATE
CAMPAIGN_END_DATE	Campaign_end_date		DATE
CAMPAIGN_OTHER_DETAILS	Campaign_other_details		VARCHAR(40)

Keys :

Name	Primary Key	Description
KEY_1	true

Columns Detail :

Name	CAMPAIGN_ID
Table	CAMPAIGN
Type	INT(10)
Domain
Primary Key	true
Not null	true

Name	CAMPAIGN_NAME
Table	CAMPAIGN
Type	VARCHAR(40)
Domain

Name	CAMPAIGN_OBJECTIVES
Table	CAMPAIGN
Type	VARCHAR(40)
Domain

Name	CAMPAIGN_SPONSOR
Table	CAMPAIGN
Type	VARCHAR(40)
Domain

Name	CAMPAIGN_START_DATE
Table	CAMPAIGN
Type	DATE
Domain

Name	CAMPAIGN_END_DATE
Table	CAMPAIGN
Type	DATE
Domain

Name	CAMPAIGN_OTHER_DETAILS
Table	CAMPAIGN
Type	VARCHAR(40)
Domain

Tables : CAMPAIGNMEMBER

Columns 4	Keys 1	Triggers 0	Comment: Description:
Indexes 0	Contraints 0

Columns :

Name	Caption	Primary Key	type
CAMPAIGNMEMBER_ID	CampaignMember_ID	true	INT(10)
CAMPAIGN_ID	Campaign_ID		INT(10)
LEAD_ID	Lead_ID		INT(10)
CONTACT_ID	Contact_ID		INT(10)

Keys :

Name	Primary Key	Description
KEY_2	true

Columns Detail :

Name	CAMPAIGNMEMBER_ID
Table	CAMPAIGNMEMBER
Type	INT(10)
Domain
Primary Key	true
Not null	true

Name	CAMPAIGN_ID
Table	CAMPAIGNMEMBER
Type	INT(10)
Domain
Foreign key	true

Name	LEAD_ID
Table	CAMPAIGNMEMBER
Type	INT(10)
Domain
Foreign key	true

Name	CONTACT_ID
Table	CAMPAIGNMEMBER
Type	INT(10)
Domain
Foreign key	true

Tables : LEAD

Columns 4	Keys 1	Triggers 0	Comment: Description:
Indexes 0	Contraints 0

Columns :

Name	Caption	Primary Key	type
LEAD_ID	Lead_ID	true	INT(10)
LEAD_FIRESTNAME	Lead_firestname		VARCHAR(40)
LEAD_SURNAME	Lead_surname		VARCHAR(40)
LEAD_OTHER_DETAILS	Lead_other_details		VARCHAR(40)

Keys :

Name	Primary Key	Description
KEY_3	true

Columns Detail :

Name	LEAD_ID
Table	LEAD
Type	INT(10)
Domain
Primary Key	true
Not null	true

Name	LEAD_FIRESTNAME
Table	LEAD
Type	VARCHAR(40)
Domain

Name	LEAD_SURNAME
Table	LEAD
Type	VARCHAR(40)
Domain

Name	LEAD_OTHER_DETAILS
Table	LEAD
Type	VARCHAR(40)
Domain

Tables : CONTACT

Columns 4	Keys 1	Triggers 0	Comment: Description:
Indexes 0	Contraints 0

Columns :

Name	Caption	Primary Key	type
CONTACT_ID	Contact_ID	true	INT(10)
ACCOUNT_ID	Account_ID		INT(10)
CONTACT_ADDRESS	Contact_address		VARCHAR(40)
CONTACT_CONTACT_DETAILS	Contact_contact_details		VARCHAR(40)

Keys :

Name	Primary Key	Description
KEY_4	true

Columns Detail :

Name	CONTACT_ID
Table	CONTACT
Type	INT(10)
Domain
Primary Key	true
Not null	true

Name	ACCOUNT_ID
Table	CONTACT
Type	INT(10)
Domain
Foreign key	true

Name	CONTACT_ADDRESS
Table	CONTACT
Type	VARCHAR(40)
Domain

Name	CONTACT_CONTACT_DETAILS
Table	CONTACT
Type	VARCHAR(40)
Domain

Tables : OPPORTUNITYCONTACTROLE

Columns 5	Keys 1	Triggers 0	Comment: Description:
Indexes 0	Contraints 0

Columns :

Name	Caption	Primary Key	type
OPPORTUNITYCONTACTROLE_ID	OpportunityContactRole_ID	true	INT(10)
CONTACT_ID	Contact_ID		INT(10)
OPPORTUNITY_ID	Opportunity_ID		INT(10)
DATE_TIME	Date_time		DATETIME(2)
OTHER_DETAILS	Other_details		VARCHAR(40)

Keys :

Name	Primary Key	Description
KEY_5	true

Columns Detail :

Name	OPPORTUNITYCONTACTROLE_ID
Table	OPPORTUNITYCONTACTROLE
Type	INT(10)
Domain
Primary Key	true
Not null	true

Name	CONTACT_ID
Table	OPPORTUNITYCONTACTROLE
Type	INT(10)
Domain
Foreign key	true

Name	OPPORTUNITY_ID
Table	OPPORTUNITYCONTACTROLE
Type	INT(10)
Domain
Foreign key	true

Name	DATE_TIME
Table	OPPORTUNITYCONTACTROLE
Type	DATETIME(2)
Domain

Name	OTHER_DETAILS
Table	OPPORTUNITYCONTACTROLE
Type	VARCHAR(40)
Domain

Tables : ACCOUNTCONTACTROLE

Columns 3	Keys 1	Triggers 0	Comment: Description:
Indexes 0	Contraints 0

Columns :

Name	Caption	Primary Key	type
ACCOUNTCONTACTROLE_ID	AccountContactRole_ID	true	INT(10)
CONTACT_ID	Contact_ID		INT(10)
ACCOUNT_ID	Account_ID		INT(10)

Keys :

Name	Primary Key	Description
KEY_6	true

Columns Detail :

Name	ACCOUNTCONTACTROLE_ID
Table	ACCOUNTCONTACTROLE
Type	INT(10)
Domain
Primary Key	true
Not null	true

Name	CONTACT_ID
Table	ACCOUNTCONTACTROLE
Type	INT(10)
Domain
Foreign key	true

Name	ACCOUNT_ID
Table	ACCOUNTCONTACTROLE
Type	INT(10)
Domain
Foreign key	true

Tables : ACCOUNT

Columns 7	Keys 1	Triggers 0	Comment: Description:
Indexes 0	Contraints 0

Columns :

Name	Caption	Primary Key	type
ACCOUNT_ID	Account_ID	true	INT(10)
ACCOUNT_NAME	Account_name		VARCHAR(40)
ACCOUNT_DESCRIPTION	Account_description		VARCHAR(40)
ACCOUNT_PHONE	Account_phone		INT(10)
BILING_ADDRESS	Biling_address		VARCHAR(40)
ACCOUNT_DETAILS	Account_details		VARCHAR(40)
ACCOUNT_PARTNER	Account_partner		VARCHAR(40)

Keys :

Name	Primary Key	Description
KEY_7	true

Columns Detail :

Tables : CASE

Columns 2	Keys 1	Triggers 0	Comment: Description:
Indexes 0	Contraints 0

Columns :

Keys :

Columns Detail :

Tables : OPPORTUNITY

Columns 5	Keys 1	Triggers 0	Comment: Description:
Indexes 0	Contraints 0

Columns :

Name	Caption	Primary Key	type
OPPORTUNITY_ID	Opportunity_ID	true	INT(10)
ACCOUNT_ID	Account_ID		INT(10)
OPPORTUNITY_DESCRIPTION	Opportunity_description		VARCHAR(40)
OPPORTUNITY_DETAILS	Opportunity_details		VARCHAR(40)
OPPORTUNITY_STAGE	Opportunity_stage		VARCHAR(40)

Keys :

Columns Detail :

Tables : CONTRACT

Columns 4	Keys 1	Triggers 0	Comment: Description:
Indexes 0	Contraints 0

Columns :

Name	Caption	Primary Key	type
CONTRACT_ID	Contract_ID	true	INT(10)
ACCOUNT_ID	Account_ID		INT(10)
CONTRACT_STATUS	Contract_status		VARCHAR(40)
CONTRACT_APPROVAL	Contract_approval		VARCHAR(40)

Keys :

Columns Detail :

Columns

Name	Caption	Primary Key	Type
CAMPAIGN_ID	Campaign_ID	true	INT(10)
CAMPAIGN_NAME	Campaign_name		VARCHAR(40)
CAMPAIGN_OBJECTIVES	Campaign_objectives		VARCHAR(40)
CAMPAIGN_SPONSOR	Campaign_sponsor		VARCHAR(40)
CAMPAIGN_START_DATE	Campaign_start_date		DATE
CAMPAIGN_END_DATE	Campaign_end_date		DATE
CAMPAIGN_OTHER_DETAILS	Campaign_other_details		VARCHAR(40)
CAMPAIGNMEMBER_ID	CampaignMember_ID	true	INT(10)
CAMPAIGN_ID	Campaign_ID		INT(10)
LEAD_ID	Lead_ID		INT(10)
CONTACT_ID	Contact_ID		INT(10)
LEAD_ID	Lead_ID	true	INT(10)
LEAD_FIRESTNAME	Lead_firestname		VARCHAR(40)
LEAD_SURNAME	Lead_surname		VARCHAR(40)
LEAD_OTHER_DETAILS	Lead_other_details		VARCHAR(40)
CONTACT_ID	Contact_ID	true	INT(10)
ACCOUNT_ID	Account_ID		INT(10)
CONTACT_ADDRESS	Contact_address		VARCHAR(40)
CONTACT_CONTACT_DETAILS	Contact_contact_details		VARCHAR(40)
OPPORTUNITYCONTACTROLE_ID	OpportunityContactRole_ID	true	INT(10)
CONTACT_ID	Contact_ID		INT(10)
OPPORTUNITY_ID	Opportunity_ID		INT(10)
DATE_TIME	Date_time		DATETIME(2)
OTHER_DETAILS	Other_details		VARCHAR(40)
ACCOUNTCONTACTROLE_ID	AccountContactRole_ID	true	INT(10)
CONTACT_ID	Contact_ID		INT(10)
ACCOUNT_ID	Account_ID		INT(10)
ACCOUNT_ID	Account_ID	true	INT(10)
ACCOUNT_NAME	Account_name		VARCHAR(40)
ACCOUNT_DESCRIPTION	Account_description		VARCHAR(40)
ACCOUNT_PHONE	Account_phone		INT(10)
BILING_ADDRESS	Biling_address		VARCHAR(40)
ACCOUNT_DETAILS	Account_details		VARCHAR(40)
ACCOUNT_PARTNER	Account_partner		VARCHAR(40)
CASE_ID	Case_ID	true	INT(10)
CONTACT_ID	Contact_ID		INT(10)
OPPORTUNITY_ID	Opportunity_ID	true	INT(10)
ACCOUNT_ID	Account_ID		INT(10)
OPPORTUNITY_DESCRIPTION	Opportunity_description		VARCHAR(40)
OPPORTUNITY_DETAILS	Opportunity_details		VARCHAR(40)
OPPORTUNITY_STAGE	Opportunity_stage		VARCHAR(40)
CONTRACT_ID	Contract_ID	true	INT(10)
ACCOUNT_ID	Account_ID		INT(10)
CONTRACT_STATUS	Contract_status		VARCHAR(40)
CONTRACT_APPROVAL	Contract_approval		VARCHAR(40)

Relationships

Name	Parent table	Child table	Parent table column	Child table column
REFERENCE_3	CONTACT	CAMPAIGNMEMBER	CONTACT_ID	CONTACT_ID
REFERENCE_4	CONTACT	OPPORTUNITYCONTACTROLE	CONTACT_ID	CONTACT_ID
REFERENCE_5	ACCOUNT	CONTACT	ACCOUNT_ID	ACCOUNT_ID
REFERENCE_6	CONTACT	CASE	CONTACT_ID	CONTACT_ID
REFERENCE_7	CONTACT	ACCOUNTCONTACTROLE	CONTACT_ID	CONTACT_ID
REFERENCE_8	ACCOUNT	ACCOUNTCONTACTROLE	ACCOUNT_ID	ACCOUNT_ID
REFERENCE_9	OPPORTUNITY	OPPORTUNITYCONTACTROLE	OPPORTUNITY_ID	OPPORTUNITY_ID
REFERENCE_10	ACCOUNT	OPPORTUNITY	ACCOUNT_ID	ACCOUNT_ID
REFERENCE_11	ACCOUNT	CONTRACT	ACCOUNT_ID	ACCOUNT_ID
REFERENCE_1	CAMPAIGN	CAMPAIGNMEMBER	CAMPAIGN_ID	CAMPAIGN_ID
REFERENCE_2	LEAD	CAMPAIGNMEMBER	LEAD_ID	LEAD_ID

General

CRM

Tables

10

Columns

45

Triggers

0

Sequences

0

Relationships

11

Views

0

Procedures

0

Domains

0

Diagram

All Items

Tables

Tables : CAMPAIGN

Columns

7

Keys

1

Triggers

0

Comment:

Description:

Indexes

0

Contraints

0

Columns :

Keys :

Columns Detail :

Tables : CAMPAIGNMEMBER

Columns

4

Keys

1

Triggers

0

Comment:

Description:

Indexes

0

Contraints

0

Columns :

Keys :

Columns Detail :

Tables : LEAD

Columns

4

Keys

1

Triggers

0

Comment:

Description:

Indexes

0

Contraints

0

Columns :

Keys :

Columns Detail :

Tables : CONTACT

Columns

4

Keys

1

Triggers

0

Comment:

Description:

Indexes

0