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