
    !+i
                     |    d dl mZmZmZmZmZmZmZmZ d dl	m
Z
 d dlmZ d dlmZ  G d de      Z G d de      Zy	)
    )ColumnStringIntegerFloatDateTimeBoolean
ForeignKeyNumeric)relationship)datetime)Basec                      e Zd ZdZdZ eedd      Z e ed      d      Z	 e e
dd	      d      Z e ed
            Z eed      Z eed      Z eeej$                        Z eeej$                  ej$                        Zy)	FixedCostub   
    Representa um custo fixo recorrente da operação.
    Ex: Aluguel, Salários, Software.
    financial_costsTprimary_keyautoincrementd   F)nullable
      2   default   )r   onupdateN)__name__
__module____qualname____doc____tablename__r   r   idr   namer
   amountcategoryr   activeday_of_monthr   r   utcnow
created_at
updated_at     B/var/www/hypershopcomercio.com.br/hyper-ai/app/models/financial.pyr   r      s     &M	T	>B&+.DGBNU3FfRj!H GT*F'1-L (//:J(//HOOTJr,   r   c                   j   e Zd ZdZdZ eedd      Z e ed      ddd      Z	 ee
d	      Z e ed
d      d	      Z ee
d	      Z e ed
d      d	      Z e ed
d      d	      Z e ed
d      d	      Z e ed
d      d	      Z e ed
d      d	      Z eeej,                  	      Zy)ProductFinancialMetricuz   
    Cache de métricas financeiras específicas de um produto (SKU).
    Calculado periodicamente (ex: job diário).
    product_financial_metricsTr   r   F)indexr   uniqueg        r   r   r      N)r   r   r   r    r!   r   r   r"   r   skur   return_rate_90dr
   avg_return_costrevenue_share_30dcalculated_fixed_cost_sharestorage_costdaily_storage_feeinbound_freight_coststorage_risk_costr   r   r(   last_calculated_atr+   r,   r-   r/   r/      s     0M	T	>B
4%
EC UC0OWR^S9O uc2
 #)Q"E '"a.#6Lwr1~s;!'"a.#>wr1~s;(//Br,   r/   N)
sqlalchemyr   r   r   r   r   r   r	   r
   sqlalchemy.ormr   r   app.core.databaser   r   r/   r+   r,   r-   <module>rA      s3    ] ] ] '  "U U(CT Cr,   