How to Add a Digital Business Card Generator to Your App — Copy-Paste Prompts

1create table public.cards (
2  id uuid primary key default gen_random_uuid(),
3  user_id uuid references auth.users(id) on delete cascade not null,
4  slug text unique not null default gen_random_uuid()::text,
5  display_name text not null,
6  job_title text,
7  company text,
8  email text,
9  phone text,
10  website text,
11  linkedin_url text,
12  twitter_url text,
13  instagram_url text,
14  bio text,
15  avatar_url text,
16  theme_color text not null default '#1a1a2e',
17  template_id text not null default 'classic',
18  is_active bool not null default true,
19  view_count int not null default 0,
20  created_at timestamptz not null default now(),
21  updated_at timestamptz not null default now()
22);
23
24create table public.card_views (
25  id uuid primary key default gen_random_uuid(),
26  card_id uuid references public.cards(id) on delete cascade not null,
27  viewer_ip text,
28  referrer text,
29  viewed_at timestamptz not null default now()
30);
31
32alter table public.cards enable row level security;
33alter table public.card_views enable row level security;
34
35-- Anyone can view active cards (public card URL)
36create policy "Active cards are publicly readable"
37  on public.cards for select
38  using (is_active = true);
39
40-- Only card owner can read all their cards (including inactive)
41create policy "Owner can read all own cards"
42  on public.cards for select
43  using (auth.uid() = user_id);
44
45-- Only authenticated users can create cards
46create policy "Authenticated users can create cards"
47  on public.cards for insert
48  with check (auth.uid() = user_id);
49
50-- Only card owner can update or delete
51create policy "Owner can update own cards"
52  on public.cards for update
53  using (auth.uid() = user_id);
54
55create policy "Owner can delete own cards"
56  on public.cards for delete
57  using (auth.uid() = user_id);
58
59-- Card views: insert is public (no auth to track views); only owner can read their card's views
60create policy "Anyone can record a card view"
61  on public.card_views for insert
62  with check (true);
63
64create policy "Card owner can read their card views"
65  on public.card_views for select
66  using (
67    auth.uid() = (select user_id from public.cards where id = card_id)
68  );
69
70-- RPC to increment view count atomically
71create or replace function public.increment_card_view(card_id uuid)
72returns void language plpgsql security definer as $$
73begin
74  update public.cards set view_count = view_count + 1 where id = card_id;
75end;
76$$;
77
78-- Trigger to update updated_at on card edit
79create or replace function public.set_updated_at()
80returns trigger language plpgsql as $$
81begin
82  new.updated_at = now();
83  return new;
84end;
85$$;
86
87create trigger cards_set_updated_at
88  before update on public.cards
89  for each row execute function public.set_updated_at();
90
91-- Storage bucket for card avatars
92-- Run this separately in Supabase Dashboard → Storage → New bucket
93-- Bucket name: card-avatars | Public: true
94
95-- Index for fast owner card lookups
96create index cards_user_id_idx on public.cards (user_id);
97create index card_views_card_id_idx on public.card_views (card_id, viewed_at desc);