29 lines
884 B
Python
29 lines
884 B
Python
# coding: utf-8
|
|
from sqlalchemy import Column, DateTime, Float, Integer, JSON, text
|
|
from sqlalchemy.dialects.mysql import VARCHAR
|
|
from sqlalchemy.ext.declarative import declarative_base
|
|
|
|
Base = declarative_base()
|
|
metadata = Base.metadata
|
|
|
|
|
|
class FootballMatchZjqOdd(Base):
|
|
__tablename__ = 'football_match_zjq_odds'
|
|
__table_args__ = {'comment': '竞彩足球总进球数赔率表'}
|
|
|
|
id = Column(Integer, primary_key=True)
|
|
issue = Column(VARCHAR(255))
|
|
match_id = Column(Integer)
|
|
result = Column(VARCHAR(50))
|
|
odds = Column(Float)
|
|
ball_0 = Column(Float)
|
|
ball_1 = Column(Float)
|
|
ball_2 = Column(Float)
|
|
ball_3 = Column(Float)
|
|
ball_4 = Column(Float)
|
|
ball_5 = Column(Float)
|
|
ball_6 = Column(Float)
|
|
ball_7_plus = Column(Float)
|
|
odds_history = Column(JSON)
|
|
created_at = Column(DateTime, server_default=text("CURRENT_TIMESTAMP"))
|