매쉬보드

테이블 (34)

CameraOrientation (CopyOfUntitled14)

  • uid (Key) — 기본 키 — NOT NULL
  • location (Field)
  • id (Field2)
  • valid_from (Field3)
  • valid_until (Field4)
  • camera (Field5)
  • created_at (Field6)
  • updated_at (Field7)

CameraOrientation (Untitled14)

  • uid (Key) — 기본 키 — NOT NULL
  • location (Field)
  • id (Field2)
  • valid_from (Field3)
  • valid_until (Field4)
  • camera (Field5)
  • created_at (Field6)
  • updated_at (Field7)

CameraOrientationSnapshot (Untitled15)

  • uid (Key) — 기본 키 — NOT NULL
  • camera_orientation (Key2) — 외래 키 → CameraOrientation.uid — NOT NULL
  • path (Field) — S3 주소
  • timestamp (Field2)
  • created_at (Field3) — auto_now_add
  • updated_at (Field4) — auto_now

CountingLine (CopyOfUntitled16)

  • uid (Key) — 기본 키 — NOT NULL
  • daram_param (Field)
  • segments (Field2) — line 정보
  • key (Field3)
  • valid_from (Field4)
  • valid_until (Field5)
  • created_at (Field6) — auto_now_add
  • updated_at (Field7) — auto_now
  • is_cropped (Field8)
  • extra_daram_param (Field9)
  • camera_orientation (Key2) — 외래 키 → CameraOrientation.uid — NOT NULL

CountingLine (Untitled16)

  • uid (Key) — 기본 키 — NOT NULL
  • camera_orientation (Key2) — 외래 키 → CameraOrientation.uid — NOT NULL
  • daram_param (Field)
  • segments (Field2) — line 정보
  • key (Field3)
  • valid_from (Field4)
  • valid_until (Field5)
  • created_at (Field6) — auto_now_add
  • updated_at (Field7) — auto_now
  • is_cropped (Field8)
  • extra_daram_param (Field9)

CountingLineEventType (CopyOfUntitled18)

  • uid (Key) — 기본 키 — NOT NULL
  • craeted_at (Field)
  • updated_at (Field2)
  • type (Field3) — 입장, 퇴장, 일반라인 여부
  • counting_line (Key2) — 외래 키 → CountingLine.uid — NOT NULL

CountingLineEventType (Untitled18)

  • uid (Key) — 기본 키 — NOT NULL
  • craeted_at (Field)
  • updated_at (Field2)
  • type (Field3) — 입장, 퇴장, 일반라인 여부
  • counting_line (Key2) — 외래 키 → CountingLine.uid — NOT NULL

IntervalZone (Untitled13)

  • uid (Key) — 기본 키 — NOT NULL
  • camera_orientation (Key2) — 외래 키 → CameraOrientation.uid — NOT NULL
  • daram_param (Field) — polygon정보
  • key (Field2)
  • valid_from (Field3)
  • valid_until (Field4)
  • created_at (Field5) — auto_now_add
  • updated_at (Field6) — auto_now

Line (Untitled6)

  • uid (Key) — 기본 키 — NOT NULL
  • name (Field5)
  • tag (Field4)
  • line_category (Field) — 일반라인(0), 입장(1), 퇴장(2)
  • no_direction_line (Key3) — 외래 키 → NoDirectionLine.uid — NOT NULL
  • timestamp (Field2) — auto_now_add
  • last_update (Field3) — auto_now

Line (CopyOfUntitled6)

  • uid (Key) — 기본 키 — NOT NULL
  • timestamp (Field2) — auto_now_add
  • last_update (Field3) — auto_now
  • tag (Field4)
  • name (Field5)
  • line_category (Field) — 일반라인(0), 입장(1), 퇴장(2)
  • place (Key2) — 외래 키 → Place.uid — NOT NULL

LineDataMap (CopyOfUntitled17)

  • uid (Key) — 기본 키 — NOT NULL
  • timestamp (Field) — auto_now_add
  • valid_from (Field2)
  • valid_to (Field3) — null=True, blank=True
  • last_update (Field4) — auto_now
  • line (Key2) — 외래 키 → Line.uid — NOT NULL

LineDataMap (Untitled17)

  • uid (Key) — 기본 키 — NOT NULL
  • line (Key2) — 외래 키 → Line.uid — NOT NULL
  • timestamp (Field) — auto_now_add
  • valid_from (Field2)
  • valid_to (Field3) — null=True, blank=True
  • last_update (Field4) — auto_now

LineDataMapEventTypes (Untitled19)

  • id (Key) — 기본 키 — NOT NULL
  • line_data_map (Key2) — 외래 키 → LineDataMap.uid — NOT NULL
  • counting_line_event_type (Key3) — 외래 키 → CountingLineEventType.uid — NOT NULL

LineDataMapEventTypes (CopyOfUntitled19)

  • id (Key) — 기본 키 — NOT NULL
  • line_data_map (Key2) — 외래 키 → LineDataMap.uid — NOT NULL
  • counting_line_event_type (Key3) — 외래 키 → CountingLineEventType.uid — NOT NULL

LineEvent (Untitled4)

  • id (int auto increase) — 기본 키 — NOT NULL
  • start_time (통과시간)
  • person (Foreignkey) — 외래 키 → Person(특정날짜에 unique한 한 사람).id — NOT NULL
  • line (Key) — 외래 키 → Line.uid — NOT NULL

LineEvent (CopyOfUntitled4)

  • id (int auto increase) — 기본 키 — NOT NULL
  • start_time (통과시간)
  • line (Key) — 외래 키 → Line.uid — NOT NULL
  • pid (Field) — index
  • age (Field2)
  • gender (Field3)

LineLineEvent (Untitled22)

    NoDirectionLine (Untitled26)

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

    PathBaseNode (Untitled5)

    • id (auto increase) — 기본 키 — NOT NULL
    • age (나이대)
    • gender (성별)
    • count (사람수)
    • start_time (Field6)
    • previous_node (self Foreignkey) — 외래 키 → PathBaseNode.id — NOT NULL

    PathLineNode (Untitled8)

    • pathbasenode (OneToOne) — 외래 키 → PathBaseNode.id — NOT NULL
    • line (Key) — 외래 키 → Line.uid — NOT NULL

    PathZoneNode (Untitled7)

    • pathbasenode (OneToOne) — 외래 키 → PathBaseNode.id — NOT NULL
    • zone (Key) — 외래 키 → Zone.uid — NOT NULL
    • residence_sum (Field)

    Person(특정날짜에 unique한 한 사람) (Untitled2)

    • id (int auto increase) — 기본 키 — NOT NULL
    • age (성별)
    • gender (연령대)

    Place (CopyOfUntitled10)

    • uid (Key) — 기본 키 — NOT NULL
    • timestamp (Field) — auto_now_add
    • last_update (Field2) — auto_now
    • tag (Field3) — unique=True
    • name (Field4)
    • open_time (Field5)
    • close_time (Field6)
    • use_traffic (Field7)
    • use_visit (Field8)
    • use_purchase (Field9)
    • use_stay (Field10)
    • collection_start (Field11)
    • collection_end (Field12) — null=True, blank=True
    • longitude (Field13)
    • latitude (Field14)
    • address (Field15)
    • client (Field16)
    • use_flow (Field17)
    • use_staff_filter (Field18)

    Place (Untitled10)

    • uid (Key) — 기본 키 — NOT NULL
    • timestamp (Field) — auto_now_add
    • last_update (Field2) — auto_now
    • tag (Field3) — unique=True
    • name (Field4)
    • open_time (Field5)
    • close_time (Field6)
    • use_traffic (Field7)
    • use_visit (Field8)
    • use_purchase (Field9)
    • use_stay (Field10)
    • collection_start (Field11)
    • collection_end (Field12) — null=True, blank=True
    • longitude (Field13)
    • latitude (Field14)
    • address (Field15)
    • client (Field16)
    • use_flow (Field17)
    • use_staff_filter (Field18)

    PlaceEvent (Untitled)

    • id (int auto increase) — 기본 키 — NOT NULL
    • start_time (매장 입장 시간) — ENTER정보
    • residence_time (매장 체류 시간)
    • person (OnetoOne) — 외래 키 → Person(특정날짜에 unique한 한 사람).id — NOT NULL
    • place (Key) — 외래 키 → Place.uid — NOT NULL

    PlaceEvent (CopyOfUntitled)

    • id (int auto increase) — 기본 키 — NOT NULL
    • start_time (매장 입장 시간) — ENTER정보
    • residence_time (매장 체류 시간)
    • place (Key) — 외래 키 → Place.uid — NOT NULL
    • pid (Field) — index
    • age (Field2)
    • gender (Field3)

    TargetDataMap (Untitled11)

    • uid (Key) — 기본 키 — NOT NULL
    • zone (Key2) — 외래 키 → Zone.uid — NOT NULL
    • timestamp (Field2) — auto_now_add
    • valid_from (Field)
    • valid_to (Field3) — null=True, blank=True
    • last_update (Field4) — auto_now
    • threshold (Field5)

    TargetDataMapIntervalTypes (Untitled12)

    • id (Key) — 기본 키 — NOT NULL
    • targetdatamap (Key3) — 외래 키 → TargetDataMap.uid — NOT NULL
    • intervalzone (Key2) — 외래 키 → IntervalZone.uid — NOT NULL

    Zone (CopyOfUntitled9)

    • uid (Key) — 기본 키 — NOT NULL
    • timestamp (Field) — auto_now_add
    • last_update (Field3) — auto_now
    • tag (Field4)
    • name (Field5)
    • use_exposure (Field6)
    • use_target (Field7)
    • use_stay (Field8)
    • thumbnail (Field9)
    • zone_category (Field2) — 일반존(0),구매존(1)
    • place (Key2) — 외래 키 → Place.uid — NOT NULL

    Zone (Untitled9)

    • uid (Key) — 기본 키 — NOT NULL
    • place (Key2) — 외래 키 → Place.uid — NOT NULL
    • timestamp (Field) — auto_now_add
    • last_update (Field3) — auto_now
    • tag (Field4)
    • name (Field5)
    • use_exposure (Field6)
    • use_target (Field7)
    • use_stay (Field8)
    • thumbnail (Field9)
    • zone_category (Field2) — 일반존(0),구매존(1)

    ZoneEvent (CopyOfUntitled3)

    • id (int auto increase) — 기본 키 — NOT NULL
    • start_time (구역 입장 시간)
    • residence_time (구역 체류 시간)
    • zone (Key) — 외래 키 → Zone.uid — NOT NULL
    • pid (Field) — index
    • age (Field2)
    • gender (Field3)

    ZoneEvent (Untitled3)

    • id (int auto increase) — 기본 키 — NOT NULL
    • start_time (구역 입장 시간)
    • residence_time (구역 체류 시간)
    • person (Foreignkey) — 외래 키 → Person(특정날짜에 unique한 한 사람).id — NOT NULL
    • zone (Key) — 외래 키 → Zone.uid — NOT NULL

    ZoneLineEvent (Untitled21)

      ZoneZoneEvent (Untitled20)

      • id (Key) — 기본 키 — NOT NULL
      • Field