# Navegacion Rapida de Base de Datos - MiInventario
# Alias: @PROJ_QUICK_DATABASE
# Version: 1.0.0
# Fecha: 2026-01-16

version: "1.0.0"
proyecto: "miinventario"

# ============================================================================
# SCHEMAS
# ============================================================================
schemas:
  public:
    descripcion: "Schema principal (unico)"
    tablas_count: 21
    tablas_principales:
      - users
      - stores
      - videos
      - inventory_items
      - credit_balances
      - payments

# ============================================================================
# TABLAS PRINCIPALES (Top 10)
# ============================================================================
tablas_principales:
  - nombre: "users"
    schema: "public"
    descripcion: "Usuarios del sistema"
    entity: "User.entity.ts"
    relaciones: ["stores", "credit_balances", "payments", "referrals", "notifications"]

  - nombre: "stores"
    schema: "public"
    descripcion: "Tiendas de usuarios"
    entity: "Store.entity.ts"
    relaciones: ["users", "store_users", "videos", "inventory_items"]

  - nombre: "videos"
    schema: "public"
    descripcion: "Videos subidos para procesamiento"
    entity: "Video.entity.ts"
    relaciones: ["stores", "users", "inventory_items"]

  - nombre: "inventory_items"
    schema: "public"
    descripcion: "Items de inventario detectados"
    entity: "InventoryItem.entity.ts"
    relaciones: ["stores", "videos", "corrections"]

  - nombre: "credit_balances"
    schema: "public"
    descripcion: "Saldos de creditos por usuario"
    entity: "CreditBalance.entity.ts"
    relaciones: ["users"]

  - nombre: "credit_transactions"
    schema: "public"
    descripcion: "Transacciones de creditos"
    entity: "CreditTransaction.entity.ts"
    relaciones: ["users"]

  - nombre: "payments"
    schema: "public"
    descripcion: "Pagos de usuarios"
    entity: "Payment.entity.ts"
    relaciones: ["users", "credit_packages"]

  - nombre: "referrals"
    schema: "public"
    descripcion: "Sistema de referidos"
    entity: "Referral.entity.ts"
    relaciones: ["users"]

  - nombre: "notifications"
    schema: "public"
    descripcion: "Notificaciones de usuarios"
    entity: "Notification.entity.ts"
    relaciones: ["users"]

  - nombre: "audit_logs"
    schema: "public"
    descripcion: "Registros de auditoria"
    entity: "AuditLog.entity.ts"
    relaciones: ["users"]

# ============================================================================
# BUSQUEDA RAPIDA
# ============================================================================
busqueda:
  por_modulo:
    auth: ["otps", "refresh_tokens"]
    users: ["users"]
    stores: ["stores", "store_users"]
    inventory: ["inventory_items"]
    videos: ["videos"]
    credits: ["credit_balances", "credit_packages", "credit_transactions"]
    payments: ["payments"]
    referrals: ["referrals"]
    notifications: ["notifications"]
    admin: ["audit_logs", "promotions", "ia_providers"]
    feedback: ["corrections", "ground_truth", "product_submissions"]
    validations: ["validation_requests", "validation_responses"]

  por_tipo:
    catalogo:
      - credit_packages
      - ia_providers
    transaccional:
      - videos
      - inventory_items
      - credit_transactions
      - payments
      - referrals
      - notifications
      - corrections
      - validation_requests
      - validation_responses
    auditoria:
      - audit_logs
      - ground_truth
    configuracion:
      - promotions
      - ia_providers

# ============================================================================
# ENUMS IMPORTANTES
# ============================================================================
enums:
  users_role_enum:
    valores: [USER, VIEWER, MODERATOR, ADMIN, SUPER_ADMIN]
    uso: "Roles de usuario en el sistema"

  videos_status_enum:
    valores: [PENDING, UPLOADING, UPLOADED, PROCESSING, COMPLETED, FAILED]
    uso: "Estado de procesamiento de video"

  payments_method_enum:
    valores: [CARD, OXXO, 7ELEVEN]
    uso: "Metodo de pago"

  payments_status_enum:
    valores: [PENDING, PROCESSING, COMPLETED, FAILED, REFUNDED, EXPIRED]
    uso: "Estado de pago"

  credit_transactions_type_enum:
    valores: [PURCHASE, CONSUMPTION, REFERRAL_BONUS, PROMO, REFUND]
    uso: "Tipo de transaccion de creditos"

# ============================================================================
# MIGRACIONES RECIENTES
# ============================================================================
migraciones:
  ubicacion: "apps/backend/src/migrations/"
  recientes:
    - archivo: "1768099560565-Init.ts"
      descripcion: "Creacion inicial de tablas"
      fecha: "2026-01-10"

    - archivo: "1736502000000-CreateFeedbackTables.ts"
      descripcion: "Tablas de feedback y correcciones"
      fecha: "2026-01-10"

    - archivo: "1736600000000-CreateAdminTables.ts"
      descripcion: "Tablas de administracion"
      fecha: "2026-01-13"

# ============================================================================
# REFERENCIAS
# ============================================================================
referencias:
  schema_completo: "@PROJ_DEF_DB"
  entities: "@PROJ_DEF_ENTITIES"
  inventario: "orchestration/inventarios/DATABASE_INVENTORY.yml"