# Navegacion Rapida de Base de Datos - MiChangarrito
# Proyecto: michangarrito
# Fecha: 2026-01-16

version: "1.0.0"
proyecto: "michangarrito"

# ============================================================================
# SCHEMAS
# ============================================================================
schemas:
  public:
    descripcion: "Schema principal - Usuarios y configuracion base"
    tablas_count: 4
    tablas_principales: ["users", "roles", "permissions", "user_roles"]

  stores:
    descripcion: "Gestion de tiendas/changarritos"
    tablas_count: 3
    tablas_principales: ["stores", "store_settings", "store_hours"]

  products:
    descripcion: "Catalogo de productos e inventario"
    tablas_count: 4
    tablas_principales: ["products", "categories", "inventory", "price_history"]

  sales:
    descripcion: "Punto de venta y transacciones"
    tablas_count: 4
    tablas_principales: ["sales", "sale_items", "payments", "cash_registers"]

  orders:
    descripcion: "Pedidos y entregas"
    tablas_count: 3
    tablas_principales: ["orders", "order_items", "deliveries"]

  customers:
    descripcion: "Gestion de clientes"
    tablas_count: 2
    tablas_principales: ["customers", "customer_addresses"]

  fiados:
    descripcion: "Sistema de creditos/fiados"
    tablas_count: 3
    tablas_principales: ["fiados", "fiado_payments", "credit_limits"]

  subscriptions:
    descripcion: "Planes y suscripciones SaaS"
    tablas_count: 3
    tablas_principales: ["plans", "subscriptions", "subscription_history"]

  tokens:
    descripcion: "Tienda de tokens IA"
    tablas_count: 3
    tablas_principales: ["token_packages", "token_purchases", "token_usage"]

  notifications:
    descripcion: "Sistema de notificaciones"
    tablas_count: 3
    tablas_principales: ["notifications", "notification_templates", "notification_logs"]

  integrations:
    descripcion: "Integraciones externas"
    tablas_count: 3
    tablas_principales: ["whatsapp_configs", "llm_configs", "payment_configs"]

  analytics:
    descripcion: "Metricas y reportes"
    tablas_count: 3
    tablas_principales: ["daily_metrics", "monthly_reports", "predictions"]

# ============================================================================
# TABLAS PRINCIPALES (Top 10)
# ============================================================================
tablas_principales:
  - nombre: "users"
    schema: "public"
    descripcion: "Usuarios del sistema (duenos de changarritos)"
    entity: "User.entity.ts"
    relaciones: ["stores", "subscriptions", "sessions"]

  - nombre: "stores"
    schema: "stores"
    descripcion: "Changarritos/tiendas"
    entity: "Store.entity.ts"
    relaciones: ["users", "products", "sales", "customers"]

  - nombre: "products"
    schema: "products"
    descripcion: "Catalogo de productos"
    entity: "Product.entity.ts"
    relaciones: ["stores", "categories", "sale_items", "order_items"]

  - nombre: "sales"
    schema: "sales"
    descripcion: "Ventas realizadas en POS"
    entity: "Sale.entity.ts"
    relaciones: ["stores", "sale_items", "payments", "customers"]

  - nombre: "customers"
    schema: "customers"
    descripcion: "Clientes del changarrito"
    entity: "Customer.entity.ts"
    relaciones: ["stores", "sales", "orders", "fiados"]

  - nombre: "fiados"
    schema: "fiados"
    descripcion: "Creditos otorgados a clientes"
    entity: "Fiado.entity.ts"
    relaciones: ["customers", "stores", "fiado_payments"]

  - nombre: "orders"
    schema: "orders"
    descripcion: "Pedidos (WhatsApp/Web)"
    entity: "Order.entity.ts"
    relaciones: ["stores", "customers", "order_items", "deliveries"]

  - nombre: "subscriptions"
    schema: "subscriptions"
    descripcion: "Suscripciones de usuarios a planes"
    entity: "Subscription.entity.ts"
    relaciones: ["users", "plans"]

  - nombre: "plans"
    schema: "subscriptions"
    descripcion: "Planes de suscripcion disponibles"
    entity: "Plan.entity.ts"
    relaciones: ["subscriptions"]

  - nombre: "token_usage"
    schema: "tokens"
    descripcion: "Uso de tokens de IA"
    entity: "TokenUsage.entity.ts"
    relaciones: ["users", "stores"]

# ============================================================================
# BUSQUEDA RAPIDA
# ============================================================================
busqueda:
  por_modulo:
    auth: ["users", "sessions", "refresh_tokens"]
    stores: ["stores", "store_settings", "store_hours"]
    products: ["products", "categories", "inventory"]
    sales: ["sales", "sale_items", "payments", "cash_registers"]
    customers: ["customers", "customer_addresses"]
    fiados: ["fiados", "fiado_payments", "credit_limits"]
    orders: ["orders", "order_items", "deliveries"]
    subscriptions: ["plans", "subscriptions", "subscription_history"]
    tokens: ["token_packages", "token_purchases", "token_usage"]

  por_tipo:
    catalogo: ["plans", "token_packages", "categories"]
    transaccional: ["sales", "orders", "fiados", "payments"]
    auditoria: ["notification_logs", "token_usage", "subscription_history"]
    configuracion: ["store_settings", "whatsapp_configs", "llm_configs"]

# ============================================================================
# CONEXION
# ============================================================================
conexion:
  host: "localhost"
  puerto: 5432
  database: "michangarrito_db"
  usuario: "ver .env"
  password: "ver .env"

# ============================================================================
# MIGRACIONES RECIENTES
# ============================================================================
migraciones:
  ubicacion: "apps/backend/src/database/migrations/"
  recientes: []

# ============================================================================
# REFERENCIAS
# ============================================================================
referencias:
  schema_completo: "@MCH_DEF_DB"
  entities: "@MCH_DEF_ENTITIES"
  especificaciones: "docs/02-especificaciones/ARQUITECTURA-DATABASE.md"