CRM_PRESALES
Tables (39)
ACCOUNT_TB
- ID — NUMBER — Primary key — NOT NULL
- NAME — VARCHAR(150) — NOT NULL
- DATE_ENTERED — DATE
- DATE_MODIFIED — DATE
- FACEBOOK — VARCHAR(255)
- TWITTER — VARCHAR(255)
- GOOGLE — VARCHAR(255)
- INDUSTRY — VARCHAR(100) — NOT NULL
- EMAIL_ADDRESS — VARCHAR(100) — NOT NULL
- PHONE_WORK — VARCHAR(50)
- ADDRESS_STREET — VARCHAR(150)
- ADDRESS_CITY — VARCHAR(100)
- ADDRESS_STATE — VARCHAR(100)
- ADDRESS_POSTALCODE — VARCHAR(20)
- ADDRESS_COUNTRY — VARCHAR(255)
- PICTURE — VARCHAR(255)
- BUSINESS_PURPOSE — VARCHAR(1000)
- WEBSITE — VARCHAR(255)
- DESCRIPTION_REGISTER — VARCHAR(30000) — NOT NULL
- DESCRIPTION — VARCHAR(30000) — NOT NULL
- DOCUMENTS — VARCHAR(255)
- ASSET — NUMBER
- DELETED — NUMBER — NOT NULL
CALL_TB
- ID — NUMBER — Primary key — NOT NULL
- CRM_USER_ID — NUMBER — Foreign key → CRM_USER_TB.ID
- CONTACT_ID — NUMBER — Foreign key → CONTACT_TB.ID
- NAME — VARCHAR(150) — NOT NULL
- PARENT_ID — NUMBER — NOT NULL
- PARENT_TYPE — VARCHAR(100) — NOT NULL
- START_DATE — TIMESTAMP
- END_DATE — TIMESTAMP
- ATTACHMENT — VARCHAR(255)
- DESCRIPTION — VARCHAR(65000)
- DELETED — NUMBER — NOT NULL
CAMPAIGN_ASSIGNED_TB
- ID — NUMBER — Primary key — NOT NULL
- CAMPAIGN_ID — NUMBER — Foreign key → CAMPAIGN_TB.ID — NOT NULL
- CRM_USER_ID — NUMBER — Foreign key → CRM_USER_TB.ID — NOT NULL
- STATUS — VARCHAR(100) — NOT NULL
- DATE_ENTERED — DATE — NOT NULL
- DELETED — NUMBER — NOT NULL
CAMPAIGN_RESULT_ATTRIBUTE_TB
- ID — NUMBER — Primary key — NOT NULL
- NAME — VARCHAR(100) — NOT NULL
- DESCRIPTION — VARCHAR(65000)
- DELETED — NUMBER — NOT NULL
CAMPAIGN_RESULT_TB
- ID — NUMBER — Primary key — NOT NULL
- CAMPAIGN_TARGET_ID — NUMBER — Foreign key → CAMPAIGN_TARGET_TB.ID — NOT NULL
- CAMPAIGN_RESULT_ATTRIBUTE_ID — NUMBER — Foreign key → CAMPAIGN_RESULT_ATTRIBUTE_TB.ID — NOT NULL
- VALUE — VARCHAR(100) — NOT NULL
- DATE_ENTERED — DATE — NOT NULL
- DELETED — NUMBER — NOT NULL
- Key — Foreign key → CAMPAIGN_TARGET_TB.Key — NOT NULL
CAMPAIGN_TARGET_ASSIGNED_TB
- ID — NUMBER — Primary key — NOT NULL
- CAMPAIGN_TARGET_ID — NUMBER — Foreign key → CAMPAIGN_TARGET_TB.ID — NOT NULL
- CRM_USER_ID — NUMBER — Foreign key → CRM_USER_TB.ID — NOT NULL
- DATE_ENTERED — DATE — NOT NULL
- DELETED — NUMBER — NOT NULL
- Key — Foreign key → CAMPAIGN_TARGET_TB.Key — NOT NULL
CAMPAIGN_TARGET_TB
- ID — NUMBER — Primary key — NOT NULL
- CAMPAIGN_ID — NUMBER — Foreign key → CAMPAIGN_TB.ID — NOT NULL
- LEAD_ID — NUMBER — Foreign key → LEAD_TB.ID
- END_LEAD_STATE — VARCHAR(100)
- DATE_ENTERED — DATE — NOT NULL
- DELETED — NUMBER — NOT NULL
- Key — Foreign key → OPPORTUNITY_TB.Key — NOT NULL
CAMPAIGN_TB
- ID — NUMBER — Primary key — NOT NULL
- PRODUCT_CLASS_ID — NUMBER — Foreign key → PRODUCT_CLASS_TB.ID — NOT NULL
- CRM_USER_ID — NUMBER — Foreign key → CRM_USER_TB.ID — NOT NULL
- NAME — VARCHAR(100) — NOT NULL
- DATE_ENTERED — DATE — NOT NULL
- DATE_MODIFIED — DATE — NOT NULL
- LEAD_TYPE — VARCHAR(100) — NOT NULL
- LEAD_STATUS — VARCHAR(100) — NOT NULL
- LEAD_POSITION — VARCHAR(100)
- LEAD_TITLE — VARCHAR(100)
- LEAD_JOB — VARCHAR(100)
- CHANNEL — VARCHAR(100) — NOT NULL
- STATUS — VARCHAR(100) — NOT NULL
- START_DATE — DATE — NOT NULL
- END_DATE — DATE — NOT NULL
- DESCRIPTION — VARCHAR(65000)
- DELETED — NUMBER — NOT NULL
COLLABORATION_TB
- ID — NUMBER — Primary key — NOT NULL
- CRM_USER_ID — NUMBER — Foreign key → CRM_USER_TB.ID — NOT NULL
- ASSIGNEE_ID — NUMBER — Foreign key → CRM_USER_TB.ID — NOT NULL
- CAMPAIGN_ID — NUMBER — Foreign key → CAMPAIGN_TB.ID — NOT NULL
- NAME — VARCHAR(150) — NOT NULL
- DATE_ENTERED — DATE
- DATE_MODIFIED — DATE
- DIVISION — VARCHAR(100) — NOT NULL
- DESCRIPTION — VARCHAR(65000)
- DELETED — NUMBER — NOT NULL
CONTACT_TB
- ID — NUMBER — Primary key — NOT NULL
- ACCOUNT_ID — NUMBER — Foreign key → ACCOUNT_TB.ID — NOT NULL
- NAME — VARCHAR(50) — NOT NULL
- DATE_ENTERED — DATE
- DATE_MODIFIED — DATE
- TITLE — VARCHAR(100)
- POSITION — VARCHAR(100)
- JOB — VARCHAR(100)
- EMAIL_ADDRESS — VARCHAR(100) — NOT NULL
- FACEBOOK — VARCHAR(255)
- TWITTER — VARCHAR(255)
- GOOGLE — VARCHAR(255)
- DEPARTMENT — VARCHAR(100)
- PHONE_HOME — VARCHAR(50)
- PHONE_WORK — VARCHAR(50) — NOT NULL
- FAX — VARCHAR(50)
- ADDRESS_STREET — VARCHAR(150)
- ADDRESS_CITY — VARCHAR(100)
- ADDRESS_STATE — VARCHAR(100)
- ADDRESS_POSTALCODE — VARCHAR(20)
- ADDRESS_COUNTRY — VARCHAR(255)
- PICTURE — VARCHAR(255)
- BIRTHDATE — DATE
- BUSINESS_PURPOSE — VARCHAR(1000)
- PREFERRED_LANGUAGE — VARCHAR(50)
- PORTAL_ID — VARCHAR(50)
- DOCUMENTS — VARCHAR(255)
- DESCRIPTION_REGISTER — VARCHAR(30000) — NOT NULL
- DESCRIPTION — VARCHAR(30000) — NOT NULL
- DELETED — NUMBER — NOT NULL
CONTENT_TB
- ID — NUMBER — Primary key — NOT NULL
- CRM_USER_ID — NUMBER — Foreign key → CRM_USER_TB.ID — NOT NULL
- PRODUCT_CLASS_ID — NUMBER — Foreign key → PRODUCT_CLASS_TB.ID — NOT NULL
- NAME — VARCHAR(150) — NOT NULL
- TYPE — VARCHAR(150) — NOT NULL
- DATA_TYPE — VARCHAR(150) — NOT NULL
- LEAD_TYPE — VARCHAR(150)
- LEAD_STATUS — VARCHAR(150)
- POSITION — VARCHAR(150)
- TITLE — VARCHAR(150)
- JOB — VARCHAR(150)
- SOURCE — VARCHAR(150)
- TIME_REGISTERED — TIMESTAMP — NOT NULL
- DESCRIPTION — VARCHAR(1000)
- DEFINED — NUMBER — NOT NULL
- DELETED — NUMBER — NOT NULL
CRM_TEAM_TB
- ID — NUMBER — Primary key — NOT NULL
- NAME — VARCHAR(50) — NOT NULL
CRM_USER_TB
- ID — NUMBER — Primary key — NOT NULL
- NAME — VARCHAR(50)
- PHONE — VARCHAR(50)
- EMAIL — VARCHAR(50)
CRM_USER_TEAM_TB
- TEAM_ID — NUMBER — Foreign key → CRM_TEAM_TB.ID — NOT NULL
- CRM_USER_ID — NUMBER — Foreign key → CRM_USER_TB.ID — NOT NULL
DRAFT_CONTENT_TB
- ID — NUMBER — Primary key — NOT NULL
- DRAFT_ID — NUMBER — Foreign key → DRAFT_TB.ID — NOT NULL
- CONTENT_ID — NUMBER — Foreign key → CONTENT_TB.ID — NOT NULL
- DELETED — NUMBER — NOT NULL
DRAFT_TB
- ID — NUMBER — Primary key — NOT NULL
- CRM_USER_ID — NUMBER — Foreign key → CRM_USER_TB.ID — NOT NULL
- PRODUCT_CLASS_ID — NUMBER — Foreign key → PRODUCT_CLASS_TB.ID — NOT NULL
- TEMPLATE_CONTENT_ID — NUMBER — Foreign key → TEMPLATE_CONTENT_TB.ID — NOT NULL
- NAME — VARCHAR(150) — NOT NULL
- DATE_ENTERED — DATE — NOT NULL
- DATE_MODIFIED — DATE — NOT NULL
- LEAD_TYPE — VARCHAR(150) — NOT NULL
- LEAD_STATUS — VARCHAR(150) — NOT NULL
- LEAD_POSITION — VARCHAR(150)
- LEAD_TITLE — VARCHAR(150)
- LEAD_JOB — VARCHAR(150)
- STATUS — VARCHAR(150) — NOT NULL
- DESCRIPTION — VARCHAR(65000)
- DELETED — NUMBER — NOT NULL
EMAIL_CAMPAIGN_TB
- ID — NUMBER — Primary key — NOT NULL
- CAMPAIGN_ID — NUMBER — Foreign key → CAMPAIGN_TB.ID — NOT NULL
- DRAFT_ID — NUMBER — Foreign key → DRAFT_TB.ID — NOT NULL
- EMAIL_ADDRESS — VARCHAR(100) — NOT NULL
- SENDER_NAME (SENDRER_NAME) — VARCHAR(100)
- SENDER_SIGNATURE — VARCHAR(100)
- DELETED — NUMBER — NOT NULL
EMAIL_TB
- ID — NUMBER — Primary key — NOT NULL
- CRM_USER_ID — NUMBER — Foreign key → CRM_USER_TB.ID
- CONTACT_ID — NUMBER — Foreign key → CONTACT_TB.ID
- NAME — VARCHAR(150) — NOT NULL
- PARENT_ID — NUMBER — NOT NULL
- PARENT_TYPE — VARCHAR(100) — NOT NULL
- EMAIL_CODE — NUMBER — NOT NULL
- SENDER — VARCHAR(100)
- RECEIVER — VARCHAR(100)
- DESCRIPTION — VARCHAR(65000)
- ATTACHMENT — VARCHAR(255)
- DELETED — NUMBER — NOT NULL
GUIDANCE_CONTENT_TB
- ID — NUMBER — Primary key — NOT NULL
- GUIDANCE_ID — NUMBER — Foreign key → GUIDANCE_TB.ID — NOT NULL
- CONTENT_ID — NUMBER — Foreign key → CONTENT_TB.ID — NOT NULL
- DESCRIPTION — VARCHAR(65000)
- DELETED — NUMBER — NOT NULL
GUIDANCE_TB
- ID — NUMBER — Primary key — NOT NULL
- CRM_USER_ID — NUMBER — Foreign key → CRM_USER_TB.ID — NOT NULL
- PRODUCT_CLASS_ID — NUMBER — Foreign key → PRODUCT_CLASS_TB.ID — NOT NULL
- TEMPLATE_CONTENT_ID — NUMBER — Foreign key → TEMPLATE_CONTENT_TB.ID — NOT NULL
- NAME — VARCHAR(100) — NOT NULL
- DATE_ENTERED — DATE — NOT NULL
- DATE_MODIFIED — DATE — NOT NULL
- LEAD_TYPE — VARCHAR(100) — NOT NULL
- LEAD_STATUS — VARCHAR(100) — NOT NULL
- LEAD_POSITION — VARCHAR(100)
- LEAD_TITLE — VARCHAR(100)
- LEAD_JOB — VARCHAR(100)
- STATUS — VARCHAR(100) — NOT NULL
- DESCRIPTION — VARCHAR(65000)
- DELETED — NUMBER — NOT NULL
LEAD_TB
- ID — NUMBER — Primary key — NOT NULL
- CONTACT_ID — NUMBER — Foreign key → CONTACT_TB.ID — NOT NULL
- CRM_USER_ID — NUMBER — Foreign key → CRM_USER_TB.ID — NOT NULL
- REGISTER_BY — NUMBER — Foreign key → CRM_USER_TB.ID
- PRODUCT_CLASS_ID — NUMBER — Foreign key → PRODUCT_CLASS_TB.ID — NOT NULL
- NAME — VARCHAR(150) — NOT NULL
- DATE_ENTERED — DATE
- DATE_MODIFIED — DATE
- SOURCE — VARCHAR(100)
- SOURCE_DESCRIPTION — VARCHAR(1000)
- INTEREST_POINT — NUMBER — NOT NULL
- STATUS — VARCHAR(100)
- OPPORTUNITY_NAME — VARCHAR(150)
- OPPORTUNITY_AMOUNT — NUMBER
- OPPORTUNITY_PRODUCT — VARCHAR(255)
- OPPORTUNITY_DESCRIPTION — VARCHAR(65000)
- CUSTOMER_RELATIONSHIP — NUMBER
- CONVERTED — NUMBER — NOT NULL
- DELETED — NUMBER — NOT NULL
- DESCRIPTION — VARCHAR(65000)
MEETING_CONTACT_TB
- ID — NUMBER — Primary key — NOT NULL
- MEETING_ID — NUMBER — Foreign key → MEETING_TB.ID — NOT NULL
- CONTACT_ID — NUMBER — Foreign key → CONTACT_TB.ID — NOT NULL
- DELETED — NUMBER — NOT NULL
MEETING_TB
- ID — NUMBER — Primary key — NOT NULL
- PARENT_ID — NUMBER — NOT NULL
- PARENT_TYPE — VARCHAR(100) — NOT NULL
- NAME — VARCHAR(150) — NOT NULL
- LOCATION — VARCHAR(150) — NOT NULL
- START_DATE — TIMESTAMP
- END_DATE — TIMESTAMP
- ATTACHMENT — VARCHAR(255)
- DESCRIPTION — VARCHAR(65000)
- DELETED — NUMBER — NOT NULL
MEETING_USER_TB
- ID — NUMBER — Primary key — NOT NULL
- CRM_USER_ID — NUMBER — Foreign key → CRM_USER_TB.ID — NOT NULL
- MEETING_ID — NUMBER — Foreign key → MEETING_TB.ID — NOT NULL
- DELETED — NUMBER — NOT NULL
OPPORTUNITY_TB
- Key — Primary key — NOT NULL
- CONTACT_ID — NUMBER — Foreign key → CONTACT_TB.ID — NOT NULL
- LEAD_ID — NUMBER — Foreign key → LEAD_TB.ID
- PRODUCT_CLASS_ID — NUMBER — Foreign key → PRODUCT_CLASS_TB.ID — NOT NULL
- CRM_USER_ID — NUMBER — Foreign key → CRM_USER_TB.ID — NOT NULL
- REGISTER_BY — NUMBER — Foreign key → CRM_USER_TB.ID
- NAME — VARCHAR(150)
- DATE_ENTERED — DATE
- DATE_MODIFIED — DATE
- NEED_PROBLEM — VARCHAR(4000)
- NEED_PRODUCT — VARCHAR(2000)
- NEED_SPEC — VARCHAR(4000)
- SCORE_NEED — NUMBER — NOT NULL
- SCORE_BUDGET — NUMBER — NOT NULL
- SCORE_TIMING — NUMBER — NOT NULL
- SOURCE — VARCHAR(100)
- SOURCE_DESCRIPTION — VARCHAR(1000)
- STAGE — NUMBER — NOT NULL
- PROBABILITY — NUMBER
- EXPECTED_CLOSE_DATE — DATE
- CONVERTED — NUMBER — NOT NULL
- DELETED — NUMBER — NOT NULL
- DESCRIPTION — VARCHAR(65000)
- EXPECTED_DELIVERY_DATE — DATE
PRODUCT_ATTRIBUTE_TB
- ID — NUMBER — Primary key — NOT NULL
- CLASS_ID — NUMBER — Foreign key → PRODUCT_CLASS_TB.ID — NOT NULL
- NAME — VARCHAR(50) — NOT NULL
PRODUCT_CLASS_KEYWORD_TB
- CLASS_ID — NUMBER — Foreign key → PRODUCT_CLASS_TB.ID — NOT NULL
- KEYWORD — VARCHAR(100) — NOT NULL
PRODUCT_CLASS_TB
- ID — NUMBER — Primary key — NOT NULL
- NAME — VARCHAR(100) — NOT NULL
- PARENT_CLASS — NUMBER — Foreign key → PRODUCT_CLASS_TB.ID
PRODUCT_TB
- ID — NUMBER — Primary key — NOT NULL
- PRODUCT_CLASS_ID — NUMBER — Foreign key → PRODUCT_CLASS_TB.ID — NOT NULL
- NAME — VARCHAR(100) — NOT NULL
- PRICE — NUMBER
- DESCRIPTION — VARCHAR(65000)
SALESREP_CAMPAIGN_TB
- ID — NUMBER — Primary key — NOT NULL
- CAMPAIGN_ID — NUMBER — Foreign key → CAMPAIGN_TB.ID — NOT NULL
- GUIDANCE_ID — NUMBER — Foreign key → GUIDANCE_TB.ID — NOT NULL
- DELETED — NUMBER — NOT NULL
SALES_REPOSITORY_TB
- ID — NUMBER — Primary key — NOT NULL
- CRM_USER_ID — NUMBER — Foreign key → CRM_USER_TB.ID — NOT NULL
- AUTHOR_ID — NUMBER — Foreign key → CRM_USER_TB.ID — NOT NULL
- CONTENT_ID — NUMBER — Foreign key → CONTENT_TB.ID
- NAME — VARCHAR(150) — NOT NULL
- DATE_ENTERED — DATE
- DATE_MODIFIED — DATE
- ATTACHMENT — VARCHAR(255) — NOT NULL
- DESCRIPTION — VARCHAR(65000)
- DELETED — NUMBER — NOT NULL
TASK_CONTACT_TB
- ID — NUMBER — Primary key — NOT NULL
- TASK_ID — NUMBER — Foreign key → TASK_TB.ID — NOT NULL
- CONTACT_ID — NUMBER — Foreign key → CONTACT_TB.ID — NOT NULL
- DELETED — NUMBER — NOT NULL
TASK_CRM_USER_TB
- ID — NUMBER — Primary key — NOT NULL
- TASK_ID — NUMBER — Foreign key → TASK_TB.ID — NOT NULL
- CRM_USER_ID — NUMBER — Foreign key → CRM_USER_TB.ID — NOT NULL
- DELETED — NUMBER — NOT NULL
TASK_TB
- ID — NUMBER — Primary key — NOT NULL
- NAME — VARCHAR(150) — NOT NULL
- DATE_START — DATE
- DATE_DUE — DATE
- STATUS — VARCHAR(100)
- PARENT_TYPE — VARCHAR(100)
- PARENT_ID — NUMBER
- TYPE — VARCHAR(100) — NOT NULL
- DESCRIPTION — VARCHAR(65000)
- DELETED — NUMBER — NOT NULL
TEMPLATECONTENT_CONTENTTYPE_TB
- ID — NUMBER — Primary key — NOT NULL
- TEMPLATE_CONTENT_ID — NUMBER — Foreign key → TEMPLATE_CONTENT_TB.ID — NOT NULL
- CONTENT_TYPE — VARCHAR(150) — NOT NULL
- DESCRIPTION — VARCHAR(1000)
- DELETED — NUMBER — NOT NULL
TEMPLATE_CONTENT_TB
- ID — NUMBER — Primary key — NOT NULL
- PRODUCT_CLASS_ID — NUMBER — Foreign key → PRODUCT_CLASS_TB.ID — NOT NULL
- NAME — VARCHAR(150) — NOT NULL
- LEAD_TYPE — VARCHAR(150)
- LEAD_STATUS — VARCHAR(150)
- POSITION — VARCHAR(150)
- TITLE — VARCHAR(150)
- JOB — VARCHAR(150)
- DESCRIPTION — VARCHAR(1000)
- DELETED — NUMBER — NOT NULL
UNSATISFACTORY_ACCOUNT_TB
- ID — NUMBER — Primary key — NOT NULL
- NAME — VARCHAR(150) — NOT NULL
- DATE_ENTERED — DATE
- DATE_MODIFIED — DATE
- INDUSTRY — VARCHAR(100) — NOT NULL
- EMAIL_ADDRESS — VARCHAR(100) — NOT NULL
- PHONE_WORK — VARCHAR(50)
- ADDRESS_STREET — VARCHAR(150)
- ADDRESS_CITY — VARCHAR(100)
- ADDRESS_STATE — VARCHAR(100)
- ADDRESS_POSTALCODE — VARCHAR(20)
- ADDRESS_COUNTRY — VARCHAR(255)
- PICTURE — VARCHAR(255)
- BUSINESS_PURPOSE — VARCHAR(1000)
- WEBSITE — VARCHAR(255)
- DESCRIPTION — VARCHAR(30000)
- DOCUMENTS — VARCHAR(255)
- ASSET — NUMBER
- DELETED — NUMBER — NOT NULL
UNSATISFACTORY_CONTACT_TB
- ID — NUMBER — Primary key — NOT NULL
- ACCOUNT_ID — NUMBER — Foreign key → ACCOUNT_TB.ID
- NAME — VARCHAR(50) — NOT NULL
- DATE_ENTERED — DATE
- DATE_MODIFIED — DATE
- TITLE — VARCHAR(100)
- POSITION — VARCHAR(100)
- JOB — VARCHAR(100)
- EMAIL_ADDRESS — VARCHAR(100) — NOT NULL
- DEPARTMENT — VARCHAR(100)
- PHONE_HOME — VARCHAR(50)
- PHONE_WORK — VARCHAR(50) — NOT NULL
- FAX — VARCHAR(50)
- ADDRESS_STREET — VARCHAR(150)
- ADDRESS_CITY — VARCHAR(100)
- ADDRESS_STATE — VARCHAR(100)
- ADDRESS_POSTALCODE — VARCHAR(20)
- ADDRESS_COUNTRY — VARCHAR(255)
- DOCUMENTS — VARCHAR(255)
- DESCRIPTION — VARCHAR(30000)
- DELETED — NUMBER — NOT NULL
UNSATISFACTORY_LEAD_TB
- ID — NUMBER — Primary key — NOT NULL
- CONTACT_ID — NUMBER — Foreign key → CONTACT_TB.ID — NOT NULL
- CRM_USER_ID — NUMBER — Foreign key → CRM_USER_TB.ID — NOT NULL
- PRODUCT_CLASS_ID — NUMBER — Foreign key → PRODUCT_CLASS_TB.ID — NOT NULL
- NAME — VARCHAR(150) — NOT NULL
- LEAD_TYPE — VARCHAR(20)
- SOURCE — VARCHAR(100)
- SOURCE_DESCRIPTION — VARCHAR(1000)
- DESCRIPTION — VARCHAR(65000)
- DELETED — NUMBER — NOT NULL