SQL Editor'da tabloları kurun
Supabase panelinde SQL Editor'a gidin, aşağıdaki kodu yapıştırın ve çalıştırın:
CREATE TABLE cards (
id BIGSERIAL PRIMARY KEY,
p TEXT DEFAULT 'instagram',
type TEXT DEFAULT '',
title TEXT NOT NULL,
descr TEXT DEFAULT '',
hook TEXT DEFAULT '',
detail TEXT DEFAULT '',
tags TEXT DEFAULT '',
url TEXT DEFAULT '',
perf INT DEFAULT 4,
created_at TIMESTAMPTZ DEFAULT NOW()
);
CREATE TABLE clients (
id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
name TEXT NOT NULL,
username TEXT UNIQUE NOT NULL,
password TEXT NOT NULL,
contact TEXT DEFAULT '',
email TEXT DEFAULT '',
note TEXT DEFAULT '',
created_at TIMESTAMPTZ DEFAULT NOW()
);
CREATE TABLE assignments (
client_id UUID REFERENCES clients(id) ON DELETE CASCADE,
card_id BIGINT REFERENCES cards(id) ON DELETE CASCADE,
PRIMARY KEY (client_id, card_id)
);
CREATE TABLE feedback (
id UUID DEFAULT gen_random_uuid() PRIMARY KEY,
client_id UUID REFERENCES clients(id) ON DELETE CASCADE,
card_id BIGINT REFERENCES cards(id) ON DELETE CASCADE,
status TEXT DEFAULT 'pending',
comment TEXT DEFAULT '',
submitted_at TIMESTAMPTZ DEFAULT NOW(),
UNIQUE(client_id, card_id)
);