매쉬보드
테이블 (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