메타정보 관계도

테이블 (20)

Board (Untitled11)

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

Branch (Untitled9)

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

Camera (Untitled13)

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

CameraOrientation (Untitled6)

  • uid (Key) — 기본 키 — NOT NULL
  • location (Key2) — 외래 키 → Location.uid — NOT NULL
  • camera (Key3) — 외래 키 → Camera.uid — NOT NULL
  • id (Field)

CameraOrientationSnapshot (Untitled7)

  • uid (Key) — 기본 키 — NOT NULL
  • camera_orientation (Key2) — 외래 키 → CameraOrientation.uid — NOT NULL
  • path (Field)
  • updated_at (Field2)

Client (Untitled10)

  • uid (Key) — 기본 키 — NOT NULL

CountingLine (Untitled17)

  • uid (Key) — 기본 키 — NOT NULL
  • camera_orientation (Key2) — 외래 키 → CameraOrientation.uid — NOT NULL
  • key (Field)

CountingLineEventType (Untitled18)

  • uid (Key) — 기본 키 — NOT NULL
  • counting_line (Key2) — 외래 키 → CountingLine.uid — NOT NULL
  • type (Field)

DwellTimeAnalysisUnit (Untitled14)

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

IntervalZone (Untitled5)

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

Line (Untitled16)

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

LineDataMap (Untitled19)

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

LineDataMapEventTypes (Untitled20)

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

Location (Untitled8)

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

NoDirectionLine (Untitled15)

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

Place (Untitled2)

  • uid (Key) — 기본 키 — NOT NULL

PlaceBoards (Untitled12)

  • id (Key) — 기본 키 — NOT NULL
  • board_id (Key2) — 외래 키 → Board.uid — NOT NULL
  • place_id (Key3) — 외래 키 → Place.uid — NOT NULL

TargetDataMap (Untitled3)

  • uid (Key) — 기본 키 — NOT NULL
  • zone_id (Key2) — 외래 키 → Zone.uid — NOT NULL
  • valid_from (Field)
  • valid_to (Field2)

TargetDataMapIntervalTypes (Untitled4)

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

Zone (Untitled)

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