o
    !\i                     @   sl   d Z ddl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dS )zCountry, League, Season models (football schema)

We keep the filename `sport.py` to minimize project churn, but the
project is currently focused on football only.
    )ColumnIntegerString
ForeignKeyDate)relationship)Basec                   @   sR   e Zd ZdZdZeedddZeeddddZ	eeZ
eddd	Zed
dd	ZdS )CountryzCountry dictionary	countriesTprimary_keyindexF)uniquenullabler   Leaguecountryback_populatesTeamN)__name__
__module____qualname____doc____tablename__r   r   idr   namecoder   leaguesteams r   r   W/var/www/www-root/data/www/176.119.141.140/sports-predictor/app/core/db/models/sport.pyr	      s    r	   c                   @   s   e Zd ZdZdZeedddZeeedddZ	ee
dddZeeZee
dd	Zee
ddd
ZedddZedddZedddZdS )r   zLeague/competitionr   Tr   zcountries.idr   Fr   r   )r   )r   r   r	   r   SeasonleagueMatchN)r   r   r   r   r   r   r   r   r   
country_idr   r   level	source_idr   r   r   seasonsmatchesr   r   r   r    r      s    r   c                   @   sv   e Zd ZdZdZeedddZeeedddZ	ee
dddZeeZeeZeed	d
ZedddZedddZdS )r#   zSeason within a leaguer)   Tr   z
leagues.idFr!   r"      )defaultr   r   r%   seasonN)r   r   r   r   r   r   r   r   r   	league_idr   r   r   
start_dateend_date
is_currentr   r$   r*   r   r   r   r    r#   -   s    r#   N)r   
sqlalchemyr   r   r   r   r   sqlalchemy.ormr   app.core.db.databaser   r	   r   r#   r   r   r   r    <module>   s    