BUG: SQL Syntax Error

[simrithi]

Is there an existing issue for this?

• I have searched the existing issues

What happened?

📌 Issue Overview

SQL schema has syntax errors preventing database setup

🔍 Steps to Reproduce

1. Go to Supabase Dashboard
2. Navigate to SQL Editor
3. Copy supabase/schemas/schema.sql file contents
4. Paste into Supabase SQL Editor
5. Click "Run"
6. See SQL syntax error

🎯 Expected Behavior

• All database tables should be created successfully
• No SQL errors should appear
• All 14 tables should be visible in Table Editor

🚨 Actual Behavior

• SQL syntax error appears
• Database tables are not created
• Error message: "syntax error at or near ')'"

📋 Error Details

The schema file contains 4 syntax errors (missing/extra commas):

1. therapist table (line ~23): Extra trailing comma before closing bracket
2. daily_activity_logs table (line ~142): Missing comma between activity_items and patient_id columns
3. observation_master table (line ~112): Extra trailing comma before closing bracket
4. activity_master table (line ~127): Extra trailing comma before closing bracket

📷 Error Message

Error: Failed to run sql query: ERROR: 42601: syntax error at or near ")" LINE 37: ); ^

📷 Screenshot

💡 Suggested Improvements

💡 Suggested Fix

Fix comma placement in the following tables:

therapist table:

• Remove comma after license_number TEXT, → license_number TEXT

daily_activity_logs table:

• Add comma after activity_items JSONB NOT NULL, (currently missing)

observation_master table:

• Remove comma after applicable_therapies UUID[] NOT NULL, → applicable_therapies UUID[] NOT NULL

activity_master table:

• Remove comma after applicable_therapies UUID[] NOT NULL, → applicable_therapies UUID[] NOT NULL

Record

• I agree to follow this project's Code of Conduct
• I want to work on this issue

[simrithi]

Hi @mdmohsin7

I'd like to work on this issue. I can fix the SQL syntax errors
in the schema.sql file and test them in Supabase.

Please assign me to this issue when you're ready.

Thanks!