Admin Docs

🟢 System Health

System Overview

Jorrii Spark is a kid-first AI creativity platform for ages 6-12 with a Pixar-inspired bubbly design. Kids can create images, videos, music, sounds, and multi-step projects using safe, curated AI tools — all managed by a parent dashboard.

📊 Business Dashboard

Architecture

Tech Stack

Domain & Hosting

Pages & Status

Supabase Setup

Database Schema

kids table

CREATE TABLE kids (
  id          UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  parent_id   UUID NOT NULL REFERENCES auth.users(id) ON DELETE CASCADE,
  name        TEXT NOT NULL,
  pin         TEXT NOT NULL,
  avatar      INTEGER DEFAULT 1,
  created_at  TIMESTAMPTZ DEFAULT now()
);

-- RLS Policies
"Parents see own kids"    → SELECT WHERE parent_id = auth.uid()
"Parents add own kids"    → INSERT WITH CHECK parent_id = auth.uid()
"Parents update own kids" → UPDATE WHERE parent_id = auth.uid()
"Parents delete own kids" → DELETE WHERE parent_id = auth.uid()
"Anyone can verify PIN"   → SELECT WHERE true (for kid login)

subscriptions table

CREATE TABLE subscriptions (
  id          UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  parent_id   UUID NOT NULL REFERENCES auth.users(id) ON DELETE CASCADE,
  plan        TEXT NOT NULL DEFAULT 'spark',
  status      TEXT NOT NULL DEFAULT 'active',
  billing     TEXT DEFAULT 'monthly',
  stripe_id   TEXT,
  created_at  TIMESTAMPTZ DEFAULT now(),
  expires_at  TIMESTAMPTZ
);

-- Plans: spark (free), glow, blaze, supernova, infinite
-- Status: active, cancelled, trialing, expired

usage_tracking table

CREATE TABLE usage_tracking (
  id          UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  parent_id   UUID NOT NULL REFERENCES auth.users(id),
  type        TEXT NOT NULL,  -- image, video, voice, sfx, music
  date        DATE NOT NULL DEFAULT CURRENT_DATE,
  count       INTEGER DEFAULT 0,
  UNIQUE(parent_id, type, date)
);

-- Helper functions:
-- check_usage(p_parent_id, p_type) → {allowed, remaining, limit}
-- increment_usage(p_parent_id, p_type) → increments daily count

gallery_items table (MIGRATED to DynamoDB)

-- Supabase gallery_items is NO LONGER USED for storage.
-- Gallery data is now in DynamoDB: spark-gallery
-- DynamoDB Key: userId (HASH) + createdAt (RANGE)
-- GSI: isPublic-createdAt-index (for Showcase)
-- S3 Bucket: jorrii-spark-creations (public read)
-- S3 Temp: jorrii-spark-jobs-output (1-day TTL)
-- Lambda: jorrii-spark-api (auto-saves on generation)
-- API endpoints: /api/gallery, /api/gallery/share, /api/showcase

-- Supabase tables STILL ACTIVE:
-- subscriptions, kids, usage_tracking (check_usage/increment_usage)
-- generation_log (logging only)

generation_log table

CREATE TABLE generation_log (
  id          UUID DEFAULT gen_random_uuid() PRIMARY KEY,
  parent_id   UUID REFERENCES auth.users(id),
  kid_id      UUID REFERENCES kids(id),
  type        TEXT NOT NULL,
  model       TEXT,
  prompt      TEXT,
  status      TEXT DEFAULT 'completed',
  file_url    TEXT,
  created_at  TIMESTAMPTZ DEFAULT now()
);

plan_limits view

-- View that returns daily limits per plan per type
-- Used by check_usage() function
-- Plans: spark → glow → blaze → supernova → infinite
-- Types: image, video, voice, sfx, music

Authentication

Parent Auth (Supabase)

Kid Auth (PIN-based)

Kid sessions are stored in sessionStorage (not Supabase auth). This means kid sessions don't persist across tabs or browser restarts — this is intentional for safety.

Supabase URL Configuration

Google OAuth Config

API / Backend

Endpoints Used (Spark API — ymf072zyfd)

Design System

Colors

Typography

Shared CSS

All pages (except kid-pin.html and parent-login.html) import spark-styles.css which contains the top nav, sidebar, footer, and base styles. Always cache-bust with ?v=N.

Key Sizing

Icon Assets

All custom icons are in the images/ folder. Created in Photoshop at 792×792px (11×11 inches at 72ppi).

Sidebar Icons

Section Icons

Videos

Sidebar & Nav

Top Navigation

White background with glass blur, teal glow line on bottom. Contains: logo + tagline, nav links (Home, Safety/Parents, Pricing), Sign In button, Kid Pin button, hamburger for mobile.

Nav text: "Spark your creativity" (not "Jorrii Spark")

Left Sidebar

Blue-to-purple gradient (#4A8FE7 → #C27DEB) with teal glow line on right edge. Dark teal text (#0D3B4A). Contains tool links grouped into Create / Build / Learn / Library sections.

Sidebar Links

Present on: index.html, kid-dashboard.html, all create tool pages, book-maker.html, movie-maker.html, my-creations.html, showcase.html, spark-lab.html, spark-missions.html

Absent on: parent-login.html, kid-pin.html (immersive layouts)

Responsive Breakpoints

Auth Flows

Parent Google Sign-In

1. Parent clicks "Continue with Google" on parent-login.html
2. Redirects to Google consent screen
3. Google sends back to https://cwudeohugaraangftkfz.supabase.co/auth/v1/callback
4. Supabase exchanges code and redirects to https://jorrii.io/parent-login.html
5. Page detects session → redirects to parent-dashboard.html

Parent Email Sign-In

1. Parent clicks "Continue with Email"
2. Enters email + password
3. Calls sb.auth.signInWithPassword()
4. On success → redirect to dashboard

Kid PIN Login

1. Kid visits kid-pin.html
2. Taps 4-digit PIN on arcade numpad
3. Queries kids table: WHERE pin = ?
4. Match → confetti + welcome screen → sessionStorage → redirect to homepage
5. No match → shake animation + "try again"

Kid PIN System

Pricing Plans

30% yearly discount on all paid plans. Model access increases with tier (free = Nano Banana only, top tiers = all models).

Model Access by Tier

Usage Tracking

How It Works

• Each generation calls check_usage(parent_id, type) → returns {allowed, remaining, limit}
• If allowed = false, generation is blocked with friendly message
• On success, increment_usage(parent_id, type) bumps the daily count
• Counters reset at midnight UTC (via usage_tracking.date column)
• Limits defined in plan_limits view based on subscription plan
• Kid dashboard shows usage bars: color-coded by fill percentage
• Nav bar shows remaining counts for quick reference

AI Models

Image Generation

Video Generation

Audio Generation

🔊 Completion Sound Effects

👤 Character Builder

🧪 Spark Lab

⚡ Spark Studio

📚 Book Maker

User Flow

Wizard Steps

Backend: doGenerateStory()

Tier Gating

Key Files

🎞️ Movie Maker

User Flow

Clip Sources

Features

Technical Architecture

Tier Gating

Hosting

Deployment

How to Update

1. Delete old file from Hostinger
2. Upload new file
3. Hard refresh browser: Ctrl + Shift + R
4. If CSS not updating, bump the version: spark-styles.css?v=4

Troubleshooting

Common Issues

Changelog

TODO