-- 세션 테이블 CREATE TABLE trading_sessions ( id uuid DEFAULT gen_random_uuid() PRIMARY KEY, created_at timestamptz DEFAULT now(), status text DEFAULT 'active', total_pnl numeric DEFAULT 0, trade_count int DEFAULT 0, session_hour int DEFAULT 0 ); -- 거래 기록 테이블 CREATE TABLE trades ( id uuid DEFAULT gen_random_uuid() PRIMARY KEY, created_at timestamptz DEFAULT now(), session_id uuid REFERENCES trading_sessions(id), hour int NOT NULL, coin text NOT NULL, direction text NOT NULL, action text NOT NULL, entry_price numeric NOT NULL, current_price numeric NOT NULL, quantity numeric DEFAULT 1, leverage int DEFAULT 10, pnl numeric DEFAULT 0, pnl_pct numeric DEFAULT 0, strategy text, status text DEFAULT 'open' ); -- RLS 비활성화 (개인 사용) ALTER TABLE trading_sessions DISABLE ROW LEVEL SECURITY; ALTER TABLE trades DISABLE ROW LEVEL SECURITY;