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