TOBE 리뉴얼 분석페이지 새 모델

테이블 (8)

NewExposureOfLine (CopyOfCopyOfUntitled)

  • id (Key) — 기본 키 — NOT NULL — pk
  • age (Field) — 연령대
  • gender (Field2) — 성별
  • line_start_time (Field3) — 방문 timestamp
  • line_id (Field16) — 라인
  • place_id (Field12) — 매장

NewItemOfDwellTimeAnalysisUnit (CopyOfCopyOfUntitled2)

  • id (Key) — 기본 키 — NOT NULL — pk
  • age (Field) — 연령대
  • gender (Field2) — 성별
  • dwell_time_analysis_unit_start_time (Field3) — 방문 timestamp
  • dwell_time_analysis_unit_residence_time (Field4) — 체류 시간
  • dwell_time_analysis_unit_id (Field16) — DCI
  • place_id (Field12) — 매장

NewLineEvent (CopyOfUntitled22)

  • id (Key) — 기본 키 — NOT NULL
  • line_id (Field10)
  • line_start_time (Field11)
  • person_id (Field9)
  • age (Field)
  • gender (Field2)
  • place_start_time (Field3)
  • place_residence_time (Field4)
  • place_id (Field5)
  • line_ids (Field6)
  • zone_ids (Field7)
  • zone_residence_times (Field8)

NewPerson (Untitled2)

  • id (Key) — 기본 키 — NOT NULL
  • age (Field)
  • gender (Field2)
  • place_start_time (Field3)
  • place_residence_time (Field4)
  • place_id (Field5)
  • line_ids (Field6)
  • zone_ids (Field7)
  • zone_residence_times (Field8)

NewPlaceStay (Untitled3)

  • id (Key) — 기본 키 — NOT NULL
  • age (Field)
  • gender (Field2)
  • place_start_time (Field3)
  • place_residence_time (Field4) — 체류시간
  • place_id (Field5)

NewVisit (Untitled)

  • id (Key) — 기본 키 — NOT NULL — pk
  • age (Field) — 연령대
  • gender (Field2) — 성별
  • place_start_time (Field3) — 매장 방문 timestamp
  • place_id (Field12) — 매장

NewZoneEvent (CopyOfUntitled2)

  • id (Key) — 기본 키 — NOT NULL
  • zone_id (Field10)
  • zone_start_time (Field12)
  • zone_residence_time (Field11)
  • person_id (Field9)
  • age (Field)
  • gender (Field2)
  • place_start_time (Field3)
  • place_residence_time (Field4)
  • place_id (Field5)
  • line_ids (Field6)
  • zone_ids (Field7)
  • zone_residence_times (Field8)

NewZoneStay (CopyOfUntitled)

  • id (Key) — 기본 키 — NOT NULL — pk
  • age (Field) — 연령대
  • gender (Field2) — 성별
  • zone_start_time (Field3) — 방문 timestamp
  • zone_residence_time (Field4) — 체류 시간
  • zone_id (Field16) — 구역
  • place_id (Field12) — 매장