viewLens

Tables (5)

issued_codes

  • code — TEXT — Primary key — NOT NULL
  • group_code — TEXT — NOT NULL
  • createdAt — TEXT

participants

  • id — INTEGER — Primary key — NOT NULL
  • anonymousId — TEXT — NOT NULL
  • group_code — TEXT — NOT NULL
  • installDate — TEXT — NOT NULL
  • createdAt — TEXT

popup_events

  • id — INTEGER — Primary key — NOT NULL
  • anonymousId — TEXT — Foreign key — NOT NULL
  • dwellMs — INTEGER
  • tabTodayClicks — INTEGER
  • tabWeekClicks — INTEGER
  • feedbackViewed — INTEGER
  • openedAt — TEXT
  • createdAt — TEXT

sessions

  • id — INTEGER — Primary key — NOT NULL
  • anonymousId — TEXT — Foreign key → participants.anonymousId — NOT NULL
  • sessionId — TEXT — NOT NULL
  • startTime — TEXT — NOT NULL
  • endTime — TEXT — NOT NULL
  • videoCount — INTEGER
  • categoryDistribution — TEXT
  • entropy — REAL
  • createdAt — TEXT

video_events

  • id — INTEGER — Primary key — NOT NULL
  • anonymousId — TEXT — Foreign key → participants.anonymousId — NOT NULL
  • videoId — TEXT — NOT NULL
  • title — TEXT
  • watchedAt — TEXT — NOT NULL
  • createdAt — TEXT