-- ✅ Supabase 테이블 구조 (SQL) -- 1. 회원 테이블 CREATE TABLE users ( id UUID DEFAULT uuid_generate_v4() PRIMARY KEY, email TEXT UNIQUE NOT NULL, name TEXT NOT NULL, role TEXT DEFAULT 'student', -- student/teacher/both/admin avatar_url TEXT, created_at TIMESTAMPTZ DEFAULT NOW() ); -- 2. 강의 테이블 CREATE TABLE courses ( id UUID DEFAULT uuid_generate_v4() PRIMARY KEY, teacher_id UUID REFERENCES users(id), title TEXT NOT NULL, category TEXT, -- SAT/AP/IB price INTEGER DEFAULT 0, is_free BOOLEAN DEFAULT true, status TEXT DEFAULT 'pending', -- pending/active/rejected is_public BOOLEAN DEFAULT true, created_at TIMESTAMPTZ DEFAULT NOW() ); -- 3. 수강신청 테이블 CREATE TABLE enrollments ( id UUID DEFAULT uuid_generate_v4() PRIMARY KEY, user_id UUID REFERENCES users(id), course_id UUID REFERENCES courses(id), paid_amount INTEGER DEFAULT 0, progress INTEGER DEFAULT 0, -- 0-100% created_at TIMESTAMPTZ DEFAULT NOW() ); -- 4. 자료 테이블 CREATE TABLE materials ( id UUID DEFAULT uuid_generate_v4() PRIMARY KEY, uploader_id UUID REFERENCES users(id), course_id UUID REFERENCES courses(id), title TEXT NOT NULL, file_url TEXT, file_type TEXT, -- pdf/video/image/ppt is_shared BOOLEAN DEFAULT true, download_count INTEGER DEFAULT 0, created_at TIMESTAMPTZ DEFAULT NOW() ); -- 5. 다이어리 테이블 CREATE TABLE diaries ( id UUID DEFAULT uuid_generate_v4() PRIMARY KEY, user_id UUID REFERENCES users(id), title TEXT NOT NULL, body TEXT, is_shared BOOLEAN DEFAULT true, created_at TIMESTAMPTZ DEFAULT NOW() ); -- 6. 일정(이벤트) 테이블 CREATE TABLE events ( id UUID DEFAULT uuid_generate_v4() PRIMARY KEY, user_id UUID REFERENCES users(id), title TEXT NOT NULL, event_date DATE NOT NULL, event_time TIME, color TEXT DEFAULT '#FF6B6B', is_shared BOOLEAN DEFAULT true, created_at TIMESTAMPTZ DEFAULT NOW() ); -- 7. 수익 정산 테이블 CREATE TABLE settlements ( id UUID DEFAULT uuid_generate_v4() PRIMARY KEY, teacher_id UUID REFERENCES users(id), gross_amount INTEGER, fee_rate DECIMAL DEFAULT 0.10, -- 10% 수수료 net_amount INTEGER, status TEXT DEFAULT 'pending', -- pending/completed settled_at TIMESTAMPTZ, created_at TIMESTAMPTZ DEFAULT NOW() );