176 lines
5.2 KiB
YAML
176 lines
5.2 KiB
YAML
# 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"
|