Data Seeding

In one line: Idempotent seed scripts provision production essentials in every environment and add realistic demo data in non-prod. prod gets essentials only, pprd is never seeded (it receives anonymised prod data), and dev/test get full demo fixtures.

Seed scripts provision production essentials in every environment and add realistic demo data in non-production environments for development, testing, and stakeholder demos. Seeds are idempotent — running twice produces the same result (upsert, not duplicate insert).

Seeding by Environment

prod
pprd
dev
test

Seeded: Branch, categories, services, settings, membership tiers, customer tags.Purpose: Production bootstrap — real data added by staff.

pprd is never seeded. It receives real (anonymized) data via nightly Neon branch reset from prod. See Git Workflow for the replication process.

Commands

# Seed everything for current environment (reads APP_ENV)
bun run scripts/seed.ts

# Seed specific modules
bun run scripts/seed.ts --only=services,staff,offers

# Reset and reseed (TRUNCATES all data first — dev/test only)
bun run scripts/seed.ts --reset

# Seed production essentials (safe — upserts only, no demo data)
bun run scripts/seed-prod.ts

Safety guard: --reset is blocked on prod — the script checks APP_ENV and exits with an error if you try.

Seed Execution Order

Dependencies matter — FK constraints require specific insertion order:

 branch
 system_setting
 service_category
 service
 spa_membership_tier
 customer_tag
 user (staff)
 user (customers)          ← dev/test only
 customer_tag_assignment
offer + offer_service
booking + booking_service
invoice + invoice_item
spa_membership
loyalty_account + loyalty_transaction
lead + lead_note
notification

Production Essentials

These are seeded in all environments including production.

Branch

The Rayasandra branch is the primary branch. A second branch (Marathahalli) is seeded with status: 'opens_soon' for future expansion.

Service Categories (10)

Category	Type
Haircut & Styling	salon
Hair Colouring / Treatment	salon
Facial & Skincare	salon
Waxing	salon
Manicure & Pedicure	salon
Makeup Services	salon
Hair SPA & Head Therapies	salon
Standard SPA Service	spa
Premium SPA Service	spa
VVIP SPA Service	spa

SPA Services (23)

Three tiers of SPA services, each available in 60-minute and 90-minute durations:

Standard SPA: Swedish Therapy, Thai Therapy, Aroma Therapy
Premium SPA: Lomi Lomi Spa, Balinese Therapy, Deep Tissue Therapy
VVIP SPA: Hot Stone Massage, Kerala Potli Massage, Synchronic Massage, Body Polish Massage, Body Scrub & Cleansing (4 variants)

Salon Services (~40)

Covering all 7 salon categories: haircuts, colouring/treatments, facials, waxing, manicure/pedicure, makeup, and hair spa.

Membership Tiers

Tier	Hours	Price	Validity
Silver	8 hours	₹10,000	90 days
Gold	15 hours	₹15,000	90 days
Platinum	Custom	Custom	90 days

System Settings

Key-value pairs stored in the system_setting table:

Name	Type	Default	Description
`gst_rate`	`percentage`	`18%`	GST rate (SAC code 999721)
`gems_earn_rate`	`percentage`	`1%`	Gems earned per spend (1 gem per ₹100)
`gems_expiry`	`days`	`365`	Days after which earned gems expire
`cancellation_window`	`hours`	`4`	Free-cancellation window before appointment
`reschedule_limit`	`count`	`2`	Maximum reschedules per booking
`noshow_approval_threshold`	`count`	`4`	No-shows in 90 days that trigger manager approval

Customer Tags

VIP, Frequent Visitor, Inactive 60d+, Bridal, No-Show Risk, SPA Member, Referred

Demo Data (Dev & Test Only)

Demo Staff (8 users — all roles covered)

Name	Role	Designation
Siddharth Fernandes	developer	—
Roshini Verma	owner	—
Kavitha Nair	manager	—
Divya Sharma	receptionist	—
Anjali Reddy	staff	stylist (Senior — Bridal, Keratin)
Priya Menon	staff	stylist
Meera Iyer	staff	therapist (Senior — Deep tissue, Hot stone)
Lakshmi Krishnan	staff	therapist

Demo Customers (15 in dev, 5 in test)

Realistic Indian women’s names — target demographic. All demo emails use @demo.test domain — never accidentally sent real emails. Acquisition source coverage is intentional: organic root, GMB deep-link, in-store QR, and converted Meta ad leads are all represented.

Demo Bookings — All Statuses Represented

Status	Count	Notes
`pending`	2	Awaiting receptionist confirmation
`confirmed`	2	Upcoming appointments
`completed`	3	Past bookings with invoices
`cancelled`	1	Customer-cancelled
`rejected`	1	Staff unavailable
`no_show`	1	Customer didn’t arrive
`completed` (membership)	1	₹0 membership session

Demo Memberships

Active Gold — 5 hours used, 10 hours remaining
Active Silver — almost expired (7 days left), 2 hours remaining
Expired Gold — 6 hours forfeited (for testing expiry UI)

Verify Seed

After seeding, run the verification script to check row counts and FK integrity:

bun run scripts/verify-seed.ts

This checks that all expected tables have the correct row counts and that no FK constraints are violated.

Getting started

System design

Standards

Application surface

Platform

Quality & security

Operations

Delivery workflow

Seeding by Environment

Commands

Seed Execution Order

Production Essentials

Branch

Service Categories (10)

SPA Services (23)

Salon Services (~40)

Membership Tiers

System Settings

Customer Tags

Demo Data (Dev & Test Only)

Demo Staff (8 users — all roles covered)

Demo Customers (15 in dev, 5 in test)

Demo Bookings — All Statuses Represented

Demo Memberships

Verify Seed

​Seeding by Environment

​Commands

​Seed Execution Order

​Production Essentials

​Branch

​Service Categories (10)

​SPA Services (23)

​Salon Services (~40)

​Membership Tiers

​System Settings

​Customer Tags

​Demo Data (Dev & Test Only)

​Demo Staff (8 users — all roles covered)

​Demo Customers (15 in dev, 5 in test)

​Demo Bookings — All Statuses Represented

​Demo Memberships

​Verify Seed

Seeding by Environment

Commands

Seed Execution Order

Production Essentials

Branch

Service Categories (10)

SPA Services (23)

Salon Services (~40)

Membership Tiers

System Settings

Customer Tags

Demo Data (Dev & Test Only)

Demo Staff (8 users — all roles covered)

Demo Customers (15 in dev, 5 in test)

Demo Bookings — All Statuses Represented

Demo Memberships

Verify Seed