19 lines
653 B
Python
19 lines
653 B
Python
# 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"))
|