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