final매쉬보드 방문통계

테이블 (15)

DwellTimeAnalysisUnit (Untitled11)

  • uid (Key) — 기본 키 — NOT NULL
  • place (Key2) — 외래 키 → Place.uid — NOT NULL
  • name (Field2)
  • key (Field)

ExposureAggreagation(노출횟수) (Untitled8)

  • id (Key) — 기본 키 — NOT NULL
  • zone (Key2) — 외래 키 → Zone.uid — NOT NULL
  • age (Field)
  • gender (Field2)
  • count (Field3)
  • start_time (Field4)

ExposureAggregationOfLine (Untitled10)

  • id (Key) — 기본 키 — NOT NULL
  • line (Key2) — 외래 키 → Line.Key — NOT NULL
  • age (Field)
  • gender (Field2)
  • count (Field3)
  • start_time (Field4)

ExposureOfLine (Untitled21)

  • id (Key) — 기본 키 — NOT NULL
  • age (23, 52, ...)
  • gender (Field2)
  • timestamp (Field3)
  • line (Key2) — 외래 키 → Line.Key — NOT NULL

ItemOfDwellTimeAnalysisUnit (Untitled22)

  • id (Key) — 기본 키 — NOT NULL
  • age (23, 52, ...)
  • gender (Field)
  • timestamp (Field2)
  • residence_time (Field3)
  • dwell_time_analysis_unit (Key2) — 외래 키 → DwellTimeAnalysisUnit.uid — NOT NULL

Line (Untitled3)

  • Key — 기본 키 — NOT NULL
  • Key (Key2) — 외래 키 → NoDirectionLine.Key — NOT NULL

NoDirectionLine (Untitled13)

  • Key — 기본 키 — NOT NULL
  • Key (Key2) — 외래 키 → Place.uid — NOT NULL

Place (Untitled)

  • uid (Key) — 기본 키 — NOT NULL
  • name (Field)
  • collection_start (Field2)
  • collection_end (Field3)
  • open_time (Field4)
  • close_time (Field5)
  • tag (Field6)

PlaceStayAggreagation(매장체류) (Untitled7)

  • id (Key) — 기본 키 — NOT NULL
  • place (Key2) — 외래 키 → Place.uid — NOT NULL
  • age (Field)
  • gender (Field2)
  • count (Field3)
  • start_time (Field4)
  • residence_sum (Field5)

PurchaseAggregation(구매추정) (Untitled6)

  • id (Key) — 기본 키 — NOT NULL
  • place (Key2) — 외래 키 → Place.uid — NOT NULL
  • age (Field)
  • gender (Field2)
  • count (Field3)
  • start_time (Field4)

TargetAggregation(체류횟수 + 구역체류) (Untitled9)

  • id (Key) — 기본 키 — NOT NULL
  • zone (Key2) — 외래 키 → Zone.uid — NOT NULL
  • age (Field)
  • gender (Field2)
  • count (Field3)
  • start_time (Field4)
  • residence_sum (Field5)

TargetAggregationOfDwellTimeAnalysisUnit (Untitled12)

  • id (Key) — 기본 키 — NOT NULL
  • dwell_time_analysis_unit (Key2) — 외래 키 → DwellTimeAnalysisUnit.uid — NOT NULL
  • age (Field)
  • gender (Field2)
  • count (Field3)
  • start_time (Field4)
  • residence_sum (Field5)

TrafficAggregation(유동인구) (Untitled4)

  • id (Key) — 기본 키 — NOT NULL
  • place (Key2) — 외래 키 → Place.uid — NOT NULL
  • age (Field4)
  • gender (Field)
  • count (Field2)
  • start_time (Field3)

VisitAggregation(매장방문) (Untitled5)

  • id (Key) — 기본 키 — NOT NULL
  • place (Key2) — 외래 키 → Place.uid — NOT NULL
  • age (Field)
  • gender (Field2)
  • count (Field3)
  • start_time (Field4)

Zone (Untitled2)

  • uid (Key) — 기본 키 — NOT NULL
  • place (Key2) — 외래 키 → Place.uid — NOT NULL
  • name (Field)
  • tag (Field2)
  • zone_category (Field3)