Data model

"ACHIEVEMENT" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "achieved_on": DATE 
  "berries_with_cents": FLOAT 
  "bonuses": INTEGER 
  "bonuses_with_cents": FLOAT 
  "collected_on": DATE 
  "constraint_ref": TEXT 
  "definition_id": UUID 
  "player_id": UUID 
  "points": INTEGER 
  "tags": TEXT 
  "team_challenge_team_id": UUID 
}
"ACHIEVEMENT_DEFINITION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "category": TEXT 
  "code": TEXT 
  "declaration_limit": TEXT 
  "points": INTEGER 
}
"BENEFICIARY_LEAGUE_SKIN" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "emoji": VARCHAR 
  "name": VARCHAR 
  "policy_id": TEXT 
}
"DAILY_CHALLENGE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "code": TEXT 
  "day": DATE 
  "exercise_id": TEXT 
  "external_id": TEXT 
  "has_requested_rating": BOOLEAN 
  "level_when_achieved": INTEGER 
  "player_id": UUID 
  "streak": INTEGER 
}
"WALK_DUEL" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "accepted_at": DATETIME 
  "berries_amount": INTEGER 
  "canceled_at": DATETIME 
  "declined_at": DATETIME 
  "ended_at": DATETIME 
  "receiver_final_steps": INTEGER 
  "receiver_id": UUID 
  "sender_final_steps": INTEGER 
  "sender_id": UUID 
}
"ITEM" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "code": TEXT 
}
"TEAM_CHALLENGE_TEAM" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_id": TEXT 
  "captain_id": UUID 
  "color": TEXT 
  "company_id": TEXT 
  "customized_at": DATETIME 
  "name": TEXT 
  "visual": TEXT 
}
"PLAYER" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_id": TEXT 
  "app_id": VARCHAR(255) 
  "app_user_id": VARCHAR(255) 
  "avatar_character_id": TEXT 
  "badges_last_displayed_at": DATETIME 
  "company_id": TEXT 
  "disabled_external_activity_notifications_at": DATETIME 
  "enabled_beneficiary_league_at": DATETIME 
  "enabled_berries_notifications_at": DATETIME 
  "enabled_duels_at": DATETIME 
  "enabled_leaderboard_notifications_at": DATETIME 
  "enabled_marketing_notifications_at": DATETIME 
  "enabled_reactions_at": DATETIME 
  "enabled_reminders_at": DATETIME 
  "enabled_social_notifications_at": DATETIME 
  "has_given_consent_for_walking_leaderboard_at": DATETIME 
  "level": INTEGER 
  "onboarded_at": DATETIME 
  "reactions_last_fetched_at": DATETIME 
  "referral_code": TEXT 
  "team_challenge_asked_boost_at": DATETIME 
  "team_challenge_team_id": UUID 
  "team_challenge_team_joined_at": DATETIME 
  "token": TEXT 
  "user_state": TEXT 
  "walk_activation_dismissed_at": DATETIME 
  "walk_promotion_dismissed_at": DATETIME 
  "walk_start_date": DATE 
  "widget_tuto_displayed_at": DATETIME 
}
"PURCHASE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "player_id": UUID 
  "points": INTEGER 
  "purchased_at": DATETIME 
  "store_item_id": UUID 
  "tags": TEXT 
}
"REACTION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "emoji": TEXT 
  "note": TEXT 
  "receiver_id": UUID 
  "report_message": TEXT 
  "reported_at": DATETIME 
  "sender_id": UUID 
}
"STORE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
}
"STORE_ITEM" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "category": TEXT 
  "code": TEXT 
  "points": INTEGER 
}
"TEAM_CHALLENGE_BOOST" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "creator_id": UUID 
  "ends_at": DATETIME 
  "player_id": UUID 
}
"TEAM_CHALLENGE_INVITATION" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "invitee_id": UUID 
  "inviter_id": UUID 
  "team_id": UUID 
}
"TURING_GAMIFICATION_ACCOUNT_STATS" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_id": TEXT 
  "current_day_of_week": INTEGER 
  "customer_industry": TEXT 
  "display_customer_dashboard_stats": BOOLEAN 
  "enrollment_rate": FLOAT 
  "league_enrollment_rate": FLOAT 
  "n_active_users_d_0": INTEGER 
  "n_active_users_d_1": INTEGER 
  "n_active_users_d_2": INTEGER 
  "n_active_users_d_3": INTEGER 
  "n_active_users_d_4": INTEGER 
  "n_active_users_d_5": INTEGER 
  "n_active_users_d_6": INTEGER 
  "n_eligible_employees": INTEGER 
  "n_enrolled_employees": INTEGER 
  "n_steps": BIGINT 
  "n_steps_summer_2025": INTEGER 
  "n_total_berries_achieved": BIGINT 
  "qvct_daily_challenge_completed_count_friday": INTEGER 
  "qvct_daily_challenge_completed_count_monday": INTEGER 
  "qvct_daily_challenge_completed_count_thursday": INTEGER 
  "qvct_daily_challenge_completed_count_tuesday": INTEGER 
  "qvct_daily_challenge_completed_count_wednesday": INTEGER 
  "reference_enrollment_rate": FLOAT 
  "reference_n_days_to_reach_15_pct_enrollment_rate": INTEGER 
  "reference_weekly_active_users_rate": FLOAT 
  "share_of_berries_spent_on_charity": FLOAT 
  "share_of_industry_reaching_30_pct_enrollment_rate": FLOAT 
  "share_of_industry_reaching_50_pct_enrollment_rate": FLOAT 
  "top_enrollment_rate_percentage": FLOAT 
  "weekly_active_users_rate": FLOAT 
}
"VOUCHER" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "code": TEXT 
  "discount_code": TEXT 
  "expires_at": DATETIME 
  "player_id": UUID 
  "used_at": DATETIME 
}
"WALK_ACCOUNT_ELIGIBILITY" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_id": TEXT 
  "app_id": TEXT 
  "can_access_duel": BOOLEAN 
  "can_access_league": BOOLEAN 
  "company_id": TEXT 
  "display_name": TEXT 
  "promoted_health_program": TEXT 
  "qvct_week_theme": TEXT 
  "release_type": TEXT 
  "start_day": DATE 
  "team_challenge_charity_code": TEXT 
  "team_challenge_starts_on": DATE 
  "team_challenge_teams_size": INTEGER 
}
"WALK_FEEDBACK" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "comment": TEXT 
  "player_id": UUID 
}
"WALK_LEAGUE" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "account_id": TEXT 
  "company_id": TEXT 
  "emoji": VARCHAR 
  "name": VARCHAR 
}
"WALK_LEAGUE_PLAYERS" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "player_id": UUID 
  "status": VARCHAR(7) 
  "walk_league_id": UUID 
}
"WALKING_DAY_HISTORY" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "day": DATE 
  "frozen": BOOLEAN 
  "player_id": UUID 
  "steps": INTEGER 
}
"WALKING_WEEK_HISTORY" {
  shape: sql_table
  "id": UUID {constraint: primary_key}
  "leaderboard_steps": INTEGER 
  "player_id": UUID 
  "steps": INTEGER 
  "week": DATE 
}
"PLAYER"."id" -> "ACHIEVEMENT"."player_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"ACHIEVEMENT_DEFINITION"."id" -> "ACHIEVEMENT"."definition_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"PLAYER"."id" -> "DAILY_CHALLENGE"."player_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"PLAYER"."id" -> "WALK_DUEL"."sender_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"PLAYER"."id" -> "WALK_DUEL"."receiver_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"PLAYER"."id" -> "TEAM_CHALLENGE_TEAM"."captain_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-one-required
}
"TEAM_CHALLENGE_TEAM"."id" -> "PLAYER"."team_challenge_team_id": {
  source-arrowhead.shape: cf-one
  target-arrowhead.shape: cf-many
}
"STORE_ITEM"."id" -> "PURCHASE"."store_item_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"PLAYER"."id" -> "PURCHASE"."player_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"PLAYER"."id" -> "REACTION"."sender_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"PLAYER"."id" -> "REACTION"."receiver_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"PLAYER"."id" -> "TEAM_CHALLENGE_BOOST"."player_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"PLAYER"."id" -> "TEAM_CHALLENGE_BOOST"."creator_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"TEAM_CHALLENGE_TEAM"."id" -> "TEAM_CHALLENGE_INVITATION"."team_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"PLAYER"."id" -> "TEAM_CHALLENGE_INVITATION"."invitee_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"PLAYER"."id" -> "TEAM_CHALLENGE_INVITATION"."inviter_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"PLAYER"."id" -> "VOUCHER"."player_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"PLAYER"."id" -> "WALK_FEEDBACK"."player_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"PLAYER"."id" -> "WALK_LEAGUE_PLAYERS"."player_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"WALK_LEAGUE"."id" -> "WALK_LEAGUE_PLAYERS"."walk_league_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"PLAYER"."id" -> "WALKING_DAY_HISTORY"."player_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}
"PLAYER"."id" -> "WALKING_WEEK_HISTORY"."player_id": {
  source-arrowhead.shape: cf-one-required
  target-arrowhead.shape: cf-many
}

Hold "Alt" / "Option" to enable pan & zoom