a
    %Dh	                     @   s   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 G dd deZG dd deZG d	d
 d
eZG dd deZG dd deZG dd deZdS )    )ColumnIntegerStringDateFloat
ForeignKeyUniqueConstraintIndex)relationship   )Basec                   @   s0   e Zd ZdZeeddZeeZe	dddZ
dS )MarketmarketTprimary_key
InstrumentZback_populatesN__name__
__module____qualname____tablename__r   r   idr   namer
   instruments r   r   6/var/www/html/stockanalysis-backend/./app/db/models.pyr      s   r   c                   @   s0   e Zd ZdZeeddZeeZe	dddZ
dS )SectorsectorTr   r   r   Nr   r   r   r   r   r      s   r   c                   @   sN   e Zd ZdZeeddZeedddZeeZ	eeZ
eeZedddZd	S )
MarketExchngesZmarket_exchangesTr   Funiquenullabler   market_exchanger   N)r   r   r   r   r   r   r   r   Z
index_code
index_nameZechange_nameZmarket_namer
   r   r   r   r   r   r      s   r   c                   @   s   e Zd ZdZeeddZeeedddZeeedddZ	eeedddZ
eeddZeeddd	Zeeddd	Zeeddd	ZeeZed
ddZedddZedddZdS )r   r   Tr   zmarket_exchanges.idr"   z	market.idz	sector.idFr    r   r   r   r   N)r   r   r   r   r   r   r   r   Zmarket_exchange_idZ	market_idZ	sector_idZ
short_coder   symbolZricZtickerr   r
   r#   r   r   r   r   r   r   r      s   r   c                   @   s2   e Zd ZdZeeddZeedddZeeZ	dS )KPIZkpisTr   Fr    N)
r   r   r   r   r   r   r   r   coder   r   r   r   r   r'   2   s   r'   c                   @   st   e Zd ZdZeeddZeeedZeeedZ	ee
ddZeeddZeeZee
Zedd	d
dddfZdS )KPIValueZ
kpi_valuesTr   zinstruments.idzkpis.idFr%   instrument_idkpi_id	frequencydateZunique_kpi_entry)r   N)r   r   r   r   r   r   r   r   r*   r+   r   r,   r   r-   r   valuecurrencyr   Z__table_args__r   r   r   r   r)   8   s   r)   N)
sqlalchemyr   r   r   r   r   r   r   r	   Zsqlalchemy.ormr
   databaser   r   r   r   r   r'   r)   r   r   r   r   <module>   s   (
