pilot2

Tables (9)

administration_sector (gamang_1)

  • hcode (1) — varchar — Primary key
  • address (2) — varchar

advertisement_statistics (ad_0)

  • cumulative_time (1) — date — Primary key
  • guid (2) — varchar — Primary key
  • hcode (3) — varchar
  • address (4) — varchar
  • product_classification (5) — varchar
  • phone_number (6) — varchar
  • biz_code (7) — varchar
  • poi_name (8) — varchar

call_statistics (ad_3)

  • guid (1) — varchar — Primary key
  • cumulative_time (2) — date — Primary key
  • call_count (3) — bigint

channel_statistics (ad_1_2)

  • guid (1) — varchar — Primary key
  • cumulative_time (2) — date — Primary key
  • channel_type (3) — varchar — Primary key
  • channel_exposure_count (4) — bigint

click_statistics (ad_2)

  • guid (1) — varchar — Primary key
  • cumulative_time (2) — date — Primary key
  • click_count (3) — bigint

exposure_statistics (ad_1)

  • guid (1) — varchar — Primary key
  • cumulative_time (2) — date — Primary key
  • exposure_count (3) — bigint

prospect_statistics (gamang_0)

  • cumulative_time (1) — date — Primary key
  • hcode (2) — varchar — Primary key
  • biz_code (3) — varchar — Primary key
  • quary (4) — varchar — Primary key
  • quary_count (5) — bigint

sector (gamang_2)

  • biz_code (1) — varchar — Primary key
  • biz_name (2) — varchar

vendor_statistics (ad_1_1)

  • guid (1) — varchar — Primary key
  • cumulative_time (2) — date — Primary key
  • vendor_type (3) — varchar — Primary key
  • vendor_exposure_count (4) — bigint