final메타정보

테이블 (39)

AccountUser (Untitled27)

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

AccountUserGroups (Untitled30)

  • id (Key) — 기본 키 — NOT NULL
  • user_id (Key2) — 외래 키 → AccountUser.uid — NOT NULL
  • group_id (Key3) — 외래 키 → AuthGroup.id — NOT NULL

AuthGroup (Untitled28)

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

Board (Untitled11)

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

BoardGroups (Untitled29)

  • id (Key) — 기본 키 — NOT NULL
  • board_id (Key2) — 외래 키 → Board.uid — NOT NULL
  • group_id (Key3) — 외래 키 → AuthGroup.id — 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)

DashBoard (Untitled34)

  • uid (Key) — 기본 키 — NOT NULL
  • board_id (Key2) — 외래 키 → Board.uid — NOT NULL
  • owner_id (Key3) — 외래 키 → AccountUser.uid — NOT NULL

DwellTimeAnalysisUnit (Untitled14)

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

EventSourceGroup (Untitled36)

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

EventSourceGroupDwellTimeAnalysisUnits (Untitled39)

  • id (Key) — 기본 키 — NOT NULL
  • eventsourcegroup_id (Key2) — 외래 키 → EventSourceGroup.uid — NOT NULL
  • dwelltimeanalysisunit_id (Key3) — 외래 키 → DwellTimeAnalysisUnit.uid — NOT NULL

EventSourceGroupLines (Untitled38)

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

EventSourceGroupZones (Untitled37)

  • id (Key) — 기본 키 — NOT NULL
  • eventsourcegroup_id (Key2) — 외래 키 → EventSourceGroup.uid — NOT NULL
  • zone_id (Key3) — 외래 키 → Zone.uid — NOT NULL

ExitDataMap (Untitled32)

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

ExitDataMapEventTypes (Untitled33)

  • id (Key) — 기본 키 — NOT NULL
  • exitdatamap_id (Key2) — 외래 키 → ExitDataMap.uid — NOT NULL
  • countinglineeventtype_id (Key3) — 외래 키 → CountingLineEventType.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

PurchaseDataMap (Untitled25)

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

PurchaseDataMapIntervalTypes (Untitled26)

  • id (Key) — 기본 키 — NOT NULL
  • purchasedatamap_id (Key2) — 외래 키 → PurchaseDataMap.uid — NOT NULL
  • intervalzone_id (Key3) — 외래 키 → IntervalZone.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

TrafficDataMap (Untitled23)

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

TrafficDataMapEventTyes (Untitled24)

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

UserAdditionalInfo (Untitled31)

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

VisitDataMap (Untitled21)

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

VisitDataMapEventTypes (Untitled22)

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

Widget (Untitled35)

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

Zone (Untitled)

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