Vetycos Client Record

A simple, mobile-friendly web app for Vetycos to keep pet client records (grooming & consultation visits) and track reminders for vaccination, deworming, tick & flea treatment, follow-ups, and next grooming due dates.

Because it's a real website backed by a hosted database, it works from any phone, tablet, or computer, and the data is permanent (stored in the cloud, not on one device).

How it's built

• Next.js (React) — the website itself
• Supabase — free hosted Postgres database + login system, where all pet/owner/ reminder data lives permanently
• Vercel — free hosting for the website, gives you a public URL that works on any device

Total cost to run: $0/month on the free tiers, unless the business grows a lot.

One-time setup (about 15 minutes)

1. Create a Supabase project (the database)

1. Go to https://supabase.com and sign up (free).

2. Click "New project". Pick any name (e.g. vetycos) and a strong database password (save it somewhere safe — you likely won't need it again, but keep it).

3. Once the project is ready, open SQL Editor in the left sidebar, click New query, paste the entire contents of supabase/schema.sql from this repo, and click Run. This creates the tables for owners, pets, visits, and reminders.

   If you already set up an earlier version of this app and have real data in it, run supabase/migrations/002_owners_and_codes.sql instead — it upgrades your existing tables in place without losing data.

4. Go to Authentication → Users and click Add user to create your own login (the email/password you'll use to sign in to the site). You can add more staff logins the same way later.

5. Go to Project Settings → API. You'll need two values for the next step:

   • Project URL
   • anon public key

2. Deploy the website to Vercel

1. Push this repository to GitHub if it isn't already (it already lives at vetycos/client-record).
2. Go to https://vercel.com, sign up (free), click Add New → Project, and import the vetycos/client-record GitHub repository.
3. When asked for environment variables, add:
   • NEXT_PUBLIC_SUPABASE_URL = the Project URL from Supabase
   • NEXT_PUBLIC_SUPABASE_ANON_KEY = the anon public key from Supabase
4. Click Deploy. After a minute you'll get a live URL like https://client-record.vercel.app — this works from any device, anywhere.

That's it. Bookmark the URL on your phone and computer, sign in with the login you created in step 1.4, and start adding pets.

Running it locally (optional, for development)

cp .env.local.example .env.local
# edit .env.local and fill in your Supabase URL + anon key
npm install
npm run dev

Then open http://localhost:3000.

What the app does

• Owners — each customer gets their own record with a short reference code (e.g. OWN-00001), name, mobile, WhatsApp, email, and address. One owner can have multiple pets.
• Pets — each pet gets its own reference code (e.g. PET-00001), linked to an owner, with species, breed, sex, DOB, colour, weight, microchip, allergies, and medical alerts.
• Visit & service history — log consultations, grooming, vaccinations, deworming, tick/flea treatment, surgery, follow-ups, home visits, or pick & drop, with staff, amount charged, purpose, findings, and treatment notes. A visit can create a follow-up reminder in the same step.
• Reminders — set due dates per pet for vaccination, deworming, tick/flea treatment, follow-up, or next grooming. Each reminder can be marked Contacted (owner reached out to) and then Complete.
• Dashboard ("Command Centre") — quick stats (owners, active pets, visits today, due today, overdue, due in the next 7 days) plus an "Attention Required" table of every reminder due soon, so nothing slips through.
• Search — the search box in the header finds an owner or pet by name, code, mobile, breed, or microchip number.

Data permanence & backups

Data lives in Supabase's managed Postgres database, which is durable and backed up by Supabase. Only signed-in users can read or write data (enforced by Postgres row-level security), so owner and pet records aren't publicly exposed.