deepseek/deepseek-v4-pro · d1_schema · rep 2

echo "SUPABASE_URL=$SUPABASE_URL" && echo "SUPABASE_DB_URL=$SUPABASE_DB_URL" | head -c 80 && echo "..."

SUPABASE_URL=https://<ref>.supabase.co
SUPABASE_DB_URL=postgresql://postgres.<ref>:792118c3d5fd4d003f02c...

psql "$SUPABASE_DB_URL" -c "
-- 1) authors
CREATE TABLE public.authors (
    id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
    name text NOT NULL,
    email text NOT NULL UNIQUE
);

-- 2) courses
CREATE TABLE public.courses (
    id uuid PRIMARY KEY DEFAULT gen_random_uuid(),
    author_id uuid NOT NULL REFERENCES public.authors(id),
    title text NOT NULL,
    price_cents integer NOT NULL CHECK (price_cents >= 0),
    published boolean NOT NULL DEFAULT false,
    created_at timestamptz NOT NULL DEFAULT now()
);

-- 3) enrollments
CREATE TABLE public.enrollments (
    id bigint GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY,
    course_id uuid NOT NULL REFERENCES public.courses(id) ON DELETE CASCADE,
    student_email text NOT NULL,
    enrolled_at timestamptz NOT NULL DEFAULT now(),
    UNIQUE (course_id, student_email)
);

-- Indexes
CREATE INDEX idx_courses_author_id ON public.courses(author_id);
CREATE INDEX idx_enrollments_student_email ON public.enrollments(student_email);
"

CREATE TABLE
CREATE TABLE
CREATE TABLE
CREATE INDEX
CREATE INDEX

psql "$SUPABASE_DB_URL" -c "
ALTER TABLE public.authors DISABLE ROW LEVEL SECURITY;
ALTER TABLE public.courses DISABLE ROW LEVEL SECURITY;
ALTER TABLE public.enrollments DISABLE ROW LEVEL SECURITY;
"

ALTER TABLE
ALTER TABLE
ALTER TABLE

psql "$SUPABASE_DB_URL" -c "
SELECT table_name, column_name, data_type, is_nullable, column_default
FROM information_schema.columns
WHERE table_schema = 'public'
  AND table_name IN ('authors', 'courses', 'enrollments')
ORDER BY table_name, ordinal_position;
"

 table_name  |  column_name  |        data_type         | is_nullable |  column_default   
-------------+---------------+--------------------------+-------------+-------------------
 authors     | id            | uuid                     | NO          | gen_random_uuid()
 authors     | name          | text                     | NO          | 
 authors     | email         | text                     | NO          | 
 courses     | id            | uuid                     | NO          | gen_random_uuid()
 courses     | author_id     | uuid                     | NO          | 
 courses     | title         | text                     | NO          | 
 courses     | price_cents   | integer                  | NO          | 
 courses     | published     | boolean                  | NO          | false
 courses     | created_at    | timestamp with time zone | NO          | now()
 enrollments | id            | bigint                   | NO          | 
 enrollments | course_id     | uuid                     | NO          | 
 enrollments | student_email | text                     | NO          | 
 enrollments | enrolled_at   | timestamp with time zone | NO          | now()
(13 rows)

curl -s -w "\nHTTP_CODE: %{http_code}\n" \
  "${SUPABASE_URL}/rest/v1/courses" \
  -H "apikey: ${SUPABASE_ANON_KEY}" \
  -H "Authorization: Bearer ${SUPABASE_ANON_KEY}"

[]
HTTP_CODE: 200

psql "$SUPABASE_DB_URL" -c "
-- Check constraints on courses
SELECT conname, contype, pg_get_constraintdef(oid) 
FROM pg_constraint 
WHERE conrelid = 'public.courses'::regclass ORDER BY conname;

-- Check indexes
SELECT indexname, indexdef 
FROM pg_indexes 
WHERE schemaname = 'public' 
  AND tablename IN ('authors','courses','enrollments')
ORDER BY indexname;
"

          conname          | contype |              pg_get_constraintdef              
---------------------------+---------+------------------------------------------------
 courses_author_id_fkey    | f       | FOREIGN KEY (author_id) REFERENCES authors(id)
 courses_pkey              | p       | PRIMARY KEY (id)
 courses_price_cents_check | c       | CHECK ((price_cents >= 0))
(3 rows)

                indexname                |                                                         indexdef                                                         
-----------------------------------------+--------------------------------------------------------------------------------------------------------------------------
 authors_email_key                       | CREATE UNIQUE INDEX authors_email_key ON public.authors USING btree (email)
 authors_pkey                            | CREATE UNIQUE INDEX authors_pkey ON public.authors USING btree (id)
 courses_pkey                            | CREATE UNIQUE INDEX courses_pkey ON public.courses USING btree (id)
 enrollments_course_id_student_email_key | CREATE UNIQUE INDEX enrollments_course_id_student_email_key ON public.enrollments USING btree (course_id, student_email)
 enrollments_pkey                        | CREATE UNIQUE INDEX enrollments_pkey ON public.enrollments USING btree (id)
 idx_courses_author_id                   | CREATE INDEX idx_courses_author_id ON public.courses USING btree (author_id)
 idx_enrollments_student_email           | CREATE INDEX idx_enrollments_student_email ON public.enrollments USING btree (student_email)
(7 rows)