
    !\i                     ~    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e
      Z G d de
      Z G d	 d
e
      Zy)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                   z    e Zd ZdZdZ eedd      Z eeddd      Z	 ee      Z
 edd	      Z ed
d	      Zy)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      /app/app/core/db/models/sport.pyr   r      sI    M	T	6B&TBD&>D8I>G	:Er"   r   c                       e Zd ZdZdZ eedd      Z ee ed      d      Z	 ee
dd      Z ee      Z ee
d	      Z ee
dd
      Z edd      Z edd      Z edd      Zy)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    M	T	6BN!;dKJ&55D7OE vT*I&T2D9Y?G8H=G78<Gr"   r   c                       e Zd ZdZdZ eedd      Z ee ed      d      Z	 ee
dd      Z ee      Z ee      Z eed	
      Z edd      Z edd      Zy)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'   -   sq     M	T	6Bw
< 85II&55D Jd|H+J(9=F78<Gr"   r'   N)r   
sqlalchemyr   r   r   r   r   sqlalchemy.ormr   app.core.db.databaser	   r   r   r'   r!   r"   r#   <module>r:      s=    A @ ' %
;d 
;=T =&=T =r"   