PreSales-Prac

Tables (42)

ACCOUNT TB

  • ID — Primary key — NOT NULL
  • REGISTEREDBY_ID — NUMBER — Foreign key → ERP_TB.ID — NOT NULL
  • NAME — VARCHAR2(50) — NOT NULL
  • REGISTERED_DATE — DATE — NOT NULL
  • SATISFACTORY — CHAR — NOT NULL
  • DATE_OF_RATING — DATE
  • INDUSTRY — VARCHAR2(100)
  • WEBSITE — VARCHAR2(100)
  • OFFICE_PHONE — VARCHAR2(50)
  • EMAIL_ADDRESS — VARCHAR2(100)
  • FAX — VARCHAR2(50)
  • SHIPPING_ADDRESS — VARCHAR2(100)
  • DESCRIPTION — VARCHAR2(10000)
  • CEO — VARCHAR2(50)
  • ANNUAL_REVENUE — VARCHAR2(100)
  • COMPANY_SCALES — VARCHAR2(100)
  • BUSINESS_NUMBER — VARCHAR2(50)
  • CREDIT_RATING — VARCHAR2(50)
  • RATING_AGENCY — VARCHAR2(50)
  • DOCUMENT — BINARY
  • SOURCE — VARCHAR2(500)

ACTIVITY_TB

  • ID — NUMBER — Primary key — NOT NULL
  • Key (COLLABORATOR_ID) — NUMBER — Foreign key → Untitled.Key
  • COMPANION_ID — NUMBER — Foreign key → ERP_TB.ID — NOT NULL
  • SR_ID — NUMBER — Foreign key → SALES_REPRESENTATIVE_TB.ID — NOT NULL
  • CAMPAIGN_ID — NUMBER — Foreign key → CAMPAIGN_TB.ID — NOT NULL
  • STATUS — VARCHAR2(50)
  • DATE (DATE_START) — DATE
  • VOC — VARCHAR2(10000)
  • DETAIL — VARCHAR2(10000)
  • Field (TYPE) — VARCHAR2(100)
  • Field (MATERIAL) — BINARY
  • Field (DATE_END) — DATE
  • Field2 (DATE_LABEL) — VARCHAR2(100)

AD_DRAFT_TB

  • BANNER_DRAFT_ID — NUMBER — Foreign key → BANNER_DRAFT_TB.ID — NOT NULL
  • AD_ID — NUMBER — Foreign key → CONTACT_TB.ID — NOT NULL

AD_GROUP_TB

  • ID — NUMBER — Primary key — NOT NULL
  • BANNER_DRAFT_ID — NUMBER — Foreign key → BANNER_DRAFT_TB.ID — NOT NULL
  • AD_GROUP_NAME — VARCHAR2(50)
  • AD_GROUP_DATE — DATE
  • AD_GROUP_DETAIL — VARCHAR2(500)
  • PLATFORM — VARCHAR2(50)
  • PLATFORM_POSITION — VARCHAR2(50)
  • GENDER — VARCHAR2(50)
  • AGE_START — NUMBER
  • AGE_END — NUMBER
  • LANGUAGE — VARCHAR2(50)

BANNER_DRAFT_TB

  • ID — NUMBER — Primary key — NOT NULL
  • CAMPAIGN_ID — NUMBER — Foreign key → CAMPAIGN_TB.ID — NOT NULL
  • BUDGET (BUGDET) — VARCHAR2(50)
  • RANDING_PAGE_URL — VARCHAR2(50)
  • DESCRIPTION — VARCHAR(10000)

CAMPAIGN_TB (CAMPAIGN BASIC_TB)

  • ID — NUMBER — Primary key — NOT NULL
  • NAME — VARCHAR2(50) — NOT NULL
  • TYPE — VARCHAR2(50) — NOT NULL
  • DESCRIPTION — VARCHAR2(10000)
  • START_DATE — DATE
  • END_DATE — DATE
  • Field (STATUS) — VARCHAR(10) — NOT NULL

CONTACT_TB

  • ID — NUMBER — Primary key — NOT NULL
  • REGISTEREDBY_ID — NUMBER — Foreign key → ERP_TB.ID — NOT NULL
  • ACCOUNT_ID — NUMBER — Foreign key → ACCOUNT TB.ID
  • NAME — VARCHAR2(100) — NOT NULL
  • SATISFACTORY — CHAR — NOT NULL
  • REGISTED_DATE — DATE — NOT NULL
  • R&R — VARCHAR2(50)
  • POSITION — VARCHAR2(50)
  • PHONE — VARCHAR2(100)
  • EMAIL_ADDRESS — VARCHAR2(100)
  • DESCRIPTION — VARCHAR2(10000)
  • ADDRESS — VARCHAR2(100)
  • SOURCE — VARVHAR2(500)
  • AGE — NUMBER

CONTENT_TB

  • ID — NUMBER — Primary key — NOT NULL
  • REGISTEREDBY_ID — NUMBER — Foreign key → ERP_TB.ID — NOT NULL
  • NAME — VARCHAR2(50) — NOT NULL
  • DATA_TYPE — VARCHAR2(100)
  • SOURCE — VARCHAR2(100)
  • CONTENT_TYPE — VARCHAR2(100)
  • CONTENT_OBJECT — VARCHAR2(100)
  • SATISTACTORY (SATISFACTORY) — CHAR — NOT NULL
  • DESCRIPTION — VARCHAR2(10000)
  • CONTENT — BINARY — NOT NULL

EMAIL_DRAFT_TB (DRAFT_TB)

  • ID — NUMBER — Primary key — NOT NULL
  • NAME — VARCHAR2(50) — NOT NULL
  • STATUS — VARCHAR2(50) — NOT NULL
  • CREATED_BY — VARCHAR2(50)
  • CREATED_DATE — DATE
  • DESCRIPTION — VARCHAR2(10000)

ERP_TB

  • ID — NUMBER — Primary key — NOT NULL
  • NAME — VARCHAR2(100) — NOT NULL
  • ADDRESS — VARCHAR2(100) — NOT NULL
  • DEPARTMENT — VARCHAR2(100) — NOT NULL
  • R&R — VARCHAR2(100) — NOT NULL
  • POSITION — VARCHAR2(100) — NOT NULL
  • MOBILE — VARCHAR2(100) — NOT NULL
  • EMAIL — VARCHAR2(100) — NOT NULL

GUIDANCE_TB

  • ID — NUMBER — Primary key — NOT NULL
  • SR_ID — NUMBER — Foreign key → SALES_REPRESENTATIVE_TB.ID
  • NAME — VARCHAR2(50) — NOT NULL
  • STATUS — VARCHAR2(50)
  • CREATED_BY — VARCHAR2(50)
  • CREATED_DATE — DATE
  • DESCRIPTION — VARCHAR2(10000)

GUIDELINE_TB

  • ID — Primary key — NOT NULL
  • GUIDELINE_ACCOUNT — VARCHAR2(10000)
  • GUIDELINE_CONTACT — VARCHAR2(10000)
  • GUIDELINE_LEAD — VARCHAR2(10000)
  • GUIDELINE_CONTENT — VARCHAR2(10000)

INVENTORY LEAD_CAMPAIGN_TB

  • INVENTORY LEAD_ID — NUMBER — Foreign key → INVENTORY LEAD_TB.ID — NOT NULL
  • CAMPAIGN_ID — NUMBER — Foreign key → CAMPAIGN_TB.ID — NOT NULL

INVENTORY LEAD_CONTENT_TB

  • LEAD_ID — NUMBER — Foreign key → INVENTORY LEAD_TB.ID — NOT NULL
  • CONTENT_ID — NUMBER — Foreign key → CONTENT_TB.ID — NOT NULL

INVENTORY LEAD_DRAFT_TB

  • LEAD_ID — NUMBER — Foreign key → INVENTORY LEAD_TB.ID — NOT NULL
  • DRAFT_ID — NUMBER — Foreign key → EMAIL_DRAFT_TB.ID — NOT NULL

INVENTORY LEAD_GUIDANCE_TB

  • LEAD_ID — NUMBER — Foreign key → INVENTORY LEAD_TB.ID — NOT NULL
  • GUIDACNE_ID (GUIDANCE_ID) — NUMBER — Foreign key → GUIDANCE_TB.ID — NOT NULL

INVENTORY LEAD_TB

  • ID — NUMBER — Primary key — NOT NULL
  • REGISTEDBY_ID — NUMBER — Foreign key → ERP_TB.ID — NOT NULL
  • PROCUCT_ID (PRODUCT_ID) — NUMBER — Foreign key → PRODUCT_TB.ID — NOT NULL
  • CONTACT_ID — NUMBER — Foreign key → CONTACT_TB.ID — NOT NULL
  • NAME — VARCHAR2(50) — NOT NULL
  • SATISFACTORY — CHAR — NOT NULL
  • SOURCE — VARCHAR2(500)
  • STATUS — NUMBER
  • DESCRIPTION — VARCHAR2(10000)
  • BUDGET_SCORE — NUMBER
  • TIME_SCORE — NUMBER
  • NEED_SCORE — NUMBER
  • PROBLEM — VARCHAR2(10000)
  • PRODUCT_SPEC — VARCHAR2(10000)
  • CONTRACT_DATE — DATE
  • DELIVERY_DATE — DATE
  • QUOTE — BINARY
  • COMPELTE — CHAR — NOT NULL
  • Field (EMAIL) — VARCHAR2(500)

MARKETING LEAD_CAMAPIGN_TB (MARKETING LEAD_CAMPAIGN_TB)

  • CAMPAIGN_ID (CAMAPAIGN_ID) — NUMBER — Foreign key → CAMPAIGN_TB.ID — NOT NULL
  • MARKETING LEAD_ID — NUMBER — Foreign key → MARKETING LEAD_TB.ID — NOT NULL

MARKETING LEAD_CONTENT_TB

  • CONTENT_ID — NUMBER — Foreign key → CONTENT_TB.ID — NOT NULL
  • LEAD_ID — NUMBER — Foreign key → MARKETING LEAD_TB.ID — NOT NULL

MARKETING LEAD_DRAFT_TB

  • LEAD_ID — NUMBER — Foreign key → MARKETING LEAD_TB.ID — NOT NULL
  • DRAFT_ID — NUMBER — Foreign key → EMAIL_DRAFT_TB.ID — NOT NULL

MARKETING LEAD_GUIDANCE_TB

  • LEAD_ID — NUMBER — Foreign key → MARKETING LEAD_TB.ID — NOT NULL
  • GUIDANCE_ID — NUMBER — Foreign key → GUIDANCE_TB.ID — NOT NULL

MARKETING LEAD_TB

  • ID — NUMBER — Primary key — NOT NULL
  • REGISTEREDBY_ID — NUMBER — Foreign key → ERP_TB.ID — NOT NULL
  • CONTACT_ID — NUMBER — Foreign key → CONTACT_TB.ID — NOT NULL
  • NAME — VARCHAR2(50) — NOT NULL
  • SATISFACTORY — CHAR — NOT NULL
  • SOURCE — VARCHAR2(500)
  • TYPE — VARCHAR2(50)
  • DESCRIPTION — VARVHAR2(10000)
  • INTEREST_POINT — NUMBER
  • PREFERENCE_POINT — NUMBER

PRODUCT_CONTENT_TB

  • CONTENT_ID — NUMBER — Foreign key → CONTENT_TB.ID — NOT NULL
  • PROCUCT_ID (PRODUCT_ID) — NUMBER — Foreign key → PRODUCT_TB.ID — NOT NULL

PRODUCT_LEAD_TB

  • PRODUCT_ID (PROCTUCT_ID) — Foreign key → PRODUCT_TB.ID — NOT NULL
  • LEAD_ID — Foreign key → MARKETING LEAD_TB.ID — NOT NULL

PRODUCT_TB (PROCUCT_TB)

  • ID — NUMBER — Primary key — NOT NULL
  • CATEGORY — VARCHAR2(50) — NOT NULL
  • NAME — VARCHAR2(50) — NOT NULL
  • DESCRIPTION — VARCHAR2(10000) — NOT NULL

RECOMMENDED_TARGET_TB

  • ID — NUMBER — Primary key — NOT NULL
  • DESCRIPTION — NUMBER
  • GENDER — VARCHAR2(50)
  • AGE_START — NUMBER
  • AGE_END — NUMBER
  • LANGUAGE — VARCHAR2(50)
  • AD_GROUP_ID — NUMBER — Foreign key → AD_GROUP_TB.ID — NOT NULL

REVIEWER_BANNER DRAFT_TB

  • BANNER DRAFT_ID — NUMBER — Foreign key → BANNER_DRAFT_TB.ID — NOT NULL
  • REVIEWER_ID — NUMBER — Foreign key → ERP_TB.ID — NOT NULL
  • DESCRIPTION — VARCHAR(10000)

REVIEWER_EMAIL DRAFT_TB

  • REVIEWER_ID — NUMBER — Foreign key → ERP_TB.ID — NOT NULL
  • DRAFT_ID — NUMBER — Foreign key → EMAIL_DRAFT_TB.ID — NOT NULL
  • DESCRIPTION — VARCHAR2(10000)

REVIEWER_GUIDANCE_TB

  • GUIDANCE_ID — NUMBER — Foreign key → GUIDANCE_TB.ID — NOT NULL
  • REVIEWER_ID — NUMBER — Foreign key → ERP_TB.ID — NOT NULL
  • DESCRIPTION — VARCHER(10000)

SALES_REPRESENTATIVE_TB

  • ID — NUMBER — Primary key — NOT NULL
  • SR_ID — NUMBER — Foreign key → ERP_TB.ID — NOT NULL

TEMPLATE CONTENT_TB

  • PRODUCT_ID — NUMBER — Foreign key → PRODUCT_TB.ID
  • MARKETING LEAD_ID — NUMBER — Foreign key → MARKETING LEAD_TB.ID
  • INVENTORY LEAD_ID — NUMBER — Foreign key → INVENTORY LEAD_TB.ID
  • CONTENT_ID — NUMBER — Foreign key → CONTENT_TB.ID
  • TEMPLATE CONTENT (TEMPALTE_CONTENT) — CHAR — NOT NULL
  • Field (DESCRIPTION) — VARCHAR2(10000)

Untitled (RESEARCHAER_TB)

  • Key (ID) — NUMBER — Primary key — NOT NULL
  • ID (PRODUCT_ID) — NUMBER — Foreign key → PRODUCT_TB.ID — NOT NULL
  • ID (RESEARCHER_ID) — NUMBER — Foreign key → ERP_TB.ID — NOT NULL

Untitled (CAMPAIGN ARRANGE_TB)

  • ID (CAMPAIGN_ID) — NUMBER — Foreign key → CAMPAIGN_TB.ID — NOT NULL
  • ID (SR_ID) — NUMBER — Foreign key → SALES_REPRESENTATIVE_TB.ID — NOT NULL
  • Field (ADDMISSION) — VARCHAR(10) — NOT NULL

Untitled (DRAFT FOR CAMPAIGN_TB)

  • Key (ID) — NUMBER — Primary key — NOT NULL
  • ID (DRAFT_ID) — NUMBER — Foreign key → EMAIL_DRAFT_TB.ID — NOT NULL

Untitled (GUIDANCE FOR CAMPAIGN_TB)

  • Key (ID) — NUMBER — Primary key — NOT NULL
  • ID (GUIDANCE_ID) — NUMBER — Foreign key → GUIDANCE_TB.ID — NOT NULL

Untitled (BANNER DRAFT FOR CAMPAIGN_TB)

  • Key (ID) — NUMBER — Primary key — NOT NULL
  • ID (BANNER DRAFT_ID) — NUMBER — Foreign key → BANNER_DRAFT_TB.ID — NOT NULL

Untitled (DRAFT_MODIFIED_CONTENT_TB)

  • Key (DRAFT_ID) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • ID (CONTENT_ID) — NUMBER — Foreign key → CONTENT_TB.ID — NOT NULL

Untitled (BANNER_MODIFIED_CONTENT_TB)

  • Key (BANNER_ID) — Foreign key → Untitled.Key — NOT NULL
  • ID (CONTENT_ID) — NUMBER — Foreign key → CONTENT_TB.ID — NOT NULL

Untitled (GUIDANCE_MODIFIED_CONTENT_TB)

  • Key (GUIDANCE_ID) — NUMBER — Foreign key → Untitled.Key — NOT NULL
  • ID (CONTENT_ID) — NUMBER — Foreign key → CONTENT_TB.ID — NOT NULL

Untitled (CAMPAIGN DRAFT_TB)

  • ID (CAMPAIGN_ID) — NUMBER — Foreign key → CAMPAIGN_TB.ID — NOT NULL
  • Field
  • Key (GUIDANCE_ID) — NUMBER — Foreign key → Untitled.Key
  • Key (BANNER_ID) — NUMBER — Foreign key → Untitled.Key
  • Key (DRAFT_ID) — NUMBER — Foreign key → Untitled.Key

table (Untitled)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Field4
  • Field5

tanle2 (Untitled2)

  • Key — Primary key — NOT NULL
  • Field
  • Field2
  • Field3
  • Key (Key2) — Foreign key → table.Key — NOT NULL