# coding: utf-8
from sqlalchemy import Column, DateTime, Integer, text
from sqlalchemy.dialects.mysql import VARCHAR
from sqlalchemy.ext.declarative import declarative_base

Base = declarative_base()
metadata = Base.metadata


class FootballLeague(Base):
    __tablename__ = 'football_league'
    __table_args__ = {'comment': '足球联赛信息表'}

    id = Column(Integer, primary_key=True)
    league_id = Column(Integer, comment='联赛id')
    league_name = Column(VARCHAR(255), comment='联赛名称')
    league_all_name = Column(VARCHAR(255), comment='联赛全称')
    created_at = Column(DateTime, server_default=text("CURRENT_TIMESTAMP"))