f64251e459
ST-2.1: Unify timeframe enum - Created ddl/00-global-types.sql with public.trading_timeframe - Marked trading.timeframe and market_data.timeframe as DEPRECATED ST-2.2: Resolve transaction_type conflict - Documented rename plan: financial.wallet_transaction_type - Documented rename plan: investment.investment_transaction_type - Added deprecation comments to both enums ST-2.3: Unify common functions - Created ddl/00-global-functions.sql with public.update_updated_at() - Marked schema-specific functions as DEPRECATED: - auth.update_updated_at() - education.update_updated_at_column() - financial.update_timestamp() - feature_flags.update_timestamp() Migrations created (not executed): - 2026-02-03_unify_timeframe_enum.sql - 2026-02-03_rename_transaction_type_enums.sql - 2026-02-03_unify_common_functions.sql Co-Authored-By: Claude Opus 4.5 <noreply@anthropic.com>
38 lines
1.4 KiB
SQL
38 lines
1.4 KiB
SQL
-- ============================================================================
|
|
-- Schema: market_data
|
|
-- File: 00-enums.sql
|
|
-- Description: ENUMs para datos de mercado OHLCV
|
|
-- ============================================================================
|
|
|
|
-- Tipo de activo
|
|
CREATE TYPE market_data.asset_type AS ENUM (
|
|
'forex', -- Pares de divisas (EURUSD, GBPUSD, etc.)
|
|
'crypto', -- Criptomonedas (BTCUSD, ETHUSD, etc.)
|
|
'commodity', -- Commodities (XAUUSD, XAGUSD, etc.)
|
|
'index', -- Índices (SPX500, NAS100, etc.)
|
|
'stock' -- Acciones
|
|
);
|
|
|
|
-- ============================================================================
|
|
-- DEPRECATED: Use public.trading_timeframe instead
|
|
-- This enum is maintained for backwards compatibility only.
|
|
-- Migration: migrations/2026-02-03_unify_timeframe_enum.sql
|
|
-- Task: ST-2.1 - Unificar enum timeframe en schema publico
|
|
-- Note: This version is missing '1M' (1 month) - use unified type for full support
|
|
-- Date: 2026-02-03
|
|
-- ============================================================================
|
|
-- Temporalidad
|
|
CREATE TYPE market_data.timeframe AS ENUM (
|
|
'1m',
|
|
'5m',
|
|
'15m',
|
|
'30m',
|
|
'1h',
|
|
'4h',
|
|
'1d',
|
|
'1w'
|
|
);
|
|
|
|
COMMENT ON TYPE market_data.asset_type IS 'Clasificación de tipo de activo financiero';
|
|
COMMENT ON TYPE market_data.timeframe IS 'Temporalidades soportadas para datos OHLCV';
|