AOSSIE-Org / AOSSIE-Org/NeuroTrack

BUG: SQL Syntax Error

オープン
#144 コメント 1 件 リアクション 0 件 担当者 0 名 GitHub で見る
主要言語
Dart
スター
29
フォーク
50
PR マージ指標
30日以内にマージされた PR はありません

説明

### Is there an existing issue for this?

- [x] 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

Image

## 💡 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

- [x] I agree to follow this project's Code of Conduct
- [x] I want to work on this issue

コントリビューションガイド

このリポジトリのコントリビューションガイドは索引されていません

評価

この issue はまだ評価されていません。

新しい issue をメールで受け取る

初心者向けの GitHub issue を短くまとめたダイジェスト。